PO_GENCLAIM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	THRU_DATE	Date(10)	DATE	Through Date Default Value: %Date
5	CLAIM_RUN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Claim Run Options 0=All Rebate Agreements 1=Specific Rebate Agreements Default Value: 0
6	VRBT_UNRESTRICT_FL	Character(1)	VARCHAR2(1) NOT NULL	Unrestricted Rebate Manager Default Value: N
7	TOTAL_CLAIM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Amount
8	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID
11	DUP_CHK	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Check
12	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
13	CLAIM_DT	Date(10)	DATE	Claim Date
14	CLAIM_DUE_DT	Date(10)	DATE	Claim Due Date
15	MAX_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Maximum Line Number
16	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
17	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
18	TERM	Number(5,0)	INTEGER NOT NULL	Term
19	VRBT_RULE_ID	Number(5,0)	INTEGER NOT NULL	Vendor Rebate Agreement Rule ID
20	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
21	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
22	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
23	PYMNT_TERMS_CD2	Character(5)	VARCHAR2(5) NOT NULL	Settlement Terms Code used in Vendor Rebate Agreement (For AR)
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
26	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
27	SETTLEMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Vendor Rebate Settlement Method (Payment Method) ACH=Automated Clearing House AV=Adjustment Voucher CHK=Check CM=Credit Memo DD=Direct Debit DR=Draft EFT=Electronic Funds Transfer
28	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
29	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
30	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
31	VRBT_BEGIN_DT	Date(10)	DATE	Vendor Rebate Agreement Begin Date
32	VRBT_EXPIRE_DT	Date(10)	DATE	Vendor Rebate Agreement Expire Date
33	NEXT_CLAIMS_GEN_DT	Date(10)	DATE	Next Claims Generation Date
34	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
35	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit