FCT_ATOCRS_ACCOUNT_BALANCE_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 EXTRACT_DATE TIMESTAMP 8
2 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(12) 12
3 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
4 DATE_OPEN TIMESTAMP 8
5 DATE_CLOSED TIMESTAMP 8
6 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
7 YTD_DATE TIMESTAMP 8
8 YTD_COMPLETION CHARACTER VARYING(8) 8
9 FATCA_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
10 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
11 OPEN_BALANCE_YTD NUMERIC(38,8) 19
12 OPEN_BALANCE_YTD_AUD NUMERIC(38,15) 19
13 OPEN_BALANCE_YTD_USD NUMERIC(38,23) 19
14 FATCA_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
15 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
16 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
17 CRS_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
18 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
19 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
20 CREDIT_INTEREST_CALENDAR_YTD NUMERIC(38,4) 19
21 CREDIT_INTEREST_CALENDAR_YTD_AUD NUMERIC(38,14) 19
22 CREDIT_INTEREST_CALENDAR_YTD_USD NUMERIC(38,22) 19
23 PRE_FATCA_BALANCE NUMERIC(28,8) 19
24 PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
25 PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
26 PRE_CRS_BALANCE NUMERIC(38,8) 19
27 PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
28 PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
29 CURRENT_BALANCE NUMERIC(38,8) 19
30 CURRENT_BALANCE_AUD NUMERIC(38,15) 19
31 CURRENT_BALANCE_USD NUMERIC(38,23) 19
32 FATCA_CLOSED_BALANCE NUMERIC(38,8) 19
33 FATCA_CLOSED_BALANCE_AUD NUMERIC(38,15) 19
34 FATCA_CLOSED_BALANCE_USD NUMERIC(38,23) 19
35 CRS_CLOSED_BALANCE NUMERIC(38,8) 19
36 CRS_CLOSED_BALANCE_AUD NUMERIC(38,15) 19
37 CRS_CLOSED_BALANCE_USD NUMERIC(38,23) 19
38 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
39 DATA_SOURCE CHARACTER VARYING(41) 41