DS10100 - dsUnassignedAcctsView
Dynamics GP table DS10100 (dsUnassignedAcctsView) contains 4 columns including ACTINDX, ACCATDSC, ACCATNUM....
SQL Query Builder
4 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| 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 | |
| ACCATDSC | Account Category Description | String | 52 | |
| 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 | |
| ACTNUMST | Account Number String | String | 130 |