Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module PM tables > PM00300

DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change

COMPANY..PM00300 Table Definition

(COMPANY..PM Address MSTR)
The PM Address Master holds the Primary Address ID as well as additional addresses for the Vendor.  The Primary Address ID (and any additional ID’s) from the Vendor Card must exist in this table
4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
ADRSCODE char(15)
''
Address Co...(more) Join Now
VNDCNTCT char(61)
''
Vendor Con...(more) Join Now
ADDRESS1 char(61)
''
Address 1:...(more) Join Now
ADDRESS2 char(61)
''
Address 2:...(more) Join Now
ADDRESS3 char(61)
''
Address 3:...(more) Join Now
CITY char(35)
''
City:...(more) Join Now
STATE char(29)
''
State: 4 ...(more) Join Now
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
COUNTRY char(61)
''
Country:...(more) Join Now
UPSZONE char(3)
''
UPS Zone:...(more) Join Now
PHNUMBR1 char(21)
''
Phone 1: ...(more) Join Now
PHNUMBR2 char(21)
''
Phone 2: ...(more) Join Now
PHONE3 char(21)
''
Phone 3: 3...(more) Join Now
FAXNUMBR char(21)
''
Fax Number...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
EmailPOs tinyint
0
Email PO’s...(more) Join Now
POEmailRecipient char(81)
''
PO Email R...(more) Join Now
EmailPOFormat smallint
0
Email PO F...(more) Join Now
FaxPOs tinyint
0
Fax PO’s: ...(more) Join Now
POFaxNumber char(21)
''
PO Fax Num...(more) Join Now
FaxPOFormat smallint
0
Fax PO For...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
DECLID char(15)
''
Declarant ...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables