IU_INTER_PR_TR

(SQL Table)
Index Back

IU Pair Transaction

Child to IU_INTER_PAIR; parent to IU_INTER_PR_TR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IU_FROM_GLBU Character(5) VARCHAR2(5) NOT NULL From GL Business Unit

Prompt Table: SP_BU_IUF_NONVW

2 IU_TO_GLBU Character(5) VARCHAR2(5) NOT NULL To GL Business Unit

Prompt Table: SP_BU_IUT_NONVW

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

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