GP Tables

CT00102 - IC COST Item Master

Dynamics GP table CT00102 (IC COST Item Master) contains 86 columns including ITEMNMBR, ITEMDESC, NOTEINDX....

SQL Query Builder

86 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
LISTPRCE List Price 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
COMMCODE Commission Code String 16
ICIVMFIXI IC IV Material Fixed Index Long Integer 4
ICIVMVIXI IC IV Material Var Index Long Integer 4
ICIVLVIXI IC IV Labor Var Index Long Integer 4
ICIVLABVAROHIX_I IC IV Lab Variance OH Index Long Integer 4
ICIVLABVAROHVARIX_I IC IV Lab Variance OH Var Index Long Integer 4
ICIVMEVIXI IC IV Machine Efficiency Var Index Long Integer 4
ICIVMACHEFFVAROHIX_I IC IV Mach Eff Variance OH Index Long Integer 4
ICIVMACHEFFVAROHVARIX_I IC IV Mach Eff Variance OH Var Index Long Integer 4
ICIVMUIXI IC IV Material Usage Var Index Long Integer 4
ICIVMATUSAGEVAROHIX_I IC IV Mat Usage Variance OH Index Long Integer 4
ICIVMATUSAGEVAROHVARIX_I IC IV Mat Usage Variance OH Var Index Long Integer 4
ICIVOVIXI IC IV Overhead Var Index Long Integer 4
ICIVPVIXI IC IV Purchase Price Var Index Long Integer 4
ICIVSCIXI IC IV Standard Cost Reval Index Long Integer 4
ICIVROIXI IC IV Returns Offset Index Long Integer 4
ICIVWMIXI IC IV WIP Material Index Long Integer 4
ICIVUPPV_I IC IV Unrealized PPV Index Long Integer 4
ICIVWMATOHIXI IC IV WIP Material OH Index Long Integer 4
ICIVWIPMATOHVARIX_I IC IV WIP Material OH Var Index Long Integer 4
ICIVWLIXI IC IV WIP Labor Index Long Integer 4
ICIVWLOHIXI IC IV WIP Labor OH Index Long Integer 4
ICIVWIPLABOHVARIX_I IC IV WIP Labor OH Var Index Long Integer 4
ICIVWCIXI IC IV WIP Machine Index Long Integer 4
ICIVWMACHOHIXI IC IV WIP Machine OH Index Long Integer 4
ICIVWIPMACHOHVARIX_I IC IV WIP Machine OH Var Index Long Integer 4
ICIVWOIXI IC IV WIP Overhead Index Long Integer 4
ICIVCMIXI IC IV CoGS Material Index Long Integer 4
ICIVCMATOHIXI IC IV CoGS Material OH Index Long Integer 4
ICIVCOGSMATOHVARIX_I IC IV CoGS Material OH Var Index Long Integer 4
ICIVCLIXI IC IV CoGS Labor Index Long Integer 4
ICIVCLABOHIXI IC IV CoGS Labor OH Index Long Integer 4
ICIVCOGSLABOHVARIX_I IC IV CoGS Labor OH Var Index Long Integer 4
ICIVCCIXI IC IV CoGS Machine Index Long Integer 4
ICIVCMACHOHIXI IC IV CoGS Machine OH Index Long Integer 4
ICIVCOGSMACHOHVARIX_I IC IV CoGS Machine OH Var Index Long Integer 4
ICIVCOIXI IC IV CoGS Overhead Index Long Integer 4
ICIVILIXI IC IV INV Labor Index Long Integer 4
ICIVILABOHIXI IC IV INV Labor OH Index Long Integer 4
ICIVINVLABOHVARIX_I IC IV INV Labor OH Var Index Long Integer 4
ICIVIMXI IC IV INV Machine Index Long Integer 4
ICIVIMACHOHIXI IC IV INV Machine OH Index Long Integer 4
ICIVINVMACHOHVARIX_I IC IV INV Machine OH Var Index Long Integer 4
ICIVIMATOHIXI IC IV INV Material OH Index Long Integer 4
ICIVINVMATOHVARIX_I IC IV INV Material OH Var 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
ITMKTFLG Item Kit Flag Boolean 2
ALWBKORD Allow Back Orders Boolean 2
FSHGDFLG Finished Good Flag Boolean 2
CMPTFLAG Component Flag 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
MDFUSRID Modified User ID String 16
CREATDDT Created Date Date 4
WRNTYDYS Warranty Days Integer 2
PRCLEVEL PriceLevel String 12

Related Tables

Tables that share columns with CT00102. 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

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

ITMTSHID

ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24 ASIEXP26