SmartList

33 tables in this module

SmartList tables store saved SmartList favorites, column configurations, and the ASIEXP tables that power SmartList data export functionality.

Table	Description	Columns
ASI1	ASI_SQL_Order_By_Table	4
ASIEXP01	SmartList Account Master	37
ASIEXP02	SmartList RM Customer MSTR	172
ASIEXP03	SmartList PM Vendor Master File	150
ASIEXP04	SmartList Item Master	80
ASIEXP05	SmartList Payroll Master	106
ASIEXP06	SmartList Sales Transaction	346
ASIEXP07	SmartList Purchase Order	455
ASIEXP08	SmartList Receivables Transaction	307
ASIEXP09	SmartList Payables Transactions	288
ASIEXP10	SmartList Payroll Transactions	139
ASIEXP100	ASI_SQL_Custom_Order	7
ASIEXP11	SmartList Item Quantity Master	250
ASIEXP12	ASI GL Transaction SmartList	130
ASIEXP13	Account Summary Master SmartList	40
ASIEXP14	ASI_MDA_SmartList	23
ASIEXP15	ASI_RM_Customer_MSTR_ADDR_SmartList	104
ASIEXP16	ASI_PM_Address_MSTR_SmartList	105
ASIEXP17	ASI_SOP_Prospect_MSTR_SmartList	26
ASIEXP18	Payroll Transaction History SmartList	144
ASIEXP19	SmartList Inventory Transaction Amount	107
ASIEXP20	ASI SOP Line Item SmartList	527
ASIEXP21	SmartList Purchasing Line Items	592
ASIEXP22	SmartList Bank Reconciliation Explorer	69
ASIEXP23	Item Vendor SmartList	181
ASIEXP24	SmartList Customer Items	251
ASIEXP25	SmartList Invoicing Transaction Work	107
ASIEXP26	SmartList Invoicing Transaction Amounts Work	62
ASIEXP27	SmartList Purchasing Receipts	181
ASIEXP28	SmartList Purchasing Receipt Lines	77
ASIEXP29	SmartList Tax History	38
ASIEXP32	SmartList Payroll Employee Summary	371
ASILOC50	ASI_IV_Item_MSTR_CUST	15