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 TypeLength
1VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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 CodeStringSTR15_Address_Code15
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 ContactStringSTR6060
4ADDRESS1 SearchAddress 1StringSTR6060
5ADDRESS2 SearchAddress 2StringSTR6060
6ADDRESS3 SearchAddress 3StringSTR6060
7CITY SearchCityStringSTR3535
8STATE SearchStateStringSTR30_State29
9ZIPCODE SearchZip CodeStringSTR1010
10COUNTRY SearchCountryStringSTR6060
11UPSZONE SearchUPS ZoneStringSTR33
12PHNUMBR1 SearchPhone Number 1StringPhone_Number14
13PHNUMBR2 SearchPhone Number 2StringPhone_Number14
14PHONE3 SearchPhone 3StringPhone_Number314
15FAXNUMBR SearchFax NumberStringSTR14_FAX14
16SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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 IDStringSTR15_Tax_Schedule_ID15
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 OrdersBooleanCB_EmailPurchaseOrders0
19POEmailRecipient SearchPurchase Order Email RecipientStringSTR8080
20EmailPOFormat SearchEmail PO FormatIntegerDDL_PO_DocDeliveryFormat0
21FaxPOs SearchFax Purchase OrdersBooleanCB_FaxPurchaseOrders0
22POFaxNumber SearchPurchase Order Fax NumberStringSTR14_FAX14
23FaxPOFormat SearchFax PO FormatIntegerDDL_PO_DocDeliveryFormat0
24CCode SearchCountry CodeStringSTR6_VAT6
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 IDStringSTR15_Address_Code15

Leave a Reply

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