This section lists the SmartList objects that are defined for Microsoft Dynamics GP. You can add additional columns and Go To items to these objects. The constant used to refer to the object, along with the tables and join information for the object are listed.
|
Object type value |
13 |
|
Constant |
SMARTLIST_OBJECTTYPE_ACCOUNTSUMMARY |
|
Tables |
GL10110 - GL_Account_SUM_MSTR GL10111 - GL_Account_SUM_HIST GL00100 - GL_Account_MSTR |
|
Joins |
GL10110 left-outer join to GL00100 GL10111 left-outer join to GL00100 |
|
Object type value |
12 |
|
Constant |
SMARTLIST_OBJECTTYPE_ACCOUNTTRANSACTIONS |
|
Tables |
GL10001 - GL_TRX_LINE_WORK GL20000 - GL_YTD_TRX_OPEN GL30000 - GL_Account_TRX_HIST MC40200 - MC_Currency_SETP GL00100 - GL_Account_MSTR GL10000 - GL_TRX_HDR_WORK |
|
Joins |
GL10001 left-outer join to MC40200 GL10001 left-outer join to GL00100 GL10001 left-outer join to GL10000 GL20000 left-outer join to GL00100 GL20000 left-outer join to GL10000 GL30000 left-outer join to GL00100 |
|
Object type value |
1 |
|
Constant |
SMARTLIST_OBJECTTYPE_ACCOUNTS |
|
Tables |
GL00100 - GL_Account_MSTR |
|
Joins |
None |
|
Object type value |
22 |
|
Constant |
SMARTLIST_OBJECTTYPE_BANKTRANSACTIONS |
|
Tables |
CM20300 - CM_Recipt CM20200 - CM_Transaction |
|
Joins |
None |
|
Object type value |
15 |
|
Constant |
SMARTLIST_OBJECTTYPE_CUSTOMERADDRESSES |
|
Tables |
RM00102 - RM_Customer_MSTR_ADDR RM00101 - RM_Customer_MSTR SY01200 - coINetAddrs |
|
Joins |
RM00102 left-outer join to RM00101 RM00102 left-outer join to SY01200 |
|
Object type value |
24 |
|
Constant |
SMARTLIST_OBJECTTYPE_CUSTOMERITEMS |
|
Tables |
SOP60300 - sopCustomerItemXref IV00101 - IV_Item_MSTR RM00101 - RM_Customer_MSTR RM00103 - RM_Customer_MSTR_SUM |
|
Joins |
SOP60300 left-outer join to IV00101 SOP60300 left-outer join to RM00101 SOP60300 left-outer join to RM00103 |
|
Object type value |
2 |
|
Constant |
SMARTLIST_OBJECTTYPE_CUSTOMERS |
|
Tables |
RM00101 - RM_Customer_MSTR |
|
Joins |
None |
|
Object type value |
32 |
|
Constant |
SMARTLIST_OBJECTTYPE_EMPLOYEESUMMARY |
|
Tables |
UPR00100 - UPR_MSTR UPR00900 - UPR_Employee_SUM UPR00901 - UPR_Employee_Tips_SUM UPR00300 - UPR_MSTR_Tax_Info UPR00900 - UPR_Employee_SUM |
|
Joins |
UPR00100 left-outer join to UPR00900 UPR00100 left-outer join to UPR00901 UPR00100 left-outer join to UPR00300 UPR00900 left-outer join to UPR00901 |
|
Object type value |
5 |
|
Constant |
SMARTLIST_OBJECTTYPE_EMPLOYEES |
|
Tables |
UPR00100 - UPR_MSTR UPR00300 - UPR_MSTR_Tax_Info UPR00102 - uprMstrAddress |
|
Joins |
UPR00100 left-outer join to UPR00300 UPR00100 left-outer join to UPR00102 |
|
Object type value |
19 |
|
Constant |
SMARTLIST_OBJECTTYPE_INVENTORYTRANSACTIONS |
|
Tables |
IV10001 - IV_TRX_WORK_LINE IV40201 - IV_UofM_SETP_HDR IV10000 - IV_TRX_WORK_HDR IV30300 - IV_TRX_HIST_LINE IV30200 - IV_TRX_HIST_HDR IV00101 - IV_Item_MSTR |
|
Joins |
IV10001 left-outer join to IV00101 IV10001 left-outer join to IV10000 IV30300 left-outer join to IV00101 IV30300 left-outer join to IV30200 IV00101 left-outer join to IV40201 |
|
Object type value |
11 |
|
Constant |
SMARTLIST_OBJECTTYPE_ITEMQUANTITIES |
|
Tables |
IV00102 - IV_Item_MSTR_QTYS IV00103 - IV_Item_MSTR_VNDR PM00200 - PM_Vendor_MSTR IV00101 - IV_Item_MSTR IV40201 - IV_UofM_SETP_HDR |
|
Joins |
IV00102 left-outer join to IV00103 IV00102 left-outer join to PM00200 IV00102 left-outer join to IV00101 IV00101 left-outer join to IV40201 |
|
Object type value |
4 |
|
Constant |
SMARTLIST_OBJECTTYPE_ITEMS |
|
Tables |
IV00101 - IV_Item_MSTR |
|
Joins |
None |
|
Object type value |
31 |
|
Constant |
SMARTLIST_OBJECTTYPE_LANDEDCOSTGROUPID |
|
Tables |
IV41101 - ivLandedCostGroup IV41102 - ivLandedCostGroupDetails IV41100 - ivLandedCost |
|
Joins |
IV41101 left-outer join to IV41102 IV41102 left-outer join to IV41100 |
|
Object type value |
30 |
|
Constant |
SMARTLIST_OBJECTTYPE_LANDEDCOSTID |
|
Tables |
IV41100 - ivLandedCost |
|
Joins |
None |
|
Object type value |
14 |
|
Constant |
SMARTLIST_OBJECTTYPE_MDA |
|
Tables |
DTA10200 - DTA_Transaction_Codes_WORK DTA10100 - DTA_Transaction_Groups_WORK GL00100 - GL_Account_MSTR |
|
Joins |
DTA10200 left-outer join to DTA10100 DTA10200 left-outer join to GL00100 |
|
Object type value |
9 |
|
Constant |
SMARTLIST_OBJECTTYPE_PAYABLESTRANSACTIONS |
|
Tables |
PM10000 - PM_Transaction_WORK MC020103 - MC_PM_Transactions PM00200 - PM_Vendor_MSTR PM00201 - PM_Vendor_MSTR_SUM PM20000 - PM_Transaction_OPEN PM30200 - PM_Paid_Transaction_HIST |
|
Joins |
PM10000 left-outer join to MC020103 PM10000 left-outer join to PM00200 PM10000 left-outer join to PM00201 PM20000 left-outer join to MC020103 PM20000 left-outer join to PM00200 PM20000 left-outer join to PM00201 PM30200 left-outer join to MC020103 PM30200 left-outer join to PM00200 PM30200 left-outer join to PM00201 |
|
Object type value |
18 |
|
Constant |
SMARTLIST_OBJECTTYPE_PAYROLLHISTORICALTRX |
|
Tables |
UPR30300 - UPR_Transaction_HIST UPR00100 - UPR_MSTR UPR00300 - UPR_MSTR_Tax_Info UPR00102 - uprMstrAddress |
|
Joins |
None |
|
Object type value |
10 |
|
Constant |
SMARTLIST_OBJECTTYPE_PAYROLLTRANSACTIONS |
|
Tables |
UPR10302 - UPR_TRX_Batch_Detail UPR00100 - UPR_MSTR UPR00300 - UPR_MSTR_Tax_Info UPR00102 - uprMstrAddress |
|
Joins |
UPR10302 left-outer join to UPR00100 UPR10302 left-outer join to UPR00300 UPR00100 left-outer join to UPR00102 |
|
Object type value |
17 |
|
Constant |
SMARTLIST_OBJECTTYPE_PROSPECTS |
|
Tables |
SOP00200 - SOP_Prospect_MSTR |
|
Joins |
None |
|
Object type value |
21 |
|
Constant |
SMARTLIST_OBJECTTYPE_PURCHASELINEITEMS |
|
Tables |
POP10110 - POP_POLine POP10100 - POP_PO IV00101 - IV_Item_MSTR PM00200 - PM_Vendor_MSTR PM00201 - PM_Vendor_MSTR_SUM RM00101 - RM_Customer_MSTR RM00103 - RM_Customer_MSTR_SUM POP30110 - POP_POLineHist POP30100 - POP_POHist IV40201 - IV_UofM_SETP_HDR |
|
Joins |
POP10110 left-outer join to POP10100 POP10110 left-outer join to IV00101 POP10110 left-outer join to PM00200 POP10110 left-outer join to PM00201 POP10100 left-outer join to RM00101 POP10100 left-outer join to RM00103 POP30110 left-outer join to POP30100 POP30110 left-outer join to IV00101 POP30110 left-outer join to PM00200 POP30110 left-outer join to PM00201 POP30100 left-outer join to RM00101 POP30100 left-outer join to RM00103 IV00101 left-outer join to IV40201 |
|
Object type value |
7 |
|
Constant |
SMARTLIST_OBJECTTYPE_PURCHASEORDERS |
|
Tables |
POP10100 - POP_PO PM00200 - PM_Vendor_MSTR PM00201 - PM_Vendor_MSTR_SUM RM00101 - RM_Customer_MSTR RM00103 - RM_Customer_MSTR_SUM POP30100 - POP_POHist |
|
Joins |
POP10100 left-outer join to PM00200 POP10100 left-outer join to PM00201 POP10100 left-outer join to RM00101 POP10100 left-outer join to RM00103 POP30100 left-outer join to PM00200 POP30100 left-outer join to PM00201 POP30100 left-outer join to RM00101 POP30100 left-outer join to RM00103 |
|
Object type value |
8 |
|
Constant |
SMARTLIST_OBJECTTYPE_RECEIVABLESTRANSACTIONS |
|
Tables |
RM10301 - RM_Sales_WORK RM00101 - RM_Customer_MSTR MC020102 - MC_RM_Transactions RM00103 - RM_Customer_MSTR_SUM RM20101 - RM_OPEN RM30101 - RM_HISTORY |
|
Joins |
RM10301 left-outer join to RM00101 RM10301 left-outer join to MC020102 RM10301 left-outer join to RM00103 RM20101 left-outer join to RM00101 RM20101 left-outer join to MC020102 RM20101 left-outer join to RM00103 RM30101 left-outer join to RM00101 RM30101 left-outer join to MC020102 RM30101 left-outer join to RM00103 |
|
Object type value |
28 |
|
Constant |
SMARTLIST_OBJECTTYPE_RECEIVINGSLINEITEMS |
|
Tables |
POP10310 - POP_ReceiptLine POP10300 - POP_Receipt ASIV0001 - ASI_POP_ReceiptLine_QTYS IV00101 - IV_Item_MSTR POP30310 - POP_ReceiptLineHist POP30300 - POP_ReceiptHist IV40201 - IV_UofM_SETP_HDR |
|
Joins |
POP10310 left-outer join to POP10300 POP10310 left-outer join to ASIV0001 POP10310 left-outer join to IV00101 POP30310 left-outer join to POP30300 POP30310 left-outer join to ASIV0001 POP30310 left-outer join to IV00101 IV00101 left-outer join to IV40201 |
|
Object type value |
27 |
|
Constant |
SMARTLIST_OBJECTTYPE_RECEIVINGSTRANSACTIONS |
|
Tables |
POP10300 - POP_Receipt PM00201 - PM_Vendor_MSTR_SUM POP10306 - POP_ReceiptUserDefined POP30300 - POP_ReceiptHist |
|
Joins |
POP10300 left-outer join to PM00201 POP10300 left-outer join to POP10306 POP30300 left-outer join to PM00201 POP30300 left-outer join to POP10306 |
|
Object type value |
20 |
|
Constant |
SMARTLIST_OBJECTTYPE_SALESLINEITEMS |
|
Tables |
SOP10200 - SOP_LINE_WORK IV00101 - IV_Item_MSTR SOP10100 - SOP_HDR_WORK SOP10106 - sopUsrDefWorkHist RM00101 - RM_Customer_MSTR RM00103 - RM_Customer_MSTR_SUM SOP30300 - SOP_LINE_HIST SOP30200 - SOP_HDR_HIST IV40201 - IV_UofM_SETP_HDR |
|
Joins |
SOP10200 left-outer join to IV00101 SOP10200 left-outer join to SOP10100 SOP10200 left-outer join to SOP10106 SOP10100 left-outer join to RM00101 SOP10100 left-outer join to RM00103 SOP30300 left-outer join to IV00101 SOP30300 left-outer join to SOP30200 SOP30300 left-outer join to SOP10106 SOP30200 left-outer join to RM00101 SOP30200 left-outer join to RM00103 IV00101 left-outer join to IV40201 |
|
Object type value |
6 |
|
Constant |
SMARTLIST_OBJECTTYPE_SALESTRANSACTIONS |
|
Tables |
SOP10100 - SOP_HDR_WORK SOP10106 - sopUsrDefWorkHist RM00101 - RM_Customer_MSTR RM00103 - RM_Customer_MSTR_SUM SOP30200 - SOP_HDR_HIST |
|
Joins |
SOP10100 left-outer join to SOP10106 SOP10100 left-outer join to RM00101 SOP10100 left-outer join to RM00103 SOP30200 left-outer join to SOP10106 SOP30200 left-outer join to RM00101 SOP30200 left-outer join to RM00103 |
|
Object type value |
29 |
|
Constant |
SMARTLIST_OBJECTTYPE_TAXDETAILTRANSACTIONS |
|
Tables |
TX30000 - taxHistory TX00201 - TX_Detail_MSTR GL00100 - GL_Account_MSTR |
|
Joins |
TX30000 left-outer join to TX00201 TX30000 left-outer join to GL00100 |
|
Object type value |
16 |
|
Constant |
SMARTLIST_OBJECTTYPE_VENDORADDRESSES |
|
Tables |
PM00300 - PM_Address_MSTR PM00200 - PM_Vendor_MSTR SY01200 - coINetAddrs |
|
Joins |
PM00300 left-outer join to PM00200 PM00300 left-outer join to SY01200 |
|
Object type value |
23 |
|
Constant |
SMARTLIST_OBJECTTYPE_VENDORITEMS |
|
Tables |
IV00103 - IV_Item_MSTR_VNDR IV00101 - IV_Item_MSTR PM00200 - PM_Vendor_MSTR |
|
Joins |
IV00103 left-outer join to IV00101 IV00103 left-outer join to PM00200 |
|
Object type value |
3 |
|
Constant |
SMARTLIST_OBJECTTYPE_VENDORS |
|
Tables |
PM00200 - PM_Vendor_MSTR PM00201 - PM_Vendor_MSTR_SUM PA00001 - paCustomerVendorMSTR RM00101 - RM_Customer_MSTR |
|
Joins |
PM00200 left-outer join to PM00201 PM00200 left-outer join to PA00001 PM00200 left-outer join to RM00101 |