ECM_HIST (EC010131) – azurecurve

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EC010131

Display Name: ECM_HIST
Physical Name: EC010131
Technical Name: ECM_HIST

Group Display Name: Manufacturing ECM
Group Technical Name: Manufacturing ECM

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ECNumber	ECNumber	String	STR15	15
2	DSCRIPTN	Description	String	STR30	30
3	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['ECM_HIST'].ITEMNMBR AS 'ECM_HIST-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM EC010131 AS ['ECM_HIST'] INNER JOIN IV00101 AS ['Item Master'] ON ['ECM_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR
4	ITEMDESC	Item Description	String	STR100	100
5	DATEENTERED_I	Date Entered	Date	DT	8
6	STRTDATE	Start Date	Date	DT	8
7	ENDDATE	End Date	Date	DT	8
8	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ECM_HIST'].USERID AS 'ECM_HIST-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM EC010131 AS ['ECM_HIST'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ECM_HIST'].USERID = ['Users Master'].USERID
9	CHANGEBY_I	Change By	String	STR15_User_ID	15
10	CHANGEDATE_I	Change Date	Date	DT	8
11	ECOSTATUS_I	ECO_Status	Integer	DDL_ECO_Status	0
12	REVISIONLEVEL_I	Revision Level	String	STR50	50
13	DWGNUM_I	DWG #	String	STR30_Item_Number	30
14	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
15	EC_Routing_Name	EC_Routing_Name	String	STR15_LBAU	15
16	TIME1	Time	Time	TM6	6