SRBT_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_OM_NONVW
3	SRBT_ID	Character(6)	VARCHAR2(6) NOT NULL	Sales Rebate ID
4	END_DATE	Date(10)	DATE	End Date
5	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
6	REBATE_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Rebate Amount
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	BASIS_AMT_OM	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Withholding Basis Amount
9	BASIS_PCT	Number(6,1)	DECIMAL(5,1) NOT NULL	Basis Percent
10	BASIS_QTY	Number(15,4)	DECIMAL(14,4) NOT NULL	Basis Quantity
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	REBATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Rebate Flag
13	RBT_PNLTY_DEFN	Character(6)	VARCHAR2(6) NOT NULL	Rebate/Penalty Definition
14	QTY_MAX	Number(16,4)	DECIMAL(15,4) NOT NULL	Maximum Quantity
15	RBT_AMT_NO_QTY_TYP	Character(1)	VARCHAR2(1) NOT NULL	Amount Type F=Flat Amount
16	RBT_AMT_QTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Amount Type F=Flat Amount L=(List - Net) Price N=Net Price U=Flat Amount per Unit
17	RBT_BASIS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Basis Type A=Amount N=None P=Percent Q=Quantity
18	RBT_PCT_NO_QTY_TYP	Character(1)	VARCHAR2(1) NOT NULL	Percent Type A=% of Amount
19	RBT_PCT_QTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Percent Type A=% of Amount L=% of (List - Net) Price N=% of Net Price
20	RBT_PNLTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Reward Type A=Amount P=Percent
21	QUALIFIED_BASE	Character(1)	VARCHAR2(1) NOT NULL	Qualified Base A=Current Sales Amount/Qty C=Agreement or Previous Amt/Qty D=Amount/Qty Difference
22	MAX_AMOUNT	Number(16,4)	DECIMAL(15,4) NOT NULL	Maximum Amount
23	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
24	AMT_CNTRCT_MAX	Number(27,3)	DECIMAL(26,3) NOT NULL	Maximum Amount of Contract.