IC COST Item Master (CT00102)

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

Product: Manufacturing (346)
Series:

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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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 DescriptionStringSTR100100
3NOTEINDX SearchNote IndexCurrencyDLR1414
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 NameStringSTR1515
5ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
6ITMGEDSC SearchItem Generic DescriptionStringSTR1010
7STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
8CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
9LISTPRCE SearchList PriceCurrencyDLR17_RBS0_STR$17
10ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
11DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
12DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
13ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
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 OptionsIntegerDDL_Tax_Options0
15COMMCODE SearchCommission CodeStringSTR15_LBAU15
16ICIVMFIXI SearchIC IV Material Fixed IndexLong IntegerLI_1414
17ICIVMVIXI SearchIC IV Material Var IndexLong IntegerLI_1414
18ICIVLVIXI SearchIC IV Labor Var IndexLong IntegerLI_1414
19ICIVLABVAROHIX_I SearchIC IV Lab Variance OH IndexLong IntegerLI_1414
20ICIVLABVAROHVARIX_I SearchIC IV Lab Variance OH Var IndexLong IntegerLI_1414
21ICIVMEVIXI SearchIC IV Machine Efficiency Var IndexLong IntegerLI_1414
22ICIVMACHEFFVAROHIX_I SearchIC IV Mach Eff Variance OH IndexLong IntegerLI_1414
23ICIVMACHEFFVAROHVARIX_I SearchIC IV Mach Eff Variance OH Var IndexLong IntegerLI_1414
24ICIVMUIXI SearchIC IV Material Usage Var IndexLong IntegerLI_1414
25ICIVMATUSAGEVAROHIX_I SearchIC IV Mat Usage Variance OH IndexLong IntegerLI_1414
26ICIVMATUSAGEVAROHVARIX_I SearchIC IV Mat Usage Variance OH Var IndexLong IntegerLI_1414
27ICIVOVIXI SearchIC IV Overhead Var IndexLong IntegerLI_1414
28ICIVPVIXI SearchIC IV Purchase Price Var IndexLong IntegerLI_1414
29ICIVSCIXI SearchIC IV Standard Cost Reval IndexLong IntegerLI_1414
30ICIVROIXI SearchIC IV Returns Offset IndexLong IntegerLI_1414
31ICIVWMIXI SearchIC IV WIP Material IndexLong IntegerLI_1414
32ICIVUPPV_I SearchIC IV Unrealized PPV IndexLong IntegerLI_1414
33ICIVWMATOHIXI SearchIC IV WIP Material OH IndexLong IntegerLI_1414
34ICIVWIPMATOHVARIX_I SearchIC IV WIP Material OH Var IndexLong IntegerLI_1414
35ICIVWLIXI SearchIC IV WIP Labor IndexLong IntegerLI_1414
36ICIVWLOHIXI SearchIC IV WIP Labor OH IndexLong IntegerLI_1414
37ICIVWIPLABOHVARIX_I SearchIC IV WIP Labor OH Var IndexLong IntegerLI_1414
38ICIVWCIXI SearchIC IV WIP Machine IndexLong IntegerLI_1414
39ICIVWMACHOHIXI SearchIC IV WIP Machine OH IndexLong IntegerLI_1414
40ICIVWIPMACHOHVARIX_I SearchIC IV WIP Machine OH Var IndexLong IntegerLI_1414
41ICIVWOIXI SearchIC IV WIP Overhead IndexLong IntegerLI_1414
42ICIVCMIXI SearchIC IV CoGS Material IndexLong IntegerLI_1414
43ICIVCMATOHIXI SearchIC IV CoGS Material OH IndexLong IntegerLI_1414
44ICIVCOGSMATOHVARIX_I SearchIC IV CoGS Material OH Var IndexLong IntegerLI_1414
45ICIVCLIXI SearchIC IV CoGS Labor IndexLong IntegerLI_1414
46ICIVCLABOHIXI SearchIC IV CoGS Labor OH IndexLong IntegerLI_1414
47ICIVCOGSLABOHVARIX_I SearchIC IV CoGS Labor OH Var IndexLong IntegerLI_1414
48ICIVCCIXI SearchIC IV CoGS Machine IndexLong IntegerLI_1414
49ICIVCMACHOHIXI SearchIC IV CoGS Machine OH IndexLong IntegerLI_1414
50ICIVCOGSMACHOHVARIX_I SearchIC IV CoGS Machine OH Var IndexLong IntegerLI_1414
51ICIVCOIXI SearchIC IV CoGS Overhead IndexLong IntegerLI_1414
52ICIVILIXI SearchIC IV INV Labor IndexLong IntegerLI_1414
53ICIVILABOHIXI SearchIC IV INV Labor OH IndexLong IntegerLI_1414
54ICIVINVLABOHVARIX_I SearchIC IV INV Labor OH Var IndexLong IntegerLI_1414
55ICIVIMXI SearchIC IV INV Machine IndexLong IntegerLI_1414
56ICIVIMACHOHIXI SearchIC IV INV Machine OH IndexLong IntegerLI_1414
57ICIVINVMACHOHVARIX_I SearchIC IV INV Machine OH Var IndexLong IntegerLI_1414
58ICIVIMATOHIXI SearchIC IV INV Material OH IndexLong IntegerLI_1414
59ICIVINVMATOHVARIX_I SearchIC IV INV Material OH Var IndexLong IntegerLI_1414
60ITMCLSCD SearchItem Class CodeStringSTR10_Class_ID10
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 OptionIntegerDDL_Track0
62LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
63KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
64KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
65KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
66KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
67ITMKTFLG SearchItem Kit FlagBooleanCB_Kit_Item0
68ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
69FSHGDFLG SearchFinished Good FlagBooleanCB_Finished_Item0
70CMPTFLAG SearchComponent FlagBooleanCB_Component_Item0
71VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
72UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
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 1StringSTR30_Item_Number30
74ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
75USCATVLS SearchUser Category ValuesUser_Category_ValueString10
76USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
77USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
78USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
79USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
80USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
81USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
82MSTRCDTY SearchMaster Record TypeIntegerINT11
83MODIFDT SearchModified DateDateDT8
84MDFUSRID SearchModified User IDStringSTR1515
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
85CREATDDT SearchCreated DateDateDT8
86WRNTYDYS SearchWarranty DaysIntegerINT44
87PRCLEVEL SearchPriceLevelStringSTR10_LBAU10

Leave a Reply

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