ICIV0323 - IC_IV_STANDARD | Prospr - Dynamics GP Table Reference

ICIV0323 - IC_IV_STANDARD

Query Builder

Select * from ICIV0323

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
ITMCLSCD	Item Class Code	String	12	View
MATCOSTI_1	Mat Cost[1]	Currency	10	View
MATCOSTI_2	Mat Cost[2]	Currency	10	View
MATCOSTI_3	Mat Cost[3]	Currency	10	View
MATCOSTI_4	Mat Cost[4]	Currency	10	View
MATCOSTI_5	Mat Cost[5]	Currency	10	View
MATCOSTI_6	Mat Cost[6]	Currency	10	View
MATCOSTI_7	Mat Cost[7]	Currency	10	View
MATCOSTI_8	Mat Cost[8]	Currency	10	View
MATCOSTEFFDATEI_1	Mat Cost Eff Date[1]	Date	4	View
MATCOSTEFFDATEI_2	Mat Cost Eff Date[2]	Date	4	View
MATCOSTEFFDATEI_3	Mat Cost Eff Date[3]	Date	4	View
MATCOSTEFFDATEI_4	Mat Cost Eff Date[4]	Date	4	View
MATCOSTEFFDATEI_5	Mat Cost Eff Date[5]	Date	4	View
MATCOSTEFFDATEI_6	Mat Cost Eff Date[6]	Date	4	View
MATCOSTEFFDATEI_7	Mat Cost Eff Date[7]	Date	4	View
MATCOSTEFFDATEI_8	Mat Cost Eff Date[8]	Date	4	View
NO_CALC_MAT	NO_CALC_MAT	Boolean	2	View
MATFIXOHDCOSTI_1	Mat Fix Ohd Cost[1]	Currency	10	View
MATFIXOHDCOSTI_2	Mat Fix Ohd Cost[2]	Currency	10	View
MATFIXOHDCOSTI_3	Mat Fix Ohd Cost[3]	Currency	10	View
MATFIXOHDCOSTI_4	Mat Fix Ohd Cost[4]	Currency	10	View
MATFIXOHDCOSTI_5	Mat Fix Ohd Cost[5]	Currency	10	View
MATFIXOHDCOSTI_6	Mat Fix Ohd Cost[6]	Currency	10	View
MATFIXOHDCOSTI_7	Mat Fix Ohd Cost[7]	Currency	10	View
MATFIXOHDCOSTI_8	Mat Fix Ohd Cost[8]	Currency	10	View
MATFIXOHDCOSTEFFDTI_1	Mat Fix Ohd Cost Eff Date[1]	Date	4	View
MATFIXOHDCOSTEFFDTI_2	Mat Fix Ohd Cost Eff Date[2]	Date	4	View
MATFIXOHDCOSTEFFDTI_3	Mat Fix Ohd Cost Eff Date[3]	Date	4	View
MATFIXOHDCOSTEFFDTI_4	Mat Fix Ohd Cost Eff Date[4]	Date	4	View
MATFIXOHDCOSTEFFDTI_5	Mat Fix Ohd Cost Eff Date[5]	Date	4	View
MATFIXOHDCOSTEFFDTI_6	Mat Fix Ohd Cost Eff Date[6]	Date	4	View
MATFIXOHDCOSTEFFDTI_7	Mat Fix Ohd Cost Eff Date[7]	Date	4	View
MATFIXOHDCOSTEFFDTI_8	Mat Fix Ohd Cost Eff Date[8]	Date	4	View
NO_CALC_MAT_FIX_OHD	NO_CALC_MAT_FIX_OHD	Boolean	2	View
MATVAROHDCOSTI_1	Mat Var Ohd Cost[1]	Currency	10	View
MATVAROHDCOSTI_2	Mat Var Ohd Cost[2]	Currency	10	View
MATVAROHDCOSTI_3	Mat Var Ohd Cost[3]	Currency	10	View
MATVAROHDCOSTI_4	Mat Var Ohd Cost[4]	Currency	10	View
MATVAROHDCOSTI_5	Mat Var Ohd Cost[5]	Currency	10	View
MATVAROHDCOSTI_6	Mat Var Ohd Cost[6]	Currency	10	View
MATVAROHDCOSTI_7	Mat Var Ohd Cost[7]	Currency	10	View
MATVAROHDCOSTI_8	Mat Var Ohd Cost[8]	Currency	10	View
MATVAROHDCOSTEFFDTI_1	Mat Var Ohd Cost Eff Date[1]	Date	4	View
MATVAROHDCOSTEFFDTI_2	Mat Var Ohd Cost Eff Date[2]	Date	4	View
MATVAROHDCOSTEFFDTI_3	Mat Var Ohd Cost Eff Date[3]	Date	4	View
MATVAROHDCOSTEFFDTI_4	Mat Var Ohd Cost Eff Date[4]	Date	4	View
MATVAROHDCOSTEFFDTI_5	Mat Var Ohd Cost Eff Date[5]	Date	4	View
MATVAROHDCOSTEFFDTI_6	Mat Var Ohd Cost Eff Date[6]	Date	4	View
MATVAROHDCOSTEFFDTI_7	Mat Var Ohd Cost Eff Date[7]	Date	4	View
MATVAROHDCOSTEFFDTI_8	Mat Var Ohd Cost Eff Date[8]	Date	4	View
NO_CALC_MAT_VAR_OHD	NO_CALC_MAT_VAR_OHD	Boolean	2	View
LABCOSTI_1	Lab Cost[1]	Currency	10	View
LABCOSTI_2	Lab Cost[2]	Currency	10	View
LABCOSTI_3	Lab Cost[3]	Currency	10	View
LABCOSTI_4	Lab Cost[4]	Currency	10	View
LABCOSTI_5	Lab Cost[5]	Currency	10	View
LABCOSTI_6	Lab Cost[6]	Currency	10	View
LABCOSTI_7	Lab Cost[7]	Currency	10	View
LABCOSTI_8	Lab Cost[8]	Currency	10	View
LABCOSTEFFDTI_1	Lab Cost Eff Date[1]	Date	4	View
LABCOSTEFFDTI_2	Lab Cost Eff Date[2]	Date	4	View
LABCOSTEFFDTI_3	Lab Cost Eff Date[3]	Date	4	View
LABCOSTEFFDTI_4	Lab Cost Eff Date[4]	Date	4	View
LABCOSTEFFDTI_5	Lab Cost Eff Date[5]	Date	4	View
LABCOSTEFFDTI_6	Lab Cost Eff Date[6]	Date	4	View
NO_CALC_LAB	NO_CALC_LAB	Boolean	2	View
LABFIXOHDCOSTI_1	Lab Fix Ohd Cost[1]	Currency	10	View
LABFIXOHDCOSTI_2	Lab Fix Ohd Cost[2]	Currency	10	View
LABFIXOHDCOSTI_3	Lab Fix Ohd Cost[3]	Currency	10	View
LABFIXOHDCOSTI_4	Lab Fix Ohd Cost[4]	Currency	10	View
LABFIXOHDCOSTI_5	Lab Fix Ohd Cost[5]	Currency	10	View
LABFIXOHDCOSTI_6	Lab Fix Ohd Cost[6]	Currency	10	View
LABFIXOHDCOSTI_7	Lab Fix Ohd Cost[7]	Currency	10	View
LABFIXOHDCOSTI_8	Lab Fix Ohd Cost[8]	Currency	10	View
LABFIXOHDCOSTEFFDTI_1	Lab Fix Ohd Cost Eff Date[1]	Date	4	View
LABFIXOHDCOSTEFFDTI_2	Lab Fix Ohd Cost Eff Date[2]	Date	4	View
LABFIXOHDCOSTEFFDTI_3	Lab Fix Ohd Cost Eff Date[3]	Date	4	View
LABFIXOHDCOSTEFFDTI_4	Lab Fix Ohd Cost Eff Date[4]	Date	4	View
LABFIXOHDCOSTEFFDTI_5	Lab Fix Ohd Cost Eff Date[5]	Date	4	View
LABFIXOHDCOSTEFFDTI_6	Lab Fix Ohd Cost Eff Date[6]	Date	4	View
NO_CALC_LAB_FIX_OHD	NO_CALC_LAB_FIX_OHD	Boolean	2	View
LABVAROHDCOSTI_1	Lab Var Ohd Cost[1]	Currency	10	View
LABVAROHDCOSTI_2	Lab Var Ohd Cost[2]	Currency	10	View
LABVAROHDCOSTI_3	Lab Var Ohd Cost[3]	Currency	10	View
LABVAROHDCOSTI_4	Lab Var Ohd Cost[4]	Currency	10	View
LABVAROHDCOSTI_5	Lab Var Ohd Cost[5]	Currency	10	View
LABVAROHDCOSTI_6	Lab Var Ohd Cost[6]	Currency	10	View
LABVAROHDCOSTI_7	Lab Var Ohd Cost[7]	Currency	10	View
LABVAROHDCOSTI_8	Lab Var Ohd Cost[8]	Currency	10	View
LABVAROHDCOSTEFFDTI_1	Lab Var Ohd Cost Eff Date[1]	Date	4	View
LABVAROHDCOSTEFFDTI_2	Lab Var Ohd Cost Eff Date[2]	Date	4	View
LABVAROHDCOSTEFFDTI_3	Lab Var Ohd Cost Eff Date[3]	Date	4	View
LABVAROHDCOSTEFFDTI_4	Lab Var Ohd Cost Eff Date[4]	Date	4	View
LABVAROHDCOSTEFFDTI_5	Lab Var Ohd Cost Eff Date[5]	Date	4	View
LABVAROHDCOSTEFFDTI_6	Lab Var Ohd Cost Eff Date[6]	Date	4	View
NO_CALC_LAB_VAR_OHD	NO_CALC_LAB_VAR_OHD	Boolean	2	View
MACHCOSTI_1	Mach Cost[1]	Currency	10	View
MACHCOSTI_2	Mach Cost[2]	Currency	10	View
MACHCOSTI_3	Mach Cost[3]	Currency	10	View
MACHCOSTI_4	Mach Cost[4]	Currency	10	View
MACHCOSTI_5	Mach Cost[5]	Currency	10	View
MACHCOSTI_6	Mach Cost[6]	Currency	10	View
MACHCOSTI_7	Mach Cost[7]	Currency	10	View
MACHCOSTI_8	Mach Cost[8]	Currency	10	View
MACHCOSTEFFDTI_1	Mach Cost Eff Date[1]	Date	4	View
MACHCOSTEFFDTI_2	Mach Cost Eff Date[2]	Date	4	View
MACHCOSTEFFDTI_3	Mach Cost Eff Date[3]	Date	4	View
MACHCOSTEFFDTI_4	Mach Cost Eff Date[4]	Date	4	View
MACHCOSTEFFDTI_5	Mach Cost Eff Date[5]	Date	4	View
MACHCOSTEFFDTI_6	Mach Cost Eff Date[6]	Date	4	View
NO_CALC_MACH	NO_CALC_MACH	Boolean	2	View
MACHFIXOHDCOSTI_1	Mach Fix Ohd Cost[1]	Currency	10	View
MACHFIXOHDCOSTI_2	Mach Fix Ohd Cost[2]	Currency	10	View
MACHFIXOHDCOSTI_3	Mach Fix Ohd Cost[3]	Currency	10	View
MACHFIXOHDCOSTI_4	Mach Fix Ohd Cost[4]	Currency	10	View
MACHFIXOHDCOSTI_5	Mach Fix Ohd Cost[5]	Currency	10	View
MACHFIXOHDCOSTI_6	Mach Fix Ohd Cost[6]	Currency	10	View
MACHFIXOHDCOSTI_7	Mach Fix Ohd Cost[7]	Currency	10	View
MACHFIXOHDCOSTI_8	Mach Fix Ohd Cost[8]	Currency	10	View
MACHFIXOHDCOSTEFFDTI_1	Mach Fix Ohd Cost Eff Date[1]	Date	4	View
MACHFIXOHDCOSTEFFDTI_2	Mach Fix Ohd Cost Eff Date[2]	Date	4	View
MACHFIXOHDCOSTEFFDTI_3	Mach Fix Ohd Cost Eff Date[3]	Date	4	View
MACHFIXOHDCOSTEFFDTI_4	Mach Fix Ohd Cost Eff Date[4]	Date	4	View
MACHFIXOHDCOSTEFFDTI_5	Mach Fix Ohd Cost Eff Date[5]	Date	4	View
MACHFIXOHDCOSTEFFDTI_6	Mach Fix Ohd Cost Eff Date[6]	Date	4	View
NO_CALC_MACH_FIX_OHD	NO_CALC_MACH_FIX_OHD	Boolean	2	View
MACHVAROHDCOSTI_1	Mach Var Ohd Cost[1]	Currency	10	View
MACHVAROHDCOSTI_2	Mach Var Ohd Cost[2]	Currency	10	View
MACHVAROHDCOSTI_3	Mach Var Ohd Cost[3]	Currency	10	View
MACHVAROHDCOSTI_4	Mach Var Ohd Cost[4]	Currency	10	View
MACHVAROHDCOSTI_5	Mach Var Ohd Cost[5]	Currency	10	View
MACHVAROHDCOSTI_6	Mach Var Ohd Cost[6]	Currency	10	View
MACHVAROHDCOSTI_7	Mach Var Ohd Cost[7]	Currency	10	View
MACHVAROHDCOSTI_8	Mach Var Ohd Cost[8]	Currency	10	View
MACHVAROHDCOSTEFFDTI_1	Mach Var Ohd Cost Eff Date[1]	Date	4	View
MACHVAROHDCOSTEFFDTI_2	Mach Var Ohd Cost Eff Date[2]	Date	4	View
MACHVAROHDCOSTEFFDTI_3	Mach Var Ohd Cost Eff Date[3]	Date	4	View
MACHVAROHDCOSTEFFDTI_4	Mach Var Ohd Cost Eff Date[4]	Date	4	View
MACHVAROHDCOSTEFFDTI_5	Mach Var Ohd Cost Eff Date[5]	Date	4	View
MACHVAROHDCOSTEFFDTI_6	Mach Var Ohd Cost Eff Date[6]	Date	4	View
NO_CALC_MACH_VAR_OHD	NO_CALC_MACH_VAR_OHD	Boolean	2	View
TOTALCOSTI_1	Total Cost[1]	Currency	10	View
TOTALCOSTI_2	Total Cost[2]	Currency	10	View
TOTALCOSTI_3	Total Cost[3]	Currency	10	View
TOTALCOSTI_4	Total Cost[4]	Currency	10	View
TOTALCOSTI_5	Total Cost[5]	Currency	10	View
TOTALCOSTI_6	Total Cost[6]	Currency	10	View
TOTALCOSTI_7	Total Cost[7]	Currency	10	View
TOTALCOSTI_8	Total Cost[8]	Currency	10	View
BTDT_I	BTDT	Boolean	2	View
DONT_ROLLUP_WU	Dont_Rollup_WU	Boolean	2	View
MAT_SET_TO_ZERO	Mat_Set_To_Zero	Boolean	2	View
MAT_FIXED_SET_TO_ZERO	Mat_Fixed_Set_To_Zero	Boolean	2	View
MAT_VAR_SET_TO_ZERO	Mat_Var_Set_To_Zero	Boolean	2	View

ICIV0323 - IC_IV_STANDARD

Query Builder

Customer Service

Information

My Account

Contact Us