RECV_DEL_STG

#	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	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
4	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
5	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
6	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
7	RECEIPT_DT	Date(10)	DATE	Received Date
8	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
9	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
10	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
11	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
12	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
14	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
15	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
16	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
17	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
18	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
19	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
20	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
21	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
22	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
23	BUILDING	Character(10)	VARCHAR2(10) NOT NULL	Building #
24	FLOOR	Character(10)	VARCHAR2(10) NOT NULL	Floor #
25	ATTN_TO	Character(30)	VARCHAR2(30) NOT NULL	Attention
26	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
27	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
28	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
29	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
30	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
31	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
32	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
33	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
34	RECEIPT_UM	Character(3)	VARCHAR2(3) NOT NULL	Receiving UOM
35	REJECT_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reject Reason Code DAM=Damaged Goods FAL=Failed Inspection INC=Incomplete Shipment LAT=Late Shipment RLY=Early Shipment WRG=Wrong Goods or Service
36	REJECT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action On Rejection C=Return for Credit R=Return For Replacement
37	DELIVERED_TO	Character(30)	VARCHAR2(30) NOT NULL	Delivered To
38	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
39	DELIVERED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Delivered Flag
40	QTY_DS_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Distributed Qty in Supp UOM
41	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.
42	DELIVERED_DT	Date(10)	DATE	Delivered Date
43	QTY_SH_REJCT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Reject QTY in Supplier UOM
44	QTY_SH_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accept QTY in Supplier UOM
45	QTY_SH_RECVD_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Receipt QTY in Supplier UOM
46	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
47	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled
48	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
49	REQUESTOR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Requestor
50	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
51	BUYER_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Buyer Desc
52	COMMENTS_2000_WRK	Long Character(32700)	CLOB	Comments 2000 Work Record