PUR_LOAD_EC_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
7	PO_AVAIL_DT	Date(10)	DATE	PO Available Date
8	PO_UNAVAIL_DT	Date(10)	DATE	PO Unavailable Date
9	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
10	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
12	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_NB_VW
13	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_NB_VW
14	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_NB_VW
15	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_NB_VW
16	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_NB_VW
17	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_NB_VW
18	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
19	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
20	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
21	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_NB_VW
22	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_NB_VW
23	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_NB_VW
24	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
25	PRICE_LIST	Number(16,5)	DECIMAL(15,5) NOT NULL	Standard Price
26	TAXABLE_CD	Character(1)	VARCHAR2(1) NOT NULL	Taxable or Non-Taxable
27	AUTO_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Auto Select
28	STD_LEAD	Number(3,0)	SMALLINT NOT NULL	Purchase Lead Time Days
29	STD_MIN_QTY	Number(7,0)	INTEGER NOT NULL	Std Minimum Qty
30	STD_MAX_QTY	Number(7,0)	INTEGER NOT NULL	Std Maximum Qty
31	STD_MULTIPLE	Number(7,0)	INTEGER NOT NULL	Standard Multiple
32	UNIT_PRC_TOL	Number(14,5)	DECIMAL(13,5) NOT NULL	Unit Price Tolerance
33	PCT_UNIT_PRC_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	% Unit Price Tolerance
34	EXT_PRC_TOL	Number(14,5)	DECIMAL(13,5) NOT NULL	Ext Price Tolerance
35	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
36	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension
37	PCT_EXT_PRC_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	% Ext Price Tolerance
38	INSPECT_CD	Character(1)	VARCHAR2(1) NOT NULL	Inspection Required N=No Y=Yes
39	INSPECT_UOM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Inspection UOM S=Standard V=Supplier
40	ROUTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Inspection Routing ID
41	RECV_REQ	Character(1)	VARCHAR2(1) NOT NULL	Receiving Required N=Optional X=Do Not Y=Required
42	QTY_RECV_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Qty Rcvd Tolerance %
43	RJCT_OVER_TOL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reject Qty Over Tolerance
44	RFQ_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	RFQ Required
45	REJECT_DAYS	Number(3,0)	SMALLINT NOT NULL	Early Ship Rjct Days
46	PRIMARY_BUYER	Character(30)	VARCHAR2(30) NOT NULL	Primary Buyer
47	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
48	ACCEPT_ALL_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Accept Any Vendor
49	ACCEPT_ALL_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Accept Any Ship To
50	CONTRACT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Contract Required
51	RECV_PARTIAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qty 1=Recvd 2=Recvd/Warn 3=Open 4=Open/Warn 5=Open/Error
52	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
53	PCT_UNDER_QTY	Signed Number(4,0)	DECIMAL(3) NOT NULL	Close PO Under Qty Pct Tol
54	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
55	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
56	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
57	UPDATE_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Update Inventory Item
58	STOCKLESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Stockless Item N=No Y=Yes
59	INSPECT_SAMPLE_PER	Number(6,2)	DECIMAL(5,2) NOT NULL	Inspect Sample Percent
60	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
61	LAST_PO_PRICE_PAID	Number(16,5)	DECIMAL(15,5) NOT NULL	Last PO Price Paid
62	SRC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Sourcing Method B=Basic F=Flexible H=Cumulative Split S=Sched Split
63	LEAD_TIME_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Lead Time Factor %
64	PRICE_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Price Factor %
65	SHIPTO_PR_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Ship to Priority Factor %
66	VNDR_PR_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Vendor Priority Factor %
67	USE_CAT_SRC_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Use Category Sourcing Controls
68	UNIT_PRC_TOL_L	Number(14,5)	DECIMAL(13,5) NOT NULL	Unit Price Tolerance - Under
69	PCT_UNIT_PRC_TOL_L	Number(6,2)	DECIMAL(5,2) NOT NULL	% Unit Price Tolerance - Under
70	EXT_PRC_TOL_L	Number(14,5)	DECIMAL(13,5) NOT NULL	Ext Price Tolerance - Under
71	PCT_EXT_PRC_TOL_L	Number(6,2)	DECIMAL(5,2) NOT NULL	% Ext Price Tolerance - Under
72	PACKING_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Packing Volume
73	PACKING_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Packing Weight
74	UNIT_MEASURE_VOL	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM
75	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
76	SHIP_LATE_DAYS	Number(4,0)	SMALLINT NOT NULL	Days Allowed After Request Dt
77	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code