UPG_IU_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	IU_METHOD	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Method D=Direct I=Indirect P=Pairs
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	IU_INTER_TMPLT_CD	Character(5)	VARCHAR2(5) NOT NULL	Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
6	IU_INTRA_TMPLT_CD	Character(5)	VARCHAR2(5) NOT NULL	Key field for IntraUnit Template
7	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
8	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.
9	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.
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	UPG_IU_INTER_SRC	Character(3)	VARCHAR2(3) NOT NULL	InterUnit Setup Source AMU=Assets Business Unit APP=Proc Acctg Cntrl - Payment APV=Proc Acctg Cntrl - Voucher BII=Billing InterUnit Controls GLU=General Ledger Bus Unit INS=Inventory Shipment on Behalf INT=Inventory InterUnit Transfer INX=Inventory Expense Issue NON=None TRI=Treasury Internal Banks
12	UPG_IU_INTRA_SRC	Character(3)	VARCHAR2(3) NOT NULL	IntraUnit Setup Source AMU=Assets Business Unit ARA=Receivables Options IntraUnit BII=Billing InterUnit Controls BNP=Bank Account - Non-Pooled GMA=Grants F&A IntraUnit Accounts INA=Inventory IntraUnit Accounts INT=Inventory InterUnit Transfers NON=None
13	SQLROWS	Number(5,0)	INTEGER NOT NULL	SQL Rows
14	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
15	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
16	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
17	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
18	PRINT_IVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Print Invoice
19	GEN_AR_ITEM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Generate AR Open Item
20	GEN_AP_VCHR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Generate AP Voucher
21	INTERCOMPANY_FLG	Character(1)	VARCHAR2(1) NOT NULL	/* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
22	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
23	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
24	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
26	BUS_UNIT_BI_TR	Character(5)	VARCHAR2(5) NOT NULL	Billing Xfer Business Unit
27	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.