OMBI_KIT_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	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
4	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
5	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
6	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
7	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
8	INV_ITEM_ID_NEW	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
11	DEMAND_LINE_NO_TO	Number(4,0)	SMALLINT NOT NULL	Demand line
12	SHIP_TIME	Time(15)	TIMESTAMP	Ship Time
13	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
14	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
15	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
16	PRODUCT_ID_TEMP	Character(18)	VARCHAR2(18) NOT NULL	Product Id Temp
17	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
18	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
19	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
20	SHIP_DATE	Date(10)	DATE	Item Shipping Date
21	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
22	BUSINESS_UNIT_OLD	Character(5)	VARCHAR2(5) NOT NULL	Old Business Unit
23	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Exist
24	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
25	UNIT_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
26	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
27	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
28	UOM_BILL	Character(3)	VARCHAR2(3) NOT NULL	Bill Unit of Measure
29	UPS_FLAG1	Character(1)	VARCHAR2(1) NOT NULL	Flag
30	UPS_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	Flag
31	UPS_FLAG3	Character(1)	VARCHAR2(1) NOT NULL	Flag
32	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
33	ORDER_NO_TO	Character(10)	VARCHAR2(10) NOT NULL	To Order No
34	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
35	SCHED_ROW	Number(5,0)	INTEGER NOT NULL	Schedule Row
36	CHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Work field used to store status values
37	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
38	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
39	HOLD_REQD	Character(1)	VARCHAR2(1) NOT NULL	Hold Processing Required
40	SHIP_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Determines the status of a demand line in the fullfillment process. Values can be: Unfulfilled, Reserved, On Pick Plan, Confirmed, Shipped, Cancelled and On-Hold 01=Unfulfilled 02=Reserved 03=On Pick Plan 04=Confirmed 05=Shipped 06=Cancelled 07=On Hold 08=Depleted 09=In Process
41	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status C=Closed O=Open
42	STOCK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Type F=Finished R=Raw Mtrl W=WIP
43	SELECT_COMP	Character(1)	VARCHAR2(1) NOT NULL	Select Competency
44	OPTIONAL_SHIP	Character(1)	VARCHAR2(1) NOT NULL	OK to Ship Without
45	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
46	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
47	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Component ID
48	PRODUCT_KIT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Kit Number
49	KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Kit Line Number
50	MAX_LINE_NO	Number(8,0)	INTEGER NOT NULL	Interface Line Number
51	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
52	AMOUNT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
53	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
54	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
55	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
56	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
57	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
58	GROSS_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Extended
59	TOT_LINE_DST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Dist Amount
60	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
61	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
62	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
63	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
64	CURRENCY_CHK	Character(3)	VARCHAR2(3) NOT NULL	Currency Check
65	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
66	AMOUNT_ROUND	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Amount Rounded
67	ROUND_UNIT_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
68	LIST_PRICE_ROUND	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
69	GROSS_ROUND	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Amount Rounded
70	GROSS_EXT_ROUND	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Amount Rounded
71	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
72	SETID_PRODKIT	Character(5)	VARCHAR2(5) NOT NULL	SetID
73	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
74	VAT_TXN_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
75	DECIMALPOS1	Number(4,0)	SMALLINT NOT NULL	Decimal Positions1
76	VAT_APPLICABLE	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable E=Exempt O=Outside of Scope of VAT T=Taxable
77	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
78	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
79	TAX_TRANS_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Sub Type 1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None
80	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
81	DIFFERENCE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Difference Amount
82	OM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OM Work Flag
83	VAT_KIT_PCT	Number(3,0)	SMALLINT NOT NULL	% of Kit Value for VAT
84	MAX_KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Field used by OM_BILL to hold the maximum KIT_LINE_NBR value for a given kit.