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 | 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. |