HDG_AOCI_AET(SQL Table) |
Index Back |
---|---|
HDG AOCI AE State RecordHDG 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. |