IC COST Item Class Setup (CT40401)

azurecurve Products Manufacturing (346)3rd PartyIC COST Item Class Setup (CT40401)

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

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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ITMCLSCD	Item Class Code	String	STR10_Class_ID	10
	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
2	ITMCLSDC	Item Class Description	String	STR30	30
3	DEFLTCLS	Default Class	Boolean	CB_Default	0
4	NOTEINDX	Note Index	Currency	DLR14	14
	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
5	ITEMTYPE	Item Type	Integer	DDL_Item_Type	0
6	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
7	LOTTYPE	Lot Type	String	STR10_Lot_Type	10
8	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
9	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
10	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
11	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
12	ALWBKORD	Allow Back Orders	Boolean	CB_Allow_Back_Orders	0
13	ITMGEDSC	Item Generic Description	String	STR10	10
14	TAXOPTNS	Tax Options	Integer	DDL_Tax_Options	0
15	ITMTSHID	Item Tax Schedule ID	String	STR15_LBAU	15
	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
16	COMMCODE	Commission Code	String	STR15_LBAU	15
17	UOMSCHDL	U Of M Schedule	String	STR10_Schedule	10
	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
18	VCTNMTHD	Valuation Method	Integer	DDL_Valuation_Method	0
19	USCATVLS	User Category Values	User_Category_Value	String	10
20	USCATVLS_1	User Category Values[1]	String	User_Category_Value	10
21	USCATVLS_2	User Category Values[2]	String	User_Category_Value	10
22	USCATVLS_3	User Category Values[3]	String	User_Category_Value	10
23	USCATVLS_4	User Category Values[4]	String	User_Category_Value	10
24	USCATVLS_5	User Category Values[5]	String	User_Category_Value	10
25	USCATVLS_6	User Category Values[6]	String	User_Category_Value	10
26	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
27	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
28	ICIVCLIXI	IC IV CoGS Labor Index	Long Integer	LI_14	14
29	ICIVCLABOHIXI	IC IV CoGS Labor OH Index	Long Integer	LI_14	14
30	ICIVCOGSLABOHVARIX_I	IC IV CoGS Labor OH Var Index	Long Integer	LI_14	14
31	ICIVCCIXI	IC IV CoGS Machine Index	Long Integer	LI_14	14
32	ICIVCMACHOHIXI	IC IV CoGS Machine OH Index	Long Integer	LI_14	14
33	ICIVCOGSMACHOHVARIX_I	IC IV CoGS Machine OH Var Index	Long Integer	LI_14	14
34	ICIVCMIXI	IC IV CoGS Material Index	Long Integer	LI_14	14
35	ICIVCMATOHIXI	IC IV CoGS Material OH Index	Long Integer	LI_14	14
36	ICIVCOGSMATOHVARIX_I	IC IV CoGS Material OH Var Index	Long Integer	LI_14	14
37	ICIVCOIXI	IC IV CoGS Overhead Index	Long Integer	LI_14	14
38	ICIVMFIXI	IC IV Material Fixed Index	Long Integer	LI_14	14
39	ICIVMUIXI	IC IV Material Usage Var Index	Long Integer	LI_14	14
40	ICIVMATUSAGEVAROHIX_I	IC IV Mat Usage Variance OH Index	Long Integer	LI_14	14
41	ICIVMATUSAGEVAROHVARIX_I	IC IV Mat Usage Variance OH Var Index	Long Integer	LI_14	14
42	ICIVMVIXI	IC IV Material Var Index	Long Integer	LI_14	14
43	ICIVPVIXI	IC IV Purchase Price Var Index	Long Integer	LI_14	14
44	ICIVROIXI	IC IV Returns Offset Index	Long Integer	LI_14	14
45	ICIVSCIXI	IC IV Standard Cost Reval Index	Long Integer	LI_14	14
46	ICIVLVIXI	IC IV Labor Var Index	Long Integer	LI_14	14
47	ICIVUPPV_I	IC IV Unrealized PPV Index	Long Integer	LI_14	14
48	ICIVLABVAROHIX_I	IC IV Lab Variance OH Index	Long Integer	LI_14	14
49	ICIVLABVAROHVARIX_I	IC IV Lab Variance OH Var Index	Long Integer	LI_14	14
50	ICIVMEVIXI	IC IV Machine Efficiency Var Index	Long Integer	LI_14	14
51	ICIVMACHEFFVAROHIX_I	IC IV Mach Eff Variance OH Index	Long Integer	LI_14	14
52	ICIVMACHEFFVAROHVARIX_I	IC IV Mach Eff Variance OH Var Index	Long Integer	LI_14	14
53	ICIVOVIXI	IC IV Overhead Var Index	Long Integer	LI_14	14
54	ICIVWLIXI	IC IV WIP Labor Index	Long Integer	LI_14	14
55	ICIVWLOHIXI	IC IV WIP Labor OH Index	Long Integer	LI_14	14
56	ICIVWIPLABOHVARIX_I	IC IV WIP Labor OH Var Index	Long Integer	LI_14	14
57	ICIVWCIXI	IC IV WIP Machine Index	Long Integer	LI_14	14
58	ICIVWMACHOHIXI	IC IV WIP Machine OH Index	Long Integer	LI_14	14
59	ICIVWIPMACHOHVARIX_I	IC IV WIP Machine OH Var Index	Long Integer	LI_14	14
60	ICIVWMIXI	IC IV WIP Material Index	Long Integer	LI_14	14
61	ICIVWMATOHIXI	IC IV WIP Material OH Index	Long Integer	LI_14	14
62	ICIVWIPMATOHVARIX_I	IC IV WIP Material OH Var Index	Long Integer	LI_14	14
63	ICIVWOIXI	IC IV WIP Overhead Index	Long Integer	LI_14	14
64	ICIVILIXI	IC IV INV Labor Index	Long Integer	LI_14	14
65	ICIVILABOHIXI	IC IV INV Labor OH Index	Long Integer	LI_14	14
66	ICIVINVLABOHVARIX_I	IC IV INV Labor OH Var Index	Long Integer	LI_14	14
67	ICIVIMXI	IC IV INV Machine Index	Long Integer	LI_14	14
68	ICIVIMACHOHIXI	IC IV INV Machine OH Index	Long Integer	LI_14	14
69	ICIVINVMACHOHVARIX_I	IC IV INV Machine OH Var Index	Long Integer	LI_14	14
70	ICIVIMATOHIXI	IC IV INV Material OH Index	Long Integer	LI_14	14
71	ICIVINVMATOHVARIX_I	IC IV INV Material OH Var Index	Long Integer	LI_14	14
72	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
73	MODIFDT	Modified Date	Date	DT	8
74	MDFUSRID	Modified User ID	String	STR15	15
	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

azurecurve Products Manufacturing (346)3rd PartyIC COST Item Class Setup (CT40401)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply