FCT_BNK_EFS_ACCOUNT_EOD_CS_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CLOSURE_DATE DATE 4
2 ACCOUNT_CREATION_DATE DATE 4
3 ACCOUNT_EFS_DIM_ID BIGINT 8
4 ACCOUNT_GL_CLOSURE_DATE TIMESTAMP 8
5 ACCOUNT_GL_OPENING_DATE TIMESTAMP 8
6 ACCOUNT_NUMBER BIGINT 8
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 EFFECTIVE_START_DATE TIMESTAMP 8
18 EFFECTIVE_END_DATE TIMESTAMP 8
19 FACILITY_ID CHARACTER VARYING(43) 43
20 IS_CURRENT CHARACTER VARYING(1) 1
21 PRODUCT_CLASS CHARACTER VARYING(3) 3
22 PRODUCT_GROUP_CODE CHARACTER VARYING(3) 3
23 PRODUCT_ID CHARACTER VARYING(2) 2
24 PRODUCT_SUB_CODE CHARACTER VARYING(2) 2
25 SERVICE_BRANCH_CODE CHARACTER VARYING(4) 4
26 SOURCE_PRODUCT_CODE CHARACTER VARYING(2) 2
27 OFFSET_ASSOC_ACCT CHARACTER VARYING(20) 20
28 OFFSET_FLAG CHARACTER VARYING(1) 1
29 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
30 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
31 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
32 OF_ENTITY_CODE CHARACTER VARYING(100) 100
33 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(100) 100
34 OF_PRINCIPAL_PRODUCT_CODE CHARACTER VARYING(100) 100
35 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(100) 100
36 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(100) 100
37 OF_INT_ACCRUED_PRODUCT_CODE CHARACTER VARYING(100) 100
38 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(100) 100
39 OF_INT_INCOME_ACCOUNT_CODE CHARACTER VARYING(100) 100
40 OF_INT_INCOME_CATEGORY_CODE CHARACTER VARYING(100) 100
41 OF_INT_INCOME_PRODUCT_CODE CHARACTER VARYING(100) 100
42 OF_INT_EXPENSE_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(100) 100
43 OF_INT_EXPENSE_ACCRUED_PRODUCT_CODE CHARACTER VARYING(100) 100
44 OF_INT_EXPENSE_ACCRUED_CATEGORY_CODE CHARACTER VARYING(100) 100
45 OF_INT_EXPENSE_ACCOUNT_CODE CHARACTER VARYING(100) 100
46 OF_INT_EXPENSE_CATEGORY_CODE CHARACTER VARYING(100) 100
47 OF_INT_EXPENSE_PRODUCT_CODE CHARACTER VARYING(100) 100
48 REVOLVING_CREDIT_FLAG CHARACTER VARYING(1) 1
49 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
50 ACCOUNT_ID_NUMBER CHARACTER VARYING(27) 27
51 SOURCE_PRODUCT_DIM_ID BIGINT 8
52 OF_COST_CENTRE_DIM_ID CHARACTER VARYING(150) 150
53 OF_ENTITY_DIM_ID CHARACTER VARYING(100) 100
54 OF_INT_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
55 OF_INT_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
56 OF_INT_ACCRUED_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
57 OF_INT_EXPENSE_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
58 OF_INT_EXPENSE_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
59 OF_INT_EXPENSE_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
60 OF_INT_EXPENSE_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
61 OF_INT_EXPENSE_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
62 OF_INT_EXPENSE_ACCRUED_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
63 OF_PRINCIPAL_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
64 OF_PRINCIPAL_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
65 OF_PRINCIPAL_PRODUCT_DIM_ID CHARACTER VARYING(100) 100