IC COST Item Class Setup (CT40401)

azurecurveProductsManufacturing (346)3rd PartyIC COST Item Class Setup (CT40401)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CT40401

Product: Manufacturing (346)
Series: 3rd Party

Display Name: IC COST Item Class Setup
Physical Name: CT40401
Technical Name: IC_COST_IV_Item_Class_SETP

Group Display Name: Manufacturing Inventory
Group Technical Name: Manufacturing Inventory

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITMCLSCD SearchItem Class CodeSTR10_Class_IDString10
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['IC COST Item Class Setup'].ITMCLSCD AS 'IC COST Item Class Setup-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       CT40401 AS ['IC COST Item Class Setup']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['IC COST Item Class Setup'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
2ITMCLSDC SearchItem Class DescriptionSTR30String30
3DEFLTCLS SearchDefault ClassCB_DefaultBoolean0
4NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['IC COST Item Class Setup'].NOTEINDX AS 'IC COST Item Class Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CT40401 AS ['IC COST Item Class Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['IC COST Item Class Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
5ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
6ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger0
7LOTTYPE SearchLot TypeSTR10_Lot_TypeString10
8KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
9KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
10KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
11KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
12ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
13ITMGEDSC SearchItem Generic DescriptionSTR10String10
14TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger0
15ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['IC COST Item Class Setup'].ITMTSHID AS 'IC COST Item Class Setup-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CT40401 AS ['IC COST Item Class Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['IC COST Item Class Setup'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
16COMMCODE SearchCommission CodeSTR15_LBAUString15
17UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['IC COST Item Class Setup'].UOMSCHDL AS 'IC COST Item Class Setup-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       CT40401 AS ['IC COST Item Class Setup']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['IC COST Item Class Setup'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
18VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
19USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
20USCATVLS SearchUser Category ValuesUser_Category_ValueString10
21USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
22DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
23USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
24DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
25ICIVCLIXI SearchIC IV CoGS Labor IndexLI_14Long Integer14
26USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString10
27USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
28ICIVCLABOHIXI SearchIC IV CoGS Labor OH IndexLI_14Long Integer14
29ICIVCOGSLABOHVARIX_I SearchIC IV CoGS Labor OH Var IndexLI_14Long Integer14
30USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
31ICIVCCIXI SearchIC IV CoGS Machine IndexLI_14Long Integer14
32ICIVCMACHOHIXI SearchIC IV CoGS Machine OH IndexLI_14Long Integer14
33ICIVCOGSMACHOHVARIX_I SearchIC IV CoGS Machine OH Var IndexLI_14Long Integer14
34ICIVCMIXI SearchIC IV CoGS Material IndexLI_14Long Integer14
35ICIVCMATOHIXI SearchIC IV CoGS Material OH IndexLI_14Long Integer14
36ICIVCOGSMATOHVARIX_I SearchIC IV CoGS Material OH Var IndexLI_14Long Integer14
37ICIVCOIXI SearchIC IV CoGS Overhead IndexLI_14Long Integer14
38ICIVMFIXI SearchIC IV Material Fixed IndexLI_14Long Integer14
39ICIVMUIXI SearchIC IV Material Usage Var IndexLI_14Long Integer14
40ICIVMATUSAGEVAROHIX_I SearchIC IV Mat Usage Variance OH IndexLI_14Long Integer14
41ICIVMATUSAGEVAROHVARIX_I SearchIC IV Mat Usage Variance OH Var IndexLI_14Long Integer14
42ICIVMVIXI SearchIC IV Material Var IndexLI_14Long Integer14
43ICIVPVIXI SearchIC IV Purchase Price Var IndexLI_14Long Integer14
44ICIVROIXI SearchIC IV Returns Offset IndexLI_14Long Integer14
45ICIVSCIXI SearchIC IV Standard Cost Reval IndexLI_14Long Integer14
46ICIVLVIXI SearchIC IV Labor Var IndexLI_14Long Integer14
47ICIVUPPV_I SearchIC IV Unrealized PPV IndexLI_14Long Integer14
48ICIVLABVAROHIX_I SearchIC IV Lab Variance OH IndexLI_14Long Integer14
49ICIVLABVAROHVARIX_I SearchIC IV Lab Variance OH Var IndexLI_14Long Integer14
50ICIVMEVIXI SearchIC IV Machine Efficiency Var IndexLI_14Long Integer14
51ICIVMACHEFFVAROHIX_I SearchIC IV Mach Eff Variance OH IndexLI_14Long Integer14
52ICIVMACHEFFVAROHVARIX_I SearchIC IV Mach Eff Variance OH Var IndexLI_14Long Integer14
53ICIVOVIXI SearchIC IV Overhead Var IndexLI_14Long Integer14
54ICIVWLIXI SearchIC IV WIP Labor IndexLI_14Long Integer14
55ICIVWLOHIXI SearchIC IV WIP Labor OH IndexLI_14Long Integer14
56ICIVWIPLABOHVARIX_I SearchIC IV WIP Labor OH Var IndexLI_14Long Integer14
57ICIVWCIXI SearchIC IV WIP Machine IndexLI_14Long Integer14
58ICIVWMACHOHIXI SearchIC IV WIP Machine OH IndexLI_14Long Integer14
59ICIVWIPMACHOHVARIX_I SearchIC IV WIP Machine OH Var IndexLI_14Long Integer14
60ICIVWMIXI SearchIC IV WIP Material IndexLI_14Long Integer14
61ICIVWMATOHIXI SearchIC IV WIP Material OH IndexLI_14Long Integer14
62ICIVWIPMATOHVARIX_I SearchIC IV WIP Material OH Var IndexLI_14Long Integer14
63ICIVWOIXI SearchIC IV WIP Overhead IndexLI_14Long Integer14
64ICIVILIXI SearchIC IV INV Labor IndexLI_14Long Integer14
65ICIVILABOHIXI SearchIC IV INV Labor OH IndexLI_14Long Integer14
66ICIVINVLABOHVARIX_I SearchIC IV INV Labor OH Var IndexLI_14Long Integer14
67ICIVIMXI SearchIC IV INV Machine IndexLI_14Long Integer14
68ICIVIMACHOHIXI SearchIC IV INV Machine OH IndexLI_14Long Integer14
69ICIVINVMACHOHVARIX_I SearchIC IV INV Machine OH Var IndexLI_14Long Integer14
70ICIVIMATOHIXI SearchIC IV INV Material OH IndexLI_14Long Integer14
71ICIVINVMATOHVARIX_I SearchIC IV INV Material OH Var IndexLI_14Long Integer14
72PRCLEVEL SearchPriceLevelSTR10_LBAUString10
73MODIFDT SearchModified DateDTDate8
74MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['IC COST Item Class Setup'].MDFUSRID AS 'IC COST Item Class Setup-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CT40401 AS ['IC COST Item Class Setup']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['IC COST Item Class Setup'].MDFUSRID = ['Users Master'].USERID
75DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyIC COST Item Class Setup (CT40401)

Leave a Reply

Your email address will not be published. Required fields are marked *