CA_IU_AET(SQL Table) |
Index Back |
|---|---|
IU Entries State RecordState record used to create interunit account entries. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME_BU | Character(15) | VARCHAR2(15) NOT NULL | Business Unit Recname |
| 3 | RECNAME_UPDATE | Character(15) | VARCHAR2(15) NOT NULL | Record to Update |
| 4 | FIELDNAME_BU | Character(18) | VARCHAR2(18) NOT NULL | Business Unit Field Name |
| 5 | DST_USE | Character(3) | VARCHAR2(3) NOT NULL | Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 8 | CHARTFIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ChartField Value |
| 9 | CUR_EFFDT | Date(10) | DATE | Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header. |