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 > PM00200

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

(COMPANY..PM Vendor Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID:...(more) Join Now
VENDNAME char(65)
''
Vendor Nam...(more) Join Now
VNDCHKNM char(65)
''
Vendor Che...(more) Join Now
VENDSHNM char(15)
''
Vendor Sho...(more) Join Now
VADDCDPR char(15)
''
Vendor Add...(more) Join Now
VADCDPAD char(15)
''
Vendor Add...(more) Join Now
VADCDSFR char(15)
''
Vendor Add...(more) Join Now
VADCDTRO char(15)
''
Vendor Add...(more) Join Now
VNDCLSID char(11)
''
Vendor Cla...(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
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
UPSZONE char(3)
''
UPS Zone:...(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
ACNMVNDR char(21)
''
Account Nu...(more) Join Now
TXIDNMBR char(11)
''
Tax ID Num...(more) Join Now
VENDSTTS smallint
0
Vendor Sta...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now
PARVENID char(15)
''
Parent Ven...(more) Join Now
TRDDISCT smallint
0
Trade Disc...(more) Join Now
TEN99TYPE smallint
0
1099 Type:...(more) Join Now
TEN99BOXNUMBER smallint
0
1099 Box N...(more) Join Now
MINORDER numeric(19,5)
0.00
Minimum Or...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
MINPYTYP smallint
0
Minimum ...(more) Join Now
MINPYPCT smallint
0
Minimum Pa...(more) Join Now
MINPYDLR numeric(19,5)
0.00
Minimum Pa...(more) Join Now
MXIAFVND smallint
0
Maximum In...(more) Join Now
MAXINDLR numeric(19,5)
0.00
Maximum In...(more) Join Now
COMMENT1 char(31)
''
Comment 1:...(more) Join Now
COMMENT2 char(31)
''
Comment 2:...(more) Join Now
USERDEF1 char(21)
''
UserDefine...(more) Join Now
USERDEF2 char(21)
''
UserDefine...(more) Join Now
CRLMTDLR numeric(19,5)
0.00
Credit Lim...(more) Join Now
PYMNTPRI char(3)
''
Payment Pr...(more) Join Now
KPCALHST tinyint
0
Keep Calen...(more) Join Now
KGLDSTHS tinyint
0
Keep GL Di...(more) Join Now
KPERHIST tinyint
0
Keep Perio...(more) Join Now
KPTRXHST tinyint
0
Keep Trx H...(more) Join Now
HOLD tinyint
0
Hold: 1 i...(more) Join Now
PTCSHACF smallint
0
Post To Ca...(more) Join Now
CREDTLMT smallint
0
Credit Lim...(more) Join Now
WRITEOFF smallint
0
Writeoff: ...(more) Join Now
MXWOFAMT numeric(19,5)
0.00
Maximum Wr...(more) Join Now
SBPPSDED tinyint
0
Subject to...(more) Join Now
PPSTAXRT smallint
0
PPS Tax Ra...(more) Join Now
DXVARNUM char(25)
''
Deduction ...(more) Join Now
CRTCOMDT datetime
'1/1/1900'
Certificat...(more) Join Now
CRTEXPDT datetime
'1/1/1900'
Certificat...(more) Join Now
RTOBUTKN tinyint
0
Reporting ...(more) Join Now
XPDTOBLG tinyint
0
Expiration...(more) Join Now
PRSPAYEE tinyint
0
Prescribed...(more) Join Now
PMAPINDX int
0
PM AP Inde...(more) Join Now
PMCSHIDX int
0
PM Cash In...(more) Join Now
PMDAVIDX int
0
PM Discoun...(more) Join Now
PMDTKIDX int
0
PM Discoun...(more) Join Now
PMFINIDX int
0
PM Finance...(more) Join Now
PMMSCHIX int
0
PM Misc Ch...(more) Join Now
PMFRTIDX int
0
PM Freight...(more) Join Now
PMTAXIDX int
0
PM Tax Ind...(more) Join Now
PMWRTIDX int
0
PM Writeof...(more) Join Now
PMPRCHIX int
0
PM Purchas...(more) Join Now
PMRTNGIX int
0
PM Retaina...(more) Join Now
PMTDSCIX int
0
PM Trade ...(more) Join Now
ACPURIDX int
0
Accrued Pu...(more) Join Now
PURPVIDX int
0
Purchase P...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
RATETPID char(15)
''
Rate Type ...(more) Join Now
Revalue_Vendor tinyint
0
Revalue Ve...(more) Join Now
Post_Results_To smallint
0
Post Resul...(more) Join Now
FREEONBOARD smallint
0
Free On Bo...(more) Join Now
GOVCRPID char(31)
''
Government...(more) Join Now
GOVINDID char(31)
''
Government...(more) Join Now
DISGRPER smallint
0
Discount G...(more) Join Now
DUEGRPER smallint
0
Due Date G...(more) Join Now
DOCFMTID char(15)
''
Document F...(more) Join Now
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now
USERLANG smallint
0
User Langu...(more) Join Now
WithholdingType smallint
0
Withholdin...(more) Join Now
WithholdingFormType smallint
0
Withholdin...(more) Join Now
WithholdingEntityType smallint
0
Withholdin...(more) Join Now
TaxFileNumMode smallint
0
Tax File N...(more) Join Now
BRTHDATE datetime
'1/1/1900'
Birth Date...(more) Join Now
LaborPmtType smallint
0
Labor Paym...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
DECLID char(15)
''
Declarant ...(more) Join Now
CBVAT tinyint
0
Cash Based...(more) Join Now
Workflow_Approval_Status smallint
0
Workflow A...(more) Join Now
Workflow_Priority smallint
0
Workflow P...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
Workflow_Status smallint
0

VADCD1099 char
''

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