Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1200
Product: Manufacturing (346)
Series:
Display Name: MOP_PickDoc_MSTR
Physical Name: MOP1200
Technical Name: MOP_PickDoc_MSTRSeq 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'].NOTEINDX4 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'].USERID7 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