ADW_ACCOUNT

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

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 SMALLINT 2
10 DEFERRED_CHARGES_MULTIPLIER1 SMALLINT 2
11 DEFERRED_INCOME_MULTIPLIER1 SMALLINT 2
12 DEFERRED_INCOME_TAXES_MULTIP1 SMALLINT 2
13 DEPRECIATION_MULTIPLIER1 SMALLINT 2
14 DISCOUNTS_MULTIPLIER1 SMALLINT 2
15 DIVIDENDS_PAYABLE_MULTIPLIER1 SMALLINT 2
16 EQUITY_INCOME_MULTIPLIER1 SMALLINT 2
17 EXCISE_TAX_MULTIPLIER1 SMALLINT 2
18 FIRST_MORTGAGE_BONDS_DUE_MUL1 SMALLINT 2
19 FIXED_ASSETS_MULTIPLIER1 SMALLINT 2
20 FIXED_CHARGES_MULTIPLIER1 SMALLINT 2
21 FOREIGN_CURRENCY_ADJUSTMENT_1 SMALLINT 2
22 GROSS_OPERATING_PROFIT_MULTI1 SMALLINT 2
23 INCOME_TAXES_PAYABLE_MULTIPL1 SMALLINT 2
24 INTANGIBLE_ASSETS_MULTIPLIER1 SMALLINT 2
25 INTEREST_INCOME_MULTIPLIER1 SMALLINT 2
26 INVENTORY_MULTIPLIER1 SMALLINT 2
27 LONGTERM_DEBT_MULTIPLIER1 SMALLINT 2
28 MARKETABLE_SECURITY_MULTIPLI1 SMALLINT 2
29 MINORITY_INTEREST_MULTIPLIER1 SMALLINT 2
30 MISCELLANEOUS_ASSETS_MULTIPL1 SMALLINT 2
31 NET_INCOME_BEFORE_INCOME_TAX1 SMALLINT 2
32 NET_INCOME_BEI_MULTIPLIER1 SMALLINT 2
33 NET_INCOME_MULTIPLIER1 SMALLINT 2
34 NET_OPERATING_PROFIT_MULTIPL1 SMALLINT 2
35 NET_SALES_MULTIPLIER1 SMALLINT 2
36 OTHER_LIABILITIES_MULTIPLIER1 SMALLINT 2
37 PREFFERED_SHARE_CAPITAL_MULT1 SMALLINT 2
38 PREPAID_EXPENSE_MULTIPLIER1 SMALLINT 2
39 RECEIVABLE_MULTIPLIER1 SMALLINT 2
40 RETAINED_EARNINGS_MULTIPLIER1 SMALLINT 2
41 RETURNS_AND_ALLOWANCES_MULTI1 SMALLINT 2
42 SALES_MULTIPLER1 SMALLINT 2
43 SHORTTERM_DEBT_MULTIPLIER1 SMALLINT 2
44 TOTAL_ASSETS_MULTIPLER1 SMALLINT 2
45 TOTAL_DEBT_MULTIPLER1 SMALLINT 2
46 TOTAL_EQUITY_MULTIPLER1 SMALLINT 2
47 TOTAL_EXPENSES_MULTIPLER1 SMALLINT 2
48 TOTAL_INCOME_TAX_EXPENSES_MU1 SMALLINT 2
49 TOTAL_LIABILITIES_MULTIPLER1 SMALLINT 2
50 TOTAL_SALES_MULTIPLER1 SMALLINT 2
51 ACCOUNTS_PAYABLE_MULTIPLIER1 SMALLINT 2
52 BANK_ADVANCES_MULTIPLER1 SMALLINT 2
53 CAPITAL_STOCK_MULTIPLER1 SMALLINT 2
54 CAPITALIZED_INTEREST_MULTIPL1 SMALLINT 2
55 CAPITALIZED_LEASE_PAYMENTS1 SMALLINT 2
56 CASH_FLOW_STATEMENT_MULTIPLE1 SMALLINT 2
57 CASH_MULTIPLER1 SMALLINT 2
58 COMMON_SHARE_CAPITAL_MULTIPL1 SMALLINT 2
59 CONTRIBUTED_SURPLUS_MULTIPLE1 SMALLINT 2
60 COST_OF_GOODS_SOLD_MULTIPLER1 SMALLINT 2
61 CURRENT_ASSETS_MULTIPLER1 SMALLINT 2
62 CURRENT_INCOME_TAXES_MULTIPL1 SMALLINT 2
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 SMALLINT 2