ICJC_MDataCollection_Link (ICJC5001)

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

Display Name: ICJC_MDataCollection_Link
Physical Name: ICJC5001
Technical Name: ICJC_MDataCollection_Link

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
2	SEQ_I	Seq	Long Integer	LINT_10	10
3	RTSEQNUM_I	rtseqnum	String	STR10	10
4	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['ICJC_MDataCollection_Link'].ITEMNMBR AS 'ICJC_MDataCollection_Link-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ICJC5001 AS ['ICJC_MDataCollection_Link'] INNER JOIN IV00101 AS ['Item Master'] ON ['ICJC_MDataCollection_Link'].ITEMNMBR = ['Item Master'].ITEMNMBR
5	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ICJC_MDataCollection_Link'].USERID AS 'ICJC_MDataCollection_Link-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ICJC5001 AS ['ICJC_MDataCollection_Link'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ICJC_MDataCollection_Link'].USERID = ['Users Master'].USERID
6	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10