Item Vendor SmartList (ASIEXP23)

azurecurveProductsSmartList (1493)PathnameItem Vendor SmartList (ASIEXP23)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP23

Product: SmartList (1493)
Series: Pathname

Display Name: Item Vendor SmartList
Physical Name: ASIEXP23
Technical Name: ASI_Item_Vendor_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].ITEMNMBR AS 'Item Vendor SmartList-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Item Vendor SmartList'].ITEMNMBR = ['Item Master'].ITEMNMBR
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].VENDORID AS 'Item Vendor SmartList-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Item Vendor SmartList'].VENDORID = ['PM Vendor Master File'].VENDORID
5ITMVNDTY SearchItem Vendor TypeINTInteger20
6VNDITNUM SearchVendor Item NumberItem_NumberString3230
7QTYRQSTN SearchQTY RequisitionedDLR17_QTY_RBS0_UTRCurrency1017
8QTYONORD SearchQTY On OrderDLR17_QTY_RBS0_UTRCurrency1017
9QTY_Drop_Shipped SearchQTY Drop ShippedDLR17_QTY_RBS0_UTRCurrency1017
10LSTORDDT SearchLast ORD DateDATEDate46
11LSORDQTY SearchLast ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
12LRCPTQTY SearchLast RCPT QTYDLR17_QTY_RBS0_UTRCurrency1017
13LSRCPTDT SearchLast RCPT DateDATEDate46
14LRCPTCST SearchLast RCPT CostDLR17_RBS0_UTR$Currency1017
15AVRGLDTM SearchAverage Lead TimeLI6_RBS2_UTLong Integer46
16NORCTITM SearchNumber Of RCPTS For ItemINT4Integer24
17MINORQTY SearchMinimum ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
18MAXORDQTY SearchMaximum ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
19ECORDQTY SearchEconomic ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
20VNDITDSC SearchVendor Item DescriptionSTR100String102100
21Last_Originating_Cost SearchLast Originating CostDLR17_RBS0_UTR$Currency1017
22Last_Currency_ID SearchLast Currency IDSTR15_Currency_IDString1615
23FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
24PRCHSUOM SearchPurchasing U Of MU_Of_MString108
25CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].CURRNIDX AS 'Item Vendor SmartList-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Item Vendor SmartList'].CURRNIDX = ['Currency Setup'].CURRNIDX
26PLANNINGLEADTIME SearchPlanning Lead TimeINT4_RB_U0Integer24
27ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
28ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
29ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
30ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
31ASMVRIDX SearchAssembly Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].ASMVRIDX AS 'Item Vendor SmartList-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].ASMVRIDX = ['Account Index Master'].ACTINDX
32CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].CGSINFLX AS 'Item Vendor SmartList-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].CGSINFLX = ['Account Index Master'].ACTINDX
33CGSMCIDX SearchCOGS Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].CGSMCIDX AS 'Item Vendor SmartList-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].CGSMCIDX = ['Account Index Master'].ACTINDX
34CREATDDT SearchCreated DateDTDate48
35CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
36DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
37DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
38DPSHPIDX SearchDrop Ship IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].DPSHPIDX AS 'Item Vendor SmartList-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].DPSHPIDX = ['Account Index Master'].ACTINDX
39IVINFIDX SearchInventory Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVINFIDX AS 'Item Vendor SmartList-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVINFIDX = ['Account Index Master'].ACTINDX
40INVMCIDX SearchInventory Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].INVMCIDX AS 'Item Vendor SmartList-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].INVMCIDX = ['Account Index Master'].ACTINDX
41IVRETIDX SearchInventory Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVRETIDX AS 'Item Vendor SmartList-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVRETIDX = ['Account Index Master'].ACTINDX
42ITMCLSCD SearchItem Class CodeSTR10_Class_IDString1210
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].ITMCLSCD AS 'Item Vendor SmartList-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['Item Vendor SmartList'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
43ITEMCODE SearchItem CodeSTR15String1615
44ITEMDESC SearchItem DescriptionSTR100String102100
45ITMGEDSC SearchItem Generic DescriptionSTR10String1210
46ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
47ITMSHNAM SearchItem Short NameSTR15String1615
48ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].ITMTSHID AS 'Item Vendor SmartList-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Vendor SmartList'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
50ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
51IVCOGSIX SearchIV COGS IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVCOGSIX AS 'Item Vendor SmartList-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVCOGSIX = ['Account Index Master'].ACTINDX
52IVDMGIDX SearchIV Damaged IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVDMGIDX AS 'Item Vendor SmartList-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVDMGIDX = ['Account Index Master'].ACTINDX
53IVINSVIX SearchIV In Service IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVINSVIX AS 'Item Vendor SmartList-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVINSVIX = ['Account Index Master'].ACTINDX
54IVINUSIX SearchIV In Use IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVINUSIX AS 'Item Vendor SmartList-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVINUSIX = ['Account Index Master'].ACTINDX
55IVIVINDX SearchIV IV IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVIVINDX AS 'Item Vendor SmartList-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVIVINDX = ['Account Index Master'].ACTINDX
56IVIVOFIX SearchIV IV Offset IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVIVOFIX AS 'Item Vendor SmartList-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVIVOFIX = ['Account Index Master'].ACTINDX
57IVSLDSIX SearchIV Sales Discounts IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVSLDSIX AS 'Item Vendor SmartList-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVSLDSIX = ['Account Index Master'].ACTINDX
58IVSLSIDX SearchIV Sales IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVSLSIDX AS 'Item Vendor SmartList-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVSLSIDX = ['Account Index Master'].ACTINDX
59IVSLRNIX SearchIV Sales Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVSLRNIX AS 'Item Vendor SmartList-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVSLRNIX = ['Account Index Master'].ACTINDX
60IVVARIDX SearchIV Variances IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].IVVARIDX AS 'Item Vendor SmartList-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].IVVARIDX = ['Account Index Master'].ACTINDX
61KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
62KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
63KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
64KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
65KTACCTSR SearchKit COGS Account SourceGBInteger20
66LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
67LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].LOCNCODE AS 'Item Vendor SmartList-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Item Vendor SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE
68LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
69MSTRCDTY SearchMaster Record TypeINT1Integer21
70MODIFDT SearchModified DateDTDate48
71NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].NOTEINDX AS 'Item Vendor SmartList-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Item Vendor SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
72PriceGroup SearchPrice GroupSTR10_LBAUString1210
73PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
74PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
75PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PINFLIDX AS 'Item Vendor SmartList-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PINFLIDX = ['Account Index Master'].ACTINDX
76PURMCIDX SearchPurch Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PURMCIDX AS 'Item Vendor SmartList-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PURMCIDX = ['Account Index Master'].ACTINDX
77PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PURPVIDX AS 'Item Vendor SmartList-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PURPVIDX = ['Account Index Master'].ACTINDX
78SELNGUOM SearchSelling U Of MU_Of_MString108
79STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
80TCC SearchTax Commodity CodeSTR30_VATString3230
81TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
82UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].UOMSCHDL AS 'Item Vendor SmartList-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['Item Vendor SmartList'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
83UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].UPPVIDX AS 'Item Vendor SmartList-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].UPPVIDX = ['Account Index Master'].ACTINDX
84VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
85WRNTYDYS SearchWarranty DaysINT4Integer24
86USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
87USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
88USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
89USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
90USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
91USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
92TEN99TYPE Search1099 Type1099_TypeInteger20
93ACNMVNDR SearchAccount Number With VendorSTR20String2220
94ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].ACPURIDX AS 'Item Vendor SmartList-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].ACPURIDX = ['Account Index Master'].ACTINDX
95ADDRESS1 SearchAddress 1STR60String6260
96ADDRESS2 SearchAddress 2STR60String6260
97ADDRESS3 SearchAddress 3STR60String6260
98CRTCOMDT SearchCertificate Commencing DateDTDate48
99CRTEXPDT SearchCertificate Expiration DateDTDate48
100CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].CHEKBKID AS 'Item Vendor SmartList-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Item Vendor SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
101CITY SearchCitySTR35String3635
102COMMENT1 SearchComment1STR30String3230
103COMMENT2 SearchComment2STR30String3230
104COUNTRY SearchCountrySTR60String6260
105CREDTLMT SearchCredit LimitGBInteger20
106CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
107CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].CURNCYID AS 'Item Vendor SmartList-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Item Vendor SmartList'].CURNCYID = ['Currency Setup'].CURNCYID
108DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
109DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
110DOCFMTID SearchDocument Format IDSTR15_LBUString1615
111DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
112XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
113FAXNUMBR SearchFax NumberSTR14_FAXString2214
114GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
115GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
116HOLD SearchHoldCB_HoldBoolean20
117KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
118MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
119MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
120MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
121MINORDER SearchMinimum OrderDLR17_$U2Currency1017
122MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
123MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
124MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
125PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
126PYMNTPRI SearchPayment PrioritySTR3String43
127PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PYMTRMID AS 'Item Vendor SmartList-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Item Vendor SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
128PHONE3 SearchPhone 3Phone_Number3String2214
129PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
130PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
131PMAPINDX SearchPM AP IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMAPINDX AS 'Item Vendor SmartList-PM AP Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMAPINDX = ['Account Index Master'].ACTINDX
132PMCSHIDX SearchPM Cash IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMCSHIDX AS 'Item Vendor SmartList-PM Cash Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMCSHIDX = ['Account Index Master'].ACTINDX
133PMDAVIDX SearchPM Discount Available IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMDAVIDX AS 'Item Vendor SmartList-PM Discount Available Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMDAVIDX = ['Account Index Master'].ACTINDX
134PMDTKIDX SearchPM Discount Taken IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMDTKIDX AS 'Item Vendor SmartList-PM Discount Taken Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMDTKIDX = ['Account Index Master'].ACTINDX
135PMFINIDX SearchPM Finance Charge IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMFINIDX AS 'Item Vendor SmartList-PM Finance Charge Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMFINIDX = ['Account Index Master'].ACTINDX
136PMFRTIDX SearchPM Freight IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMFRTIDX AS 'Item Vendor SmartList-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMFRTIDX = ['Account Index Master'].ACTINDX
137PMMSCHIX SearchPM Misc Charges IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMMSCHIX AS 'Item Vendor SmartList-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMMSCHIX = ['Account Index Master'].ACTINDX
138PMPRCHIX SearchPM Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMPRCHIX AS 'Item Vendor SmartList-PM Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMPRCHIX = ['Account Index Master'].ACTINDX
139PMRTNGIX SearchPM Retainage IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMRTNGIX AS 'Item Vendor SmartList-PM Retainage Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMRTNGIX = ['Account Index Master'].ACTINDX
140PMTAXIDX SearchPM Tax IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMTAXIDX AS 'Item Vendor SmartList-PM Tax Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMTAXIDX = ['Account Index Master'].ACTINDX
141PMTDSCIX SearchPM Trade Discount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMTDSCIX AS 'Item Vendor SmartList-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMTDSCIX = ['Account Index Master'].ACTINDX
142PMWRTIDX SearchPM Write Offs IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].PMWRTIDX AS 'Item Vendor SmartList-PM Write Offs Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Vendor SmartList'].PMWRTIDX = ['Account Index Master'].ACTINDX
143Post_Results_To SearchPost Results ToGBInteger20
144PTCSHACF SearchPost To Cash Account FromGBInteger20
145PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
146PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
147RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].RATETPID AS 'Item Vendor SmartList-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Item Vendor SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
148RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
149Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean20
150SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].SHIPMTHD AS 'Item Vendor SmartList-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Item Vendor SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
151STATE SearchStateSTR30_StateString3029
152SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
153TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
154TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
155TXRGNNUM SearchTax Registration NumberSTR25String2625
156TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].TAXSCHID AS 'Item Vendor SmartList-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Vendor SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
157TRDDISCT SearchTrade DiscountINT4_%2Integer24
158UPSZONE SearchUPS ZoneSTR3String43
159USERDEF1 SearchUser Defined 1STR20String2220
160USERDEF2 SearchUser Defined 2STR20String2220
161VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].VADDCDPR AS 'Item Vendor SmartList-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Item Vendor SmartList'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID
162VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].VADCDPAD AS 'Item Vendor SmartList-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Item Vendor SmartList'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID
163VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].VADCDTRO AS 'Item Vendor SmartList-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Item Vendor SmartList'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID
164VADCDSFR SearchVendor Address Code - Ship FromSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].VADCDSFR AS 'Item Vendor SmartList-Vendor Address Code - Ship From'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Item Vendor SmartList'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID
165VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
166VNDCLSID SearchVendor Class IDSTR10_Class_IDString1210
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['Item Vendor SmartList'].VNDCLSID AS 'Item Vendor SmartList-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['Item Vendor SmartList'].VNDCLSID = ['PM Class Master File'].VNDCLSID
167VNDCNTCT SearchVendor ContactSTR60String6260
168VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
169VENDSHNM SearchVendor Short NameSTR15String1615
170VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
171WRITEOFF SearchWriteoffGBInteger20
172ZIPCODE SearchZip CodeSTR10String1210
173CREATDDT1 SearchASI_Created_DateDTDate48
174KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean20
175KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean20
176KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean20
177MODIFDT1 SearchASI_Modified_DateDTDate48
178NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
179PRCHSUOM1 SearchASI_Purchasing_U_Of_MU_Of_MString108
180FREEONBOARD1 SearchASI_Free_On_BoardDDL_Free_On_BoardInteger20
181PURPVIDX1 SearchASI_Purchase_Price_Variance_IndexLI_14Long Integer414
azurecurveProductsSmartList (1493)PathnameItem Vendor SmartList (ASIEXP23)

Leave a Reply

Your email address will not be published. Required fields are marked *