GP Tables

ASIEXP04 - SmartList Item Master

Dynamics GP table ASIEXP04 (SmartList Item Master) contains 80 columns including ASI_Order_By, ITEMNMBR, ITEMDESC....

SQL Query Builder

80 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
ITEMNMBR Item Number String 32
ITEMDESC Item Description String 102
NOTEINDX Note Index Currency 10
ITMSHNAM Item Short Name String 16
ITEMTYPE Item Type1. Sales Inventory (For SBM, this type is Stock Item.)2. Discontinued3. Kit4. Misc Charges5. Services6. Flat Fee (For SBM, this type is Labor.) Integer 2
Item Type values (6)
1 = Sales Inventory2 = Discontinued3 = Kit4 = Misc Charges5 = Services6 = Flat Fee
ITMGEDSC Item Generic Description String 12
STNDCOST Standard Cost Currency 10
CURRCOST Current Cost Currency 10
ITEMSHWT Item Shipping Weight Long Integer 4
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
ITMTSHID Item Tax Schedule ID String 16
TAXOPTNS Tax Options1.  Taxable2.  Nontaxable3.  Base on customers Integer 2
Tax Options values (3)
1 = Taxable2 = Nontaxable3 = Base on customer/vendor
IVIVINDX IV IV Index Long Integer 4
IVIVOFIX IV IV Offset Index Long Integer 4
IVCOGSIX IV COGS Index Long Integer 4
IVSLSIDX IV Sales Index Long Integer 4
IVSLDSIX IV Sales Discounts Index Long Integer 4
IVSLRNIX IV Sales Returns Index Long Integer 4
IVINUSIX IV In Use Index Long Integer 4
IVINSVIX IV In Service Index Long Integer 4
IVDMGIDX IV Damaged Index Long Integer 4
IVVARIDX IV Variances Index Long Integer 4
DPSHPIDX Drop Ship Index Long Integer 4
PURPVIDX Purchase Price Variance Index Long Integer 4
IVRETIDX Inventory Returns Index Long Integer 4
ASMVRIDX Assembly Variance Index Long Integer 4
ITMCLSCD Item Class Code String 12
ITMTRKOP Item Tracking Option1. None2. Serial Numbers3. Lot Numbers Integer 2
Item Tracking Option values (3)
1 = None2 = Serial Numbers3 = Lot Numbers
LOTTYPE Lot Type String 12
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
KPCALHST Keep Calendar History Boolean 2
KPDSTHST Keep Distribution History Boolean 2
ALWBKORD Allow Back Orders Boolean 2
VCTNMTHD Valuation Method1. FIFO Perpetual2. LIFO Perpetual3. Average Perpetual4. FIFO Periodic (This value is not available for SBM.)5. LIFO Periodic (This value is not available for SBM.) Integer 2
Valuation Method values (5)
1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic
UOMSCHDL U Of M Schedule String 12
ALTITEM1 Alternate Item 1 String 32
ALTITEM2 Alternate Item 2 String 32
USCATVLS_1 User Category Values[1] String 12
USCATVLS_2 User Category Values[2] String 12
USCATVLS_3 User Category Values[3] String 12
USCATVLS_4 User Category Values[4] String 12
USCATVLS_5 User Category Values[5] String 12
USCATVLS_6 User Category Values[6] String 12
MSTRCDTY Master Record Type Integer 2
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 4
WRNTYDYS Warranty Days Integer 2
PRCLEVEL PriceLevel String 12
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
ABCCODE ABC Code1 – (None)2 – A3 – B4 – C Integer 2
CGSINFLX COGS Inflation Index Long Integer 4
CGSMCIDX COGS Monetary Correction Index Long Integer 4
IVINFIDX Inventory Inflation Index Long Integer 4
INVMCIDX Inventory Monetary Correction Index Long Integer 4
ITEMCODE Item Code String 16
KTACCTSR Kit COGS Account Source0 – COGS accounts from the components1 – COGS account from the kit Integer 2
Kit COGS Account Source values (2)
0 = From component items1 = From kit item
LASTGENSN Last Generated Serial Number String 22
PriceGroup Price Group String 12
PRICMTHD Price Method1 – Currency Amount2 – % of List Price3 – % Markup – Current Cost4 – % Markup – Standard Cost5 – % Margin – Current Cost6 – % Margin – Standard Cost Integer 2
Price Method values (6)
1 = Currency Amount2 = % of List Price3 = % Markup - Current Cost4 = % Markup - Standard Cost5 = % Margin - Current Cost6 = % Margin - Standard Cost
PINFLIDX Purch Inflation Index Long Integer 4
PURMCIDX Purch Monetary Correction Index Long Integer 4
PRCHSUOM Purchasing U Of M String 10
SELNGUOM Selling U Of M String 10
TCC Tax Commodity Code String 32
UPPVIDX Unrealized Purchase Price Variance Index Long Integer 4
LOCNCODE Location Code String 12
Revalue_Inventory Revalue Inventory Boolean 2
Tolerance_Percentage Tolerance Percentage Long Integer 4
Purchase_Item_Tax_Schedu Purchase Item Tax Schedule ID String 16
Purchase_Tax_Options Purchase Tax Options1 – Taxable2 – Nontaxable3 – Base on Vendor Integer 2
CNTRYORGN Country Origin String 8
ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer 2
CUSTPRIORITY Customer Priority Integer 2
MANUFACTURER Manufacturer String 32
MNFCTRITMNMBR Manufacture Item Number String 32
ITEMDESC1 ASI_Item_Description String 52
PRIMARYITEM Primary Item Boolean 2

Related Tables

Tables that share columns with ASIEXP04. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP12

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12 ASIEXP13

ITEMNMBR

AAG20001 AAG20011 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24

UOMSCHDL

AAG00400 ADItemP2 ADItemPr ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

LOCNCODE

ASIEXP06 ASIEXP11 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24

DECPLCUR

AAG2001T ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23 ASIEXP24

ASI_Order_By

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

ASI_Favorite_Sequence

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

DECPLQTY

AAG00400 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24 ASIEXP26