FCT_HOG_EFS_ACCOUNT_EOD_TD_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..FCT_HOG_EFS_ACCOUNT_EOD_TD

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(24) 24
7 ACCOUNT_OPENING_DATE TIMESTAMP 8
8 ACCOUNT_STATUS_CODE CHARACTER VARYING(2) 2
9 ACCOUNT_TITLE CHARACTER VARYING(25) 25
10 ARRANGEMENT_ID CHARACTER VARYING(40) 40
11 BANK_CODE CHARACTER VARYING(10) 10
12 BRANCH_CODE CHARACTER VARYING(4) 4
13 COMPANY_CODE CHARACTER VARYING(5) 5
14 COST_CENTRE_CODE CHARACTER VARYING(150) 150
15 CREATED_BY CHARACTER VARYING(7) 7
16 CURRENCY_CODE CHARACTER VARYING(3) 3
17 DEPOSIT_DATE TIMESTAMP 8
18 EFFECTIVE_END_DATE TIMESTAMP 8
19 EFFECTIVE_START_DATE TIMESTAMP 8
20 MATURITY_DATE TIMESTAMP 8
21 OFFER_ID CHARACTER VARYING(30) 30
22 OFFSET_FLAG CHARACTER VARYING(1) 1
23 OFFSET_ASSOC_ACCT CHARACTER VARYING(20) 20
24 ORIGINAL_MATURITY_DATE TIMESTAMP 8
25 PRODUCT_CLASS CHARACTER VARYING(2) 2
26 PRODUCT_GROUP_CODE CHARACTER VARYING(3) 3
27 PRODUCT_ID CHARACTER VARYING(3) 3
28 PRODUCT_SUB_CODE CHARACTER VARYING(2) 2
29 RENEW_COUNT INTEGER 4
30 SERVICE_BRANCH_CODE CHARACTER VARYING(4) 4
31 SOURCE_PRODUCT_CODE CHARACTER VARYING(2) 2
32 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
33 TERM_MONTHS BIGINT 8
34 OF_COST_CENTRE_CODE CHARACTER VARYING(240) 240
35 OF_ENTITY_CODE CHARACTER VARYING(100) 100
36 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(20) 20
37 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(20) 20
38 OF_INT_EXPENSE_ACCOUNT_CODE CHARACTER VARYING(100) 100
39 OF_INT_EXPENSE_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(100) 100
40 OF_INT_EXPENSE_ACCRUED_CATEGORY_CODE CHARACTER VARYING(100) 100
41 OF_INT_EXPENSE_CATEGORY_CODE CHARACTER VARYING(100) 100
42 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(100) 100
43 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(100) 100
44 OF_PRODUCT_CODE CHARACTER VARYING(100) 100
45 SOURCE_PRODUCT_DIM_ID BIGINT 8
46 OF_COST_CENTRE_DIM_ID CHARACTER VARYING(240) 240
47 OF_ENTITY_DIM_ID CHARACTER VARYING(100) 100
48 OF_INT_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(20) 20
49 OF_INT_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(20) 20
50 OF_INT_EXPENSE_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
51 OF_INT_EXPENSE_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
52 OF_INT_EXPENSE_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
53 OF_INT_EXPENSE_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
54 OF_PRINCIPAL_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
55 OF_PRINCIPAL_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
56 OF_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
57 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
58 ACCOUNT_ID_NUMBER CHARACTER VARYING(27) 27
59 IS_CURRENT CHARACTER VARYING(1) 1