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 TypeLength
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
3NOTEINDX SearchNote IndexDLR14Currency14
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 NameSTR15String15
5ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
6ITMGEDSC SearchItem Generic DescriptionSTR10String10
7STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency17
8CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency17
9LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency17
10ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer6
11DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
13ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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_OptionsInteger0
15COMMCODE SearchCommission CodeSTR15_LBAUString15
16ICIVMFIXI SearchIC IV Material Fixed IndexLI_14Long Integer14
17ICIVMVIXI SearchIC IV Material Var IndexLI_14Long Integer14
18ICIVLVIXI SearchIC IV Labor Var IndexLI_14Long Integer14
19ICIVLABVAROHIX_I SearchIC IV Lab Variance OH IndexLI_14Long Integer14
20ICIVLABVAROHVARIX_I SearchIC IV Lab Variance OH Var IndexLI_14Long Integer14
21ICIVMEVIXI SearchIC IV Machine Efficiency Var IndexLI_14Long Integer14
22ICIVMACHEFFVAROHIX_I SearchIC IV Mach Eff Variance OH IndexLI_14Long Integer14
23ICIVMACHEFFVAROHVARIX_I SearchIC IV Mach Eff Variance OH Var IndexLI_14Long Integer14
24ICIVMUIXI SearchIC IV Material Usage Var IndexLI_14Long Integer14
25ICIVMATUSAGEVAROHIX_I SearchIC IV Mat Usage Variance OH IndexLI_14Long Integer14
26ICIVMATUSAGEVAROHVARIX_I SearchIC IV Mat Usage Variance OH Var IndexLI_14Long Integer14
27ICIVOVIXI SearchIC IV Overhead Var IndexLI_14Long Integer14
28ICIVPVIXI SearchIC IV Purchase Price Var IndexLI_14Long Integer14
29ICIVSCIXI SearchIC IV Standard Cost Reval IndexLI_14Long Integer14
30ICIVROIXI SearchIC IV Returns Offset IndexLI_14Long Integer14
31ICIVWMIXI SearchIC IV WIP Material IndexLI_14Long Integer14
32ICIVUPPV_I SearchIC IV Unrealized PPV IndexLI_14Long Integer14
33ICIVWMATOHIXI SearchIC IV WIP Material OH IndexLI_14Long Integer14
34ICIVWIPMATOHVARIX_I SearchIC IV WIP Material OH Var IndexLI_14Long Integer14
35ICIVWLIXI SearchIC IV WIP Labor IndexLI_14Long Integer14
36ICIVWLOHIXI SearchIC IV WIP Labor OH IndexLI_14Long Integer14
37ICIVWIPLABOHVARIX_I SearchIC IV WIP Labor OH Var IndexLI_14Long Integer14
38ICIVWCIXI SearchIC IV WIP Machine IndexLI_14Long Integer14
39ICIVWMACHOHIXI SearchIC IV WIP Machine OH IndexLI_14Long Integer14
40ICIVWIPMACHOHVARIX_I SearchIC IV WIP Machine OH Var IndexLI_14Long Integer14
41ICIVWOIXI SearchIC IV WIP Overhead IndexLI_14Long Integer14
42ICIVCMIXI SearchIC IV CoGS Material IndexLI_14Long Integer14
43ICIVCMATOHIXI SearchIC IV CoGS Material OH IndexLI_14Long Integer14
44ICIVCOGSMATOHVARIX_I SearchIC IV CoGS Material OH Var IndexLI_14Long Integer14
45ICIVCLIXI SearchIC IV CoGS Labor IndexLI_14Long Integer14
46ICIVCLABOHIXI SearchIC IV CoGS Labor OH IndexLI_14Long Integer14
47ICIVCOGSLABOHVARIX_I SearchIC IV CoGS Labor OH Var IndexLI_14Long Integer14
48ICIVCCIXI SearchIC IV CoGS Machine IndexLI_14Long Integer14
49ICIVCMACHOHIXI SearchIC IV CoGS Machine OH IndexLI_14Long Integer14
50ICIVCOGSMACHOHVARIX_I SearchIC IV CoGS Machine OH Var IndexLI_14Long Integer14
51ICIVCOIXI SearchIC IV CoGS Overhead IndexLI_14Long Integer14
52ICIVILIXI SearchIC IV INV Labor IndexLI_14Long Integer14
53ICIVILABOHIXI SearchIC IV INV Labor OH IndexLI_14Long Integer14
54ICIVINVLABOHVARIX_I SearchIC IV INV Labor OH Var IndexLI_14Long Integer14
55ICIVIMXI SearchIC IV INV Machine IndexLI_14Long Integer14
56ICIVIMACHOHIXI SearchIC IV INV Machine OH IndexLI_14Long Integer14
57ICIVINVMACHOHVARIX_I SearchIC IV INV Machine OH Var IndexLI_14Long Integer14
58ICIVIMATOHIXI SearchIC IV INV Material OH IndexLI_14Long Integer14
59ICIVINVMATOHVARIX_I SearchIC IV INV Material OH Var IndexLI_14Long Integer14
60ITMCLSCD SearchItem Class CodeSTR10_Class_IDString10
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_TrackInteger0
62LOTTYPE SearchLot TypeSTR10_Lot_TypeString10
63KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
64KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
65KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
66KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
67ITMKTFLG SearchItem Kit FlagCB_Kit_ItemBoolean0
68ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
69FSHGDFLG SearchFinished Good FlagCB_Finished_ItemBoolean0
70CMPTFLAG SearchComponent FlagCB_Component_ItemBoolean0
71VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
72UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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_NumberString30
74ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString30
75USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
76USCATVLS SearchUser Category ValuesUser_Category_ValueString10
77USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
78MSTRCDTY SearchMaster Record TypeINT1Integer1
79MODIFDT SearchModified DateDTDate8
80USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
81MDFUSRID SearchModified User IDSTR15String15
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_ValueString10
83CREATDDT SearchCreated DateDTDate8
84USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
85WRNTYDYS SearchWarranty DaysINT4Integer4
86USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
87PRCLEVEL SearchPriceLevelSTR10_LBAUString10
88DEX_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.

Leave a Reply

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