CBSETOPT_TEO2(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
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 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. "
Prompt Table: CURRENCY_CD_TBL |
| 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.
Prompt Table: RT_TYPE_TBL |
| 9 | CB_MANAGER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Claimback Mgr ID
Prompt Table: CB_USER_SEC_VW |
| 10 | CB_MANAGER_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Notify Claimback Manager
Y/N Table Edit Default Value: Y |
| 11 | CB_SETTLE_MGR | Character(30) | VARCHAR2(30) NOT NULL |
Claimback Settlement Manager ID
Prompt Table: CB_SETMGDEFN_VW |
| 12 | CB_SETTLE_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Notify Settlement Manager
Y/N Table Edit Default Value: Y |
| 13 | CB_CONTRACT_PREFIX | Character(3) | VARCHAR2(3) NOT NULL |
Claimback Contract Prefix
Prompt Table: CB_CNTRCTSEQ_VW |
| 14 | CB_CLAIM_PREFIX | Character(3) | VARCHAR2(3) NOT NULL |
Claim Prefix
Prompt Table: CB_CLAIMSEQ_VW |
| 15 | SCHEDULE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table: SCHEDULE_TBL |
| 16 | CB_APPLY_SOE | Character(1) | VARCHAR2(1) NOT NULL |
Automatically Apply
F=First To Expire L=Largest Claimback Amount N=None Default Value: L |
| 17 | CB_STOP_AT_MAX | Character(1) | VARCHAR2(1) NOT NULL |
Stop Apply At Max Quantity
Y/N Table Edit Default Value: N |
| 18 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |