RBTPNLTYST_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for RBT_PNLTY_STEP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 RBT_PNLTY_DEFN Character(6) VARCHAR2(6) NOT NULL Rebate/Penalty Definition
4 EFFDT Date(10) DATE NOT NULL Effective Date
5 BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Price Break ID
6 RBT_STEP_AMT Number(15,3) DECIMAL(14,3) NOT NULL Reward Amount
7 RBT_STEP_AMT_HI Number(15,3) DECIMAL(14,3) NOT NULL Amount Basis High
8 RBT_STEP_AMT_LO Number(15,3) DECIMAL(14,3) NOT NULL Amount Basis Low
9 RBT_STEP_PCT Number(6,2) DECIMAL(5,2) NOT NULL Reward Percent
10 RBT_STEP_PCT_HI Number(6,2) DECIMAL(5,2) NOT NULL Percent Basis High
11 RBT_STEP_PCT_LO Number(6,2) DECIMAL(5,2) NOT NULL Percent Basis Low
12 RBT_STEP_QTY_HI Signed Number(16,4) DECIMAL(14,4) NOT NULL Quantity Basis High
13 RBT_STEP_QTY_LO Signed Number(16,4) DECIMAL(14,4) NOT NULL Quantity Basis Low
14 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code