CB_SETOPT_TEO1(SQL Table) |
Index Back |
---|---|
Claimback SetID OptionsClaimback 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 |