CT40401 - IC COST Item Class Setup
Dynamics GP table CT40401 (IC COST Item Class Setup) contains 73 columns including ITMCLSCD, ITMCLSDC, DEFLTCLS....
SQL Query Builder
73 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| 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 | |||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| ICIVCOIXI | IC IV CoGS Overhead Index | Long Integer | 4 | ||
| ICIVMFIXI | IC IV Material Fixed 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 | ||
| ICIVMVIXI | IC IV Material Var Index | Long Integer | 4 | ||
| ICIVPVIXI | IC IV Purchase Price Var Index | Long Integer | 4 | ||
| ICIVROIXI | IC IV Returns Offset Index | Long Integer | 4 | ||
| ICIVSCIXI | IC IV Standard Cost Reval Index | Long Integer | 4 | ||
| ICIVLVIXI | IC IV Labor Var Index | Long Integer | 4 | ||
| ICIVUPPV_I | IC IV Unrealized PPV 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 | ||
| ICIVOVIXI | IC IV Overhead 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 | ||
| ICIVWMIXI | IC IV WIP Material 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 | ||
| ICIVWOIXI | IC IV WIP 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 | ||
| PRCLEVEL | PriceLevel | String | 12 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| MDFUSRID | Modified User ID | String | 16 | ||
Related Tables
Tables that share columns with CT40401. Click "Join" to add to your query.