Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP50500
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Sales Holds Processing
Physical Name: SOP50500
Technical Name: sopHoldsProcessingSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Sales Holds Processing'].USERID AS 'Sales Holds Processing-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SOP50500 AS ['Sales Holds Processing']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales Holds Processing'].USERID = ['Users Master'].USERID2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 PRCHLDID Process Hold ID String STR15_LBAU 15 4 Password_Required Password Required Boolean CB 0 5 PASSWORD Password String STR15_LB 15 6 DUMYPSWD Dummy Password String STR15_LB 15 7 Password_Valid Password Valid Integer INT 0 8 MKTOPROC Marked To Process Boolean CB 0