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:

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 TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SmartList Item 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 DescriptionStringSTR100100
4NOTEINDX SearchNote IndexCurrencyDLR1414
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 NameStringSTR1515
6ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
7ITMGEDSC SearchItem Generic DescriptionStringSTR1010
8STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
9CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
10ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
11DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
12DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
13ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
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 OptionsIntegerDDL_Tax_Options0
15IVIVINDX SearchIV IV IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 CodeStringSTR10_Class_ID10
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 OptionIntegerDDL_Track0
31LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
32KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
33KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
34KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
35KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
36ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
37VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
38UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
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 1StringSTR30_Item_Number30
40ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
41USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
42USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
43USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
44USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
45USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
46USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
47MSTRCDTY SearchMaster Record TypeIntegerINT11
48MODIFDT SearchModified DateDateDT8
49CREATDDT SearchCreated DateDateDT8
50WRNTYDYS SearchWarranty DaysIntegerINT44
51PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
52ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
53ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
54CGSINFLX SearchCOGS Inflation IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 CodeStringSTR1515
59KTACCTSR SearchKit COGS Account SourceIntegerGB0
60LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
61PriceGroup SearchPrice GroupStringSTR10_LBAU10
62PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
63PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 MStringU_Of_M8
66SELNGUOM SearchSelling U Of MStringU_Of_M8
67TCC SearchTax Commodity CodeStringSTR30_VAT30
68UPPVIDX SearchUnrealized Purchase Price Variance IndexLong IntegerLI_1414
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 CodeStringSTR10_Location_Code10
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 InventoryBooleanCB_Revalue_Inventory0
71Tolerance_Percentage SearchTolerance PercentageLong IntegerLI7_U%37
72Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDStringSTR15_LBAU15
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 OptionsIntegerDDL_Purchase_Tax_Options0
74CNTRYORGN SearchCountry OriginStringSTR6_VAT6
75ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultIntegerDDL_OrderFulfillDefault0
76CUSTPRIORITY SearchCustomer PriorityIntegerDDL_CustomerPriority0
77MANUFACTURER SearchManufacturerStringSTR30_LBAU30
78MNFCTRITMNMBR SearchManufacture Item NumberStringSTR30_LBAU30
79ITEMDESC1 SearchASI_Item_DescriptionStringSTR5050
80PRIMARYITEM SearchPrimary ItemBooleanCB0
81USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Item Master'].USERID AS 'SmartList Item Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP04 AS ['SmartList Item Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Item Master'].USERID = ['Users Master'].USERID
82INACTIVE SearchInactiveBooleanCB_Inactive0
azurecurveProductsSmartList (1493)PathnameSmartList Item Master (ASIEXP04)

Leave a Reply

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