Sales Document Header Temp (SOP50200)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Document Header Temp (SOP50200)

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_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
2SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
3SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
4LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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'].LOCNCODE
5CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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'].CUSTNMBR
6USERID SearchUser IDSTR15_User_IDString15
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'].USERID
7SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
8DOCPRINTSEQ SearchDocument Print SequencelongLong Integer8
9ShipToName SearchShipToNameSTR64_Customer_NameString64
10CNTCPRSN SearchContact PersonSTR60String60
11ADDRESS1 SearchAddress 1STR60String60
12ADDRESS2 SearchAddress 2STR60String60
13ADDRESS3 SearchAddress 3STR60String60
14CITY SearchCitySTR35String35
15STATE SearchStateSTR30_StateString29
16ZIPCODE SearchZip CodeSTR10String10
17COUNTRY SearchCountrySTR60String60
18SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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'].SHIPMTHD
19Reprint SearchReprintCBBoolean0
20Email_Type SearchEmail TypeINTInteger0
21PHONNAME SearchPhone NumberPhone_NumberString14
22DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Document Header Temp (SOP50200)

Leave a Reply

Your email address will not be published. Required fields are marked *