RECV_MG_TAO

#	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	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
4	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	QTY_SF_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Recv Accepted Qty
7	QTY_SF_REJCT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Recv Rejected Qty
8	QTY_UPD_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Prdn Accepted Qty
9	QTY_UPD_REJCT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Prdn Rejected Qty
10	INSERT_ROW_FLG	Character(1)	VARCHAR2(1) NOT NULL	Insert Row Flag
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	SUBCONTRACT_COMP	Character(1)	VARCHAR2(1) NOT NULL	Production Complete indicator for streamline processing Y/N Table Edit Default Value: Y
13	RECV_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Receive Source 1=On-line 2=ASN 3=Data Cllct 4=Mobile Default Value: 1
14	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
15	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label
16	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
17	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
18	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
19	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
20	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
21	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
22	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
23	USER_LINE_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
24	CUSTOM_C100_B1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
25	CUSTOM_C100_B2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
26	CUSTOM_C100_B3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
27	CUSTOM_C100_B4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
28	CUSTOM_DATE_B	Date(10)	DATE	Custom Date
29	CUSTOM_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
30	USER_SCHED_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
31	CUSTOM_C100_C1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
32	CUSTOM_C100_C2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
33	CUSTOM_C100_C3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
34	CUSTOM_DATE_C1	Date(10)	DATE	Custom Date 1
35	CUSTOM_DATE_C2	Date(10)	DATE	Custom Date 2
36	CUSTOM_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2