OMBI_OMBU_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
3	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
4	SETID_FRT_TERMS	Character(5)	VARCHAR2(5) NOT NULL	Freight Terms SETID
5	SETID_CONTRACT	Character(5)	VARCHAR2(5) NOT NULL	Contract Setid
6	SETID_EOEP_RULE	Character(5)	VARCHAR2(5) NOT NULL	Price Rule Setid
7	SETID_PROD_ITEM	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	SETID_PROD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
9	SETID_REGION_CD	Character(20)	VARCHAR2(20) NOT NULL	Concatenated SETID, seperator and REGION_CD
10	SETID_DST_RULE	Character(5)	VARCHAR2(5) NOT NULL	Distribution Sets Setid
11	SETID_THIRD_PARTY	Character(5)	VARCHAR2(5) NOT NULL	SetID
12	SETID_PRODKIT	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	SETID_ORD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Order Group Setid
14	SETID_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit SetId
15	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
16	SETID_CUST_ID	Character(30)	VARCHAR2(30) NOT NULL	Concatenated SETID, seperator and CUST_ID
17	SETID_NOTE	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	SETID_BI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	BI Type Setid
19	SETID_BI_SRC	Character(5)	VARCHAR2(5) NOT NULL	Bill Source Setid
20	SETID_PROD_PGRPLNK	Character(5)	VARCHAR2(5) NOT NULL	SETID PGRP LNK
21	SETID_FREIGHT	Character(5)	VARCHAR2(5) NOT NULL	Freight Terms SETID
22	SETID_CUST	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
23	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
24	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
25	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
26	DST_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Dist Rule Code
27	DST_ID_REV	Character(10)	VARCHAR2(10) NOT NULL	Revenue Dist Code
28	DST_ID_DIS	Character(10)	VARCHAR2(10) NOT NULL	Discount Distribution Code
29	DST_ID_SUR	Character(10)	VARCHAR2(10) NOT NULL	Surcharge Distribution Code
30	DST_ID_DEPOSIT	Character(10)	VARCHAR2(10) NOT NULL	Sales Order Deposit distribution code
31	DST_ID_VOUCHER	Character(10)	VARCHAR2(10) NOT NULL	Corporate Voucher distribution code
32	REFUND_FEE_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Deposit refund fee product ID
33	FREIGHT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Freight Product ID
34	MISC_CHRG_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Misc Charge Product ID
35	OMBI_PRC_ADJ_OPT	Character(1)	VARCHAR2(1) NOT NULL	Price Adjustment Detail Option 1=Netted with Revenue 2=As Account Distribution 3=As Disc/Surch Detail
36	OMBI_ADJ_DSPLY_OPT	Character(2)	VARCHAR2(2) NOT NULL	Total Order/Load Adjustment Display Option. This field determines whether total order and load price adjustments will be invoiced as individual invoice lines or as adjustments to lines for goods or services. 01=Individual Invoice Lines 02=Adjustments to Invoice Lines
37	ORD_ACCEPT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Acceptance
38	ORD_ORIGIN_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Origin
39	TAX_DIVISION	Character(5)	VARCHAR2(5) NOT NULL	Division for Tax Suppliers
40	TAX_DEPARTMENT	Character(5)	VARCHAR2(5) NOT NULL	Department used by Tax Vendors