SETIDPrompt Table: SP_SETID_NONVW
IU_INTRA_TMPLT_CDPrompt Table: IU_INTRA_TMPLT
IU_TRAN_CDPrompt Table: IU_TRANMP_CD_VW
IU_INTRA_TRAN(SQL Table) |
Index Back |
|---|---|
IntraUnit Template TransactionChild to IU_INTRA_TMPLT; parent to IU_INTRA_CF |
| # | 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_INTRA_TMPLT_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Key field for IntraUnit Template
Prompt Table: IU_INTRA_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 |