CP010100 - CRP Line Item | Prospr - Dynamics GP Table Reference

CP010100 - CRP Line Item

Query Builder

Select * from CP010100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
ISMRP	IsMRP	Boolean	2	View
ROUTINGNAME_I	RoutingName	String	32	View
MRPAMOUNT_I	MRP_Amount	Currency	10	View
MRPISSUETIME_I	MRP_Issue Time	Time	4	View
WCID_I	WC ID	String	12	View
MACHINEID_I	Machine ID IC	String	12	View
RTSEQNUM_I	rtseqnum	String	12	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
MACHINETIME_I	MachineTime	Currency	10	View
RUNTIME_I	RunTime	Currency	10	View
LABORTIME_I	LaborTime	Currency	10	View
QUEUETIME_I	QueueTime	Currency	10	View
SETUPTIME_I	SetupTime	Currency	10	View
ALTERNATEWC_I	Alternate WC	Boolean	2	View
OVERTIMEREQUIRED_I	Overtime Required	Boolean	2	View
SKIPDAYREQUIRED_I	Skip Day Required	Boolean	2	View
CRPALLOCATED_I	CRP_allocated	Boolean	2	View