GP Tables

IV00101 - Item Master

Dynamics GP table IV00101 (Item Master) contains 87 columns including ITEMNMBR, ITEMDESC, NOTEINDX....

SQL Query Builder

87 Columns

Column Description Type Length
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
UPPVIDX Unrealized 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
LOCNCODE Location Code String 12
PINFLIDX Purch Inflation Index Long Integer 4
PURMCIDX Purch Monetary Correction Index Long Integer 4
IVINFIDX Inventory Inflation Index Long Integer 4
INVMCIDX Inventory Monetary Correction Index Long Integer 4
CGSINFLX COGS Inflation Index Long Integer 4
CGSMCIDX COGS Monetary Correction Index Long Integer 4
ITEMCODE Item Code String 16
TCC Tax Commodity Code String 32
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
PRCHSUOM Purchasing U Of M String 10
SELNGUOM Selling U Of M String 10
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
ABCCODE ABC Code1 – (None)2 – A3 – B4 – C Integer 2
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
ITMPLNNNGTYP Item Planning Type1 – Normal2 – Master Scheduled Integer 2
STTSTCLVLPRCNTG Statistical Value Percentage Integer 2
CNTRYORGN Country Origin String 8
INACTIVE Inactive Boolean 2
Active Status values (2)
0 = Active1 = Inactive
MINSHELF1 MinShelfLife1 Integer 2
MINSHELF2 MinShelfLife2 Integer 2
INCLUDEINDP Include in Demand Planning Boolean 2
LOTEXPWARN Lot Expire Warning Boolean 2
LOTEXPWARNDAYS Lot Expire Warning Days Integer 2
LASTGENLOT Last Generated Lot Number String 22
Lot_Split_Quantity Lot Split Quantity Currency 10
UseQtyOverageTolerance Use Qty Overage Tolerance Boolean 2
UseQtyShortageTolerance Use Qty Shortage Tolerance Boolean 2
QtyOverTolerancePercent Qty Overage Tolerance Percentage Long Integer 4
QtyShortTolerancePercent Qty Shortage Tolerance Percentage Long Integer 4
IVSCRVIX IV STD Cost Revaluation Index Long Integer 4

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12

ITEMNMBR

AAG20001 AAG20011 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

UOMSCHDL

AAG00400 ADItemP2 ADItemPr ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21

LOCNCODE

ASIEXP04 ASIEXP06 ASIEXP11 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

DECPLCUR

AAG2001T ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23

DECPLQTY

AAG00400 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24

PRCLEVEL

ASIEXP02 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP11 ASIEXP15 ASIEXP17

KPTRXHST

ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11