FCT_OBP_CRAI_ACCOUNT_EOD_LN

Database

SDSNZP05_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(25) 25
4 ACCOUNT_GL_CLOSURE_DATE CHARACTER VARYING(200) 200
5 ACCOUNT_GL_OPENING_DATE CHARACTER VARYING(200) 200
6 ACCOUNT_ID_NUMBER CHARACTER VARYING(24) 24
7 APPLICATION_FACILITY_EFS_DIM_ID CHARACTER VARYING(93) 93
8 ACCOUNT_NUMBER CHARACTER VARYING(24) 24
9 ACCOUNT_OPENING_DATE CHARACTER VARYING(200) 200
10 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
11 ACCOUNT_TITLE CHARACTER VARYING(300) 300
12 ACCREDITED_BROKER_CODE CHARACTER VARYING(20) 20
13 APPROVED_AMOUNT CHARACTER VARYING(25) 25
14 ARRANGEMENT_ID CHARACTER VARYING(40) 40
15 BANK_CODE CHARACTER VARYING(10) 10
16 BASE_RATE CHARACTER VARYING(25) 25
17 BROKER_ID CHARACTER VARYING(20) 20
18 COST_CENTRE_CODE CHARACTER VARYING(150) 150
19 COMPANY_CODE CHARACTER VARYING(100) 100
20 CURRENCY_CODE CHARACTER VARYING(3) 3
21 CURRENT_INTEREST_RATE CHARACTER VARYING(25) 25
22 FACILITY_ID CHARACTER VARYING(40) 40
23 FIRST_DISBURSEMENT_DATE CHARACTER VARYING(200) 200
24 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(1) 1
25 FIXED_TERM_MONTHS CHARACTER VARYING(25) 25
26 FIXED_PERIOD_END_DATE CHARACTER VARYING(200) 200
27 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
28 FV_FLAG CHARACTER VARYING(1) 1
29 COLLATERALISATION CHARACTER VARYING(17) 17
30 LINKED_OFFSET_ACCOUNT_FLAG CHARACTER VARYING(1) 1
31 INTEREST_RATE_TERM CHARACTER VARYING(10) 10
32 LOAN_PURPOSE CHARACTER VARYING(40) 40
33 LOAN_SUB_PURPOSE CHARACTER VARYING(10) 10
34 LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
35 LOAN_TO_VALUE_RATIO CHARACTER VARYING(25) 25
36 LOWDOC_FLAG CHARACTER VARYING(1) 1
37 MARGIN_RATE CHARACTER VARYING(25) 25
38 MATURED_LOAN_FLAG CHARACTER VARYING(1) 1
39 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(1) 1
40 MORTGAGE_INSURANCE_PROVIDER CHARACTER VARYING(80) 80
41 MATURITY_DATE CHARACTER VARYING(200) 200
42 MIGRATION_STATUS CHARACTER VARYING(8) 8
43 ORIGINAL_MATURITY_DATE CHARACTER VARYING(200) 200
44 OWNER_OCCUPIED CHARACTER VARYING(14) 14
45 PRODUCT_CLASS CHARACTER VARYING(2) 2
46 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
47 PRODUCT_ID CHARACTER VARYING(30) 30
48 PRODUCT_SUB_CODE CHARACTER VARYING(30) 30
49 REDRAW_PRODUCT_OPTION_FLAG CHARACTER VARYING(2) 2
50 REQUESTED_AMOUNT CHARACTER VARYING(25) 25
51 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
52 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
53 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
54 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
55 TERM_MONTHS CHARACTER VARYING(25) 25
56 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
57 OF_ENTITY_CODE CHARACTER VARYING(150) 150
58 OF_PRODUCT_CODE CHARACTER VARYING(150) 150
59 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(150) 150
60 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(150) 150
61 OF_INT_EXPENSE_ACCOUNT_CODE CHARACTER VARYING(150) 150
62 OF_INT_EXPENSE_CATEGORY_CODE CHARACTER VARYING(150) 150
63 OF_INT_EXPENSE_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(150) 150
64 OF_INT_EXPENSE_ACCRUED_CATEGORY_CODE CHARACTER VARYING(150) 150
65 OF_INT_INCOME_ACCOUNT_CODE CHARACTER VARYING(150) 150
66 OF_INT_INCOME_CATEGORY_CODE CHARACTER VARYING(150) 150
67 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(150) 150
68 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(150) 150
69 OF_INBA_ACCOUNT_CODE CHARACTER VARYING(150) 150
70 OF_INBA_CATEGORY_CODE CHARACTER VARYING(150) 150
71 SOURCE_PRODUCT_DIM_ID CHARACTER VARYING(25) 25
72 PERS_INV_USAGE_TYPE_DIM_ID CHARACTER VARYING(25) 25
73 LOAN_PURPOSE_DIM_ID CHARACTER VARYING(25) 25
74 BILL_TYPE_DIM_ID CHARACTER VARYING(25) 25
75 OF_COST_CENTRE_DIM_ID CHARACTER VARYING(150) 150
76 OF_ENTITY_DIM_ID CHARACTER VARYING(150) 150
77 OF_INT_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
78 OF_INT_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
79 OF_INT_EXPENSE_ACCOUNT_DIM_ID CHARACTER VARYING(1) 1
80 OF_INT_EXPENSE_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(1) 1
81 OF_INT_EXPENSE_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(1) 1
82 OF_INT_EXPENSE_CATEGORY_DIM_ID CHARACTER VARYING(1) 1
83 OF_INT_INCOME_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
84 OF_INT_INCOME_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
85 OF_PRINCIPAL_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
86 OF_PRINCIPAL_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
87 OF_PRODUCT_DIM_ID CHARACTER VARYING(150) 150
88 OF_INBA_ACCOUNT_DIM_ID CHARACTER VARYING(1) 1
89 OF_INBA_CATEGORY_DIM_ID CHARACTER VARYING(1) 1
90 EFFECTIVE_START_DATE CHARACTER VARYING(200) 200
91 EFFECTIVE_END_DATE CHARACTER VARYING(200) 200
92 IS_CURRENT CHARACTER VARYING(1) 1