GP Tables

CT00002 - IC COST Standard Item Class Defaults

Dynamics GP table CT00002 (IC COST Standard Item Class Defaults) contains 77 columns including CMPANYID, ITEMNMBR, ITEMDESC....

SQL Query Builder

77 Columns

Column Description Type Length
CMPANYID Company ID Integer 2
ITEMNMBR Item Number String 32
ITEMDESC Item Description String 102
ITMCLSCD Item Class Code String 12
ITMCLSDC Item Class Description String 32
DEFLTCLS Default Class Boolean 2
NOTEINDX Note Index Currency 10
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
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
ITMGEDSC Item Generic Description String 12
TAXOPTNS Tax Options1.  Taxable2.  Nontaxable3.  Base on customers Integer 2
Tax Options values (3)
1 = Taxable2 = Nontaxable3 = Base on customer/vendor
ITMTSHID Item Tax Schedule ID String 16
COMMCODE Commission Code String 16
UOMSCHDL U Of M Schedule String 12
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
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
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
ICIVICOFDI IC IV Item Class Ohead Fixed Dollars Currency 10
ICIVICOFPI IC IV Item Class Ohead Fixed Percent Long Integer 4
ICIVICOVDI IC IV Item Class Ohead Var Dollars Currency 10
ICIVICOVPI IC IV Item Class Ohead Var Percent Long Integer 4
ICIVICOFDOPI IC IV Item Class Fixed Dollars or Percent Integer 2
ICIVICVDOPI IC IV Item Class Var Dollars or Percent Integer 2
ICIVOUSEI_1 IC IV Overhead Use[1] Boolean 2
ICIVOUSEI_2 IC IV Overhead Use[2] Boolean 2
ICIVOUSEI_3 IC IV Overhead Use[3] Boolean 2
ICIVOUSEI_4 IC IV Overhead Use[4] Boolean 2
ICIVOUSEI_5 IC IV Overhead Use[5] Boolean 2
ICIVOUSEI_6 IC IV Overhead Use[6] Boolean 2
ICIVOUSEI_7 IC IV Overhead Use[7] Boolean 2
ICIVOUSEI_8 IC IV Overhead Use[8] Boolean 2
ICIVOUSEI_9 IC IV Overhead Use[9] Boolean 2
ICIVOUSEI_10 IC IV Overhead Use[10] Boolean 2
ICIVOUSEI_11 IC IV Overhead Use[11] Boolean 2
ICIVOUSEI_12 IC IV Overhead Use[12] Boolean 2
ICIVOUSEI_13 IC IV Overhead Use[13] Boolean 2
ICIVOUSEI_14 IC IV Overhead Use[14] Boolean 2
ICIVOUSEI_15 IC IV Overhead Use[15] Boolean 2
ICIVOUSEI_16 IC IV Overhead Use[16] Boolean 2
ICIVOUSEI_17 IC IV Overhead Use[17] Boolean 2
ICIVOUSEI_18 IC IV Overhead Use[18] Boolean 2
ICIVOUSEI_19 IC IV Overhead Use[19] Boolean 2
ICIVOUSEI_20 IC IV Overhead Use[20] Boolean 2
ICIVOUSEI_21 IC IV Overhead Use[21] Boolean 2
ICIVOUSEI_22 IC IV Overhead Use[22] Boolean 2
ICIVOUSEI_23 IC IV Overhead Use[23] Boolean 2
ICIVOUSEI_24 IC IV Overhead Use[24] Boolean 2
ICIVOUSEI_25 IC IV Overhead Use[25] Boolean 2
ICIVOUSEI_26 IC IV Overhead Use[26] Boolean 2
ICIVOUSEI_27 IC IV Overhead Use[27] Boolean 2
ICIVOUSEI_28 IC IV Overhead Use[28] Boolean 2
ICIVOUSEI_29 IC IV Overhead Use[29] Boolean 2
ICIVOUSEI_30 IC IV Overhead Use[30] Boolean 2
ICIVOUSEI_31 IC IV Overhead Use[31] Boolean 2
ICIVOUSEI_32 IC IV Overhead Use[32] Boolean 2
ICIVOUSEI_33 IC IV Overhead Use[33] Boolean 2
ICIVOUSEI_34 IC IV Overhead Use[34] Boolean 2
ICIVOUSEI_35 IC IV Overhead Use[35] Boolean 2
ICIVOGRPI_1 IC IV Overhead Grouping[1] Integer 2
ICIVOGRPI_2 IC IV Overhead Grouping[2] Integer 2
ICIVOGRPI_3 IC IV Overhead Grouping[3] Integer 2
ICIVOGRPI_4 IC IV Overhead Grouping[4] Integer 2
ICIVOGRPI_5 IC IV Overhead Grouping[5] Integer 2
PRCLEVEL PriceLevel String 12
MODIFDT Modified Date Date 4
MDFUSRID Modified User ID String 16

Related Tables

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

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

CMPANYID

ADSK0600 ASIEXP07 ASIEXP100 ASIEXP21 ASIEXP85 CAM10200 CAM10210 CPO40001

PRCLEVEL

ASIEXP02 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP11 ASIEXP15 ASIEXP17

KPTRXHST

ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11

KPERHIST

ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11