VRBT_HDR (SQL Table)	Index Back
Supplier Rebate Agreement Head Supplier Rebate Agreement Header

VRBT_HDR

(SQL Table)

Supplier Rebate Agreement Head

Supplier Rebate Agreement Header

Parent Record Of VRBT_ACTIVITY VRBT_BU VRBT_LINE VRBT_RULE VRBT_VNDR_LOC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
Default Value: NEXT

3 VRBT_STATUS Character(2) VARCHAR2(2) NOT NULL Vendor Rebate Status
A=Approved
C=Closed
H=Hold
O=Open
X=Cancelled
Default Value: O

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_PO_VW
Set Control Field: VENDOR_SETID

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
Prompt Table: VENDOR_LOC_VW
Set Control Field: VENDOR_SETID

7 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
Prompt Table: VNDR_CNTCTSETVW

8 VRBT_BEGIN_DT Date(10) DATE NOT NULL Vendor Rebate Agreement Begin Date
Default Value: %date

9 VRBT_EXPIRE_DT Date(10) DATE Vendor Rebate Agreement Expire Date

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: CNTRCT_CONTROL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

11 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: CNTRCT_CONTROL.CUR_RT_TYPE
Prompt Table: RT_TYPE_TBL

12 VRBT_REFERENCE Character(30) VARCHAR2(30) NOT NULL Vendor Rebate Reference

13 DESCR Character(30) VARCHAR2(30) NOT NULL Description

14 REBATE_MGR Character(30) VARCHAR2(30) NOT NULL Rebate Manager
Prompt Table: VRBT_ADDAUTH_VW

15 SETTLEMENT_MGR Character(30) VARCHAR2(30) NOT NULL Settlement Manager
Prompt Table: PO_OPRDEFN_VW

16 AMT_CLAIM_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Rebate Amount

17 TOTAL_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Accrued Rebate

18 TOTAL_REBATE_RECVD Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Rebate Payment Received

19 TOTAL_CLAIM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount

20 VRBT_CORP_FLG Character(1) VARCHAR2(1) NOT NULL Vendor Rebate Agreement Corporate Flag
Y/N Table Edit
Default Value: Y

21 ALLOW_OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Open Item Rebate Agreement
N=No
Y=Yes
Y/N Table Edit
Default Value: N

22 ORDER_BY_DESCR Character(1) VARCHAR2(1) NOT NULL Allow Order by Description
Y/N Table Edit
Default Value: N

23 VRBT_RTV_REDUCT Character(1) VARCHAR2(1) NOT NULL Vendor Rebate Reduction from RTV flag
Y/N Table Edit
Default Value: Y

24 INC_VOUCHER_ONLY Character(1) VARCHAR2(1) NOT NULL Include Vouchered Trans Only
Y/N Table Edit
Default Value: N

25 DIRECT_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Include Direct Shipments Direct Shipments Only Exclude Direct Shipments
1=Include Direct Shipments
2=Direct Shipments Only
3=Exclude Direct Shipments
Default Value: 1

26 TOL_AMT_OVER Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Tolerance Over

27 TOL_AMT_UNDER Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Tolerance Under

28 TOL_PCT_OVER Number(6,2) DECIMAL(5,2) NOT NULL Percentage Tolerance Over

29 TOL_PCT_UNDER Number(6,2) DECIMAL(5,2) NOT NULL Percentage Tolerance Under

30 VRBT_DISPATCH_MTHD Character(3) VARCHAR2(3) NOT NULL Vendor Rebate Agreement Dispatch Method
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
Default Value: PRN

31 USE_REBATE_RTDT Character(1) VARCHAR2(1) NOT NULL Must Use Rebate Rate Date
Y/N Table Edit
Default Value: N

32 RATE_DATE Date(10) DATE Exchange Rate Date
Default Value: %date

33 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
Prompt Table: SP_BU_AP_NONVW

34 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
Prompt Table: SP_BUARDS_NONVW

35 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: SP_BUPRCR_NONVW

36 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

37 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
Prompt Table: SCHEDULE_TBL

38 NEXT_CLAIMS_GEN_DT Date(10) DATE NOT NULL Next Claims Generation Date

39 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

40 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.
Prompt Table: AR_TRMS_VW1

41 PYMNT_TERMS_CD2 Character(5) VARCHAR2(5) NOT NULL Settlement Terms Code used in Vendor Rebate Agreement (For AR)
Prompt Table: PYMT_TRMS_VW

42 NOTIFY_STLMENT_MGR Character(1) VARCHAR2(1) NOT NULL Notify Settlement Manager
Y/N Table Edit
Default Value: N

43 NOTIFY_REBATE_MGR Character(1) VARCHAR2(1) NOT NULL Notify Rebate Manager
Y/N Table Edit
Default Value: N

44 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Default Value: 0

45 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Y/N Table Edit
Default Value: N

46 MARK_FOR_DEL_FLG Character(1) VARCHAR2(1) NOT NULL Mark for Delete flag on Vendor Rebate.
Y/N Table Edit
Default Value: N

