IU_INTER_PR_TR(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 | Character(5) | VARCHAR2(5) NOT NULL | 
From GL Business Unit
 Prompt Table: SP_BU_IUF_NONVW  | 
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL | 
To GL Business Unit
 Prompt Table: SP_BU_IUT_NONVW  | 
|
| 3 | 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 | PRINT_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Print Invoice
 Y/N Table Edit  | 
| 5 | GEN_AP_VCHR_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Generate AP Voucher
 Y/N Table Edit  | 
| 6 | GEN_AR_ITEM_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Generate AR Open Item
 Y/N Table Edit  | 
| 7 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | 
AP Business Unit
 Prompt Table: SP_BUGLAP2NONVW  | 
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | 
Vendor Identifier
 Prompt Table: IU_VNDR_VW2  | 
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | 
Location Code
 Prompt Table: IU_VNDR_LOC_VW  | 
| 10 | INTERCOMPANY_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
/* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
 Y/N Table Edit Default Value: N  | 
| 11 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | 
Billing Business Unit
 Prompt Table: SP_BUGLBI2NONVW  | 
| 12 | 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  | 
| 13 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL | 
Ownership Unit
 D=Destination S=Source Default Value: D  |