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.