RECV_ASN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	ABORT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Abort Process Flag
5	AE_CNV_IN_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE input convert field
6	AE_CNV_OUT_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE output converion field
7	AE_N	Character(1)	VARCHAR2(1) NOT NULL	AE_N
8	AE_SPACE	Character(1)	VARCHAR2(1) NOT NULL	Blank field literal
9	AE_Y	Character(1)	VARCHAR2(1) NOT NULL	AE_Y
10	ASN_LOT_NBR	Number(9,0)	DECIMAL(9) NOT NULL	ASN Lot/Serial Sequence Number
11	ASN_LOT_RESET	Character(1)	VARCHAR2(1) NOT NULL	Reset ASN Lot Number
12	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
13	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
14	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
15	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
16	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
17	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
18	DISTRIB_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Sequence
19	MERCH_AMT_AVAIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amount Available
20	MERCH_AMT_DIST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Distribution Merchandise Amt
21	MERCH_AMT_SHIP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Shipto Merchandise Amount
22	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
23	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
24	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
25	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
26	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
27	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
28	QTY_DS_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Distributed Quantity
29	QTY_DS_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Distributed Qty in Supp UOM
30	QTY_LN_ASSET_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity to be Asset Tracked
31	QTY_LN_INV_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Line Inv Qty
32	QTY_PO_AVAIL	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Available PO Qty
33	QTY_SH_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accept QTY in Supplier UOM
34	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
35	RECORD_COUNT	Number(7,0)	INTEGER NOT NULL	Count of Records
36	RECV_ID_LAST_USED	Number(10,0)	DECIMAL(10) NOT NULL	Last Receiver Number
37	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
38	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
39	RECV_WHEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Do When
40	SHIPMENT_NO	Character(30)	VARCHAR2(30) NOT NULL	Shipment Number
41	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
42	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
43	TTL_DS_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accepted Qty
44	TTL_MERCH_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amount
45	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
46	UNIT_MEASURE_SHIP	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure
47	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
48	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
49	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID