IU_TRAN_MAP_OPT(SQL Table) |
Index Back |
|---|---|
InterUnit Bill Options |
| # | 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_TBL |
| 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 | IU_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Used for interunit bill options, to distinguish the different types of inter/intraunit entries.
AE=IntraEntity AU=IntraUnit IE=InterEntity IU=InterUnit Default Value: AU |
| 4 | PRINT_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Print Invoice
Y/N Table Edit Default Value: N |
| 5 | GEN_AR_ITEM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Generate AR Open Item
Y/N Table Edit Default Value: N |
| 6 | GEN_AP_VCHR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Generate AP Voucher
Y/N Table Edit Default Value: N |
| 7 | INTERCOMPANY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
/* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
Y/N Table Edit Default Value: N |
| 8 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source Default Value: D |