SmartList Item Master (ASIEXP04)

azurecurveProductsSmartList (1493)PathnameSmartList Item Master (ASIEXP04)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Item Master
Physical Name: ASIEXP04
Technical Name: ASI_IV_Item_MSTR_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 Master'].ITEMNMBR AS 'SmartList Item Master-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SmartList Item Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
3ITEMDESC SearchItem DescriptionSTR100String102100
4NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Item Master'].NOTEINDX AS 'SmartList Item Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Item Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
5ITMSHNAM SearchItem Short NameSTR15String1615
6ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
7ITMGEDSC SearchItem Generic DescriptionSTR10String1210
8STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
9CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
10ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
11DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
13ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Item Master'].ITMTSHID AS 'SmartList Item Master-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Item Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
14TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
15IVIVINDX SearchIV IV IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].IVIVOFIX AS 'SmartList Item Master-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].IVIVOFIX = ['Account Index Master'].ACTINDX
17IVCOGSIX SearchIV COGS IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Master'].IVCOGSIX AS 'SmartList Item Master-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].IVCOGSIX = ['Account Index Master'].ACTINDX
18IVSLSIDX SearchIV Sales IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].IVSLRNIX AS 'SmartList Item Master-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].IVSLRNIX = ['Account Index Master'].ACTINDX
21IVINUSIX SearchIV In Use IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].IVDMGIDX AS 'SmartList Item Master-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].IVDMGIDX = ['Account Index Master'].ACTINDX
24IVVARIDX SearchIV Variances IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Master'].IVVARIDX AS 'SmartList Item Master-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].IVVARIDX = ['Account Index Master'].ACTINDX
25DPSHPIDX SearchDrop Ship IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Master'].DPSHPIDX AS 'SmartList Item Master-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].DPSHPIDX = ['Account Index Master'].ACTINDX
26PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Master'].PURPVIDX AS 'SmartList Item Master-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].PURPVIDX = ['Account Index Master'].ACTINDX
27IVRETIDX SearchInventory Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Master'].IVRETIDX AS 'SmartList Item Master-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].IVRETIDX = ['Account Index Master'].ACTINDX
28ASMVRIDX SearchAssembly Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].ITMCLSCD AS 'SmartList Item Master-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['SmartList Item Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
30ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
31LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
32KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
33KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
34KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
35KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
36ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
37VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
38UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['SmartList Item Master'].UOMSCHDL AS 'SmartList Item Master-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['SmartList Item Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
39ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
40ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
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
47MSTRCDTY SearchMaster Record TypeINT1Integer21
48MODIFDT SearchModified DateDTDate48
49CREATDDT SearchCreated DateDTDate48
50WRNTYDYS SearchWarranty DaysINT4Integer24
51PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
52ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
53ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
54CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].CGSMCIDX AS 'SmartList Item Master-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].CGSMCIDX = ['Account Index Master'].ACTINDX
56IVINFIDX SearchInventory Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].INVMCIDX AS 'SmartList Item Master-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].INVMCIDX = ['Account Index Master'].ACTINDX
58ITEMCODE SearchItem CodeSTR15String1615
59KTACCTSR SearchKit COGS Account SourceGBInteger20
60LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
61PriceGroup SearchPrice GroupSTR10_LBAUString1210
62PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
63PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Item Master'].PURMCIDX AS 'SmartList Item Master-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].PURMCIDX = ['Account Index Master'].ACTINDX
65PRCHSUOM SearchPurchasing U Of MU_Of_MString108
66SELNGUOM SearchSelling U Of MU_Of_MString108
67TCC SearchTax Commodity CodeSTR30_VATString3230
68UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Item Master'].UPPVIDX AS 'SmartList Item Master-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Item Master'].UPPVIDX = ['Account Index Master'].ACTINDX
69LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Item Master'].LOCNCODE AS 'SmartList Item Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Item Master'].LOCNCODE = ['Site Setup'].LOCNCODE
70Revalue_Inventory SearchRevalue InventoryCB_Revalue_InventoryBoolean20
71Tolerance_Percentage SearchTolerance PercentageLI7_U%3Long Integer47
72Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Item Master'].Purchase_Item_Tax_Schedu AS 'SmartList Item Master-Purchase Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Item Master'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73Purchase_Tax_Options SearchPurchase Tax OptionsDDL_Purchase_Tax_OptionsInteger20
74CNTRYORGN SearchCountry OriginSTR6_VATString86
75ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger20
76CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger20
77MANUFACTURER SearchManufacturerSTR30_LBAUString3230
78MNFCTRITMNMBR SearchManufacture Item NumberSTR30_LBAUString3230
79ITEMDESC1 SearchASI_Item_DescriptionSTR50String5250
80PRIMARYITEM SearchPrimary ItemCBBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList Item Master (ASIEXP04)

Leave a Reply

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