99 items
DimAccountId | AlternateKey | Description | Operator | ParentAlternateKey | ParentDimAccountId | Type | ValueType |
---|---|---|---|---|---|---|---|
1 | 1 | Balance Sheet | ~ | Currency | |||
2 | 10 | Assets | + | 1 | 1 | Assets | Currency |
3 | 110 | Current Assets | + | 10 | 2 | Assets | Currency |
4 | 1110 | Cash | + | 110 | 3 | Assets | Currency |
5 | 1120 | Receivables | + | 110 | 3 | Assets | Currency |
6 | 1130 | Trade Receivables | + | 1120 | 5 | Assets | Currency |
7 | 1140 | Other Receivables | + | 1120 | 5 | Assets | Currency |
8 | 1150 | Allowance for Bad Debt | + | 110 | 3 | Assets | Currency |
9 | 1160 | Inventory | + | 110 | 3 | Assets | Currency |
10 | 1162 | Raw Materials | + | 1160 | 9 | Assets | Currency |
11 | 1164 | Work in Process | + | 1160 | 9 | Assets | Currency |
12 | 1166 | Finished Goods | + | 1160 | 9 | Assets | Currency |
13 | 1170 | Deferred Taxes | + | 110 | 3 | Assets | Currency |
14 | 1180 | Prepaid Expenses | + | 110 | 3 | Assets | Currency |
15 | 1185 | Intercompany Receivables | + | 110 | 3 | Assets | Currency |
17 | 1200 | Property, Plant, Equipment | + | 10 | 2 | Assets | Currency |
18 | 1210 | Land & Improvements | + | 1200 | 17 | Assets | Currency |
19 | 1220 | Buildings & Improvements | + | 1200 | 17 | Assets | Currency |
20 | 1230 | Machinery & Equipment | + | 1200 | 17 | Assets | Currency |
21 | 1240 | Office Furniture & Equipment | + | 1200 | 17 | Assets | Currency |
22 | 1250 | Leasehold Improvements | + | 1200 | 17 | Assets | Currency |
23 | 1260 | Construction In Progress | + | 1200 | 17 | Assets | Currency |
24 | 1300 | Other Assets | + | 10 | 2 | Assets | Currency |
25 | 20 | Liabilities and Owners Equity | - | 1 | 1 | Liabilities | Currency |
26 | 210 | Liabilities | + | 20 | 25 | Liabilities | Currency |
27 | 2200 | Current Liabilities | + | 210 | 26 | Liabilities | Currency |
28 | 2210 | Notes Payable | + | 2200 | 27 | Liabilities | Currency |
29 | 2230 | Accounts Payable | + | 2200 | 27 | Liabilities | Currency |
30 | 2300 | Accrued Expenses | + | 2200 | 27 | Liabilities | Currency |
31 | 2310 | Salary & Other Comp | + | 2300 | 30 | Liabilities | Currency |
32 | 2320 | Insurance | + | 2300 | 30 | Liabilities | Currency |
33 | 2330 | Warranties | + | 2300 | 30 | Liabilities | Currency |
34 | 2340 | Intercompany Payables | + | 2200 | 27 | Liabilities | Currency |
35 | 2350 | Other Current Liabilities | + | 2200 | 27 | Liabilities | Currency |
36 | 2400 | Long Term Liabilities | + | 210 | 26 | Liabilities | Currency |
37 | 2410 | Long Term Obligations | + | 2400 | 36 | Liabilities | Currency |
38 | 2420 | Pension Liability | + | 2400 | 36 | Liabilities | Currency |
39 | 2430 | Other Retirement Benefits | + | 2400 | 36 | Liabilities | Currency |
40 | 2440 | Other Long Term Liabilities | + | 2400 | 36 | Liabilities | Currency |
41 | 300 | Owners Equity | + | 20 | 25 | Liabilities | Currency |
42 | 3010 | Partner Capital | + | 300 | 41 | Liabilities | Currency |
43 | 3020 | Additional Paid In Capital | + | 300 | 41 | Liabilities | Currency |
44 | 3030 | Retained Earnings | + | 300 | 41 | Liabilities | Currency |
45 | 3540 | Prior Year Retained Earnings | + | 3030 | 44 | Liabilities | Currency |
46 | 3550 | Current Retained Earnings | + | 3030 | 44 | Liabilities | Currency |
47 | 4 | Net Income | + | Revenue | Currency | ||
48 | 40 | Operating Profit | + | 4 | 47 | Revenue | Currency |
49 | 400 | Gross Margin | + | 40 | 48 | Revenue | Currency |
50 | 4100 | Net Sales | + | 400 | 49 | Revenue | Currency |
51 | 4110 | Gross Sales | + | 4100 | 50 | Revenue | Currency |
52 | 4500 | Intercompany Sales | + | 4110 | 51 | Revenue | Currency |
53 | 4130 | Returns and Adjustments | - | 4100 | 50 | Expenditures | Currency |
54 | 4140 | Discounts | - | 4100 | 50 | Expenditures | Currency |
55 | 5000 | Total Cost of Sales | - | 400 | 49 | Expenditures | Currency |
56 | 5020 | Standard Cost of Sales | + | 5000 | 55 | Expenditures | Currency |
57 | 5050 | Variances | + | 5000 | 55 | Expenditures | Currency |
58 | 60 | Operating Expenses | - | 40 | 48 | Expenditures | Currency |
59 | 600 | Labor Expenses | + | 60 | 58 | Expenditures | Currency |
60 | 6000 | Salaries | + | 600 | 59 | Expenditures | Currency |
61 | 6020 | Payroll Taxes | + | 600 | 59 | Expenditures | Currency |
62 | 6040 | Employee Benefits | + | 600 | 59 | Expenditures | Currency |
63 | 6100 | Commissions | + | 60 | 58 | Expenditures | Currency |
64 | 620 | Travel Expenses | + | 60 | 58 | Expenditures | Currency |
65 | 6200 | Travel Transportation | + | 620 | 64 | Expenditures | Currency |
66 | 6210 | Travel Lodging | + | 620 | 64 | Expenditures | Currency |
67 | 6220 | Meals | + | 620 | 64 | Expenditures | Currency |
68 | 6230 | Entertainment | + | 620 | 64 | Expenditures | Currency |
69 | 6240 | Other Travel Related | + | 620 | 64 | Expenditures | Currency |
70 | 630 | Marketing | + | 60 | 58 | Expenditures | Currency |
71 | 6300 | Conferences | + | 630 | 70 | Expenditures | Currency |
72 | 6310 | Marketing Collateral | + | 630 | 70 | Expenditures | Currency |
73 | 6400 | Office Supplies | + | 60 | 58 | Expenditures | Currency |
74 | 6500 | Professional Services | + | 60 | 58 | Expenditures | Currency |
75 | 660 | Telephone and Utilities | + | 60 | 58 | Expenditures | Currency |
76 | 6610 | Telephone | + | 660 | 75 | Expenditures | Currency |
77 | 6620 | Utilities | + | 660 | 75 | Expenditures | Currency |
78 | 6700 | Other Expenses | + | 60 | 58 | Expenditures | Currency |
79 | 680 | Depreciation | + | 60 | 58 | Expenditures | Currency |
80 | 6810 | Building Leasehold | + | 680 | 79 | Expenditures | Currency |
81 | 6820 | Vehicles | + | 680 | 79 | Expenditures | Currency |
82 | 6830 | Equipment | + | 680 | 79 | Expenditures | Currency |
83 | 6840 | Furniture and Fixtures | + | 680 | 79 | Expenditures | Currency |
84 | 6850 | Other Assets | + | 680 | 79 | Expenditures | Currency |
85 | 6860 | Amortization of Goodwill | + | 680 | 79 | Expenditures | Currency |
87 | 6920 | Rent | + | 60 | 58 | Expenditures | Currency |
88 | 80 | Other Income and Expense | + | 4 | 47 | Revenue | Currency |
89 | 8000 | Interest Income | + | 80 | 88 | Revenue | Currency |
90 | 8010 | Interest Expense | - | 80 | 88 | Expenditures | Currency |
91 | 8020 | Gain/Loss on Sales of Asset | + | 80 | 88 | Revenue | Currency |
92 | 8030 | Other Income | + | 80 | 88 | Revenue | Currency |
93 | 8040 | Curr Xchg Gain/(Loss) | + | 80 | 88 | Revenue | Currency |
94 | 8500 | Taxes | - | 4 | 47 | Expenditures | Currency |
95 | 9500 | Statistical Accounts | ~ | Statistical | Units | ||
96 | 9510 | Headcount | ~ | 9500 | 95 | Balances | Units |
97 | 9520 | Units | ~ | 9500 | 95 | Flow | Units |
98 | 9530 | Average Unit Price | ~ | 9500 | 95 | Balances | Currency |
99 | 9540 | Square Footage | ~ | 9500 | 95 | Balances | Units |
100 | 2220 | Current Installments of Long-term Debt | + | 2200 | 27 | Liabilities | Currency |
101 | 4200 | Trade Sales | + | 4110 | 51 | Revenue | Currency |
Generated 2024-12-22 06:12:54.877 UTC