SRBT_REBATES (SQL Table)	Index Back
Sales Rebate Amounts This record contains calculated sales rebates or penalties amount for each customer per rebate period.

SRBT_REBATES

(SQL Table)

Sales Rebate Amounts

This record contains calculated sales rebates or penalties amount for each customer per rebate period.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SRBT_ID Character(6) VARCHAR2(6) NOT NULL Sales Rebate ID

3 END_DATE Date(10) DATE End Date

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

5 REBATE_AMT Number(16,2) DECIMAL(15,2) NOT NULL Rebate Amount

6 PENALTY_AMT Number(16,2) DECIMAL(15,2) NOT NULL Penalty Amount

7 DO_NOT_RECALC_FLAG Character(1) VARCHAR2(1) NOT NULL Do Not ReCalc
Y/N Table Edit

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

9 RBT_PNLTY_STATUS Character(1) VARCHAR2(1) NOT NULL Rebate Status
A=Approved
I=In Process
P=Pending
R=Granted
X=Canceled

10 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

11 LASTUPDDTTM 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SRBT_ID	Character(6)	VARCHAR2(6) NOT NULL	Sales Rebate ID
3	END_DATE	Date(10)	DATE	End Date
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
5	REBATE_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Rebate Amount
6	PENALTY_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Penalty Amount
7	DO_NOT_RECALC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Do Not ReCalc Y/N Table Edit
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	RBT_PNLTY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rebate Status A=Approved I=In Process P=Pending R=Granted X=Canceled
10	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
11	LASTUPDDTTM	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.