IU_PR_TR_TAO(SQL Table) |
Index Back |
|---|---|
IU Pair TransactionChild to IU_INTER_PAIR; parent to IU_INTER_PR_TR |
| # | 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
Prompt Table: SP_BU_IUF_NONVW |
| 3 | IU_TO_GLBU |
Character(5) | VARCHAR2(5) NOT NULL |
To GL Business Unit
Prompt Table: SP_BU_IUT_NONVW |
| 4 | 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 |
| 5 | PRINT_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Print Invoice
Y/N Table Edit |
| 6 | GEN_AP_VCHR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Generate AP Voucher
Y/N Table Edit |
| 7 | GEN_AR_ITEM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Generate AR Open Item
Y/N Table Edit |
| 8 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BUGLAP2NONVW |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: BUS_UNIT_TBL_GL.VENDOR_ID Prompt Table: IU_VNDR_VW2 |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: IU_VNDR_LOC_VW |
| 11 | INTERCOMPANY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
/* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
Y/N Table Edit |
| 12 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table: SP_BUGLBI2NONVW |
| 13 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: IU_CUST_VW |
| 14 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source Default Value: D |
| 15 | DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Delete Loaded Items
Y/N Table Edit |
| 16 | IU_PR_ACT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Flag used in IU Pairs Mass Maintenance
D=Duplicate Row I=Insert Row U=Update Row |
| 17 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 18 | MESSAGE_TEXT_2 | Character(100) | VARCHAR2(100) NOT NULL | Message Text |
| 19 | MESSAGE_TEXT_3 | Character(100) | VARCHAR2(100) NOT NULL | Message Text |
| 20 | MESSAGE_TEXT_4 | Character(100) | VARCHAR2(100) NOT NULL | Message Text |
| 21 | MESSAGE_TEXT_5 | Character(100) | VARCHAR2(100) NOT NULL | Message Text |
| 22 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 23 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |