Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP50300
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Sales Document Line Temp
Physical Name: SOP50300
Technical Name: sopDocumentLineTempSeq 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 Document Line Temp'].USERID AS 'Sales Document Line Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SOP50300 AS ['Sales Document Line Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales Document Line Temp'].USERID = ['Users Master'].USERID2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 SOPNUMBE SOP Number String STR20_SOP_Number 17 4 SOPTYPE SOP Type Integer DDL_SOP_Type 0 5 DOCTYPE Document Type Integer DDL_Document_Type 0 6 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Sales Document Line Temp'].LOCNCODE AS 'Sales Document Line Temp-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SOP50300 AS ['Sales Document Line Temp']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Sales Document Line Temp'].LOCNCODE = ['Site Setup'].LOCNCODE7 DOCPRINTSEQ Document Print Sequence Long Integer long 8 8 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10 9 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10