MM010032 - Machine Master | Prospr - Dynamics GP Table Reference

MM010032 - Machine Master

Query Builder

Select * from MM010032

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MACHINEID_I	Machine ID IC	String	12	View
MACHINEDESC_I	Machine Desc	String	32	View
SERLNMBR	Serial Number	String	22	View
VENDORID	Vendor ID	String	16	View
DATEMACHINEINSTALL_I	Date, Machine Installation	Date	4	View
YEAR1	Year	Integer	2	View
WARRANTY_I	Warranty	Boolean	2	View
WARRANTYTIME_I	Warranty Time	String	10	View
LENGTHOFWARRANTY_I	Length of Warranty	Integer	2	View
DEPRECIATIONCOST_I	Depreciation Cost	Currency	10	View
DEPRECIATIONCOSTUN_I	Depreciation Cost Unit	Integer	2	View
LOCATNID	Location ID	String	16	View
MAINTENANCEDATE_I	Maintenance Date	Date	4	View
Maintenance_Procedure_Na	Maintenance Procedure Name	String	22	View
OPERATIONCOUNT_I	Operation Count	Long Integer	4	View
TOTALOPERATIONCOUN_I	Total Operation Count	Long Integer	4	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
MFGNOTEINDEX2_I	MFG Note Index2	Currency	10	View
Mach_Mach_Applied_Acct	Mach Mach Applied Account	Long Integer	4	View
Mach_Fixed_Ohd_Acct	Mach Fixed Overhead Account	Long Integer	4	View
Mach_Variable_Ohd_Acct	Mach Variable Overhead Account	Long Integer	4	View
COST_I	Cost	Currency	10	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
COSTPERPIECE_I	Cost Per Piece	Currency	10	View
EFFECTIVEDATE2_I	Effective Date2	Date	4	View
FIXAMTORPCT_I	Fixed Amount or Percent	Integer	2	View
Fixed_Overhead_Amount	Fixed Overhead Amount	Currency	10	View
FIXOHDPCT_I	Fixed Overhead Percent	Long Integer	4	View
FIXHRPC_I	Fixed Hour Piece	Integer	2	View
FIXOHDEFFDATE_I	Fixed Overhead Effective Date	Date	4	View
VARAMTORPCT_I	Variable Amount or Percent	Integer	2	View
Variable_Overhead_Amount	Variable Overhead Amount	Currency	10	View
VAROHDPCT_I	Variable Overhead Percent	Long Integer	4	View
VARHRPC_I	Variable Hour Piece	Integer	2	View
VAROHDEFFDATE_I	Variable Overhead Effective Date	Date	4	View
PENDINGCOST_I	Pending Cost	Currency	10	View
PENDEFFDATE_I	Pending Effective Date	Date	4	View
PENDCOSTPERPIECE_I	Pending Cost Per Piece	Currency	10	View
PENDEFFDATE2_I	Pending Effective Date2	Date	4	View
PENDFIXAMTORPCT_I	Pending Fixed Amount or Percent	Integer	2	View
PENDFIXOHDAMT_I	Pending Fixed Overhead Amount	Currency	10	View
PENDFIXOHDPCT_I	Pending Fixed Overhead Percent	Long Integer	4	View
PENDFIXHRPC_I	Pending Fixed Hour Piece	Integer	2	View
PENDFIXOHDEFFDATE_I	Pending Fixed Overhead Effective Date	Date	4	View
PENDVARAMTORPCT_I	Pending Variable Amount or Percent	Integer	2	View
PENDVAROHDAMT_I	Pending Variable Overhead Amount	Currency	10	View
PENDVAROHDPCT_I	Pending Variable Overhead Percent	Long Integer	4	View
PENDVARHRPC_I	Pending Variable Hour Piece	Integer	2	View
PENDVAROHDEFFDATE_I	Pending Variable Overhead Effective Date	Date	4	View

MM010032 - Machine Master

Query Builder

Customer Service

Information

My Account

Contact Us