CB_SETOPT_TEO1

(SQL Table)
Index Back

Claimback SetID Options

Claimback SetID Options & Defaults

# 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 TOL_AMT_OVER Signed Number(28,3) DECIMAL(26,3) NOT NULL Over Tolerance Amount
4 TOL_AMT_UNDER Signed Number(28,3) DECIMAL(26,3) NOT NULL Under Tolerance Amount
5 TOL_PCT_OVER Number(6,2) DECIMAL(5,2) NOT NULL Over Tolerance Percent
6 TOL_PCT_UNDER Number(6,2) DECIMAL(5,2) NOT NULL Under Tolerance Percent
7 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
8 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
9 CB_MANAGER_ID Character(30) VARCHAR2(30) NOT NULL Claimback Mgr ID
10 CB_MANAGER_NOTIFY Character(1) VARCHAR2(1) NOT NULL Notify Claimback Manager
11 CB_SETTLE_MGR Character(30) VARCHAR2(30) NOT NULL Claimback Settlement Manager ID
12 CB_SETTLE_NOTIFY Character(1) VARCHAR2(1) NOT NULL Notify Settlement Manager
13 CB_CONTRACT_PREFIX Character(3) VARCHAR2(3) NOT NULL Claimback Contract Prefix
14 CB_CLAIM_PREFIX Character(3) VARCHAR2(3) NOT NULL Claim Prefix
15 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID
16 CB_APPLY_SOE Character(1) VARCHAR2(1) NOT NULL Automatically Apply
F=First To Expire
L=Largest Claimback Amount
N=None
17 CB_STOP_AT_MAX Character(1) VARCHAR2(1) NOT NULL Stop Apply At Max Quantity
18 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code