FCT_HOG_CRAI_ACCOUNT_EOD_CS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CLOSURE_DATE CHARACTER VARYING(200) 200
2 ACCOUNT_CREATION_DATE CHARACTER VARYING(200) 200
3 ACCOUNT_EFS_DIM_ID CHARACTER VARYING(10) 10
4 APPLICATION_FACILITY_EFS_DIM_ID CHARACTER VARYING(61) 61
5 ACCOUNT_GL_CLOSURE_DATE CHARACTER VARYING(200) 200
6 ACCOUNT_GL_OPENING_DATE CHARACTER VARYING(200) 200
7 ACCOUNT_NUMBER CHARACTER VARYING(10) 10
8 ACCOUNT_OPENING_DATE CHARACTER VARYING(200) 200
9 ACCOUNT_STATUS_CODE CHARACTER VARYING(2) 2
10 ACCOUNT_TITLE CHARACTER VARYING(25) 25
11 ARRANGEMENT_ID CHARACTER VARYING(40) 40
12 BANK_CODE CHARACTER VARYING(10) 10
13 BRANCH_CODE CHARACTER VARYING(4) 4
14 COMPANY_CODE CHARACTER VARYING(5) 5
15 COST_CENTRE_CODE CHARACTER VARYING(150) 150
16 CREATED_BY CHARACTER VARYING(7) 7
17 CURRENCY_CODE CHARACTER VARYING(3) 3
18 FACILITY_ID CHARACTER VARYING(43) 43
19 PRODUCT_CLASS CHARACTER VARYING(3) 3
20 PRODUCT_GROUP_CODE CHARACTER VARYING(3) 3
21 PRODUCT_ID CHARACTER VARYING(2) 2
22 PRODUCT_SUB_CODE CHARACTER VARYING(2) 2
23 LOAN_PURPOSE CHARACTER VARYING(60) 60
24 LOAN_SUB_PURPOSE CHARACTER VARYING(60) 60
25 OWNER_OCCUPIED CHARACTER VARYING(1) 1
26 SERVICE_BRANCH_CODE CHARACTER VARYING(4) 4
27 SOURCE_PRODUCT_CODE CHARACTER VARYING(2) 2
28 OFFSET_ASSOC_ACCT CHARACTER VARYING(20) 20
29 OFFSET_FLAG CHARACTER VARYING(1) 1
30 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
31 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
32 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
33 OF_ENTITY_CODE CHARACTER VARYING(100) 100
34 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(100) 100
35 OF_PRINCIPAL_PRODUCT_CODE CHARACTER VARYING(100) 100
36 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(100) 100
37 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(100) 100
38 OF_INT_ACCRUED_PRODUCT_CODE CHARACTER VARYING(100) 100
39 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(100) 100
40 OF_INT_INCOME_ACCOUNT_CODE CHARACTER VARYING(100) 100
41 OF_INT_INCOME_CATEGORY_CODE CHARACTER VARYING(100) 100
42 OF_INT_INCOME_PRODUCT_CODE CHARACTER VARYING(100) 100
43 OF_INT_EXPENSE_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(100) 100
44 OF_INT_EXPENSE_ACCRUED_PRODUCT_CODE CHARACTER VARYING(100) 100
45 OF_INT_EXPENSE_ACCRUED_CATEGORY_CODE CHARACTER VARYING(100) 100
46 OF_INT_EXPENSE_ACCOUNT_CODE CHARACTER VARYING(100) 100
47 OF_INT_EXPENSE_CATEGORY_CODE CHARACTER VARYING(100) 100
48 OF_INT_EXPENSE_PRODUCT_CODE CHARACTER VARYING(100) 100
49 REVOLVING_CREDIT_FLAG CHARACTER VARYING(1) 1
50 OD_LIMIT CHARACTER VARYING(25) 25
51 OD_INSURED_IND CHARACTER VARYING(1) 1
52 OD_SECURED_FLAG CHARACTER VARYING(1) 1
53 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
54 ACCOUNT_ID_NUMBER CHARACTER VARYING(27) 27
55 SOURCE_PRODUCT_DIM_ID CHARACTER VARYING(10) 10
56 OF_COST_CENTRE_DIM_ID CHARACTER VARYING(150) 150
57 OF_ENTITY_DIM_ID CHARACTER VARYING(100) 100
58 OF_INT_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
59 OF_INT_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
60 OF_INT_ACCRUED_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
61 OF_INT_EXPENSE_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
62 OF_INT_EXPENSE_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
63 OF_INT_EXPENSE_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
64 OF_INT_EXPENSE_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
65 OF_INT_EXPENSE_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
66 OF_INT_EXPENSE_ACCRUED_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
67 OF_PRINCIPAL_ACCOUNT_DIM_ID CHARACTER VARYING(100) 100
68 OF_PRINCIPAL_CATEGORY_DIM_ID CHARACTER VARYING(100) 100
69 OF_PRINCIPAL_PRODUCT_DIM_ID CHARACTER VARYING(100) 100
70 EFFECTIVE_START_DATE CHARACTER VARYING(200) 200
71 PRODUCT_DEBIT_INTEREST_RATE CHARACTER VARYING(25) 25
72 DEBIT_INTEREST_CODE CHARACTER VARYING(2) 2
73 EFFECTIVE_END_DATE CHARACTER VARYING(200) 200
74 IS_CURRENT CHARACTER VARYING(1) 1