EC050031 - ECM_Item_LINE | Prospr - Dynamics GP Table Reference

EC050031 - ECM_Item_LINE

Query Builder

Select * from EC050031

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ECNumber	ECNumber	String	16	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
Disposition_Code	Disposition Code	String	12	View
ECM_Item_Number	ECM Item Number	String	32	View
ITEMNMBR	Item Number	String	32	View
PPN_I	PPN	String	32	View
CPN_I	CPN	String	32	View
MANUFACTUREORDER_I	Manufacture Order	String	32	View
SALESORDERNUMBER_I	Sales Order Number	String	18	View
SOPNUMBE	SOP Number	String	22	View
PORDNMBR	Purchase Order Number	String	22	View
SEQNUMBR	Sequence Number	Long Integer	4	View
RCRDTYPE	Record Type	Integer	2	View
ECM_Short_Description	ECM_Short_Description	String	52	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
DISPOSITIONNOTES_I	Disposition Notes	Text	2	View