SmartList Item Quantity Master (ASIEXP11)

azurecurveProductsSmartList (1493)PathnameSmartList Item Quantity Master (ASIEXP11)

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

Product: SmartList (1493)
Series:

Display Name: SmartList Item Quantity Master
Physical Name: ASIEXP11
Technical Name: ASI_IV_Item_MSTR_QTYS_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].ITEMNMBR AS 'SmartList Item Quantity Master-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SmartList Item Quantity Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
3LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].LOCNCODE AS 'SmartList Item Quantity Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Item Quantity Master'].LOCNCODE = ['Site Setup'].LOCNCODE
4BINNMBR SearchBin NumberStringSTR2020
5RCRDTYPE SearchRecord TypeIntegerINT11
6PRIMVNDR SearchPrimary VendorStringSTR_15_Vendor_ID15
7ITMFRFLG SearchItem Freeze FlagBooleanYN0
8BGNGQTY SearchBeginning QTYCurrencyDLR17_QTY_RBS0_STR17
9LSORDQTY SearchLast ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
10LRCPTQTY SearchLast RCPT QTYCurrencyDLR17_QTY_RBS0_UTR17
11LSTORDDT SearchLast ORD DateDateDATE6
12LSORDVND SearchLast ORD VendorStringSTR_15_Vendor_ID15
13LSRCPTDT SearchLast RCPT DateDateDATE6
14QTYRQSTN SearchQTY RequisitionedCurrencyDLR17_QTY_RBS0_UTR17
15QTYONORD SearchQTY On OrderCurrencyDLR17_QTY_RBS0_UTR17
16QTYBKORD SearchQTY Back OrderedCurrencyDLR17_QTY_RBS0_UTR17
17QTY_Drop_Shipped SearchQTY Drop ShippedCurrencyDLR17_QTY_RBS0_UTR17
18ORDRPNTQTY SearchOrder Point QtyCurrencyDLR17_QTY_RBS0_UTR17
19REORDERVARIANCE SearchReorder VarianceCurrencyDLR17_QTY_RBS0_UTR17
20ORDRUPTOLVL SearchOrder Up To LevelCurrencyDLR17_QTY_RBS0_UTR17
21QTYINUSE SearchQTY In UseCurrencyDLR17_QTY_RBS0_UTR17
22QTYINSVC SearchQTY In ServiceCurrencyDLR17_QTY_RBS0_UTR17
23QTYRTRND SearchQTY ReturnedCurrencyDLR17_QTY_RBS0_UTR17
24QTYDMGED SearchQTY DamagedCurrencyDLR17_QTY_RBS0_UTR17
25QTYONHND SearchQTY On HandCurrencyDLR17_QTY_RBS0_STR17
26ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
27QTYCOMTD SearchQTY CommittedCurrencyDLR17_QTY_RBS0_UTR17
28QTYSOLD SearchQTY SoldCurrencyDLR17_QTY_RBS0_UTR17
29DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
30DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
31QTYAVAIL SearchQTY AvailableCurrencyDLR17_QTY_RBS0_UTR17
32ITEMDESC SearchItem DescriptionStringSTR100100
33ITMGEDSC SearchItem Generic DescriptionStringSTR1010
34ITMSHNAM SearchItem Short NameStringSTR1515
35VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
36VNDITNUM SearchVendor Item NumberStringItem_Number30
37VNDITDSC SearchVendor Item DescriptionStringSTR100100
38CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
39STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
40BASEUOFM SearchBase U Of MStringU_Of_M8
41USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
42USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
43USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
44USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
45USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
46USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
47ALTITEM1 SearchAlternate Item 1StringSTR30_Item_Number30
48ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
49VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
50ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].ITMTSHID AS 'SmartList Item Quantity Master-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Item Quantity Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
51ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
52ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
53KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
54KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
55KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
56KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
57ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
58TAXOPTNS SearchTax OptionsIntegerDDL_Tax_Options0
59IVIVINDX SearchIV IV IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVIVINDX AS 'SmartList Item Quantity Master-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVIVINDX = ['Account Index Master'].ACTINDX
60IVIVOFIX SearchIV IV Offset IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVIVOFIX AS 'SmartList Item Quantity Master-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVIVOFIX = ['Account Index Master'].ACTINDX
61IVCOGSIX SearchIV COGS IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVCOGSIX AS 'SmartList Item Quantity Master-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVCOGSIX = ['Account Index Master'].ACTINDX
62IVSLSIDX SearchIV Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVSLSIDX AS 'SmartList Item Quantity Master-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVSLSIDX = ['Account Index Master'].ACTINDX
63IVSLDSIX SearchIV Sales Discounts IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVSLDSIX AS 'SmartList Item Quantity Master-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVSLDSIX = ['Account Index Master'].ACTINDX
64IVSLRNIX SearchIV Sales Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVSLRNIX AS 'SmartList Item Quantity Master-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVSLRNIX = ['Account Index Master'].ACTINDX
65IVINUSIX SearchIV In Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVINUSIX AS 'SmartList Item Quantity Master-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVINUSIX = ['Account Index Master'].ACTINDX
66IVINSVIX SearchIV In Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVINSVIX AS 'SmartList Item Quantity Master-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVINSVIX = ['Account Index Master'].ACTINDX
67IVDMGIDX SearchIV Damaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVDMGIDX AS 'SmartList Item Quantity Master-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVDMGIDX = ['Account Index Master'].ACTINDX
68IVVARIDX SearchIV Variances IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVVARIDX AS 'SmartList Item Quantity Master-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVVARIDX = ['Account Index Master'].ACTINDX
69DPSHPIDX SearchDrop Ship IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].DPSHPIDX AS 'SmartList Item Quantity Master-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].DPSHPIDX = ['Account Index Master'].ACTINDX
70PURPVIDX SearchPurchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PURPVIDX AS 'SmartList Item Quantity Master-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PURPVIDX = ['Account Index Master'].ACTINDX
71IVRETIDX SearchInventory Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVRETIDX AS 'SmartList Item Quantity Master-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVRETIDX = ['Account Index Master'].ACTINDX
72ASMVRIDX SearchAssembly Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].ASMVRIDX AS 'SmartList Item Quantity Master-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].ASMVRIDX = ['Account Index Master'].ACTINDX
73ITMCLSCD SearchItem Class CodeStringSTR10_Class_ID10
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].ITMCLSCD AS 'SmartList Item Quantity Master-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['SmartList Item Quantity Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
74LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
75ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
76UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].UOMSCHDL AS 'SmartList Item Quantity Master-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['SmartList Item Quantity Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
77MSTRCDTY SearchMaster Record TypeIntegerINT11
78WRNTYDYS SearchWarranty DaysIntegerINT44
79PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
80ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
81ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
82CGSINFLX SearchCOGS Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].CGSINFLX AS 'SmartList Item Quantity Master-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].CGSINFLX = ['Account Index Master'].ACTINDX
83CGSMCIDX SearchCOGS Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].CGSMCIDX AS 'SmartList Item Quantity Master-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].CGSMCIDX = ['Account Index Master'].ACTINDX
84IVINFIDX SearchInventory Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].IVINFIDX AS 'SmartList Item Quantity Master-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].IVINFIDX = ['Account Index Master'].ACTINDX
85INVMCIDX SearchInventory Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].INVMCIDX AS 'SmartList Item Quantity Master-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].INVMCIDX = ['Account Index Master'].ACTINDX
86ITEMCODE SearchItem CodeStringSTR1515
87KTACCTSR SearchKit COGS Account SourceIntegerGB0
88LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
89PriceGroup SearchPrice GroupStringSTR10_LBAU10
90PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
91PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PINFLIDX AS 'SmartList Item Quantity Master-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PINFLIDX = ['Account Index Master'].ACTINDX
92PURMCIDX SearchPurch Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PURMCIDX AS 'SmartList Item Quantity Master-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PURMCIDX = ['Account Index Master'].ACTINDX
93PRCHSUOM SearchPurchasing U Of MStringU_Of_M8
94SELNGUOM SearchSelling U Of MStringU_Of_M8
95TCC SearchTax Commodity CodeStringSTR30_VAT30
96UPPVIDX SearchUnrealized Purchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].UPPVIDX AS 'SmartList Item Quantity Master-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].UPPVIDX = ['Account Index Master'].ACTINDX
97LSTCNTDT SearchLast Count DateDateDT8
98LSTCNTTM SearchLast Count TimeTimeTM66
99NXTCNTDT SearchNext Count DateDateDT8
100NXTCNTTM SearchNext Count TimeTimeTM66
101STCKCNTINTRVL SearchStock Count IntervalIntegerINT4_U04
102LOCNCODE1 SearchASI_Location_CodeStringSTR10_Location_Code10
103VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].VENDORID AS 'SmartList Item Quantity Master-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SmartList Item Quantity Master'].VENDORID = ['PM Vendor Master File'].VENDORID
104VNDCHKNM SearchVendor Check NameStringSTR64_Vendor_Name64
105VENDSHNM SearchVendor Short NameStringSTR1515
106VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].VADCDPAD AS 'SmartList Item Quantity Master-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Item Quantity Master'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID
108VADCDSFR SearchVendor Address Code - Ship FromStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].VADCDSFR AS 'SmartList Item Quantity Master-Vendor Address Code - Ship From'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Item Quantity Master'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID
109VADCDTRO SearchVendor Address Code - Remit ToStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].VADCDTRO AS 'SmartList Item Quantity Master-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Item Quantity Master'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID
110VNDCLSID SearchVendor Class IDStringSTR10_Class_ID10
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].VNDCLSID AS 'SmartList Item Quantity Master-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['SmartList Item Quantity Master'].VNDCLSID = ['PM Class Master File'].VNDCLSID
111VNDCNTCT SearchVendor ContactStringSTR6060
112ADDRESS1 SearchAddress 1StringSTR6060
113ADDRESS2 SearchAddress 2StringSTR6060
114ADDRESS3 SearchAddress 3StringSTR6060
115CITY SearchCityStringSTR3535
116STATE SearchStateStringSTR30_State29
117ZIPCODE SearchZip CodeStringSTR1010
118COUNTRY SearchCountryStringSTR6060
119PHNUMBR1 SearchPhone Number 1StringPhone_Number14
120PHNUMBR2 SearchPhone Number 2StringPhone_Number14
121FAXNUMBR SearchFax NumberStringSTR14_FAX14
122UPSZONE SearchUPS ZoneStringSTR33
123SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].SHIPMTHD AS 'SmartList Item Quantity Master-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Item Quantity Master'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
124TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].TAXSCHID AS 'SmartList Item Quantity Master-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Item Quantity Master'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
125ACNMVNDR SearchAccount Number With VendorStringSTR2020
126TXIDNMBR SearchTax ID NumberStringTax_ID_Number11
127VENDSTTS SearchVendor StatusIntegerDDL_Vendor_Status0
128CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].CURNCYID AS 'SmartList Item Quantity Master-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Item Quantity Master'].CURNCYID = ['Currency Setup'].CURNCYID
129TXRGNNUM SearchTax Registration NumberStringSTR2525
130PARVENID SearchParent Vendor IDStringSTR_15_Vendor_ID15
131TRDDISCT SearchTrade DiscountIntegerINT4_%24
132TEN99TYPE Search1099 TypeInteger1099_Type0
133MINORDER SearchMinimum OrderCurrencyDLR17_$U217
134PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PYMTRMID AS 'SmartList Item Quantity Master-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Item Quantity Master'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
135MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
136MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
137MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
138MXIAFVND SearchMaximum Invoice Amount For VendorsIntegerGB0
139MAXINDLR SearchMaximum Invoice DollarCurrencyDLR17_$U217
140COMMENT1 SearchComment1StringSTR3030
141COMMENT2 SearchComment2StringSTR3030
142USERDEF1 SearchUser Defined 1StringSTR2020
143USERDEF2 SearchUser Defined 2StringSTR2020
144CRLMTDLR SearchCredit Limit DollarCurrencyDLR17_$U217
145PYMNTPRI SearchPayment PriorityStringSTR33
146KGLDSTHS SearchKeep GL Dist HistoryBooleanCB_Keep_GL_Dist_History0
147HOLD SearchHoldBooleanCB_Hold0
148PTCSHACF SearchPost To Cash Account FromIntegerGB0
149CREDTLMT SearchCredit LimitIntegerGB0
150WRITEOFF SearchWriteoffIntegerGB0
151MXWOFAMT SearchMaximum Write Off AmountCurrencyDLR17_$U217
152SBPPSDED SearchSubject To PPS DeductionsBooleanCB_Subject_To_PPS_Deductions0
153PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
154DXVARNUM SearchDeduction Exemption/Variation NumberStringSTR2525
155CRTCOMDT SearchCertificate Commencing DateDateDT8
156CRTEXPDT SearchCertificate Expiration DateDateDT8
157RTOBUTKN SearchReporting Obligation UndertakenBooleanCB_Reporting_Obligation0
158XPDTOBLG SearchExpiration Date ObligationBooleanCB_Expiration_Date_Obligation0
159PRSPAYEE SearchPrescribed PayeeBooleanCB_Prescribed_Payee0
160PMAPINDX SearchPM AP IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMAPINDX AS 'SmartList Item Quantity Master-PM AP Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMAPINDX = ['Account Index Master'].ACTINDX
161PMCSHIDX SearchPM Cash IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMCSHIDX AS 'SmartList Item Quantity Master-PM Cash Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMCSHIDX = ['Account Index Master'].ACTINDX
162PMDAVIDX SearchPM Discount Available IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMDAVIDX AS 'SmartList Item Quantity Master-PM Discount Available Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMDAVIDX = ['Account Index Master'].ACTINDX
163PMDTKIDX SearchPM Discount Taken IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMDTKIDX AS 'SmartList Item Quantity Master-PM Discount Taken Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMDTKIDX = ['Account Index Master'].ACTINDX
164PMFINIDX SearchPM Finance Charge IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMFINIDX AS 'SmartList Item Quantity Master-PM Finance Charge Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMFINIDX = ['Account Index Master'].ACTINDX
165PMMSCHIX SearchPM Misc Charges IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMMSCHIX AS 'SmartList Item Quantity Master-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMMSCHIX = ['Account Index Master'].ACTINDX
166PMFRTIDX SearchPM Freight IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMFRTIDX AS 'SmartList Item Quantity Master-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMFRTIDX = ['Account Index Master'].ACTINDX
167PMTAXIDX SearchPM Tax IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMTAXIDX AS 'SmartList Item Quantity Master-PM Tax Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMTAXIDX = ['Account Index Master'].ACTINDX
168PMWRTIDX SearchPM Write Offs IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMWRTIDX AS 'SmartList Item Quantity Master-PM Write Offs Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMWRTIDX = ['Account Index Master'].ACTINDX
169PMPRCHIX SearchPM Purchases IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMPRCHIX AS 'SmartList Item Quantity Master-PM Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMPRCHIX = ['Account Index Master'].ACTINDX
170PMRTNGIX SearchPM Retainage IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMRTNGIX AS 'SmartList Item Quantity Master-PM Retainage Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMRTNGIX = ['Account Index Master'].ACTINDX
171PMTDSCIX SearchPM Trade Discount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].PMTDSCIX AS 'SmartList Item Quantity Master-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].PMTDSCIX = ['Account Index Master'].ACTINDX
172ACPURIDX SearchAccrued Purchases IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].ACPURIDX AS 'SmartList Item Quantity Master-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Quantity Master'].ACPURIDX = ['Account Index Master'].ACTINDX
173PURPVIDX1 SearchASI_Purchase_Price_Variance_IndexLong IntegerLI_1414
174NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].NOTEINDX AS 'SmartList Item Quantity Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Item Quantity Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
175CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].CHEKBKID AS 'SmartList Item Quantity Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Item Quantity Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
176MODIFDT SearchModified DateDateDT8
177CREATDDT SearchCreated DateDateDT8
178RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].RATETPID AS 'SmartList Item Quantity Master-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Item Quantity Master'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
179Revalue_Vendor SearchRevalue VendorBooleanCB Revalue Vendor0
180Post_Results_To SearchPost Results ToIntegerGB0
181FREEONBOARD SearchFree On BoardIntegerDDL_Free_On_Board0
182DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
183DOCFMTID SearchDocument Format IDStringSTR15_LBU15
184DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
185GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
186GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
187PHONE3 SearchPhone 3StringPhone_Number314
188TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
189KPCALHST1 SearchASI_Keep_Calendar_HistoryBooleanCB_Keep_Calendar_History0
190KPERHIST1 SearchASI_Keep_Period_HistoryBooleanCB_Keep_Period_History0
191KPTRXHST1 SearchASI_Keep_Trx_HistoryBooleanCB_Keep_Trx_History0
192UMDPQTYS SearchU Of M Decimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
193UMSCHDSC SearchU Of M Schedule DescriptionStringSTR3030
194CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Item Quantity Master'].CURRNIDX AS 'SmartList Item Quantity Master-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Item Quantity Master'].CURRNIDX = ['Currency Setup'].CURRNIDX
195ECORDQTY SearchEconomic ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
196ITMVNDTY SearchItem Vendor TypeIntegerINT0
197Last_Currency_ID SearchLast Currency IDStringSTR15_Currency_ID15
198Last_Originating_Cost SearchLast Originating CostCurrencyDLR17_RBS0_UTR$17
199LRCPTCST SearchLast RCPT CostCurrencyDLR17_RBS0_UTR$17
200MAXORDQTY SearchMaximum ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
201MINORQTY SearchMinimum ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
202NORCTITM SearchNumber Of RCPTS For ItemIntegerINT44
203PLANNINGLEADTIME SearchPlanning Lead TimeIntegerINT4_RB_U04
204AVRGLDTM SearchAverage Lead TimeLong IntegerLI6_RBS2_UT6
205FREEONBOARD1 SearchASI_Free_On_BoardIntegerDDL_Free_On_Board0
206LSTORDDT1 SearchASI_Last_ORD_DateDateDATE6
207LSORDQTY1 SearchASI_Last_ORD_QTYCurrencyDLR17_QTY_RBS0_UTR17
208LSRCPTDT1 SearchASI_Last_RCPT_DateDateDATE6
209LRCPTQTY1 SearchASI_Last_RCPT_QTYCurrencyDLR17_QTY_RBS0_UTR17
210QTY_Drop_Shipped1 SearchASI_QTY_Drop_ShippedCurrencyDLR17_QTY_RBS0_UTR17
211QTYONORD1 SearchASI_QTY_On_OrderCurrencyDLR17_QTY_RBS0_UTR17
212QTYRQSTN1 SearchASI_QTY_RequisitionedCurrencyDLR17_QTY_RBS0_UTR17
213PRCHSUOM1 SearchASI_Purchasing_U_Of_MStringU_Of_M8
214Landed_Cost_Group_ID SearchLanded Cost Group IDStringSTR15_LBAU15
215PORETRNBIN SearchPurchase Returns BinStringSTR15_Bin15
216SOFULFILLMENTBIN SearchSO Fulfillment BinStringSTR15_Bin15
217SORETURNBIN SearchSO Return BinStringSTR15_Bin15
218BOMRCPTBIN SearchBOM Receipt BinStringSTR15_Bin15
219MATERIALISSUEBIN SearchMaterial Issues BinStringSTR15_Bin15
220MORECEIPTBIN SearchMO Receipt BinStringSTR15_Bin15
221REPAIRISSUESBIN SearchRepair Issues BinStringSTR15_Bin15
222BUYERID SearchBuyer IDStringSTR15_User_ID15
223PLANNERID SearchPlanner IDStringSTR15_User_ID15
224ORDERPOLICY SearchOrder PolicyIntegerDDL_Order_Policy0
225FXDORDRQTY SearchFixed Order QtyCurrencyDLR17_QTY_RBS0_UTR17
226NMBROFDYS SearchNumber of DaysIntegerINT3_U03
227MNMMORDRQTY SearchMinimum Order QtyCurrencyDLR17_QTY_RBS0_UTR17
228MXMMORDRQTY SearchMaximum Order QtyCurrencyDLR17_QTY_RBS0_UTR17
229ORDERMULTIPLE SearchOrder MultipleCurrencyDLR17_QTY_RBS0_UTR17
230REPLENISHMENTMETHOD SearchReplenishment MethodIntegerDDL_Replenishment_Method0
231SHRINKAGEFACTOR SearchShrinkage FactorCurrencyDLR1_46
232PRCHSNGLDTM SearchPurchasing Lead TimeCurrencyDLR4_U29
233MNFCTRNGFXDLDTM SearchManufacturing Fixed Lead TimeCurrencyDLR4_U29
234MNFCTRNGVRBLLDTM SearchManufacturing Variable Lead TimeCurrencyDLR3_U48
235STAGINGLDTME SearchStaging Lead TimeCurrencyDLR4_U29
236PLNNNGTMFNCDYS SearchPlanning Time Fence DaysIntegerINT3_U03
237DMNDTMFNCPRDS SearchDemand Time Fence PeriodsIntegerINT3_U03
238INCLDDINPLNNNG SearchIncluded in PlanningBooleanCB0
239FRCSTCNSMPTNPRD SearchForecast Consumption PeriodIntegerDDL_Forecast_Consumption_Period0
240SFTYSTCKQTY SearchSafety Stock QtyCurrencyDLR17_QTY_RBS0_UTR17
241PORECEIPTBIN SearchPurchase Receipt BinStringSTR15_Bin15
242ReplenishmentLevel SearchReplenishment LevelIntegerDDL_ReplenishmentLevel0
243POPOrderMethod SearchPOP Order MethodIntegerDDL_POP_OrderMethod0
244MasterLocationCode SearchMaster Location CodeStringSTR10_Location_Code10
245POPVendorSelection SearchPOP Vendor SelectionIntegerDDL_POP_VendorSelection0
246POPPricingSelection SearchPOP Pricing SelectionIntegerDDL_POP_PriceSelection0
247PurchasePrice SearchPurchase PriceCurrencyDLR17_RBS0_UTR$17
248IncludeAllocations SearchInclude AllocationsBooleanCB_IncludeAllocations0
249IncludeBackorders SearchInclude BackordersBooleanCB_IncludeBackorders0
250IncludeRequisitions SearchInclude RequisitionsBooleanCB_IncludeRequisitions0
azurecurveProductsSmartList (1493)PathnameSmartList Item Quantity Master (ASIEXP11)

Leave a Reply

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