RBTPNLTDEF_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for RBT_PNLTY_DEFN

# 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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 RBT_PNLTY_DEFN Character(6) VARCHAR2(6) NOT NULL Rebate/Penalty Definition
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

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

Prompt Table: CURRENCY_CD_TBL

7 MAX_AMOUNT Number(16,4) DECIMAL(15,4) NOT NULL Maximum Amount
8 RBT_AMT_NO_QTY_TYP Character(1) VARCHAR2(1) NOT NULL Amount Type
F=Flat Amount
9 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
10 RBT_BASIS_TYPE Character(1) VARCHAR2(1) NOT NULL Basis Type
A=Amount
N=None
P=Percent
Q=Quantity

Default Value: N

11 RBT_PCT_NO_QTY_TYP Character(1) VARCHAR2(1) NOT NULL Percent Type
A=% of Amount
12 RBT_PCT_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Percent Type
A=% of Amount
L=% of (List - Net) Price
N=% of Net Price
13 RBT_PNLTY_TYPE Character(1) VARCHAR2(1) NOT NULL Reward Type
A=Amount
P=Percent

Default Value: A

14 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code