FCT_BNK_EFS_ACCOUNT_EOD_TD

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BNK_EFS_ACCOUNT_EOD_TD_V

Columns
# Name Data Type Length
1 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
2 ACCOUNT_CREATION_DATE TIMESTAMP 8
3 ACCOUNT_EFS_DIM_ID BIGINT 8
4 ACCOUNT_GL_CLOSURE_DATE TIMESTAMP 8
5 ACCOUNT_GL_OPENING_DATE TIMESTAMP 8
6 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
7 ACCOUNT_ID_NUMBER CHARACTER VARYING(37) 37
8 ACCOUNT_OPENING_DATE TIMESTAMP 8
9 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
10 ACCOUNT_TITLE CHARACTER VARYING(300) 300
11 DEPOSIT_NUMBER CHARACTER VARYING(20) 20
12 DEPOSIT_DATE TIMESTAMP 8
13 DEPOSIT_CLOSING_DATE TIMESTAMP 8
14 RENEW_COUNT DOUBLE PRECISION 8
15 PARENT_DEPOSIT_NUMBER CHARACTER VARYING(20) 20
16 ARRANGEMENT_ID CHARACTER VARYING(40) 40
17 BANK_CODE CHARACTER VARYING(10) 10
18 BRANCH_CODE CHARACTER VARYING(10) 10
19 COMPANY_CODE CHARACTER VARYING(5) 5
20 COST_CENTRE_CODE CHARACTER VARYING(150) 150
21 CREATED_BY CHARACTER VARYING(254) 254
22 CURRENCY_CODE CHARACTER VARYING(3) 3
23 EFFECTIVE_END_DATE TIMESTAMP 8
24 EFFECTIVE_START_DATE TIMESTAMP 8
25 IS_CURRENT CHARACTER VARYING(1) 1
26 MATURITY_DATE TIMESTAMP 8
27 OFFER_ID CHARACTER VARYING(30) 30
28 OFFSET_FLAG CHARACTER VARYING(1) 1
29 OFFSET_ASSOC_ACCT CHARACTER VARYING(20) 20
30 ORIGINAL_MATURITY_DATE TIMESTAMP 8
31 PRODUCT_CLASS CHARACTER VARYING(2) 2
32 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
33 PRODUCT_SUB_CODE CHARACTER VARYING(30) 30
34 PRODUCT_ID CHARACTER VARYING(30) 30
35 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
36 SOURCE_PRODUCT_CODE CHARACTER VARYING(61) 61
37 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
38 TERM_MONTHS DOUBLE PRECISION 8
39 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
40 OF_COST_CENTRE_CODE CHARACTER VARYING(240) 240
41 OF_ENTITY_CODE CHARACTER VARYING(240) 240
42 OF_PRODUCT_CODE CHARACTER VARYING(240) 240
43 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(240) 240
44 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(240) 240
45 OF_INT_EXPENSE_ACCOUNT_CODE CHARACTER VARYING(240) 240
46 OF_INT_EXPENSE_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(240) 240
47 OF_INT_EXPENSE_ACCRUED_CATEGORY_CODE CHARACTER VARYING(240) 240
48 OF_INT_EXPENSE_CATEGORY_CODE CHARACTER VARYING(240) 240
49 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(240) 240
50 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(240) 240
51 SOURCE_PRODUCT_DIM_ID BIGINT 8
52 OF_COST_CENTRE_DIM_ID CHARACTER VARYING(240) 240
53 OF_ENTITY_DIM_ID CHARACTER VARYING(240) 240
54 OF_INT_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(240) 240
55 OF_INT_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(240) 240
56 OF_INT_EXPENSE_ACCOUNT_DIM_ID CHARACTER VARYING(240) 240
57 OF_INT_EXPENSE_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(240) 240
58 OF_INT_EXPENSE_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(240) 240
59 OF_INT_EXPENSE_CATEGORY_DIM_ID CHARACTER VARYING(240) 240
60 OF_PRINCIPAL_ACCOUNT_DIM_ID CHARACTER VARYING(240) 240
61 OF_PRINCIPAL_CATEGORY_DIM_ID CHARACTER VARYING(240) 240
62 OF_PRODUCT_DIM_ID CHARACTER VARYING(240) 240