ASIEXP13 - Account Summary Master SmartList
Dynamics GP table ASIEXP13 (Account Summary Master SmartList) contains 40 columns including ASI_Order_By, ACTINDX, YEAR1....
SQL Query Builder
40 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ASI_Order_By | ASI_Order_By | Long Integer | 4 | ||
| 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 | ||
| PERIODID | Period ID | Integer | 2 | ||
| ASI_Document_Status | ASI_Document_Status | Integer | 2 | ||
| PERDBLNC | Period Balance | Currency | 10 | ||
| 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 | ||
| ACTDESCR | Account Description | String | 52 | ||
| ACTALIAS | Account Alias | String | 22 | ||
| ACTIVE | Active0 = False, for inactive records1 = True, for active records | Boolean | 2 | ||
| 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 | ||
| ACCTTYPE | Account TypeField values:1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account | Integer | 2 | ||
Account Type values (4) 1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account | |||||
| PSTNGTYP | Posting Type0 = Balance Sheet1 = Profit and Loss | Integer | 2 | ||
Posting Type values (2) 0 = Balance Sheet1 = Profit and Loss | |||||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | 4 | ||
| MNACSGMT | Main Account Segment | String | 68 | ||
| TPCLBLNC | Typical Balance0 = Debit1 = Credit | Integer | 2 | ||
Typical Balance values (2) 0 = Debit1 = Credit | |||||
| DECPLACS | Decimal Places | Integer | 2 | ||
| FXDORVAR | Fixed Or Variable1 = Fixed Allocation2 = Variable Allocation | Integer | 2 | ||
Fixed or Variable Allocation values (2) 1 = Fixed Allocation2 = Variable Allocation | |||||
| BALFRCLC | Balance For Calculation0 = Year To Date1 = TRX Period | Integer | 2 | ||
| DSPLKUPS | Display In Lookups1 = Sales2 = Inventory3 = Purchasing4 = Payroll | Long Integer | 4 | ||
| CNVRMTHD | Conversion Method1 = Current Rate2 = Average Rate3 = Historical Rate | Integer | 2 | ||
| HSTRCLRT | Historical Rate | Currency (Variable) | 10 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| CREATDDT | Created Date | Date | 4 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| USERDEF1 | User Defined 1 | String | 22 | ||
| USERDEF2 | User Defined 2 | String | 22 | ||
| PostSlsIn | Post Sales In1 = Detail2 = Summary | Integer | 2 | ||
| PostIvIn | Post Inventory In1 = Detail2 = Summary | Integer | 2 | ||
| PostPurchIn | Post Purchasing In1 = Detail2 = Summary | Integer | 2 | ||
| PostPRIn | Post Payroll In1 = Detail2 = Summary | Integer | 2 | ||
| ADJINFL | Adjust for Inflation | Boolean | 2 | ||
| INFLAEQU | Inflation Equity Account Index | Long Integer | 4 | ||
| INFLAREV | Inflation Revenue Account Index | Long Integer | 4 | ||
Related Tables
Tables that share columns with ASIEXP13. Click "Join" to add to your query.