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:

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
2ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
3ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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 IDStringSTR_15_Vendor_ID15
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 TypeIntegerINT0
6VNDITNUM SearchVendor Item NumberStringItem_Number30
7QTYRQSTN SearchQTY RequisitionedCurrencyDLR17_QTY_RBS0_UTR17
8QTYONORD SearchQTY On OrderCurrencyDLR17_QTY_RBS0_UTR17
9QTY_Drop_Shipped SearchQTY Drop ShippedCurrencyDLR17_QTY_RBS0_UTR17
10LSTORDDT SearchLast ORD DateDateDATE6
11LSORDQTY SearchLast ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
12LRCPTQTY SearchLast RCPT QTYCurrencyDLR17_QTY_RBS0_UTR17
13LSRCPTDT SearchLast RCPT DateDateDATE6
14LRCPTCST SearchLast RCPT CostCurrencyDLR17_RBS0_UTR$17
15AVRGLDTM SearchAverage Lead TimeLong IntegerLI6_RBS2_UT6
16NORCTITM SearchNumber Of RCPTS For ItemIntegerINT44
17MINORQTY SearchMinimum ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
18MAXORDQTY SearchMaximum ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
19ECORDQTY SearchEconomic ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
20VNDITDSC SearchVendor Item DescriptionStringSTR100100
21Last_Originating_Cost SearchLast Originating CostCurrencyDLR17_RBS0_UTR$17
22Last_Currency_ID SearchLast Currency IDStringSTR15_Currency_ID15
23FREEONBOARD SearchFree On BoardIntegerDDL_Free_On_Board0
24PRCHSUOM SearchPurchasing U Of MStringU_Of_M8
25CURRNIDX SearchCurrency IndexIntegerINT33
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 TimeIntegerINT4_RB_U04
27ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
28ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
29ALTITEM1 SearchAlternate Item 1StringSTR30_Item_Number30
30ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
31ASMVRIDX SearchAssembly Variance IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 DateDateDT8
35CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
36DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
37DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
38DPSHPIDX SearchDrop Ship IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 CodeStringSTR10_Class_ID10
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 CodeStringSTR1515
44ITEMDESC SearchItem DescriptionStringSTR100100
45ITMGEDSC SearchItem Generic DescriptionStringSTR1010
46ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
47ITMSHNAM SearchItem Short NameStringSTR1515
48ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
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 OptionIntegerDDL_Track0
50ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
51IVCOGSIX SearchIV COGS IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 HistoryBooleanCB_Keep_Calendar_History0
62KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
63KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
64KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
65KTACCTSR SearchKit COGS Account SourceIntegerGB0
66LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
67LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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 TypeStringSTR10_Lot_Type10
69MSTRCDTY SearchMaster Record TypeIntegerINT11
70MODIFDT SearchModified DateDateDT8
71NOTEINDX SearchNote IndexCurrencyDLR1414
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 GroupStringSTR10_LBAU10
73PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
74PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
75PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 MStringU_Of_M8
79STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
80TCC SearchTax Commodity CodeStringSTR30_VAT30
81TAXOPTNS SearchTax OptionsIntegerDDL_Tax_Options0
82UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
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 IndexLong IntegerLI_1414
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 MethodIntegerDDL_Valuation_Method0
85WRNTYDYS SearchWarranty DaysIntegerINT44
86USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
87USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
88USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
89USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
90USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
91USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
92TEN99TYPE Search1099 TypeInteger1099_Type0
93ACNMVNDR SearchAccount Number With VendorStringSTR2020
94ACPURIDX SearchAccrued Purchases IndexLong IntegerLI_1414
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 1StringSTR6060
96ADDRESS2 SearchAddress 2StringSTR6060
97ADDRESS3 SearchAddress 3StringSTR6060
98CRTCOMDT SearchCertificate Commencing DateDateDT8
99CRTEXPDT SearchCertificate Expiration DateDateDT8
100CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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 SearchCityStringSTR3535
102COMMENT1 SearchComment1StringSTR3030
103COMMENT2 SearchComment2StringSTR3030
104COUNTRY SearchCountryStringSTR6060
105CREDTLMT SearchCredit LimitIntegerGB0
106CRLMTDLR SearchCredit Limit DollarCurrencyDLR17_$U217
107CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 NumberStringSTR2525
109DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
110DOCFMTID SearchDocument Format IDStringSTR15_LBU15
111DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
112XPDTOBLG SearchExpiration Date ObligationBooleanCB_Expiration_Date_Obligation0
113FAXNUMBR SearchFax NumberStringSTR14_FAX14
114GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
115GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
116HOLD SearchHoldBooleanCB_Hold0
117KGLDSTHS SearchKeep GL Dist HistoryBooleanCB_Keep_GL_Dist_History0
118MXIAFVND SearchMaximum Invoice Amount For VendorsIntegerGB0
119MAXINDLR SearchMaximum Invoice DollarCurrencyDLR17_$U217
120MXWOFAMT SearchMaximum Write Off AmountCurrencyDLR17_$U217
121MINORDER SearchMinimum OrderCurrencyDLR17_$U217
122MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
123MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
124MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
125PARVENID SearchParent Vendor IDStringSTR_15_Vendor_ID15
126PYMNTPRI SearchPayment PriorityStringSTR33
127PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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 3StringPhone_Number314
129PHNUMBR1 SearchPhone Number 1StringPhone_Number14
130PHNUMBR2 SearchPhone Number 2StringPhone_Number14
131PMAPINDX SearchPM AP IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 ToIntegerGB0
144PTCSHACF SearchPost To Cash Account FromIntegerGB0
145PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
146PRSPAYEE SearchPrescribed PayeeBooleanCB_Prescribed_Payee0
147RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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 UndertakenBooleanCB_Reporting_Obligation0
149Revalue_Vendor SearchRevalue VendorBooleanCB Revalue Vendor0
150SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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 SearchStateStringSTR30_State29
152SBPPSDED SearchSubject To PPS DeductionsBooleanCB_Subject_To_PPS_Deductions0
153TXIDNMBR SearchTax ID NumberStringTax_ID_Number11
154TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
155TXRGNNUM SearchTax Registration NumberStringSTR2525
156TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 DiscountIntegerINT4_%24
158UPSZONE SearchUPS ZoneStringSTR33
159USERDEF1 SearchUser Defined 1StringSTR2020
160USERDEF2 SearchUser Defined 2StringSTR2020
161VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
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 AddressStringSTR15_Address_Code15
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 ToStringSTR15_Address_Code15
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 FromStringSTR15_Address_Code15
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 NameStringSTR64_Vendor_Name64
166VNDCLSID SearchVendor Class IDStringSTR10_Class_ID10
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 ContactStringSTR6060
168VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
169VENDSHNM SearchVendor Short NameStringSTR1515
170VENDSTTS SearchVendor StatusIntegerDDL_Vendor_Status0
171WRITEOFF SearchWriteoffIntegerGB0
172ZIPCODE SearchZip CodeStringSTR1010
173CREATDDT1 SearchASI_Created_DateDateDT8
174KPCALHST1 SearchASI_Keep_Calendar_HistoryBooleanCB_Keep_Calendar_History0
175KPERHIST1 SearchASI_Keep_Period_HistoryBooleanCB_Keep_Period_History0
176KPTRXHST1 SearchASI_Keep_Trx_HistoryBooleanCB_Keep_Trx_History0
177MODIFDT1 SearchASI_Modified_DateDateDT8
178NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
179PRCHSUOM1 SearchASI_Purchasing_U_Of_MStringU_Of_M8
180FREEONBOARD1 SearchASI_Free_On_BoardIntegerDDL_Free_On_Board0
181PURPVIDX1 SearchASI_Purchase_Price_Variance_IndexLong IntegerLI_1414
azurecurveProductsSmartList (1493)PathnameItem Vendor SmartList (ASIEXP23)

Leave a Reply

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