ITM_LOAD_MST_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	ITM_STATUS_EFFDT	Date(10)	DATE	Item Status Date Default Value: %DATE
6	ITM_STATUS_CURRENT	Character(1)	VARCHAR2(1) NOT NULL	Item Status Current 1=Active 2=Hold 3=Discontinue 4=Inactive 5=Pending Approval 6=Denied Approval 7=Under Initialization Default Value: 1
7	ITM_STAT_DT_FUTURE	Date(10)	DATE	Item Date Future
8	ITM_STATUS_FUTURE	Character(1)	VARCHAR2(1) NOT NULL	Item Status Future 1=Active 2=Hold 3=Discontinue 4=Inactive
9	LOADED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Item Load Step One Load Status C=Complete L=To Be Loaded Default Value: L
10	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
13	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
14	DEFINE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Item Definition Status 1=Under Initialization 2=Initialization Complete Default Value: 1
15	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure Default Value: EA Prompt Table: UNITS_TBL
16	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group Prompt Table: INV_ITEM_GROUP
17	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family Prompt Table: INV_ITEM_FAM
18	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
19	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
20	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
21	APPROVAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Item Definition Approved A=Approved D=Denied P=Pending Default Value: A
22	INVENTORY_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Inventory Item N=No Y=Yes Y/N Table Edit Default Value: Y
23	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y Y/N Table Edit Default Value: N
24	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y Y/N Table Edit Default Value: N
25	NON_OWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o N=No Y=Yes Y/N Table Edit Default Value: N
26	APPROV_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Approval Required for Demand Y/N Table Edit Default Value: N
27	DIST_CFG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Distribution Configuration Y/N Table Edit Default Value: N
28	PRDN_CFG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Production Configuration Y/N Table Edit Default Value: N
29	CFG_CODE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Configuration Code Generation B=Both N=No Y=Yes Y/N Table Edit Default Value: N
30	CFG_COST_OPT	Character(1)	VARCHAR2(1) NOT NULL	Configuration Costing Y/N Table Edit Default Value: N
31	CFG_LOT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Default Configured Lot Y/N Table Edit Default Value: N
32	CP_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID Field
33	MATERIAL_RECON_FLG	Character(1)	VARCHAR2(1) NOT NULL	Material Reconciliation Flag Y/N Table Edit Default Value: N
34	USG_TRCKNG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Usage Tracking Method 01=None 02=Billing 03=Costing Default Value: 01
35	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag Y/N Table Edit Default Value: N
36	UPDATE_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Update Inventory Item Y/N Table Edit Default Value: N