Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICIV0323
Product: Manufacturing (346)
Series:
Display Name: IC_IV_STANDARD Group Display Name: Manufacturing Inventory
Physical Name: ICIV0323
Technical Name: IC_IV_STANDARD
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/hideSELECT
['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/hideSELECT
['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 | Mat Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
4 | MATCOSTI_1 | Mat Cost[1] | Currency | DLR17_RBS0_UTR$ | 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 | MATCOSTI_4 | Mat Cost[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
9 | MATFIXOHDCOSTI | Mat Fix Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
10 | MATFIXOHDCOSTEFFDTI | Mat Fix Ohd Cost Eff Date | DT | Date | 8 | |
11 | MATCOSTI_5 | Mat Cost[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
12 | MATCOSTI_6 | Mat Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
13 | MATVAROHDCOSTI | Mat Var Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
14 | MATCOSTI_7 | Mat Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
15 | MATCOSTI_8 | Mat Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
16 | MATVAROHDCOSTEFFDTI | Mat Var Ohd Cost Eff Date | DT | Date | 8 | |
17 | MATCOSTEFFDATEI_1 | Mat Cost Eff Date[1] | Date | DT | 8 | |
18 | LABCOSTI | Lab Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
19 | MATCOSTEFFDATEI_2 | Mat Cost Eff Date[2] | Date | DT | 8 | |
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 | MATCOSTEFFDATEI_5 | Mat Cost Eff Date[5] | Date | DT | 8 | |
24 | LABFIXOHDCOSTI | Lab Fix Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
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 | LABVAROHDCOSTI | Lab Var Ohd Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
29 | MATCOSTEFFDATEI_8 | Mat Cost Eff Date[8] | Date | DT | 8 | |
30 | LABVAROHDCOSTEFFDTI | Lab Var Ohd Cost Eff Date | DT | Date | 8 | |
31 | NO_CALC_MAT | NO_CALC_MAT | Boolean | CB | 0 | |
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 | MATFIXOHDCOSTI_3 | Mat Fix Ohd Cost[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
36 | MACHCOSTEFFDTI | Mach Cost Eff Date | DT | Date | 8 | |
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 | MACHFIXOHDCOSTEFFDTI | Mach Fix Ohd Cost Eff Date | DT | Date | 8 | |
41 | MATFIXOHDCOSTI_6 | Mat Fix Ohd Cost[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
42 | MATFIXOHDCOSTI_7 | Mat Fix Ohd Cost[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
43 | MATFIXOHDCOSTI_8 | Mat Fix Ohd Cost[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
44 | MACHVAROHDCOSTI | Mach Var Ohd Cost | DLR17_RBS0_UTR$ | Currency | 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 |