HDG_AOCI_AET

(SQL Table)
Index Back

HDG AOCI AE State Record

HDG AOCI AE State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 HEDGE_ID Character(12) VARCHAR2(12) NOT NULL Hedge ID identifies the designation of Hedging Deals (Instruments) as being the Hedge of Hedged Items
6 HEDGED_ITEM_SEQ Number(4,0) SMALLINT NOT NULL Sequence number of the hedged item. this allows mulitple items to be designated as hedged items.
7 RECLASS_DT Date(10) DATE Reclassification Date.
8 AOCI_ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Accumulated Other Comprehensive Income Adjustment Type.
A=Adjust
R=Reclassify -Transaction Occurs
S=Hedge Discontinue/Impairment
9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 AMT11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 11
12 AMT12 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 12
13 AMT13 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 13
14 AMT14 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 14
15 AMT15 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 15
16 AMT16 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 16
17 AMT17 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 17
18 AMT18 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 18
19 AMT19 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 19
20 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
21 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.