[ROOT] dt DimAccount < WHERE ParentDimAccountId EQ NOTNULL >

96 items

DimAccountId	AlternateKey	Description	Operator	ParentAlternateKey	ParentDimAccountId	Type	ValueType
77	6620	Utilities	+	660	75	Expenditures	Currency
2	10	Assets	+	1	1	Assets	Currency
78	6700	Other Expenses	+	60	58	Expenditures	Currency
3	110	Current Assets	+	10	2	Assets	Currency
79	680	Depreciation	+	60	58	Expenditures	Currency
4	1110	Cash	+	110	3	Assets	Currency
80	6810	Building Leasehold	+	680	79	Expenditures	Currency
5	1120	Receivables	+	110	3	Assets	Currency
27	2200	Current Liabilities	+	210	26	Liabilities	Currency
81	6820	Vehicles	+	680	79	Expenditures	Currency
6	1130	Trade Receivables	+	1120	5	Assets	Currency
28	2210	Notes Payable	+	2200	27	Liabilities	Currency
82	6830	Equipment	+	680	79	Expenditures	Currency
7	1140	Other Receivables	+	1120	5	Assets	Currency
29	2230	Accounts Payable	+	2200	27	Liabilities	Currency
83	6840	Furniture and Fixtures	+	680	79	Expenditures	Currency
8	1150	Allowance for Bad Debt	+	110	3	Assets	Currency
30	2300	Accrued Expenses	+	2200	27	Liabilities	Currency
84	6850	Other Assets	+	680	79	Expenditures	Currency
9	1160	Inventory	+	110	3	Assets	Currency
31	2310	Salary & Other Comp	+	2300	30	Liabilities	Currency
85	6860	Amortization of Goodwill	+	680	79	Expenditures	Currency
10	1162	Raw Materials	+	1160	9	Assets	Currency
32	2320	Insurance	+	2300	30	Liabilities	Currency
87	6920	Rent	+	60	58	Expenditures	Currency
11	1164	Work in Process	+	1160	9	Assets	Currency
33	2330	Warranties	+	2300	30	Liabilities	Currency
88	80	Other Income and Expense	+	4	47	Revenue	Currency
12	1166	Finished Goods	+	1160	9	Assets	Currency
34	2340	Intercompany Payables	+	2200	27	Liabilities	Currency
89	8000	Interest Income	+	80	88	Revenue	Currency
13	1170	Deferred Taxes	+	110	3	Assets	Currency
35	2350	Other Current Liabilities	+	2200	27	Liabilities	Currency
90	8010	Interest Expense	-	80	88	Expenditures	Currency
14	1180	Prepaid Expenses	+	110	3	Assets	Currency
36	2400	Long Term Liabilities	+	210	26	Liabilities	Currency
91	8020	Gain/Loss on Sales of Asset	+	80	88	Revenue	Currency
15	1185	Intercompany Receivables	+	110	3	Assets	Currency
37	2410	Long Term Obligations	+	2400	36	Liabilities	Currency
92	8030	Other Income	+	80	88	Revenue	Currency
17	1200	Property, Plant, Equipment	+	10	2	Assets	Currency
38	2420	Pension Liability	+	2400	36	Liabilities	Currency
93	8040	Curr Xchg Gain/(Loss)	+	80	88	Revenue	Currency
18	1210	Land & Improvements	+	1200	17	Assets	Currency
39	2430	Other Retirement Benefits	+	2400	36	Liabilities	Currency
94	8500	Taxes	-	4	47	Expenditures	Currency
19	1220	Buildings & Improvements	+	1200	17	Assets	Currency
40	2440	Other Long Term Liabilities	+	2400	36	Liabilities	Currency
96	9510	Headcount	~	9500	95	Balances	Units
20	1230	Machinery & Equipment	+	1200	17	Assets	Currency
41	300	Owners Equity	+	20	25	Liabilities	Currency
97	9520	Units	~	9500	95	Flow	Units
21	1240	Office Furniture & Equipment	+	1200	17	Assets	Currency
42	3010	Partner Capital	+	300	41	Liabilities	Currency
98	9530	Average Unit Price	~	9500	95	Balances	Currency
22	1250	Leasehold Improvements	+	1200	17	Assets	Currency
43	3020	Additional Paid In Capital	+	300	41	Liabilities	Currency
99	9540	Square Footage	~	9500	95	Balances	Units
23	1260	Construction In Progress	+	1200	17	Assets	Currency
44	3030	Retained Earnings	+	300	41	Liabilities	Currency
100	2220	Current Installments of Long-term Debt	+	2200	27	Liabilities	Currency
24	1300	Other Assets	+	10	2	Assets	Currency
45	3540	Prior Year Retained Earnings	+	3030	44	Liabilities	Currency
101	4200	Trade Sales	+	4110	51	Revenue	Currency
25	20	Liabilities and Owners Equity	-	1	1	Liabilities	Currency
46	3550	Current Retained Earnings	+	3030	44	Liabilities	Currency
26	210	Liabilities	+	20	25	Liabilities	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

Generated 2025-09-20 13:37:36.230 UTC