SETIDPrompt Table: SP_SETID_NONVW
IU_INTER_TMPLT_CDPrompt Table: IU_INTER_TMPLT
IU_TRAN_CDPrompt Table: IU_TRANMP_CD_VW
ACT_BAL_GRPPrompt Table: ACT_BAL_GRP
IU_INTER_GRP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | 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.
Prompt Table: IU_INTER_TMPLT |
| 3 | 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.
Prompt Table: IU_TRANMP_CD_VW |
| 4 | ACT_BAL_GRP |
Character(10) | VARCHAR2(10) NOT NULL |
Account Balancing Group
Prompt Table: ACT_BAL_GRP |