SRBT_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for SRBT_REBATES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 SRBT_ID Character(6) VARCHAR2(6) NOT NULL Sales Rebate ID
4 END_DATE Date(10) DATE End Date
5 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.
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 DO_NOT_RECALC_FLAG Character(1) VARCHAR2(1) NOT NULL Do Not ReCalc
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 RBT_PNLTY_STATUS Character(1) VARCHAR2(1) NOT NULL Rebate Status
A=Approved
I=In Process
P=Pending
R=Granted
X=Canceled
11 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
12 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.
13 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code