IC_IV_STANDARD (ICIV0323)

azurecurve Products Manufacturing (346)3rd PartyIC_IV_STANDARD (ICIV0323)

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

Display Name: IC_IV_STANDARD
Physical Name: ICIV0323
Technical Name: IC_IV_STANDARD

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['IC_IV_STANDARD'].ITEMNMBR AS 'IC_IV_STANDARD-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ICIV0323 AS ['IC_IV_STANDARD'] INNER JOIN IV00101 AS ['Item Master'] ON ['IC_IV_STANDARD'].ITEMNMBR = ['Item Master'].ITEMNMBR
2	ITMCLSCD	Item Class Code	String	STR10_Class_ID	10
	Key to the Item Class Setup (IV40400). Click to show/hide SELECT ['IC_IV_STANDARD'].ITMCLSCD AS 'IC_IV_STANDARD-Item Class Code' ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code' FROM ICIV0323 AS ['IC_IV_STANDARD'] INNER JOIN IV40400 AS ['Item Class Setup'] ON ['IC_IV_STANDARD'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
3	MATCOSTI_1	Mat Cost[1]	Currency	DLR17_RBS0_UTR$	17
4	MATCOSTI	Mat Cost	DLR17_RBS0_UTR$	Currency	17
5	MATCOSTEFFDATEI	Mat Cost Eff Date	DT	Date	8
6	MATCOSTI_2	Mat Cost[2]	Currency	DLR17_RBS0_UTR$	17
7	MATCOSTI_3	Mat Cost[3]	Currency	DLR17_RBS0_UTR$	17
8	MATFIXOHDCOSTI	Mat Fix Ohd Cost	DLR17_RBS0_UTR$	Currency	17
9	MATCOSTI_4	Mat Cost[4]	Currency	DLR17_RBS0_UTR$	17
10	MATCOSTI_5	Mat Cost[5]	Currency	DLR17_RBS0_UTR$	17
11	MATFIXOHDCOSTEFFDTI	Mat Fix Ohd Cost Eff Date	DT	Date	8
12	MATCOSTI_6	Mat Cost[6]	Currency	DLR17_RBS0_UTR$	17
13	MATCOSTI_7	Mat Cost[7]	Currency	DLR17_RBS0_UTR$	17
14	MATVAROHDCOSTI	Mat Var Ohd Cost	DLR17_RBS0_UTR$	Currency	17
15	MATVAROHDCOSTEFFDTI	Mat Var Ohd Cost Eff Date	DT	Date	8
16	MATCOSTI_8	Mat Cost[8]	Currency	DLR17_RBS0_UTR$	17
17	MATCOSTEFFDATEI_1	Mat Cost Eff Date[1]	Date	DT	8
18	MATCOSTEFFDATEI_2	Mat Cost Eff Date[2]	Date	DT	8
19	LABCOSTI	Lab Cost	DLR17_RBS0_UTR$	Currency	17
20	LABCOSTEFFDTI	Lab Cost Eff Date	DT	Date	8
21	MATCOSTEFFDATEI_3	Mat Cost Eff Date[3]	Date	DT	8
22	MATCOSTEFFDATEI_4	Mat Cost Eff Date[4]	Date	DT	8
23	LABFIXOHDCOSTI	Lab Fix Ohd Cost	DLR17_RBS0_UTR$	Currency	17
24	MATCOSTEFFDATEI_5	Mat Cost Eff Date[5]	Date	DT	8
25	LABFIXOHDCOSTEFFDTI	Lab Fix Ohd Cost Eff Date	DT	Date	8
26	MATCOSTEFFDATEI_6	Mat Cost Eff Date[6]	Date	DT	8
27	MATCOSTEFFDATEI_7	Mat Cost Eff Date[7]	Date	DT	8
28	MATCOSTEFFDATEI_8	Mat Cost Eff Date[8]	Date	DT	8
29	LABVAROHDCOSTI	Lab Var Ohd Cost	DLR17_RBS0_UTR$	Currency	17
30	NO_CALC_MAT	NO_CALC_MAT	Boolean	CB	0
31	LABVAROHDCOSTEFFDTI	Lab Var Ohd Cost Eff Date	DT	Date	8
32	MATFIXOHDCOSTI_1	Mat Fix Ohd Cost[1]	Currency	DLR17_RBS0_UTR$	17
33	MATFIXOHDCOSTI_2	Mat Fix Ohd Cost[2]	Currency	DLR17_RBS0_UTR$	17
34	MACHCOSTI	Mach Cost	DLR17_RBS0_UTR$	Currency	17
35	MACHCOSTEFFDTI	Mach Cost Eff Date	DT	Date	8
36	MATFIXOHDCOSTI_3	Mat Fix Ohd Cost[3]	Currency	DLR17_RBS0_UTR$	17
37	MATFIXOHDCOSTI_4	Mat Fix Ohd Cost[4]	Currency	DLR17_RBS0_UTR$	17
38	MATFIXOHDCOSTI_5	Mat Fix Ohd Cost[5]	Currency	DLR17_RBS0_UTR$	17
39	MACHFIXOHDCOSTI	Mach Fix Ohd Cost	DLR17_RBS0_UTR$	Currency	17
40	MATFIXOHDCOSTI_6	Mat Fix Ohd Cost[6]	Currency	DLR17_RBS0_UTR$	17
41	MACHFIXOHDCOSTEFFDTI	Mach Fix Ohd Cost Eff Date	DT	Date	8
42	MATFIXOHDCOSTI_7	Mat Fix Ohd Cost[7]	Currency	DLR17_RBS0_UTR$	17
43	MACHVAROHDCOSTI	Mach Var Ohd Cost	DLR17_RBS0_UTR$	Currency	17
44	MATFIXOHDCOSTI_8	Mat Fix Ohd Cost[8]	Currency	DLR17_RBS0_UTR$	17
45	MACHVAROHDCOSTEFFDTI	Mach Var Ohd Cost Eff Date	DT	Date	8
46	MATFIXOHDCOSTEFFDTI_1	Mat Fix Ohd Cost Eff Date[1]	Date	DT	8
47	MATFIXOHDCOSTEFFDTI_2	Mat Fix Ohd Cost Eff Date[2]	Date	DT	8
48	MATFIXOHDCOSTEFFDTI_3	Mat Fix Ohd Cost Eff Date[3]	Date	DT	8
49	TOTALCOSTI	Total Cost	DLR17_RBS0_UTR$	Currency	17
50	MATFIXOHDCOSTEFFDTI_4	Mat Fix Ohd Cost Eff Date[4]	Date	DT	8
51	MATFIXOHDCOSTEFFDTI_5	Mat Fix Ohd Cost Eff Date[5]	Date	DT	8
52	MATFIXOHDCOSTEFFDTI_6	Mat Fix Ohd Cost Eff Date[6]	Date	DT	8
53	MATFIXOHDCOSTEFFDTI_7	Mat Fix Ohd Cost Eff Date[7]	Date	DT	8
54	MATFIXOHDCOSTEFFDTI_8	Mat Fix Ohd Cost Eff Date[8]	Date	DT	8
55	NO_CALC_MAT_FIX_OHD	NO_CALC_MAT_FIX_OHD	Boolean	CB	0
56	MATVAROHDCOSTI_1	Mat Var Ohd Cost[1]	Currency	DLR17_RBS0_UTR$	17
57	MATVAROHDCOSTI_2	Mat Var Ohd Cost[2]	Currency	DLR17_RBS0_UTR$	17
58	MATVAROHDCOSTI_3	Mat Var Ohd Cost[3]	Currency	DLR17_RBS0_UTR$	17
59	MATVAROHDCOSTI_4	Mat Var Ohd Cost[4]	Currency	DLR17_RBS0_UTR$	17
60	MATVAROHDCOSTI_5	Mat Var Ohd Cost[5]	Currency	DLR17_RBS0_UTR$	17
61	MATVAROHDCOSTI_6	Mat Var Ohd Cost[6]	Currency	DLR17_RBS0_UTR$	17
62	MATVAROHDCOSTI_7	Mat Var Ohd Cost[7]	Currency	DLR17_RBS0_UTR$	17
63	MATVAROHDCOSTI_8	Mat Var Ohd Cost[8]	Currency	DLR17_RBS0_UTR$	17
64	MATVAROHDCOSTEFFDTI_1	Mat Var Ohd Cost Eff Date[1]	Date	DT	8
65	MATVAROHDCOSTEFFDTI_2	Mat Var Ohd Cost Eff Date[2]	Date	DT	8
66	MATVAROHDCOSTEFFDTI_3	Mat Var Ohd Cost Eff Date[3]	Date	DT	8
67	MATVAROHDCOSTEFFDTI_4	Mat Var Ohd Cost Eff Date[4]	Date	DT	8
68	MATVAROHDCOSTEFFDTI_5	Mat Var Ohd Cost Eff Date[5]	Date	DT	8
69	MATVAROHDCOSTEFFDTI_6	Mat Var Ohd Cost Eff Date[6]	Date	DT	8
70	MATVAROHDCOSTEFFDTI_7	Mat Var Ohd Cost Eff Date[7]	Date	DT	8
71	MATVAROHDCOSTEFFDTI_8	Mat Var Ohd Cost Eff Date[8]	Date	DT	8
72	NO_CALC_MAT_VAR_OHD	NO_CALC_MAT_VAR_OHD	Boolean	CB	0
73	LABCOSTI_1	Lab Cost[1]	Currency	DLR17_RBS0_UTR$	17
74	LABCOSTI_2	Lab Cost[2]	Currency	DLR17_RBS0_UTR$	17
75	LABCOSTI_3	Lab Cost[3]	Currency	DLR17_RBS0_UTR$	17
76	LABCOSTI_4	Lab Cost[4]	Currency	DLR17_RBS0_UTR$	17
77	LABCOSTI_5	Lab Cost[5]	Currency	DLR17_RBS0_UTR$	17
78	LABCOSTI_6	Lab Cost[6]	Currency	DLR17_RBS0_UTR$	17
79	LABCOSTI_7	Lab Cost[7]	Currency	DLR17_RBS0_UTR$	17
80	LABCOSTI_8	Lab Cost[8]	Currency	DLR17_RBS0_UTR$	17
81	LABCOSTEFFDTI_1	Lab Cost Eff Date[1]	Date	DT	8
82	LABCOSTEFFDTI_2	Lab Cost Eff Date[2]	Date	DT	8
83	LABCOSTEFFDTI_3	Lab Cost Eff Date[3]	Date	DT	8
84	LABCOSTEFFDTI_4	Lab Cost Eff Date[4]	Date	DT	8
85	LABCOSTEFFDTI_5	Lab Cost Eff Date[5]	Date	DT	8
86	LABCOSTEFFDTI_6	Lab Cost Eff Date[6]	Date	DT	8
87	NO_CALC_LAB	NO_CALC_LAB	Boolean	CB	0
88	LABFIXOHDCOSTI_1	Lab Fix Ohd Cost[1]	Currency	DLR17_RBS0_UTR$	17
89	LABFIXOHDCOSTI_2	Lab Fix Ohd Cost[2]	Currency	DLR17_RBS0_UTR$	17
90	LABFIXOHDCOSTI_3	Lab Fix Ohd Cost[3]	Currency	DLR17_RBS0_UTR$	17
91	LABFIXOHDCOSTI_4	Lab Fix Ohd Cost[4]	Currency	DLR17_RBS0_UTR$	17
92	LABFIXOHDCOSTI_5	Lab Fix Ohd Cost[5]	Currency	DLR17_RBS0_UTR$	17
93	LABFIXOHDCOSTI_6	Lab Fix Ohd Cost[6]	Currency	DLR17_RBS0_UTR$	17
94	LABFIXOHDCOSTI_7	Lab Fix Ohd Cost[7]	Currency	DLR17_RBS0_UTR$	17
95	LABFIXOHDCOSTI_8	Lab Fix Ohd Cost[8]	Currency	DLR17_RBS0_UTR$	17
96	LABFIXOHDCOSTEFFDTI_1	Lab Fix Ohd Cost Eff Date[1]	Date	DT	8
97	LABFIXOHDCOSTEFFDTI_2	Lab Fix Ohd Cost Eff Date[2]	Date	DT	8
98	LABFIXOHDCOSTEFFDTI_3	Lab Fix Ohd Cost Eff Date[3]	Date	DT	8
99	LABFIXOHDCOSTEFFDTI_4	Lab Fix Ohd Cost Eff Date[4]	Date	DT	8
100	LABFIXOHDCOSTEFFDTI_5	Lab Fix Ohd Cost Eff Date[5]	Date	DT	8
101	LABFIXOHDCOSTEFFDTI_6	Lab Fix Ohd Cost Eff Date[6]	Date	DT	8
102	NO_CALC_LAB_FIX_OHD	NO_CALC_LAB_FIX_OHD	Boolean	CB	0
103	LABVAROHDCOSTI_1	Lab Var Ohd Cost[1]	Currency	DLR17_RBS0_UTR$	17
104	LABVAROHDCOSTI_2	Lab Var Ohd Cost[2]	Currency	DLR17_RBS0_UTR$	17
105	LABVAROHDCOSTI_3	Lab Var Ohd Cost[3]	Currency	DLR17_RBS0_UTR$	17
106	LABVAROHDCOSTI_4	Lab Var Ohd Cost[4]	Currency	DLR17_RBS0_UTR$	17
107	LABVAROHDCOSTI_5	Lab Var Ohd Cost[5]	Currency	DLR17_RBS0_UTR$	17
108	LABVAROHDCOSTI_6	Lab Var Ohd Cost[6]	Currency	DLR17_RBS0_UTR$	17
109	LABVAROHDCOSTI_7	Lab Var Ohd Cost[7]	Currency	DLR17_RBS0_UTR$	17
110	LABVAROHDCOSTI_8	Lab Var Ohd Cost[8]	Currency	DLR17_RBS0_UTR$	17
111	LABVAROHDCOSTEFFDTI_1	Lab Var Ohd Cost Eff Date[1]	Date	DT	8
112	LABVAROHDCOSTEFFDTI_2	Lab Var Ohd Cost Eff Date[2]	Date	DT	8
113	LABVAROHDCOSTEFFDTI_3	Lab Var Ohd Cost Eff Date[3]	Date	DT	8
114	LABVAROHDCOSTEFFDTI_4	Lab Var Ohd Cost Eff Date[4]	Date	DT	8
115	LABVAROHDCOSTEFFDTI_5	Lab Var Ohd Cost Eff Date[5]	Date	DT	8
116	LABVAROHDCOSTEFFDTI_6	Lab Var Ohd Cost Eff Date[6]	Date	DT	8
117	NO_CALC_LAB_VAR_OHD	NO_CALC_LAB_VAR_OHD	Boolean	CB	0
118	MACHCOSTI_1	Mach Cost[1]	Currency	DLR17_RBS0_UTR$	17
119	MACHCOSTI_2	Mach Cost[2]	Currency	DLR17_RBS0_UTR$	17
120	MACHCOSTI_3	Mach Cost[3]	Currency	DLR17_RBS0_UTR$	17
121	MACHCOSTI_4	Mach Cost[4]	Currency	DLR17_RBS0_UTR$	17
122	MACHCOSTI_5	Mach Cost[5]	Currency	DLR17_RBS0_UTR$	17
123	MACHCOSTI_6	Mach Cost[6]	Currency	DLR17_RBS0_UTR$	17
124	MACHCOSTI_7	Mach Cost[7]	Currency	DLR17_RBS0_UTR$	17
125	MACHCOSTI_8	Mach Cost[8]	Currency	DLR17_RBS0_UTR$	17
126	MACHCOSTEFFDTI_1	Mach Cost Eff Date[1]	Date	DT	8
127	MACHCOSTEFFDTI_2	Mach Cost Eff Date[2]	Date	DT	8
128	MACHCOSTEFFDTI_3	Mach Cost Eff Date[3]	Date	DT	8
129	MACHCOSTEFFDTI_4	Mach Cost Eff Date[4]	Date	DT	8
130	MACHCOSTEFFDTI_5	Mach Cost Eff Date[5]	Date	DT	8
131	MACHCOSTEFFDTI_6	Mach Cost Eff Date[6]	Date	DT	8
132	NO_CALC_MACH	NO_CALC_MACH	Boolean	CB	0
133	MACHFIXOHDCOSTI_1	Mach Fix Ohd Cost[1]	Currency	DLR17_RBS0_UTR$	17
134	MACHFIXOHDCOSTI_2	Mach Fix Ohd Cost[2]	Currency	DLR17_RBS0_UTR$	17
135	MACHFIXOHDCOSTI_3	Mach Fix Ohd Cost[3]	Currency	DLR17_RBS0_UTR$	17
136	MACHFIXOHDCOSTI_4	Mach Fix Ohd Cost[4]	Currency	DLR17_RBS0_UTR$	17
137	MACHFIXOHDCOSTI_5	Mach Fix Ohd Cost[5]	Currency	DLR17_RBS0_UTR$	17
138	MACHFIXOHDCOSTI_6	Mach Fix Ohd Cost[6]	Currency	DLR17_RBS0_UTR$	17
139	MACHFIXOHDCOSTI_7	Mach Fix Ohd Cost[7]	Currency	DLR17_RBS0_UTR$	17
140	MACHFIXOHDCOSTI_8	Mach Fix Ohd Cost[8]	Currency	DLR17_RBS0_UTR$	17
141	MACHFIXOHDCOSTEFFDTI_1	Mach Fix Ohd Cost Eff Date[1]	Date	DT	8
142	MACHFIXOHDCOSTEFFDTI_2	Mach Fix Ohd Cost Eff Date[2]	Date	DT	8
143	MACHFIXOHDCOSTEFFDTI_3	Mach Fix Ohd Cost Eff Date[3]	Date	DT	8
144	MACHFIXOHDCOSTEFFDTI_4	Mach Fix Ohd Cost Eff Date[4]	Date	DT	8
145	MACHFIXOHDCOSTEFFDTI_5	Mach Fix Ohd Cost Eff Date[5]	Date	DT	8
146	MACHFIXOHDCOSTEFFDTI_6	Mach Fix Ohd Cost Eff Date[6]	Date	DT	8
147	NO_CALC_MACH_FIX_OHD	NO_CALC_MACH_FIX_OHD	Boolean	CB	0
148	MACHVAROHDCOSTI_1	Mach Var Ohd Cost[1]	Currency	DLR17_RBS0_UTR$	17
149	MACHVAROHDCOSTI_2	Mach Var Ohd Cost[2]	Currency	DLR17_RBS0_UTR$	17
150	MACHVAROHDCOSTI_3	Mach Var Ohd Cost[3]	Currency	DLR17_RBS0_UTR$	17
151	MACHVAROHDCOSTI_4	Mach Var Ohd Cost[4]	Currency	DLR17_RBS0_UTR$	17
152	MACHVAROHDCOSTI_5	Mach Var Ohd Cost[5]	Currency	DLR17_RBS0_UTR$	17
153	MACHVAROHDCOSTI_6	Mach Var Ohd Cost[6]	Currency	DLR17_RBS0_UTR$	17
154	MACHVAROHDCOSTI_7	Mach Var Ohd Cost[7]	Currency	DLR17_RBS0_UTR$	17
155	MACHVAROHDCOSTI_8	Mach Var Ohd Cost[8]	Currency	DLR17_RBS0_UTR$	17
156	MACHVAROHDCOSTEFFDTI_1	Mach Var Ohd Cost Eff Date[1]	Date	DT	8
157	MACHVAROHDCOSTEFFDTI_2	Mach Var Ohd Cost Eff Date[2]	Date	DT	8
158	MACHVAROHDCOSTEFFDTI_3	Mach Var Ohd Cost Eff Date[3]	Date	DT	8
159	MACHVAROHDCOSTEFFDTI_4	Mach Var Ohd Cost Eff Date[4]	Date	DT	8
160	MACHVAROHDCOSTEFFDTI_5	Mach Var Ohd Cost Eff Date[5]	Date	DT	8
161	MACHVAROHDCOSTEFFDTI_6	Mach Var Ohd Cost Eff Date[6]	Date	DT	8
162	NO_CALC_MACH_VAR_OHD	NO_CALC_MACH_VAR_OHD	Boolean	CB	0
163	TOTALCOSTI_1	Total Cost[1]	Currency	DLR17_RBS0_UTR$	17
164	TOTALCOSTI_2	Total Cost[2]	Currency	DLR17_RBS0_UTR$	17
165	TOTALCOSTI_3	Total Cost[3]	Currency	DLR17_RBS0_UTR$	17
166	TOTALCOSTI_4	Total Cost[4]	Currency	DLR17_RBS0_UTR$	17
167	TOTALCOSTI_5	Total Cost[5]	Currency	DLR17_RBS0_UTR$	17
168	TOTALCOSTI_6	Total Cost[6]	Currency	DLR17_RBS0_UTR$	17
169	TOTALCOSTI_7	Total Cost[7]	Currency	DLR17_RBS0_UTR$	17
170	TOTALCOSTI_8	Total Cost[8]	Currency	DLR17_RBS0_UTR$	17
171	BTDT_I	BTDT	Boolean	Boolean	0
172	DONT_ROLLUP_WU	Dont_Rollup_WU	Boolean	Dont_Rollup	0
173	MAT_SET_TO_ZERO	Mat_Set_To_Zero	Boolean	CB	0
174	MAT_FIXED_SET_TO_ZERO	Mat_Fixed_Set_To_Zero	Boolean	CB	0
175	MAT_VAR_SET_TO_ZERO	Mat_Var_Set_To_Zero	Boolean	CB	0

azurecurve Products Manufacturing (346)3rd PartyIC_IV_STANDARD (ICIV0323)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply