RECV_HDR_ACT_C

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	COMPARE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Compare report type 1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results
3	COMPARE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Compare data source (Actuals or Expected results). A=Actuals E=Expected
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
6	DUE_DT	Date(10)	DATE NOT NULL	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.
7	ENTERED_DT	Date(10)	DATE	Entered on Default Value: %date
8	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
9	SIGNED_OFF	Character(1)	VARCHAR2(1) NOT NULL	Signed Off Y/N Table Edit Default Value: N
10	SIGNED_DT	Date(10)	DATE	Signed Date
11	OPRID_SIGNED_BY	Character(30)	VARCHAR2(30) NOT NULL	Signed By
12	COMMENTS_LONG	Long Character	CLOB	Comment Text