| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
IU_FROM_GLBU |
Character(5) |
VARCHAR2(5) NOT NULL |
From GL Business Unit
|
| 3 |
IU_TO_GLBU |
Character(5) |
VARCHAR2(5) NOT NULL |
To GL Business Unit
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 7 |
IU_INTER_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
|
| 8 |
IU_INTRA_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key field for IntraUnit Template
|
| 9 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 10 |
ACT_BAL_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Balancing Group
|