GP Tables

PM00300 - PM Address MSTR

Dynamics GP table PM00300 (PM Address MSTR) contains 25 columns including VENDORID, ADRSCODE, VNDCNTCT....

SQL Query Builder

25 Columns

Column Description Type Length
VENDORID Vendor ID String 16
ADRSCODE Address Code String 16
VNDCNTCT Vendor Contact String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
COUNTRY Country String 62
UPSZONE UPS Zone String 4
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
PHONE3 Phone 3 String 22
FAXNUMBR Fax Number String 22
SHIPMTHD Shipping Method String 16
TAXSCHID Tax Schedule ID String 16
EmailPOs Email Purchase Orders Boolean 2
POEmailRecipient Purchase Order Email Recipient String 82
EmailPOFormat Email PO Format Integer 2
FaxPOs Fax Purchase Orders Boolean 2
POFaxNumber Purchase Order Fax Number String 22
FaxPOFormat Fax PO Format Integer 2
CCode Country Code String 8
DECLID Declarant ID String 16

Related Tables

Tables that share columns with PM00300. Click "Join" to add to your query.