DIM_SDW_TSDMD_OF_ACCOUNT_COMBINED_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..DIM_SDW_TSDMD_OF_ACCOUNT_COMBINED

Columns
# Name Data Type Length
1 ACCOUNT_SID BIGINT 8
2 ACCOUNT_CATEGORY_SID CHARACTER VARYING(47) 47
3 ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
4 ACCOUNT_CODE CHARACTER VARYING(150) 150
5 CATEGORY_CODE CHARACTER VARYING(150) 150
6 ACCOUNT_CATEGORY_CODE CHARACTER VARYING(303) 303
7 ACCOUNT_NAME1 CHARACTER VARYING(150) 150
8 ACCOUNT_CATEGORY_NAME CHARACTER VARYING(393) 393
9 VALID_FROM_DATE TIMESTAMP 8
10 ACCOUNT_VALID_TO_DATE TIMESTAMP 8
11 ACCOUNT_CREATED_DATE TIMESTAMP 8
12 ACCOUNT_CHANGED_DATE TIMESTAMP 8
13 CURRENT_LIABILITIES_MULTIPLI1 NUMERIC(38,0) 19
14 DEFERRED_CHARGES_MULTIPLIER1 NUMERIC(38,0) 19
15 DEFERRED_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
16 DEFERRED_INCOME_TAXES_MULTIP1 NUMERIC(38,0) 19
17 DEPRECIATION_MULTIPLIER1 NUMERIC(38,0) 19
18 DISCOUNTS_MULTIPLIER1 NUMERIC(38,0) 19
19 DIVIDENDS_PAYABLE_MULTIPLIER1 NUMERIC(38,0) 19
20 EQUITY_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
21 EXCISE_TAX_MULTIPLIER1 NUMERIC(38,0) 19
22 FIRST_MORTGAGE_BONDS_DUE_MUL1 NUMERIC(38,0) 19
23 FIXED_ASSETS_MULTIPLIER1 NUMERIC(38,0) 19
24 FIXED_CHARGES_MULTIPLIER1 NUMERIC(38,0) 19
25 FOREIGN_CURRENCY_ADJUSTMENT_1 NUMERIC(38,0) 19
26 GROSS_OPERATING_PROFIT_MULTI1 NUMERIC(38,0) 19
27 INCOME_TAXES_PAYABLE_MULTIPL1 NUMERIC(38,0) 19
28 INTANGIBLE_ASSETS_MULTIPLIER1 NUMERIC(38,0) 19
29 INTEREST_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
30 INVENTORY_MULTIPLIER1 NUMERIC(38,0) 19
31 LONGTERM_DEBT_MULTIPLIER1 NUMERIC(38,0) 19
32 MARKETABLE_SECURITY_MULTIPLI1 NUMERIC(38,0) 19
33 MINORITY_INTEREST_MULTIPLIER1 NUMERIC(38,0) 19
34 MISCELLANEOUS_ASSETS_MULTIPL1 NUMERIC(38,0) 19
35 NET_INCOME_BEFORE_INCOME_TAX1 NUMERIC(38,0) 19
36 NET_INCOME_BEI_MULTIPLIER1 NUMERIC(38,0) 19
37 NET_INCOME_MULTIPLIER1 NUMERIC(38,0) 19
38 NET_OPERATING_PROFIT_MULTIPL1 NUMERIC(38,0) 19
39 NET_SALES_MULTIPLIER1 NUMERIC(38,0) 19
40 OTHER_LIABILITIES_MULTIPLIER1 NUMERIC(38,0) 19
41 PREFFERED_SHARE_CAPITAL_MULT1 NUMERIC(38,0) 19
42 PREPAID_EXPENSE_MULTIPLIER1 NUMERIC(38,0) 19
43 RECEIVABLE_MULTIPLIER1 NUMERIC(38,0) 19
44 RETAINED_EARNINGS_MULTIPLIER1 NUMERIC(38,0) 19
45 RETURNS_AND_ALLOWANCES_MULTI1 NUMERIC(38,0) 19
46 SALES_MULTIPLER1 NUMERIC(38,0) 19
47 SHORTTERM_DEBT_MULTIPLIER1 NUMERIC(38,0) 19
48 TOTAL_ASSETS_MULTIPLER1 NUMERIC(38,0) 19
49 TOTAL_DEBT_MULTIPLER1 NUMERIC(38,0) 19
50 TOTAL_EQUITY_MULTIPLER1 NUMERIC(38,0) 19
51 TOTAL_EXPENSES_MULTIPLER1 NUMERIC(38,0) 19
52 TOTAL_INCOME_TAX_EXPENSES_MU1 NUMERIC(38,0) 19
53 TOTAL_LIABILITIES_MULTIPLER1 NUMERIC(38,0) 19
54 TOTAL_SALES_MULTIPLER1 NUMERIC(38,0) 19
55 ACCOUNTS_PAYABLE_MULTIPLIER1 NUMERIC(38,0) 19
56 BANK_ADVANCES_MULTIPLER1 NUMERIC(38,0) 19
57 CAPITAL_STOCK_MULTIPLER1 NUMERIC(38,0) 19
58 CAPITALIZED_INTEREST_MULTIPL1 NUMERIC(38,0) 19
59 CAPITALIZED_LEASE_PAYMENTS1 NUMERIC(38,0) 19
60 CASH_FLOW_STATEMENT_MULTIPLE1 NUMERIC(38,0) 19
61 CASH_MULTIPLER1 NUMERIC(38,0) 19
62 COMMON_SHARE_CAPITAL_MULTIPL1 NUMERIC(38,0) 19
63 CONTRIBUTED_SURPLUS_MULTIPLE1 NUMERIC(38,0) 19
64 COST_OF_GOODS_SOLD_MULTIPLER1 NUMERIC(38,0) 19
65 CURRENT_ASSETS_MULTIPLER1 NUMERIC(38,0) 19
66 CURRENT_INCOME_TAXES_MULTIPL1 NUMERIC(38,0) 19
67 ACCOUNT_CATEGORY_TYPE_CODE CHARACTER VARYING(1) 1
68 ACCOUNT_CATEGORY_TYPE_NAME CHARACTER VARYING(240) 240
69 BLOCKED_INDICATOR CHARACTER VARYING(1) 1
70 POSTABLE_ACCOUNT_INDICATOR CHARACTER VARYING(1) 1
71 BALANCE_SHEET_MULTIPLIER DOUBLE PRECISION 8
72 EXPENSE_MULTIPLIER DOUBLE PRECISION 8
73 INCOME_STATEMENT_MULTIPLIER DOUBLE PRECISION 8
74 ACCOUNT_NATURAL_SIGN_MULTIPL NUMERIC(38,0) 19
75 BUSINESS_LOAD_DATE TIMESTAMP 8
76 ACCOUNT_LEVEL_01_CODE CHARACTER VARYING(60) 60
77 ACCOUNT_HIERARCH_HISTORY_SID BIGINT 8
78 ACCOUNT_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
79 ACCOUNT_NAME CHARACTER VARYING(240) 240
80 ACCOUNT_NAME_CF CHARACTER(1) 1
81 ACCOUNT_LEVEL_01_NAME CHARACTER VARYING(240) 240
82 ACCOUNT_LEVEL_01_NAME_CF CHARACTER(1) 1
83 ACCOUNT_LEVEL_02_CODE CHARACTER VARYING(150) 150
84 ACCOUNT_LEVEL_02_CODE_CF CHARACTER(1) 1
85 ACCOUNT_LEVEL_02_NAME CHARACTER VARYING(240) 240
86 ACCOUNT_LEVEL_02_NAME_CF CHARACTER(1) 1
87 ACCOUNT_LEVEL_03_CODE CHARACTER VARYING(150) 150
88 ACCOUNT_LEVEL_03_CODE_CF CHARACTER(1) 1
89 ACCOUNT_LEVEL_03_NAME CHARACTER VARYING(240) 240
90 ACCOUNT_LEVEL_03_NAME_CF CHARACTER(1) 1
91 ACCOUNT_LEVEL_04_CODE CHARACTER VARYING(150) 150
92 ACCOUNT_LEVEL_04_CODE_CF CHARACTER(1) 1
93 ACCOUNT_LEVEL_04_NAME CHARACTER VARYING(240) 240
94 ACCOUNT_LEVEL_04_NAME_CF CHARACTER(1) 1
95 ACCOUNT_LEVEL_05_CODE CHARACTER VARYING(150) 150
96 ACCOUNT_LEVEL_05_CODE_CF CHARACTER(1) 1
97 ACCOUNT_LEVEL_05_NAME CHARACTER VARYING(240) 240
98 ACCOUNT_LEVEL_05_NAME_CF CHARACTER(1) 1
99 ACCOUNT_LEVEL_06_CODE CHARACTER VARYING(150) 150
100 ACCOUNT_LEVEL_06_CODE_CF CHARACTER(1) 1
101 ACCOUNT_LEVEL_06_NAME CHARACTER VARYING(240) 240
102 ACCOUNT_LEVEL_06_NAME_CF CHARACTER(1) 1
103 ACCOUNT_LEVEL_07_CODE CHARACTER VARYING(150) 150
104 ACCOUNT_LEVEL_07_CODE_CF CHARACTER(1) 1
105 ACCOUNT_LEVEL_07_NAME CHARACTER VARYING(240) 240
106 ACCOUNT_LEVEL_07_NAME_CF CHARACTER(1) 1
107 ACCOUNT_LEVEL_08_CODE CHARACTER VARYING(150) 150
108 ACCOUNT_LEVEL_08_CODE_CF CHARACTER(1) 1
109 ACCOUNT_LEVEL_08_NAME CHARACTER VARYING(240) 240
110 ACCOUNT_LEVEL_08_NAME_CF CHARACTER(1) 1
111 ACCOUNT_LEVEL_09_CODE CHARACTER VARYING(150) 150
112 ACCOUNT_LEVEL_09_CODE_CF CHARACTER(1) 1
113 ACCOUNT_LEVEL_09_NAME CHARACTER VARYING(240) 240
114 ACCOUNT_LEVEL_09_NAME_CF CHARACTER(1) 1
115 ACCOUNT_LEVEL_10_CODE CHARACTER VARYING(150) 150
116 ACCOUNT_LEVEL_10_CODE_CF CHARACTER(1) 1
117 ACCOUNT_LEVEL_10_NAME CHARACTER VARYING(240) 240
118 ACCOUNT_LEVEL_10_NAME_CF CHARACTER(1) 1
119 ACCOUNT_LEVEL_11_CODE CHARACTER VARYING(150) 150
120 ACCOUNT_LEVEL_11_CODE_CF CHARACTER(1) 1
121 ACCOUNT_LEVEL_11_NAME CHARACTER VARYING(240) 240
122 ACCOUNT_LEVEL_11_NAME_CF CHARACTER(1) 1
123 ACCOUNT_LEVEL_12_CODE CHARACTER VARYING(150) 150
124 ACCOUNT_LEVEL_12_CODE_CF CHARACTER(1) 1
125 ACCOUNT_LEVEL_12_NAME CHARACTER VARYING(240) 240
126 ACCOUNT_LEVEL_12_NAME_CF CHARACTER(1) 1
127 ACCOUNT_LEVEL_13_CODE CHARACTER VARYING(150) 150
128 ACCOUNT_LEVEL_13_CODE_CF CHARACTER(1) 1
129 ACCOUNT_LEVEL_13_NAME CHARACTER VARYING(240) 240
130 ACCOUNT_LEVEL_13_NAME_CF CHARACTER(1) 1
131 ACCOUNT_LEVEL_14_CODE CHARACTER VARYING(150) 150
132 ACCOUNT_LEVEL_14_CODE_CF CHARACTER(1) 1
133 ACCOUNT_LEVEL_14_NAME CHARACTER VARYING(240) 240
134 ACCOUNT_LEVEL_14_NAME_CF CHARACTER(1) 1
135 ACCOUNT_LEVEL_15_CODE CHARACTER VARYING(150) 150
136 ACCOUNT_LEVEL_15_CODE_CF CHARACTER(1) 1
137 ACCOUNT_LEVEL_15_NAME CHARACTER VARYING(240) 240
138 ACCOUNT_LEVEL_15_NAME_CF CHARACTER(1) 1
139 EFFECTIVE_DATE TIMESTAMP 8
140 ACCOUNT_HIST_VALID_TO_DATE TIMESTAMP 8
141 ACCOUNT_HIST_CREATED_DATE TIMESTAMP 8
142 ACCOUNT_HIST_CHANGED_DATE TIMESTAMP 8
143 ACCOUNT_HIERARCHY_SID BIGINT 8
144 ACCOUNT_COMMIT_TIMESTAMP TIMESTAMP 8
145 ACCOUNT_HIER_COMMIT_TIMESTAMP TIMESTAMP 8
146 ACCOUNT_HIER_HIST_COMMIT_TIMESTAMP TIMESTAMP 8