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: Pathname

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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 CodeSTR10_Location_CodeString1210
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 NumberSTR20String2220
5RCRDTYPE SearchRecord TypeINT1Integer21
6PRIMVNDR SearchPrimary VendorSTR_15_Vendor_IDString1615
7ITMFRFLG SearchItem Freeze FlagYNBoolean20
8BGNGQTY SearchBeginning QTYDLR17_QTY_RBS0_STRCurrency1017
9LSORDQTY SearchLast ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
10LRCPTQTY SearchLast RCPT QTYDLR17_QTY_RBS0_UTRCurrency1017
11LSTORDDT SearchLast ORD DateDATEDate46
12LSORDVND SearchLast ORD VendorSTR_15_Vendor_IDString1615
13LSRCPTDT SearchLast RCPT DateDATEDate46
14QTYRQSTN SearchQTY RequisitionedDLR17_QTY_RBS0_UTRCurrency1017
15QTYONORD SearchQTY On OrderDLR17_QTY_RBS0_UTRCurrency1017
16QTYBKORD SearchQTY Back OrderedDLR17_QTY_RBS0_UTRCurrency1017
17QTY_Drop_Shipped SearchQTY Drop ShippedDLR17_QTY_RBS0_UTRCurrency1017
18ORDRPNTQTY SearchOrder Point QtyDLR17_QTY_RBS0_UTRCurrency1017
19REORDERVARIANCE SearchReorder VarianceDLR17_QTY_RBS0_UTRCurrency1017
20ORDRUPTOLVL SearchOrder Up To LevelDLR17_QTY_RBS0_UTRCurrency1017
21QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
22QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
23QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
24QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
25QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
26ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
27QTYCOMTD SearchQTY CommittedDLR17_QTY_RBS0_UTRCurrency1017
28QTYSOLD SearchQTY SoldDLR17_QTY_RBS0_UTRCurrency1017
29DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
30DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
31QTYAVAIL SearchQTY AvailableDLR17_QTY_RBS0_UTRCurrency1017
32ITEMDESC SearchItem DescriptionSTR100String102100
33ITMGEDSC SearchItem Generic DescriptionSTR10String1210
34ITMSHNAM SearchItem Short NameSTR15String1615
35VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
36VNDITNUM SearchVendor Item NumberItem_NumberString3230
37VNDITDSC SearchVendor Item DescriptionSTR100String102100
38CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
39STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
40BASEUOFM SearchBase U Of MU_Of_MString108
41USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
42USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
43USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
44USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
45USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
46USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
47ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
48ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
49VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
50ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
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 TypeDDL_Item_TypeInteger20
52ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
53KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
54KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
55KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
56KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
57ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
58TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
59IVIVINDX SearchIV IV IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 CodeSTR10_Class_IDString1210
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 TypeSTR10_Lot_TypeString1210
75ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
76UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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 TypeINT1Integer21
78WRNTYDYS SearchWarranty DaysINT4Integer24
79PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
80ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
81ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
82CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 CodeSTR15String1615
87KTACCTSR SearchKit COGS Account SourceGBInteger20
88LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
89PriceGroup SearchPrice GroupSTR10_LBAUString1210
90PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
91PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 MU_Of_MString108
94SELNGUOM SearchSelling U Of MU_Of_MString108
95TCC SearchTax Commodity CodeSTR30_VATString3230
96UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
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 DateDTDate48
98LSTCNTTM SearchLast Count TimeTM6Time46
99NXTCNTDT SearchNext Count DateDTDate48
100NXTCNTTM SearchNext Count TimeTM6Time46
101STCKCNTINTRVL SearchStock Count IntervalINT4_U0Integer24
102LOCNCODE1 SearchASI_Location_CodeSTR10_Location_CodeString1210
103VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 NameSTR64_Vendor_NameString6664
105VENDSHNM SearchVendor Short NameSTR15String1615
106VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
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 AddressSTR15_Address_CodeString1615
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 FromSTR15_Address_CodeString1615
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 ToSTR15_Address_CodeString1615
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 IDSTR10_Class_IDString1210
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 ContactSTR60String6260
112ADDRESS1 SearchAddress 1STR60String6260
113ADDRESS2 SearchAddress 2STR60String6260
114ADDRESS3 SearchAddress 3STR60String6260
115CITY SearchCitySTR35String3635
116STATE SearchStateSTR30_StateString3029
117ZIPCODE SearchZip CodeSTR10String1210
118COUNTRY SearchCountrySTR60String6260
119PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
120PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
121FAXNUMBR SearchFax NumberSTR14_FAXString2214
122UPSZONE SearchUPS ZoneSTR3String43
123SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 IDSTR15_Tax_Schedule_IDString1615
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 VendorSTR20String2220
126TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
127VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
128CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 NumberSTR25String2625
130PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
131TRDDISCT SearchTrade DiscountINT4_%2Integer24
132TEN99TYPE Search1099 Type1099_TypeInteger20
133MINORDER SearchMinimum OrderDLR17_$U2Currency1017
134PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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 TypeGB_Amt_TypeInteger20
136MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
137MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
138MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
139MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
140COMMENT1 SearchComment1STR30String3230
141COMMENT2 SearchComment2STR30String3230
142USERDEF1 SearchUser Defined 1STR20String2220
143USERDEF2 SearchUser Defined 2STR20String2220
144CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
145PYMNTPRI SearchPayment PrioritySTR3String43
146KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
147HOLD SearchHoldCB_HoldBoolean20
148PTCSHACF SearchPost To Cash Account FromGBInteger20
149CREDTLMT SearchCredit LimitGBInteger20
150WRITEOFF SearchWriteoffGBInteger20
151MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
152SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
153PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
154DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
155CRTCOMDT SearchCertificate Commencing DateDTDate48
156CRTEXPDT SearchCertificate Expiration DateDTDate48
157RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
158XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
159PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
160PMAPINDX SearchPM AP IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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_IndexLI_14Long Integer414
174NOTEINDX SearchNote IndexDLR14Currency1014
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 IDSTR15_Checkbook_IDString1615
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 DateDTDate48
177CREATDDT SearchCreated DateDTDate48
178RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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 VendorCB Revalue VendorBoolean20
180Post_Results_To SearchPost Results ToGBInteger20
181FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
182DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
183DOCFMTID SearchDocument Format IDSTR15_LBUString1615
184DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
185GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
186GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
187PHONE3 SearchPhone 3Phone_Number3String2214
188TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
189KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean20
190KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean20
191KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean20
192UMDPQTYS SearchU Of M Decimal Places QTYSDDL_Decimal_Places_QTYSInteger20
193UMSCHDSC SearchU Of M Schedule DescriptionSTR30String3230
194CURRNIDX SearchCurrency IndexINT3Integer23
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 QTYDLR17_QTY_RBS0_UTRCurrency1017
196ITMVNDTY SearchItem Vendor TypeINTInteger20
197Last_Currency_ID SearchLast Currency IDSTR15_Currency_IDString1615
198Last_Originating_Cost SearchLast Originating CostDLR17_RBS0_UTR$Currency1017
199LRCPTCST SearchLast RCPT CostDLR17_RBS0_UTR$Currency1017
200MAXORDQTY SearchMaximum ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
201MINORQTY SearchMinimum ORD QTYDLR17_QTY_RBS0_UTRCurrency1017
202NORCTITM SearchNumber Of RCPTS For ItemINT4Integer24
203PLANNINGLEADTIME SearchPlanning Lead TimeINT4_RB_U0Integer24
204AVRGLDTM SearchAverage Lead TimeLI6_RBS2_UTLong Integer46
205FREEONBOARD1 SearchASI_Free_On_BoardDDL_Free_On_BoardInteger20
206LSTORDDT1 SearchASI_Last_ORD_DateDATEDate46
207LSORDQTY1 SearchASI_Last_ORD_QTYDLR17_QTY_RBS0_UTRCurrency1017
208LSRCPTDT1 SearchASI_Last_RCPT_DateDATEDate46
209LRCPTQTY1 SearchASI_Last_RCPT_QTYDLR17_QTY_RBS0_UTRCurrency1017
210QTY_Drop_Shipped1 SearchASI_QTY_Drop_ShippedDLR17_QTY_RBS0_UTRCurrency1017
211QTYONORD1 SearchASI_QTY_On_OrderDLR17_QTY_RBS0_UTRCurrency1017
212QTYRQSTN1 SearchASI_QTY_RequisitionedDLR17_QTY_RBS0_UTRCurrency1017
213PRCHSUOM1 SearchASI_Purchasing_U_Of_MU_Of_MString108
214Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString1615
215PORETRNBIN SearchPurchase Returns BinSTR15_BinString1615
216SOFULFILLMENTBIN SearchSO Fulfillment BinSTR15_BinString1615
217SORETURNBIN SearchSO Return BinSTR15_BinString1615
218BOMRCPTBIN SearchBOM Receipt BinSTR15_BinString1615
219MATERIALISSUEBIN SearchMaterial Issues BinSTR15_BinString1615
220MORECEIPTBIN SearchMO Receipt BinSTR15_BinString1615
221REPAIRISSUESBIN SearchRepair Issues BinSTR15_BinString1615
222BUYERID SearchBuyer IDSTR15_User_IDString1615
223PLANNERID SearchPlanner IDSTR15_User_IDString1615
224ORDERPOLICY SearchOrder PolicyDDL_Order_PolicyInteger20
225FXDORDRQTY SearchFixed Order QtyDLR17_QTY_RBS0_UTRCurrency1017
226NMBROFDYS SearchNumber of DaysINT3_U0Integer23
227MNMMORDRQTY SearchMinimum Order QtyDLR17_QTY_RBS0_UTRCurrency1017
228MXMMORDRQTY SearchMaximum Order QtyDLR17_QTY_RBS0_UTRCurrency1017
229ORDERMULTIPLE SearchOrder MultipleDLR17_QTY_RBS0_UTRCurrency1017
230REPLENISHMENTMETHOD SearchReplenishment MethodDDL_Replenishment_MethodInteger20
231SHRINKAGEFACTOR SearchShrinkage FactorDLR1_4Currency106
232PRCHSNGLDTM SearchPurchasing Lead TimeDLR4_U2Currency109
233MNFCTRNGFXDLDTM SearchManufacturing Fixed Lead TimeDLR4_U2Currency109
234MNFCTRNGVRBLLDTM SearchManufacturing Variable Lead TimeDLR3_U4Currency108
235STAGINGLDTME SearchStaging Lead TimeDLR4_U2Currency109
236PLNNNGTMFNCDYS SearchPlanning Time Fence DaysINT3_U0Integer23
237DMNDTMFNCPRDS SearchDemand Time Fence PeriodsINT3_U0Integer23
238INCLDDINPLNNNG SearchIncluded in PlanningCBBoolean20
239FRCSTCNSMPTNPRD SearchForecast Consumption PeriodDDL_Forecast_Consumption_PeriodInteger20
240SFTYSTCKQTY SearchSafety Stock QtyDLR17_QTY_RBS0_UTRCurrency1017
241PORECEIPTBIN SearchPurchase Receipt BinSTR15_BinString1615
242ReplenishmentLevel SearchReplenishment LevelDDL_ReplenishmentLevelInteger20
243POPOrderMethod SearchPOP Order MethodDDL_POP_OrderMethodInteger20
244MasterLocationCode SearchMaster Location CodeSTR10_Location_CodeString1210
245POPVendorSelection SearchPOP Vendor SelectionDDL_POP_VendorSelectionInteger20
246POPPricingSelection SearchPOP Pricing SelectionDDL_POP_PriceSelectionInteger20
247PurchasePrice SearchPurchase PriceDLR17_RBS0_UTR$Currency1017
248IncludeAllocations SearchInclude AllocationsCB_IncludeAllocationsBoolean20
249IncludeBackorders SearchInclude BackordersCB_IncludeBackordersBoolean20
250IncludeRequisitions SearchInclude RequisitionsCB_IncludeRequisitionsBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList Item Quantity Master (ASIEXP11)

Leave a Reply

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