SCON_REBATES (SQL Table)	Index Back
Sales Contract Rebates

SCON_REBATES

(SQL Table)

Sales Contract Rebates

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

5 DO_NOT_RECALC_FLAG Character(1) VARCHAR2(1) NOT NULL Do Not ReCalc
Y/N Table Edit
Default Value: N

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

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

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
5	DO_NOT_RECALC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Do Not ReCalc Y/N Table Edit Default Value: N
6	REBATE_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Rebate Amount
7	PENALTY_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Penalty Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
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.