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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_CodeString10
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 NumberSTR20String20
5RCRDTYPE SearchRecord TypeINT1Integer1
6PRIMVNDR SearchPrimary VendorSTR_15_Vendor_IDString15
7ITMFRFLG SearchItem Freeze FlagYNBoolean0
8BGNGQTY SearchBeginning QTYDLR17_QTY_RBS0_STRCurrency17
9LSORDQTY SearchLast ORD QTYDLR17_QTY_RBS0_UTRCurrency17
10LRCPTQTY SearchLast RCPT QTYDLR17_QTY_RBS0_UTRCurrency17
11LSTORDDT SearchLast ORD DateDATEDate6
12LSORDVND SearchLast ORD VendorSTR_15_Vendor_IDString15
13LSRCPTDT SearchLast RCPT DateDATEDate6
14QTYRQSTN SearchQTY RequisitionedDLR17_QTY_RBS0_UTRCurrency17
15QTYONORD SearchQTY On OrderDLR17_QTY_RBS0_UTRCurrency17
16QTYBKORD SearchQTY Back OrderedDLR17_QTY_RBS0_UTRCurrency17
17QTY_Drop_Shipped SearchQTY Drop ShippedDLR17_QTY_RBS0_UTRCurrency17
18ORDRPNTQTY SearchOrder Point QtyDLR17_QTY_RBS0_UTRCurrency17
19REORDERVARIANCE SearchReorder VarianceDLR17_QTY_RBS0_UTRCurrency17
20ORDRUPTOLVL SearchOrder Up To LevelDLR17_QTY_RBS0_UTRCurrency17
21QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
22QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
23QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
24QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
25QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
26ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
27QTYCOMTD SearchQTY CommittedDLR17_QTY_RBS0_UTRCurrency17
28QTYSOLD SearchQTY SoldDLR17_QTY_RBS0_UTRCurrency17
29DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
30DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
31QTYAVAIL SearchQTY AvailableDLR17_QTY_RBS0_UTRCurrency17
32ITEMDESC SearchItem DescriptionSTR100String100
33ITMGEDSC SearchItem Generic DescriptionSTR10String10
34ITMSHNAM SearchItem Short NameSTR15String15
35VENDNAME SearchVendor NameSTR64_Vendor_NameString64
36VNDITNUM SearchVendor Item NumberItem_NumberString30
37VNDITDSC SearchVendor Item DescriptionSTR100String100
38CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency17
39STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency17
40BASEUOFM SearchBase U Of MU_Of_MString8
41USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
42USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
43USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
44USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString10
45USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
46USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
47ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString30
48ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString30
49VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
50ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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_TypeInteger0
52ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger0
53KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
54KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
55KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
56KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
57ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer6
58TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger0
59IVIVINDX SearchIV IV IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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_IDString10
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_TypeString10
75ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
76UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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 TypeINT1Integer1
78WRNTYDYS SearchWarranty DaysINT4Integer4
79PRCLEVEL SearchPriceLevelSTR10_LBAUString10
80ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
81ABCCODE SearchABC CodeDDL_ABC_CodeInteger0
82CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 CodeSTR15String15
87KTACCTSR SearchKit COGS Account SourceGBInteger0
88LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString20
89PriceGroup SearchPrice GroupSTR10_LBAUString10
90PRICMTHD SearchPrice MethodDDL_Price_MethodInteger0
91PINFLIDX SearchPurch Inflation IndexLI_14Long Integer14
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 Integer14
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_MString8
94SELNGUOM SearchSelling U Of MU_Of_MString8
95TCC SearchTax Commodity CodeSTR30_VATString30
96UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer14
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 DateDTDate8
98LSTCNTTM SearchLast Count TimeTM6Time6
99NXTCNTDT SearchNext Count DateDTDate8
100NXTCNTTM SearchNext Count TimeTM6Time6
101STCKCNTINTRVL SearchStock Count IntervalINT4_U0Integer4
102LOCNCODE1 SearchASI_Location_CodeSTR10_Location_CodeString10
103VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_NameString64
105VENDSHNM SearchVendor Short NameSTR15String15
106VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString15
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_CodeString15
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_CodeString15
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_CodeString15
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_IDString10
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 ContactSTR60String60
112ADDRESS1 SearchAddress 1STR60String60
113ADDRESS2 SearchAddress 2STR60String60
114ADDRESS3 SearchAddress 3STR60String60
115CITY SearchCitySTR35String35
116STATE SearchStateSTR30_StateString29
117ZIPCODE SearchZip CodeSTR10String10
118COUNTRY SearchCountrySTR60String60
119PHNUMBR1 SearchPhone Number 1Phone_NumberString14
120PHNUMBR2 SearchPhone Number 2Phone_NumberString14
121FAXNUMBR SearchFax NumberSTR14_FAXString14
122UPSZONE SearchUPS ZoneSTR3String3
123SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_IDString15
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 VendorSTR20String20
126TXIDNMBR SearchTax ID NumberTax_ID_NumberString11
127VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger0
128CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 NumberSTR25String25
130PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString15
131TRDDISCT SearchTrade DiscountINT4_%2Integer4
132TEN99TYPE Search1099 Type1099_TypeInteger0
133MINORDER SearchMinimum OrderDLR17_$U2Currency17
134PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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_TypeInteger0
136MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
137MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
138MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger0
139MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency17
140COMMENT1 SearchComment1STR30String30
141COMMENT2 SearchComment2STR30String30
142USERDEF1 SearchUser Defined 1STR20String20
143USERDEF2 SearchUser Defined 2STR20String20
144CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency17
145PYMNTPRI SearchPayment PrioritySTR3String3
146KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean0
147HOLD SearchHoldCB_HoldBoolean0
148PTCSHACF SearchPost To Cash Account FromGBInteger0
149CREDTLMT SearchCredit LimitGBInteger0
150WRITEOFF SearchWriteoffGBInteger0
151MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency17
152SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean0
153PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
154DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String25
155CRTCOMDT SearchCertificate Commencing DateDTDate8
156CRTEXPDT SearchCertificate Expiration DateDTDate8
157RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean0
158XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean0
159PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean0
160PMAPINDX SearchPM AP IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
174NOTEINDX SearchNote IndexDLR14Currency14
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_IDString15
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 DateDTDate8
177CREATDDT SearchCreated DateDTDate8
178RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
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 VendorBoolean0
180Post_Results_To SearchPost Results ToGBInteger0
181FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger0
182DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
183DOCFMTID SearchDocument Format IDSTR15_LBUString15
184DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
185GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
186GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
187PHONE3 SearchPhone 3Phone_Number3String14
188TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
189KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean0
190KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean0
191KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean0
192UMDPQTYS SearchU Of M Decimal Places QTYSDDL_Decimal_Places_QTYSInteger0
193UMSCHDSC SearchU Of M Schedule DescriptionSTR30String30
194CURRNIDX SearchCurrency IndexINT3Integer3
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_UTRCurrency17
196ITMVNDTY SearchItem Vendor TypeINTInteger0
197Last_Currency_ID SearchLast Currency IDSTR15_Currency_IDString15
198Last_Originating_Cost SearchLast Originating CostDLR17_RBS0_UTR$Currency17
199LRCPTCST SearchLast RCPT CostDLR17_RBS0_UTR$Currency17
200MAXORDQTY SearchMaximum ORD QTYDLR17_QTY_RBS0_UTRCurrency17
201MINORQTY SearchMinimum ORD QTYDLR17_QTY_RBS0_UTRCurrency17
202NORCTITM SearchNumber Of RCPTS For ItemINT4Integer4
203PLANNINGLEADTIME SearchPlanning Lead TimeINT4_RB_U0Integer4
204AVRGLDTM SearchAverage Lead TimeLI6_RBS2_UTLong Integer6
205FREEONBOARD1 SearchASI_Free_On_BoardDDL_Free_On_BoardInteger0
206LSTORDDT1 SearchASI_Last_ORD_DateDATEDate6
207LSORDQTY1 SearchASI_Last_ORD_QTYDLR17_QTY_RBS0_UTRCurrency17
208LSRCPTDT1 SearchASI_Last_RCPT_DateDATEDate6
209LRCPTQTY1 SearchASI_Last_RCPT_QTYDLR17_QTY_RBS0_UTRCurrency17
210QTY_Drop_Shipped1 SearchASI_QTY_Drop_ShippedDLR17_QTY_RBS0_UTRCurrency17
211QTYONORD1 SearchASI_QTY_On_OrderDLR17_QTY_RBS0_UTRCurrency17
212QTYRQSTN1 SearchASI_QTY_RequisitionedDLR17_QTY_RBS0_UTRCurrency17
213PRCHSUOM1 SearchASI_Purchasing_U_Of_MU_Of_MString8
214Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString15
215PORETRNBIN SearchPurchase Returns BinSTR15_BinString15
216SOFULFILLMENTBIN SearchSO Fulfillment BinSTR15_BinString15
217SORETURNBIN SearchSO Return BinSTR15_BinString15
218BOMRCPTBIN SearchBOM Receipt BinSTR15_BinString15
219MATERIALISSUEBIN SearchMaterial Issues BinSTR15_BinString15
220MORECEIPTBIN SearchMO Receipt BinSTR15_BinString15
221REPAIRISSUESBIN SearchRepair Issues BinSTR15_BinString15
222BUYERID SearchBuyer IDSTR15_User_IDString15
223PLANNERID SearchPlanner IDSTR15_User_IDString15
224ORDERPOLICY SearchOrder PolicyDDL_Order_PolicyInteger0
225FXDORDRQTY SearchFixed Order QtyDLR17_QTY_RBS0_UTRCurrency17
226NMBROFDYS SearchNumber of DaysINT3_U0Integer3
227MNMMORDRQTY SearchMinimum Order QtyDLR17_QTY_RBS0_UTRCurrency17
228MXMMORDRQTY SearchMaximum Order QtyDLR17_QTY_RBS0_UTRCurrency17
229ORDERMULTIPLE SearchOrder MultipleDLR17_QTY_RBS0_UTRCurrency17
230REPLENISHMENTMETHOD SearchReplenishment MethodDDL_Replenishment_MethodInteger0
231SHRINKAGEFACTOR SearchShrinkage FactorDLR1_4Currency6
232PRCHSNGLDTM SearchPurchasing Lead TimeDLR4_U2Currency9
233MNFCTRNGFXDLDTM SearchManufacturing Fixed Lead TimeDLR4_U2Currency9
234MNFCTRNGVRBLLDTM SearchManufacturing Variable Lead TimeDLR3_U4Currency8
235STAGINGLDTME SearchStaging Lead TimeDLR4_U2Currency9
236PLNNNGTMFNCDYS SearchPlanning Time Fence DaysINT3_U0Integer3
237DMNDTMFNCPRDS SearchDemand Time Fence PeriodsINT3_U0Integer3
238INCLDDINPLNNNG SearchIncluded in PlanningCBBoolean0
239FRCSTCNSMPTNPRD SearchForecast Consumption PeriodDDL_Forecast_Consumption_PeriodInteger0
240SFTYSTCKQTY SearchSafety Stock QtyDLR17_QTY_RBS0_UTRCurrency17
241PORECEIPTBIN SearchPurchase Receipt BinSTR15_BinString15
242ReplenishmentLevel SearchReplenishment LevelDDL_ReplenishmentLevelInteger0
243POPOrderMethod SearchPOP Order MethodDDL_POP_OrderMethodInteger0
244MasterLocationCode SearchMaster Location CodeSTR10_Location_CodeString10
245POPVendorSelection SearchPOP Vendor SelectionDDL_POP_VendorSelectionInteger0
246POPPricingSelection SearchPOP Pricing SelectionDDL_POP_PriceSelectionInteger0
247PurchasePrice SearchPurchase PriceDLR17_RBS0_UTR$Currency17
248IncludeAllocations SearchInclude AllocationsCB_IncludeAllocationsBoolean0
249IncludeBackorders SearchInclude BackordersCB_IncludeBackordersBoolean0
250IncludeRequisitions SearchInclude RequisitionsCB_IncludeRequisitionsBoolean0
azurecurveProductsSmartList (1493)PathnameSmartList Item Quantity Master (ASIEXP11)

Leave a Reply

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