Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP04
Product: SmartList (1493)
Series: Pathname
Display Name: SmartList Item Master Group Display Name: SmartList Master
Physical Name: ASIEXP04
Technical Name: ASI_IV_Item_MSTR_Explorer
Group Technical Name: ASI_Explorer_Logical_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ASI_Order_By ![]() | ASI_Order_By | LI_14 | Long Integer | 14 | |
2 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['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 | ||||||
3 | ITEMDESC ![]() | Item Description | STR100 | String | 100 | |
4 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
5 | ITMSHNAM ![]() | Item Short Name | STR15 | String | 15 | |
6 | ITEMTYPE ![]() | Item Type | DDL_Item_Type | Integer | 0 | |
7 | ITMGEDSC ![]() | Item Generic Description | STR10 | String | 10 | |
8 | STNDCOST ![]() | Standard Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
9 | CURRCOST ![]() | Current Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
10 | ITEMSHWT ![]() | Item Shipping Weight | LI6_RBS2_UT | Long Integer | 6 | |
11 | DECPLQTY ![]() | Decimal Places QTYS | DDL_Decimal_Places_QTYS | Integer | 0 | |
12 | DECPLCUR ![]() | Decimal Places Currency | DDL_Decimal_Places_Dollars | Integer | 0 | |
13 | ITMTSHID ![]() | Item Tax Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
14 | TAXOPTNS ![]() | Tax Options | DDL_Tax_Options | Integer | 0 | |
15 | IVIVINDX ![]() | IV IV Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
16 | IVIVOFIX ![]() | IV IV Offset Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
17 | IVCOGSIX ![]() | IV COGS Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
18 | IVSLSIDX ![]() | IV Sales Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
19 | IVSLDSIX ![]() | IV Sales Discounts Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
20 | IVSLRNIX ![]() | IV Sales Returns Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
21 | IVINUSIX ![]() | IV In Use Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
22 | IVINSVIX ![]() | IV In Service Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
23 | IVDMGIDX ![]() | IV Damaged Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
24 | IVVARIDX ![]() | IV Variances Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
25 | DPSHPIDX ![]() | Drop Ship Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
26 | PURPVIDX ![]() | Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
27 | IVRETIDX ![]() | Inventory Returns Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
28 | ASMVRIDX ![]() | Assembly Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
29 | ITMCLSCD ![]() | Item Class Code | STR10_Class_ID | String | 10 | |
Key to the Item Class Setup (IV40400).
Click to show/hideSELECT
['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 | ||||||
30 | ITMTRKOP ![]() | Item Tracking Option | DDL_Track | Integer | 0 | |
31 | LOTTYPE ![]() | Lot Type | STR10_Lot_Type | String | 10 | |
32 | KPERHIST ![]() | Keep Period History | CB_Keep_Period_History | Boolean | 0 | |
33 | KPTRXHST ![]() | Keep Trx History | CB_Keep_Trx_History | Boolean | 0 | |
34 | KPCALHST ![]() | Keep Calendar History | CB_Keep_Calendar_History | Boolean | 0 | |
35 | KPDSTHST ![]() | Keep Distribution History | CB_Keep_Dist_History | Boolean | 0 | |
36 | ALWBKORD ![]() | Allow Back Orders | CB_Allow_Back_Orders | Boolean | 0 | |
37 | VCTNMTHD ![]() | Valuation Method | DDL_Valuation_Method | Integer | 0 | |
38 | UOMSCHDL ![]() | U Of M Schedule | STR10_Schedule | String | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['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 | ||||||
39 | ALTITEM1 ![]() | Alternate Item 1 | STR30_Item_Number | String | 30 | |
40 | ALTITEM2 ![]() | Alternate Item 2 | STR30_Item_Number | String | 30 | |
41 | USCATVLS_1 ![]() | User Category Values[1] | User_Category_Value | String | 10 | |
42 | USCATVLS_2 ![]() | User Category Values[2] | User_Category_Value | String | 10 | |
43 | USCATVLS_3 ![]() | User Category Values[3] | User_Category_Value | String | 10 | |
44 | USCATVLS_4 ![]() | User Category Values[4] | User_Category_Value | String | 10 | |
45 | USCATVLS_5 ![]() | User Category Values[5] | User_Category_Value | String | 10 | |
46 | USCATVLS_6 ![]() | User Category Values[6] | User_Category_Value | String | 10 | |
47 | MSTRCDTY ![]() | Master Record Type | INT1 | Integer | 1 | |
48 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
49 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
50 | WRNTYDYS ![]() | Warranty Days | INT4 | Integer | 4 | |
51 | PRCLEVEL ![]() | PriceLevel | STR10_LBAU | String | 10 | |
52 | ASI_Favorite_Sequence ![]() | ASI_Favorite_Sequence | ASI_LI_10_RU | Long Integer | 10 | |
53 | ABCCODE ![]() | ABC Code | DDL_ABC_Code | Integer | 0 | |
54 | CGSINFLX ![]() | COGS Inflation Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
55 | CGSMCIDX ![]() | COGS Monetary Correction Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
56 | IVINFIDX ![]() | Inventory Inflation Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
57 | INVMCIDX ![]() | Inventory Monetary Correction Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
58 | ITEMCODE ![]() | Item Code | STR15 | String | 15 | |
59 | KTACCTSR ![]() | Kit COGS Account Source | GB | Integer | 0 | |
60 | LASTGENSN ![]() | Last Generated Serial Number | STR20_LBAU | String | 20 | |
61 | PriceGroup ![]() | Price Group | STR10_LBAU | String | 10 | |
62 | PRICMTHD ![]() | Price Method | DDL_Price_Method | Integer | 0 | |
63 | PINFLIDX ![]() | Purch Inflation Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
64 | PURMCIDX ![]() | Purch Monetary Correction Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
65 | PRCHSUOM ![]() | Purchasing U Of M | U_Of_M | String | 8 | |
66 | SELNGUOM ![]() | Selling U Of M | U_Of_M | String | 8 | |
67 | TCC ![]() | Tax Commodity Code | STR30_VAT | String | 30 | |
68 | UPPVIDX ![]() | Unrealized Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
69 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['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 | ||||||
70 | Revalue_Inventory ![]() | Revalue Inventory | CB_Revalue_Inventory | Boolean | 0 | |
71 | Tolerance_Percentage ![]() | Tolerance Percentage | LI7_U%3 | Long Integer | 7 | |
72 | Purchase_Item_Tax_Schedu ![]() | Purchase Item Tax Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
73 | Purchase_Tax_Options ![]() | Purchase Tax Options | DDL_Purchase_Tax_Options | Integer | 0 | |
74 | CNTRYORGN ![]() | Country Origin | STR6_VAT | String | 6 | |
75 | ORDERFULFILLDEFAULT ![]() | Order Fulfillment Shortage Default | DDL_OrderFulfillDefault | Integer | 0 | |
76 | CUSTPRIORITY ![]() | Customer Priority | DDL_CustomerPriority | Integer | 0 | |
77 | MANUFACTURER ![]() | Manufacturer | STR30_LBAU | String | 30 | |
78 | MNFCTRITMNMBR ![]() | Manufacture Item Number | STR30_LBAU | String | 30 | |
79 | ITEMDESC1 ![]() | ASI_Item_Description | STR50 | String | 50 | |
80 | PRIMARYITEM ![]() | Primary Item | CB | Boolean | 0 |