RECV_OPEN_TMP1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	ASN_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	ASR Key sequence number
4	ASN_SCHED_NBR	Number(9,0)	DECIMAL(9) NOT NULL	ASR Schedule Sequence Number
5	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
6	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
7	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
8	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
9	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
10	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
11	QTY_OPEN	Number(16,4)	DECIMAL(15,4) NOT NULL	Open Quantity
12	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
13	QTY_SHIPPED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
14	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
15	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
16	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
17	UNIT_MEASURE_SHIP	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure