FCT_BNK_DEP_INT_ADJUSTMENT_RPT_INSIGHT
Description
CASA and TD Accounts with Interest Adjustments with branch and user where fee was charged due to error and hence needs to be refunded
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_TYPE | CHARACTER VARYING(4) | 4 |
| 2 | ACCOUNT_NAME | CHARACTER VARYING(500) | 500 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | ACCOUNT_BRANCH_CODE | CHARACTER VARYING(10) | 10 |
| 5 | INTEREST_ADJUSTMENT_DATE | TIMESTAMP | 8 |
| 6 | USER_ID | CHARACTER VARYING(254) | 254 |
| 7 | APPROVER_ID | CHARACTER VARYING(254) | 254 |
| 8 | OPERATION | CHARACTER VARYING(50) | 50 |
| 9 | INTEREST_CLASS | CHARACTER VARYING(50) | 50 |
| 10 | INTEREST_DIVISION | CHARACTER VARYING(50) | 50 |
| 11 | ADJUSTMENT_AMOUNT | DOUBLE PRECISION | 8 |
| 12 | ADJUSTMENT_REASON | CHARACTER VARYING(300) | 300 |
| 13 | REGION | CHARACTER VARYING(240) | 240 |
| 14 | OFFER_NAME | CHARACTER VARYING(120) | 120 |
| 15 | ACCOUNT_STATUS | CHARACTER VARYING(40) | 40 |
| 16 | BRANCH_NUMBER | CHARACTER VARYING(10) | 10 |
| 17 | BRANCH_NAME | CHARACTER VARYING(105) | 105 |
| 18 | BRANCH_NUM_NM | CHARACTER VARYING(118) | 118 |