INT_BNK_DEPOSIT_ACCOUNTS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | EXTRACT_DATE | DATE | 4 |
| 2 | SOURCE_SYSTEM_CODE | CHARACTER VARYING(12) | 12 |
| 3 | ACCOUNT_DIM_ID | BIGINT | 8 |
| 4 | BANK_PRODUCT_HOLDING_NUMBER | CHARACTER VARYING(20) | 20 |
| 5 | ACCOUNT_STATUS | CHARACTER VARYING(6) | 6 |
| 6 | DATE_OPEN | TIMESTAMP | 8 |
| 7 | DATE_CLOSED | TIMESTAMP | 8 |
| 8 | SOURCE_PRODUCT_DIM_ID | BIGINT | 8 |
| 9 | BALANCE_PRE_FATCA | NUMERIC(14,2) | 19 |
| 10 | OPEN_BALANCE_YTD | NUMERIC(14,2) | 19 |
| 11 | BALANCE | NUMERIC(14,2) | 19 |
| 12 | PERIOD_DIM_ID | BIGINT | 8 |
| 13 | CLOSED_DIM_ID | INTEGER | 4 |
| 14 | ONGOING_ACCT_FLAG | CHARACTER VARYING(1) | 1 |