MOP_PickDoc_MSTR (MOP1200)

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

Display Name: MOP_PickDoc_MSTR
Physical Name: MOP1200
Technical Name: MOP_PickDoc_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PICKNUMBER	Pick Number	String	STR17_LBAU_Pick_Number	17
2	TRX_TYPE	TRX Type	Integer	DDL_TRX_Type_I	0
3	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['MOP_PickDoc_MSTR'].NOTEINDX AS 'MOP_PickDoc_MSTR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM MOP1200 AS ['MOP_PickDoc_MSTR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['MOP_PickDoc_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4	LSTPRTDT	Last Printed Date	Date	DATE_L	0
5	TIMESPRT	Times Printed	Integer	INT4_U0	4
6	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['MOP_PickDoc_MSTR'].USERID AS 'MOP_PickDoc_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MOP1200 AS ['MOP_PickDoc_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['MOP_PickDoc_MSTR'].USERID = ['Users Master'].USERID
7	CHANGEDATE_I	Change Date	Date	DT	8
8	DOCDATE	Document Date	Date	DT	8
9	POSTED	Posted	Boolean	True/False	0
10	POSTEDDT	Posted Date	Date	DATE	6
11	VOIDED	Voided	Boolean	CB	0
12	CALLEDBY	Called By	Integer	INT	0