Manufacture Order Activity (MOP10213)

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

Display Name: Manufacture Order Activity
Physical Name: MOP10213
Technical Name: MOP_Order_Activity

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
2	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
3	MANUFACTUREORDERST_I	Manufacture Order Status	Integer	DDL_WO_Status	0
4	MO_ACTIVITY_REASON_I	MO Activity Reason	Integer	DDL_MO_Activity_Reason	0
5	IVDOCNBR	IV Document Number	String	STR17_IV_Document_Number	17
6	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
7	PICKNUMBER	Pick Number	String	STR17_LBAU_Pick_Number	17
8	RCPTNMBR	Receipt Number	String	STR20_Document_Number	20
9	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
10	CHANGEDATE_I	Change Date	Date	DT	8
11	TIME1	Time	Time	TM6	6
12	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Manufacture Order Activity'].USERID AS 'Manufacture Order Activity-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MOP10213 AS ['Manufacture Order Activity'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Manufacture Order Activity'].USERID = ['Users Master'].USERID