IN_FL_STG_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 Prompt Table: SP_BUIN_NONVW
3	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID
4	CONTAINER_ID	Character(10)	VARCHAR2(10) NOT NULL	Container ID Prompt Table: CNTR_ID_INV
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW12
6	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID Default Value: INSTALLATION_IN.DFLT_SERIAL_ID
7	STAGED_NUM	Number(3,0)	SMALLINT NOT NULL	Staged Number Default Value: 1
8	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
9	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
10	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
11	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_UOM_VW
12	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
13	QTY_CONV_FLAG	Character(2)	VARCHAR2(2) NOT NULL	Quantity Convert Flag 1=Enter Qty in Stocking UOM 2=Enter Qty in Standard UOM Default Value: 1
14	PUTAWAY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Putaway Status 1=Not Assigned 2=Putaway Complete 3=In Error Default Value: 1
15	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Y/N Table Edit Default Value: N
16	JOB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
17	PUTAWAY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Item Putaway Flag Y/N Table Edit
18	STAGED_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Staging Type 1= 2=* Cancellation 3=* Short Shipment Default Value: 1
19	TRANS_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Transaction Source 01=Purchasing 02=WIP Completion 03=Inventory 04=WIP Component 05=Adjustment 06=Component Kit Returns
20	CANCEL_NETTABLE	Character(1)	VARCHAR2(1) NOT NULL	Nettable Flag from Picking Loc Y/N Table Edit Default Value: N
21	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
22	FROM_STOR_AREA	Character(5)	VARCHAR2(5) NOT NULL	From storage area
23	FROM_STOR_LEV1	Character(4)	VARCHAR2(4) NOT NULL	From Storage Level 1
24	FROM_STOR_LEV2	Character(4)	VARCHAR2(4) NOT NULL	From Storage Level 2
25	FROM_STOR_LEV3	Character(4)	VARCHAR2(4) NOT NULL	From Storage Level 3
26	FROM_STOR_LEV4	Character(4)	VARCHAR2(4) NOT NULL	From Storage Level 4
27	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
28	FROM_UOM	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure
29	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
30	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
31	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
32	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
33	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
34	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
35	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
36	GRP_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence used to uniquely identify a row in the Fulfillment Group stage table.
37	DTL_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence used to uniquely identify a row in the Fulfillment Details stage table.
38	LLS_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.