CP010030 - Capacity Master File | Prospr - Dynamics GP Table Reference

CP010030 - Capacity Master File

Query Builder

Select * from CP010030

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
WCID_I	WC ID	String	12	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
AVAILABLEEMPHOURS_I	Available Emp Hours	Currency	10	View
PLANAVAILEMPHOURS_I	Planned Available Emp Hours	Currency	10	View
SCHEDULEDEMPHOURS_I	Scheduled Emp Hours	Currency	10	View
PLANSCHEDEMPHOURS_I	Planned Scheduled Emp Hours	Currency	10	View
AVAILABLEMACHHOURS_I	Available Mach Hours	Currency	10	View
PLANAVAILMACHHOURS_I	Planned Available Mach Hours	Currency	10	View
SCHEDULEDMACHHOURS_I	Scheduled Mach Hours	Currency	10	View
PLANSCHEDMACHRS_I	Planned Scheduled Mach Hours	Currency	10	View
PERCENTOFMAXEMP_I	Percent of Max Emp	Long Integer	4	View
PLANPEROFMAXEMP_I	Planned Percent of Max Emp	Long Integer	4	View
PERCENTOFMAXMACH_I	Percent of Max Mach	Long Integer	4	View
PLANPEROFMAXMACH_I	Planned Percent of Max Mach	Long Integer	4	View
EMPLOYEEOVERLOAD_I	Employee Overload	Boolean	2	View
PLANEMPOVERLOAD_I	Planned Employee Overload	Boolean	2	View
MACHINEOVERLOAD_I	Machine Overload	Boolean	2	View
PLANMACOVERLOAD_I	Planned Machine Overload	Boolean	2	View
PLNNDAVLBLEEMPHRSMRP	Planned Available Emp Hours MRP	Currency	10	View
PLNNDSCHDLDEMPHRSMRP	Planned Scheduled Emp Hours MRP	Currency	10	View
PLNNDAVLBLMACHHRSMRP	Planned Available Mach Hours MRP	Currency	10	View
PLNNDSCHDLDMACHHRSMRP	Planned Scheduled Mach Hours MRP	Currency	10	View
PLNNEDPRCNTMAXEMPMRP	Planned Percent of Max Emp MRP	Long Integer	4	View
PLNNDPRCNTMACMACHMRP	Planned Percent of Max Mach MRP	Long Integer	4	View
PLNNDEMPOVRLDMRP	Planned Employee Overload MRP	Boolean	2	View
PLNNDMACHOVRLDMRP	Planned Machine Overload MRP	Boolean	2	View

CP010030 - Capacity Master File

Query Builder

Customer Service

Information

My Account

Contact Us