DIM_BNK_OF_ACCOUNT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_SID BIGINT 8
2 ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
3 ACCOUNT_CODE CHARACTER VARYING(150) 150
4 ACCOUNT_NAME1 CHARACTER VARYING(150) 150
5 VALID_FROM_DATE TIMESTAMP 8
6 VALID_TO_DATE TIMESTAMP 8
7 CREATED_DATE TIMESTAMP 8
8 CHANGED_DATE TIMESTAMP 8
9 CURRENT_LIABILITIES_MULTIPLI1 NUMERIC(38,0) 19
10 DEFERRED_CHARGES_MULTIPLIER1 NUMERIC(38,0) 19
11 DEFERRED_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
12 DEFERRED_INCOME_TAXES_MULTIP1 NUMERIC(38,0) 19
13 DEPRECIATION_MULTIPLIER1 NUMERIC(38,0) 19
14 DISCOUNTS_MULTIPLIER1 NUMERIC(38,0) 19
15 DIVIDENDS_PAYABLE_MULTIPLIER1 NUMERIC(38,0) 19
16 EQUITY_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
17 EXCISE_TAX_MULTIPLIER1 NUMERIC(38,0) 19
18 FIRST_MORTGAGE_BONDS_DUE_MUL1 NUMERIC(38,0) 19
19 FIXED_ASSETS_MULTIPLIER1 NUMERIC(38,0) 19
20 FIXED_CHARGES_MULTIPLIER1 NUMERIC(38,0) 19
21 FOREIGN_CURRENCY_ADJUSTMENT_1 NUMERIC(38,0) 19
22 GROSS_OPERATING_PROFIT_MULTI1 NUMERIC(38,0) 19
23 INCOME_TAXES_PAYABLE_MULTIPL1 NUMERIC(38,0) 19
24 INTANGIBLE_ASSETS_MULTIPLIER1 NUMERIC(38,0) 19
25 INTEREST_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
26 INVENTORY_MULTIPLIER1 NUMERIC(38,0) 19
27 LONGTERM_DEBT_MULTIPLIER1 NUMERIC(38,0) 19
28 MARKETABLE_SECURITY_MULTIPLI1 NUMERIC(38,0) 19
29 MINORITY_INTEREST_MULTIPLIER1 NUMERIC(38,0) 19
30 MISCELLANEOUS_ASSETS_MULTIPL1 NUMERIC(38,0) 19
31 NET_INCOME_BEFORE_INCOME_TAX1 NUMERIC(38,0) 19
32 NET_INCOME_BEI_MULTIPLIER1 NUMERIC(38,0) 19
33 NET_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
34 NET_OPERATING_PROFIT_MULTIPL1 NUMERIC(38,0) 19
35 NET_SALES_MULTIPLIER1 NUMERIC(38,0) 19
36 OTHER_LIABILITIES_MULTIPLIER1 NUMERIC(38,0) 19
37 PREFFERED_SHARE_CAPITAL_MULT1 NUMERIC(38,0) 19
38 PREPAID_EXPENSE_MULTIPLIER1 NUMERIC(38,0) 19
39 RECEIVABLE_MULTIPLIER1 NUMERIC(38,0) 19
40 RETAINED_EARNINGS_MULTIPLIER1 NUMERIC(38,0) 19
41 RETURNS_AND_ALLOWANCES_MULTI1 NUMERIC(38,0) 19
42 SALES_MULTIPLER1 NUMERIC(38,0) 19
43 SHORTTERM_DEBT_MULTIPLIER1 NUMERIC(38,0) 19
44 TOTAL_ASSETS_MULTIPLER1 NUMERIC(38,0) 19
45 TOTAL_DEBT_MULTIPLER1 NUMERIC(38,0) 19
46 TOTAL_EQUITY_MULTIPLER1 NUMERIC(38,0) 19
47 TOTAL_EXPENSES_MULTIPLER1 NUMERIC(38,0) 19
48 TOTAL_INCOME_TAX_EXPENSES_MU1 NUMERIC(38,0) 19
49 TOTAL_LIABILITIES_MULTIPLER1 NUMERIC(38,0) 19
50 TOTAL_SALES_MULTIPLER1 NUMERIC(38,0) 19
51 ACCOUNTS_PAYABLE_MULTIPLIER1 NUMERIC(38,0) 19
52 BANK_ADVANCES_MULTIPLER1 NUMERIC(38,0) 19
53 CAPITAL_STOCK_MULTIPLER1 NUMERIC(38,0) 19
54 CAPITALIZED_INTEREST_MULTIPL1 NUMERIC(38,0) 19
55 CAPITALIZED_LEASE_PAYMENTS1 NUMERIC(38,0) 19
56 CASH_FLOW_STATEMENT_MULTIPLE1 NUMERIC(38,0) 19
57 CASH_MULTIPLER1 NUMERIC(38,0) 19
58 COMMON_SHARE_CAPITAL_MULTIPL1 NUMERIC(38,0) 19
59 CONTRIBUTED_SURPLUS_MULTIPLE1 NUMERIC(38,0) 19
60 COST_OF_GOODS_SOLD_MULTIPLER1 NUMERIC(38,0) 19
61 CURRENT_ASSETS_MULTIPLER1 NUMERIC(38,0) 19
62 CURRENT_INCOME_TAXES_MULTIPL1 NUMERIC(38,0) 19
63 ACCOUNT_CATEGORY_TYPE_CODE CHARACTER VARYING(1) 1
64 ACCOUNT_CATEGORY_TYPE_NAME CHARACTER VARYING(240) 240
65 BLOCKED_INDICATOR CHARACTER VARYING(1) 1
66 POSTABLE_ACCOUNT_INDICATOR CHARACTER VARYING(1) 1
67 BALANCE_SHEET_MULTIPLIER DOUBLE PRECISION 8
68 EXPENSE_MULTIPLIER DOUBLE PRECISION 8
69 INCOME_STATEMENT_MULTIPLIER DOUBLE PRECISION 8
70 ACCOUNT_NATURAL_SIGN_MULTIPL NUMERIC(38,0) 19
71 BUSINESS_LOAD_DATE TIMESTAMP 8
72 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
73 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
74 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
75 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8