SETIDDefault Value: OPR_DEF_TBL_FS.SETID
SCENARIOFA_FEE_CODEFA_CHARGE_COMP(SQL Table) |
Index Back |
|---|---|
Fee structure comparison.This record contains service charges for 2 different fee structures. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca |
| 3 | FA_FEE_CODE |
Character(20) | VARCHAR2(20) NOT NULL | Fee code mapped to Bank Fee code used for Fee Analysis. |
| 4 | FA_FEE_COUNT | Signed Number(16,0) | DECIMAL(15) NOT NULL | Item count as reported by the bank on the Fee Analysis Statement |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | FA_SVC_CHARGE_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge for Structure 1 |
| 7 | FA_SVC_CHARGE_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge for Structure 2 |
| 8 | FA_SVC_CHARGE_3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge for Structure 3 |
| 9 | FA_SVC_CHARGE_4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge for Structure 4 |
| 10 | FA_SVC_CHARGE_5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Service Charge for Structure 5 |
| 11 | FA_CHARGE_DIFF | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Charge Difference |