DynDeveloper.com

DynDeveloper.com

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

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and 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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM00300.VENDORID
ADRSCODEchar(15) Address Co...(more) Join Now
GP 9
VNDCNTCTchar(61) Vendor Con...(more) Join Now
GP 9
ADDRESS1char(61) Address 1:...(more) Join Now
GP 9
ADDRESS2char(61) Address 2:...(more) Join Now
GP 9
ADDRESS3char(61) Address 3:...(more) Join Now
GP 9
CITYchar(35) City:...(more) Join Now
GP 9
STATEchar(29) State: 4 ...(more) Join Now
GP 9
ZIPCODEchar(11) Zip Code: ...(more) Join Now
GP 9
COUNTRYchar(61) Country:...(more) Join Now
GP 9
UPSZONEchar(3) UPS Zone:...(more) Join Now
GP 9
PHNUMBR1char(21) Phone 1: ...(more) Join Now
GP 9
PHNUMBR2char(21) Phone 2: ...(more) Join Now
GP 9
PHONE3char(21) Phone 3: 3...(more) Join Now
GP 9
FAXNUMBRchar(21) Fax Number...(more) Join Now
GP 9
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 9
join SY03000 on SY03000.SHIPMTHD = PM00300.SHIPMTHD
TAXSCHIDchar(15) Tax Schedu...(more) Join Now
GP 9
join TX00101 on TX00101.TAXSCHID = PM00300.TAXSCHID
EmailPOstinyint Email PO’s...(more) Join Now
GP 9
POEmailRecipientchar(81) PO Email R...(more) Join Now
GP 9
EmailPOFormatsmallint Email PO F...(more) Join Now
GP 9
FaxPOstinyint Fax PO’s: ...(more) Join Now
GP 9
POFaxNumberchar(21) PO Fax Num...(more) Join Now
GP 9
FaxPOFormatsmallint Fax PO For...(more) Join Now
GP 9
CCodechar(7) Country Co...(more) Join Now
GP 9
DECLIDchar(15) Declarant ...(more) Join Now
GP 9
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9