ECM00201 - ECM_Budget_SUM_MSTR

Dynamics GP table ECM00201 (ECM_Budget_SUM_MSTR) contains 7 columns including CompanyID, SessionID, BudgetID....

SQL Query Builder

SELECT * FROM ECM00201

Select all

Column	Description	Type	Length	Shared With
CompanyID	ECM_CompanyID	Long Integer	4	3 tables
SessionID	ECM_SessionID	Long Integer	4	-
BudgetID	ECM_BudgetID	String	16	-
PeriodID	ECM_PeriodID	Integer	2	-
BudgetAmt	ECM_BudgetAmt	Currency	10	-
Accatnum	ECM_AcctCatNum1 = Cash2 = Short Term Investments3 = Accounts Receivable4 = Notes Receivable5 = Inventory6 = Work In Process7 = Prepaid Expenses8 = Long-Term Investments9 = Property, Plant and Equipment10 = Accumulated Depreciation11 = Intangible Assets12 = Other Assets13 = Accounts Payable14 = Notes Payable15 = Current Maturities Of Long-Term Debt16 = Taxes Payable17 = Interest Payable18 = Dividends Payable19 = Leases Payable (Current)20 = Sinking Fund Payable (Current)21 = Other Current Liabilities22 = Long-Term Debt23 = Common Stock24 = Preferred Stock25 = Additional Paid-In Capital - Common26 = Additional Paid-In Capital - Preferred27 = Retained Earnings28 = Treasury Stock29 = Common Dividends30 = Preferred Dividends31 = Sales32 = Sales Returns And Discounts33 = Cost Of Goods Sold34 = Selling Expense35 = Administrative Expense36 = Salaries Expense37 = Other Employee Expenses38 = Interest Expense39 = Tax Expense40 = Depreciation Expense41 = Income Tax Expense42 = Other Expenses43 = Other Income44 = Charges Not Using Working Capital45 = Revenues Not Producing Working Capital46 = Gain/Loss On Asset Disposal47 = Amortization Of Intangible Assets48 = Non-Financial Accounts	Integer	2	-
ActIndx	ECM_AcctIndx	Long Integer	4	-

Tables that share columns with ECM00201. Click "Join" to add to your query.

CompanyID