RTV_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV Prompt Table: SP_BU_PM_NONVW
2	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID Default Value: NEXT
3	ACTIVITY_DATE	Date(10)	DATE	Last Activity
4	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.ADDR_SEQ_NUM_ORDR Prompt Table: VENDOR_ADDR_VW
5	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
6	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
7	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_ID_VW
8	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
9	DISPATCH_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Dispatch Flag Y/N Table Edit Default Value: N
10	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by
11	ENTERED_DT	Date(10)	DATE	Entered on
12	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
13	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
14	MODIFIED_DT	Date(10)	DATE	Date Last Modification
15	NOTIFY_INV_MGR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Notify INV MGR Y/N Table Edit Default Value: N
16	NOTIFY_INV_STAT	Character(1)	VARCHAR2(1) NOT NULL	INV MGR Status Y/N Table Edit Default Value: N
17	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	RETURN_SETID	Character(5)	VARCHAR2(5) NOT NULL	RTV (Supplier) SetID
20	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor Prompt Table: VENDOR_RTV_VW
21	RTV_ADJ_FEES	Character(1)	VARCHAR2(1) NOT NULL	RTV Adjust Fees Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.RTV_ADJ_FEES
22	RTV_ADJ_FLG	Character(1)	VARCHAR2(1) NOT NULL	RTV Adjustment Voucher A=Create Adjustment N=No adjustment S=Stage to Pending File
23	RTV_ADJ_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	RTV Adjust Source Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.RTV_ADJ_SOURCE
24	RTV_DEBIT_MEMO	Character(1)	VARCHAR2(1) NOT NULL	RTV Debit Memo Y/N Table Edit
25	RTV_DISPATCH_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Dispatch Method EDX=Electronic Document Exchange EML=Electronic Mail FAX=Fax Transmission PHN=Phone PRN=Print
26	RTV_DISPATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	RTV Dispatch Option 1=Manual 2=Dispatch When Shipped 3=Dispatched 9=Default to Business Unit Default Value: 1
27	RTV_NOTIFY_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Notification Method EML=Electronic Mail PHN=Phone
28	RTV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Return Status C=Closed O=Open S=Shipped X=Cancelled Default Value: O
29	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD_VW
30	VCHR_ADJ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Voucher Adjust Status Y/N Table Edit Default Value: N
31	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_POVW1
32	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
33	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
34	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
35	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
36	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
37	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
38	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
39	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
40	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2