IC COST Item Master (CT00102)

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

Product: CopierSeries (2992)
Series: 3rd Party

Display Name: IC COST Item Master
Physical Name: CT00102
Technical Name: IC_COST_IV_Item_MSTR

Group Display Name: QBD_MFGFiles
Group Technical Name: QBD_MFGFiles

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['IC COST Item Master'].ITEMNMBR AS 'IC COST Item Master-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       CT00102 AS ['IC COST Item Master']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['IC COST Item Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
2ITEMDESC SearchItem DescriptionSTR100String102100
3NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['IC COST Item Master'].NOTEINDX AS 'IC COST Item Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CT00102 AS ['IC COST Item Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['IC COST Item Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4ITMSHNAM SearchItem Short NameSTR15String1615
5ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
6ITMGEDSC SearchItem Generic DescriptionSTR10String1210
7STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
8CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
9LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency1017
10ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
11DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
13ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['IC COST Item Master'].ITMTSHID AS 'IC COST Item Master-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CT00102 AS ['IC COST Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['IC COST Item Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
14TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
15COMMCODE SearchCommission CodeSTR15_LBAUString1615
16ICIVMFIXI SearchIC IV Material Fixed IndexLI_14Long Integer414
17ICIVMVIXI SearchIC IV Material Var IndexLI_14Long Integer414
18ICIVLVIXI SearchIC IV Labor Var IndexLI_14Long Integer414
19ICIVLABVAROHIX_I SearchIC IV Lab Variance OH IndexLI_14Long Integer414
20ICIVLABVAROHVARIX_I SearchIC IV Lab Variance OH Var IndexLI_14Long Integer414
21ICIVMEVIXI SearchIC IV Machine Efficiency Var IndexLI_14Long Integer414
22ICIVMACHEFFVAROHIX_I SearchIC IV Mach Eff Variance OH IndexLI_14Long Integer414
23ICIVMACHEFFVAROHVARIX_I SearchIC IV Mach Eff Variance OH Var IndexLI_14Long Integer414
24ICIVMUIXI SearchIC IV Material Usage Var IndexLI_14Long Integer414
25ICIVMATUSAGEVAROHIX_I SearchIC IV Mat Usage Variance OH IndexLI_14Long Integer414
26ICIVMATUSAGEVAROHVARIX_I SearchIC IV Mat Usage Variance OH Var IndexLI_14Long Integer414
27ICIVOVIXI SearchIC IV Overhead Var IndexLI_14Long Integer414
28ICIVPVIXI SearchIC IV Purchase Price Var IndexLI_14Long Integer414
29ICIVSCIXI SearchIC IV Standard Cost Reval IndexLI_14Long Integer414
30ICIVROIXI SearchIC IV Returns Offset IndexLI_14Long Integer414
31ICIVWMIXI SearchIC IV WIP Material IndexLI_14Long Integer414
32ICIVUPPV_I SearchIC IV Unrealized PPV IndexLI_14Long Integer414
33ICIVWMATOHIXI SearchIC IV WIP Material OH IndexLI_14Long Integer414
34ICIVWIPMATOHVARIX_I SearchIC IV WIP Material OH Var IndexLI_14Long Integer414
35ICIVWLIXI SearchIC IV WIP Labor IndexLI_14Long Integer414
36ICIVWLOHIXI SearchIC IV WIP Labor OH IndexLI_14Long Integer414
37ICIVWIPLABOHVARIX_I SearchIC IV WIP Labor OH Var IndexLI_14Long Integer414
38ICIVWCIXI SearchIC IV WIP Machine IndexLI_14Long Integer414
39ICIVWMACHOHIXI SearchIC IV WIP Machine OH IndexLI_14Long Integer414
40ICIVWIPMACHOHVARIX_I SearchIC IV WIP Machine OH Var IndexLI_14Long Integer414
41ICIVWOIXI SearchIC IV WIP Overhead IndexLI_14Long Integer414
42ICIVCMIXI SearchIC IV CoGS Material IndexLI_14Long Integer414
43ICIVCMATOHIXI SearchIC IV CoGS Material OH IndexLI_14Long Integer414
44ICIVCOGSMATOHVARIX_I SearchIC IV CoGS Material OH Var IndexLI_14Long Integer414
45ICIVCLIXI SearchIC IV CoGS Labor IndexLI_14Long Integer414
46ICIVCLABOHIXI SearchIC IV CoGS Labor OH IndexLI_14Long Integer414
47ICIVCOGSLABOHVARIX_I SearchIC IV CoGS Labor OH Var IndexLI_14Long Integer414
48ICIVCCIXI SearchIC IV CoGS Machine IndexLI_14Long Integer414
49ICIVCMACHOHIXI SearchIC IV CoGS Machine OH IndexLI_14Long Integer414
50ICIVCOGSMACHOHVARIX_I SearchIC IV CoGS Machine OH Var IndexLI_14Long Integer414
51ICIVCOIXI SearchIC IV CoGS Overhead IndexLI_14Long Integer414
52ICIVILIXI SearchIC IV INV Labor IndexLI_14Long Integer414
53ICIVILABOHIXI SearchIC IV INV Labor OH IndexLI_14Long Integer414
54ICIVINVLABOHVARIX_I SearchIC IV INV Labor OH Var IndexLI_14Long Integer414
55ICIVIMXI SearchIC IV INV Machine IndexLI_14Long Integer414
56ICIVIMACHOHIXI SearchIC IV INV Machine OH IndexLI_14Long Integer414
57ICIVINVMACHOHVARIX_I SearchIC IV INV Machine OH Var IndexLI_14Long Integer414
58ICIVIMATOHIXI SearchIC IV INV Material OH IndexLI_14Long Integer414
59ICIVINVMATOHVARIX_I SearchIC IV INV Material OH Var IndexLI_14Long Integer414
60ITMCLSCD SearchItem Class CodeSTR10_Class_IDString1210
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['IC COST Item Master'].ITMCLSCD AS 'IC COST Item Master-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       CT00102 AS ['IC COST Item Master']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['IC COST Item Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
61ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
62LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
63KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
64KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
65KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
66KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
67ITMKTFLG SearchItem Kit FlagCB_Kit_ItemBoolean20
68ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
69FSHGDFLG SearchFinished Good FlagCB_Finished_ItemBoolean20
70CMPTFLAG SearchComponent FlagCB_Component_ItemBoolean20
71VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
72UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['IC COST Item Master'].UOMSCHDL AS 'IC COST Item Master-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       CT00102 AS ['IC COST Item Master']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['IC COST Item Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
73ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
74ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
75USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
76USCATVLS SearchUser Category ValuesUser_Category_ValueString1210
77USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
78MSTRCDTY SearchMaster Record TypeINT1Integer21
79MODIFDT SearchModified DateDTDate48
80USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
81MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['IC COST Item Master'].MDFUSRID AS 'IC COST Item Master-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CT00102 AS ['IC COST Item Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['IC COST Item Master'].MDFUSRID = ['Users Master'].USERID
82USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
83CREATDDT SearchCreated DateDTDate48
84USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
85WRNTYDYS SearchWarranty DaysINT4Integer24
86USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
87PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
88DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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