IU_SYS_TRAN_CDPrompt Table: IU_SYS_TRAN_VW
IU_TRAN_CDPrompt Table: IU_TRAN_CD_TBL
Y/N Table Edit
Default Value: Y
IU_TRAN_MAP_TBL(SQL Table) |
Index Back |
|---|---|
Transaction MappingMap Transaction Codes to System Transactions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IU_SYS_TRAN_CD |
Character(8) | VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
Prompt Table: IU_SYS_TRAN_VW |
| 2 | 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_TRAN_CD_TBL |
| 3 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit Default Value: Y |