PM Address MSTR (PM00300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00300

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Address MSTR
Physical Name: PM00300
Technical Name: PM_Address_MSTR

Group Display Name: Payables Vendor Master Logical File
Group Technical Name: PM_Vendor_Master_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PM Address MSTR'].VENDORID AS 'PM Address MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Address MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
Partial key to the Address Electronic Funds Transfer Master (SY06000).

Click to show/hide

SELECT
       ['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
       ,['Address Electronic Funds Transfer Master'].ADRSCODE AS 'Address Electronic Funds Transfer Master-Address Code'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       SY06000 AS ['Address Electronic Funds Transfer Master']
              ON
                     ['PM Address MSTR'].ADRSCODE = ['Address Electronic Funds Transfer Master'].ADRSCODE
              AND
                     ['PM Address MSTR'].VENDORID = ['Address Electronic Funds Transfer Master'].VENDORID
              AND
                     ['Address Electronic Funds Transfer Master'].SERIES = 4
Partial key to the Internet Addresses (SY01200).

Click to show/hide

SELECT
       ['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
       ,['Internet Addresses'].ADRSCODE AS 'Internet Addresses-Address Code'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       SY01200 AS ['Internet Addresses']
              ON
                     ['PM Address MSTR'].ADRSCODE = ['Internet Addresses'].ADRSCODE
              AND
                     ['PM Address MSTR'].VENDORID = ['Internet Addresses'].Master_ID
              AND
                     ['Internet Addresses'].Master_Type = 'VEN'
3VNDCNTCT SearchVendor ContactSTR60String6260
4ADDRESS1 SearchAddress 1STR60String6260
5ADDRESS2 SearchAddress 2STR60String6260
6ADDRESS3 SearchAddress 3STR60String6260
7CITY SearchCitySTR35String3635
8STATE SearchStateSTR30_StateString3029
9ZIPCODE SearchZip CodeSTR10String1210
10COUNTRY SearchCountrySTR60String6260
11UPSZONE SearchUPS ZoneSTR3String43
12PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
13PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
14PHONE3 SearchPhone 3Phone_Number3String2214
15FAXNUMBR SearchFax NumberSTR14_FAXString2214
16SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PM Address MSTR'].SHIPMTHD AS 'PM Address MSTR-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PM Address MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
17TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Address MSTR'].TAXSCHID AS 'PM Address MSTR-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Address MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
18EmailPOs SearchEmail Purchase OrdersCB_EmailPurchaseOrdersBoolean20
19POEmailRecipient SearchPurchase Order Email RecipientSTR80String8280
20EmailPOFormat SearchEmail PO FormatDDL_PO_DocDeliveryFormatInteger20
21FaxPOs SearchFax Purchase OrdersCB_FaxPurchaseOrdersBoolean20
22POFaxNumber SearchPurchase Order Fax NumberSTR14_FAXString2214
23FaxPOFormat SearchFax PO FormatDDL_PO_DocDeliveryFormatInteger20
24CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['PM Address MSTR'].CCode AS 'PM Address MSTR-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['PM Address MSTR'].CCode = ['VAT Country Code MSTR'].CCode
25DECLID SearchDeclarant IDSTR15_Address_CodeString1615
26DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
27DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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