Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP50200
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Sales Document Header Temp
Physical Name: SOP50200
Technical Name: SOP_Document_HDR_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type Integer DDL_Document_Type 0 2 SOPTYPE SOP Type Integer DDL_SOP_Type 0 3 SOPNUMBE SOP Number String STR20_SOP_Number 17 4 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Sales Document Header Temp'].LOCNCODE AS 'Sales Document Header Temp-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SOP50200 AS ['Sales Document Header Temp']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Sales Document Header Temp'].LOCNCODE = ['Site Setup'].LOCNCODE5 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Sales Document Header Temp'].CUSTNMBR AS 'Sales Document Header Temp-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SOP50200 AS ['Sales Document Header Temp']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Sales Document Header Temp'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR6 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Sales Document Header Temp'].USERID AS 'Sales Document Header Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SOP50200 AS ['Sales Document Header Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales Document Header Temp'].USERID = ['Users Master'].USERID7 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 8 DOCPRINTSEQ Document Print Sequence Long Integer long 8 9 ShipToName ShipToName String STR64_Customer_Name 64 10 CNTCPRSN Contact Person String STR60 60 11 ADDRESS1 Address 1 String STR60 60 12 ADDRESS2 Address 2 String STR60 60 13 ADDRESS3 Address 3 String STR60 60 14 CITY City String STR35 35 15 STATE State String STR30_State 29 16 ZIPCODE Zip Code String STR10 10 17 COUNTRY Country String STR60 60 18 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['Sales Document Header Temp'].SHIPMTHD AS 'Sales Document Header Temp-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
SOP50200 AS ['Sales Document Header Temp']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Sales Document Header Temp'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD19 Reprint Reprint Boolean CB 0 20 Email_Type Email Type Integer INT 0 21 PHONNAME Phone Number String Phone_Number 14