DynDeveloper.com

DynDeveloper.com

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

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..PM09300 Table Definition

(COMPANY..)

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 2010
join PM00200 on PM00200.VENDORID = PM09300.VENDORID
ADRSCODEchar(15) Address Co...(more) Join Now RM20101.ADRSCODE
GP 2010
VNDCNTCTchar(31) Vendor Con...(more) Join Now PM00200.VNDCNTCT
GP 2010
ADDRESS1char(31) Address 1:...(more) Join Now RM00101.ADDRESS1
GP 2010
ADDRESS2char(31) Address 2:...(more) Join Now RM00101.ADDRESS2
GP 2010
ADDRESS3char(31) Address 3:...(more) Join Now RM00101.ADDRESS3
GP 2010
CITYchar(31) City: City...(more) Join Now RM00101.CITY
GP 2010
STATEchar(29) State: Up...(more) Join Now RM00101.STATE
GP 2010
ZIPCODEchar(11) Zip Code: ...(more) Join Now SOP10100.ZIPCODE
GP 2010
COUNTRYchar(21) Country: C...(more) Join Now RM00101.COUNTRY
GP 2010
UPSZONEchar(3) UPS Zone: ...(more) Join Now RM00101.UPSZONE
GP 2010
PHNUMBR1char(21) Phone Numb...(more) Join Now SOP10100.PHNUMBR1
GP 2010
PHNUMBR2char(21) Phone Numb...(more) Join Now SOP10100.PHNUMBR2
GP 2010
PHONE3char(21) Phone 3: ...(more) Join Now RM00101.PHONE3
GP 2010
FAXNUMBRchar(21) Fax Number...(more) Join Now SOP10100.FAXNUMBR
GP 2010
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 2010
join SY03000 on SY03000.SHIPMTHD = PM09300.SHIPMTHD
TAXSCHIDchar(15) Tax Schedu...(more) Join Now PM10000.TAXSCHID
GP 2010
join TX00101 on TX00101.TAXSCHID = PM09300.TAXSCHID
Imported_Datedatetime
GP 2010
Imported_Timedatetime
GP 2010
Migratedtinyint
GP 2010
Migrated_Datedatetime
GP 2010
Migrated_Timedatetime
GP 2010
ERRDESCRchar(131) PAMELOG.ERRDESCR
GP 2010
DEX_ROW_IDint Unique aut...(more) Join Now
GP 2010