47 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID
Prompt Table: CNTRCT_MSTR_VW

48 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

49 ENTERED_DT Date(10) DATE NOT NULL Entered on
Default Value: %date

50 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

51 APPROVAL_DT Date(10) DATE Date of Approval

52 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.

53 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID Default Value: NEXT
3	VRBT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Vendor Rebate Status A=Approved C=Closed H=Hold O=Open X=Cancelled Default Value: O
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PO_VW Set Control Field: VENDOR_SETID
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VENDOR_LOC_VW Set Control Field: VENDOR_SETID
7	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VNDR_CNTCTSETVW
8	VRBT_BEGIN_DT	Date(10)	DATE NOT NULL	Vendor Rebate Agreement Begin Date Default Value: %date
9	VRBT_EXPIRE_DT	Date(10)	DATE	Vendor Rebate Agreement Expire Date
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CNTRCT_CONTROL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
11	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: CNTRCT_CONTROL.CUR_RT_TYPE Prompt Table: RT_TYPE_TBL
12	VRBT_REFERENCE	Character(30)	VARCHAR2(30) NOT NULL	Vendor Rebate Reference
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	REBATE_MGR	Character(30)	VARCHAR2(30) NOT NULL	Rebate Manager Prompt Table: VRBT_ADDAUTH_VW
15	SETTLEMENT_MGR	Character(30)	VARCHAR2(30) NOT NULL	Settlement Manager Prompt Table: PO_OPRDEFN_VW
16	AMT_CLAIM_MAX	Number(27,3)	DECIMAL(26,3) NOT NULL	Maximum Rebate Amount
17	TOTAL_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Accrued Rebate
18	TOTAL_REBATE_RECVD	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Rebate Payment Received
19	TOTAL_CLAIM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Claim Amount
20	VRBT_CORP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Rebate Agreement Corporate Flag Y/N Table Edit Default Value: Y
21	ALLOW_OPEN_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Open Item Rebate Agreement N=No Y=Yes Y/N Table Edit Default Value: N
22	ORDER_BY_DESCR	Character(1)	VARCHAR2(1) NOT NULL	Allow Order by Description Y/N Table Edit Default Value: N
23	VRBT_RTV_REDUCT	Character(1)	VARCHAR2(1) NOT NULL	Vendor Rebate Reduction from RTV flag Y/N Table Edit Default Value: Y
24	INC_VOUCHER_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Include Vouchered Trans Only Y/N Table Edit Default Value: N
25	DIRECT_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Include Direct Shipments Direct Shipments Only Exclude Direct Shipments 1=Include Direct Shipments 2=Direct Shipments Only 3=Exclude Direct Shipments Default Value: 1
26	TOL_AMT_OVER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Tolerance Over
27	TOL_AMT_UNDER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Tolerance Under
28	TOL_PCT_OVER	Number(6,2)	DECIMAL(5,2) NOT NULL	Percentage Tolerance Over
29	TOL_PCT_UNDER	Number(6,2)	DECIMAL(5,2) NOT NULL	Percentage Tolerance Under
30	VRBT_DISPATCH_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Vendor Rebate Agreement Dispatch Method EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print Default Value: PRN
31	USE_REBATE_RTDT	Character(1)	VARCHAR2(1) NOT NULL	Must Use Rebate Rate Date Y/N Table Edit Default Value: N
32	RATE_DATE	Date(10)	DATE	Exchange Rate Date Default Value: %date
33	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit Prompt Table: SP_BU_AP_NONVW
34	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit Prompt Table: SP_BUARDS_NONVW
35	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
36	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
37	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID Prompt Table: SCHEDULE_TBL
38	NEXT_CLAIMS_GEN_DT	Date(10)	DATE NOT NULL	Next Claims Generation Date
39	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
40	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. Prompt Table: AR_TRMS_VW1
41	PYMNT_TERMS_CD2	Character(5)	VARCHAR2(5) NOT NULL	Settlement Terms Code used in Vendor Rebate Agreement (For AR) Prompt Table: PYMT_TRMS_VW
42	NOTIFY_STLMENT_MGR	Character(1)	VARCHAR2(1) NOT NULL	Notify Settlement Manager Y/N Table Edit Default Value: N
43	NOTIFY_REBATE_MGR	Character(1)	VARCHAR2(1) NOT NULL	Notify Rebate Manager Y/N Table Edit Default Value: N
44	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: 0
45	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
46	MARK_FOR_DEL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mark for Delete flag on Vendor Rebate. Y/N Table Edit Default Value: N
47	MSTR_CNTRCT_ID	Character(10)	VARCHAR2(10) NOT NULL	Master Contract ID Prompt Table: CNTRCT_MSTR_VW
48	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
49	ENTERED_DT	Date(10)	DATE NOT NULL	Entered on Default Value: %date
50	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
51	APPROVAL_DT	Date(10)	DATE	Date of Approval
52	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.
53	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.