HDG_CUM_OFSTTMP

(SQL Table)
Index Back

Cumulative Cash Flow - TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 HEDGE_ID Character(12) VARCHAR2(12) NOT NULL Hedge ID identifies the designation of Hedging Deals (Instruments) as being the Hedge of Hedged Items
4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
5 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
6 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name
7 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)
8 MTM_ASEF_GAINLOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gain or Loss computed (FAS 133 para 63 included component)
9 MTM_GAINLOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Mark to Market Gain or Loss computed