GL00201 - Budget Summary Master
Dynamics GP table GL00201 (Budget Summary Master) contains 12 columns including BUDGETID, ACTNUMBR_1, ACTNUMBR_2....
SQL Query Builder
12 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| BUDGETID | Budget ID | String | 16 | |
| ACTNUMBR_1 | Account Number:Account_Segment_Pool1 | String | 10 | |
| ACTNUMBR_2 | Account Number:Account_Segment_Pool2 | String | 10 | |
| ACTNUMBR_3 | Account Number:Account_Segment_Pool3 | String | 10 | |
| ACTNUMBR_4 | Account Number:Account_Segment_Pool4 | String | 10 | |
| ACTNUMBR_5 | Account Number:Account_Segment_Pool5 | String | 10 | |
| PERIODDT | Period Date | Date | 4 | |
| PERIODID | Period ID | Integer | 2 | |
| BUDGETAMT | Budget Amount | Currency | 10 | |
| ACCATNUM | Account Category Number1 = 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 | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| YEAR1 | Year | Integer | 2 |
Related Tables
Tables that share columns with GL00201. Click "Join" to add to your query.