RECV_SH_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SHIPMENT_NO	Character(30)	VARCHAR2(30) NOT NULL	Shipment Number
3	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
4	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
5	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
6	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
7	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
8	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
9	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
10	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
11	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
12	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
13	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity
14	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.
15	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
16	MERCHANDISE_AMT_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PO Merchandise Amount
17	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
18	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
19	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
20	RECEIPT_UM	Character(3)	VARCHAR2(3) NOT NULL	Receiving UOM
21	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
22	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
23	QTY_SH_RECVD_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Receipt Quantity
24	QTY_SH_RECVD_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Receipt QTY in Supplier UOM