VRA_ACCRSUM_SCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID
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	VRBT_TRANS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Transaction Type PREV=Previous Period RCV=Receipt RTV=Return To Vendor (Supplier) VCHR=Voucher
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	DOC_ID	Character(50)	VARCHAR2(50) NOT NULL	ID
10	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
11	RECV_SHIP_SEQ	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
12	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
13	VRBT_RULE_ID	Number(5,0)	INTEGER NOT NULL	Vendor Rebate Agreement Rule ID
14	VRBT_RULE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Vendor Rebate Agreement Rule Type: There are 5 types of Rebate Rules 1) Stepped/Standard, 2) Market Contribution, 3) Growth Bonus., 4) Flat Rebate,5) Retrospective F=Flat Amount G=Growth Bonus M=Marketing Contribution R=Retrospective S=Stepped/Standard
15	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
16	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
17	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
18	VRBT_TRANS_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Vendor Rebate Accrual Status RECV=Received RTRN=Returned VCHR=Vouchered
19	VRBT_ACCR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rebate Accrual Status C=Complete E=Error I=In Process
20	TRANS_DATE	Date(10)	DATE	Transaction Date
21	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
22	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
23	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
24	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
25	CLAIM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Claim Status 1=Open 3=Approved 5=Deferred 6=Cancelled 7=Pending Payment 8=Partially Paid 9=Paid
26	TOTAL_CLAIM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Amount
27	TOTAL_CLAIMED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claimed Amount
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
30	REBATE_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Rebate Unit A=Amount Q=Quantity
31	RBTABLE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Rebateable Amount
32	RBTABLE_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Rebateable Quantity
33	UNIT_MEASURE_VRBT	Character(3)	VARCHAR2(3) NOT NULL	Vendor Rebate UOM
34	REBATE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Rebate Amount
35	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
36	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
37	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
38	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
39	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
40	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
41	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
42	BUSINESS_UNIT_RTV	Character(5)	VARCHAR2(5) NOT NULL	RTV Business Unit
43	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
44	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
45	ACCEPTED_QTY_VRBT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Accepted Quantity - Rebate UOM