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

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

(COMPANY..PM Class Master File)
This file holds all the vendor class setup information.  The primary purpose of a class is make changes to all vendors in a class quickly.  The information in the PM Class Master is so similar to the PM Vendor Master that it is not repeated here.  The 2 fields that are different are documented below. In SBF, this table is not available.

4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
VNDCLSID char(11)
''
Vendor Cla...(more) Join Now
VNDCLDSC char(31)
''
Vendor Cla...(more) Join Now
DEFLTCLS tinyint
0
Default Cl...(more) Join Now
MXIAFVND smallint
0
Maximum In...(more) Join Now PM00200.MXIAFVND
MXINVAMT numeric(19,5)
0.00

WRITEOFF smallint
0
Writeoff: ...(more) Join Now PM00200.WRITEOFF
CREDTLMT smallint
0
Credit Lim...(more) Join Now PM00200.CREDTLMT
TEN99TYPE smallint
0
1099 Type:...(more) Join Now
PTCSHACF smallint
0
Post To Ca...(more) Join Now PM00200.PTCSHACF
MXWOFAMT numeric(19,5)
0.00
Maximum Wr...(more) Join Now
MINORDER numeric(19,5)
0.00
Minimum Or...(more) Join Now
CRLMTDLR numeric(19,5)
0.00
Credit Lim...(more) Join Now
PYMNTPRI char(3)
''
Payment Pr...(more) Join Now PM00200.PYMNTPRI
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
PYMTRMID char(21)
''
Payment Te...(more) Join Now PM10000.PYMTRMID
SY033... more text available
MINPYTYP smallint
0
Minimum ...(more) Join Now RM00101.MINPYTYP
MINPYDLR numeric(19,5)
0.00
Minimum Pa...(more) Join Now
MINPYPCT smallint
0
Finance Ch...(more) Join Now RM00101.MINPYPCT
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
KPCALHST tinyint
0
Keep Calen...(more) Join Now RM00101.KPCALHST
KGLDSTHS tinyint
0
Keep GL Di...(more) Join Now PM00200.KGLDSTHS
KPERHIST tinyint
0
Keep Perio...(more) Join Now RM00101.KPERHIST
KPTRXHST tinyint
0
Keep Trx H...(more) Join Now RM00101.KPTRXHST
TRDDISCT smallint
0
Trade Disc...(more) Join Now RM10301.TRDDISCT
USERDEF1 char(21)
''
UserDefine...(more) Join Now
USERDEF2 char(21)
''
UserDefine...(more) Join Now
PMAPINDX int
0
PM AP Inde...(more) Join Now PM00200.PMAPINDX
PMCSHIDX int
0
PM Cash In...(more) Join Now PM00200.PMCSHIDX
PMDAVIDX int
0
PM Discoun...(more) Join Now PM00200.PMDAVIDX
PMDTKIDX int
0
PM Discoun...(more) Join Now PM00200.PMDTKIDX
PMFINIDX int
0
PM Finance...(more) Join Now PM00200.PMFINIDX
PMMSCHIX int
0
PM Misc Ch...(more) Join Now PM00200.PMMSCHIX
PMFRTIDX int
0
PM Freight...(more) Join Now PM00200.PMFRTIDX
PMTAXIDX int
0
PM Tax Ind...(more) Join Now PM00200.PMTAXIDX
PMWRTIDX int
0
PM Writeof...(more) Join Now PM00200.PMWRTIDX
PMPRCHIX int
0
PM Purchas...(more) Join Now PM00200.PMPRCHIX
PMRTNGIX int
0
PM Retaina...(more) Join Now PM00200.PMRTNGIX
PMTDSCIX int
0
PM Trade ...(more) Join Now PM00200.PMTDSCIX
ACPURIDX int
0
Accrued Pu...(more) Join Now PM00200.ACPURIDX
PURPVIDX int
0
Purchase P...(more) Join Now IV00101.PURPVIDX
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 RM00101.CREATDDT
RATETPID char(15)
''
A valid Ra...(more) Join Now
Revalue_Vendor tinyint
0
Revalue Ve...(more) Join Now PM00200.Revalue_Vendor
Post_Results_To smallint
0
Post Resul...(more) Join Now RM00101.Post_Results_To
FREEONBOARD smallint
0
Free On Bo...(more) Join Now IV00103.FREEONBOARD
DISGRPER smallint
0
Discount G...(more) Join Now RM10301.DISGRPER
DUEGRPER smallint
0
Due Date G...(more) Join Now RM10301.DUEGRPER
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now POP10300.TaxInvRecvd
CBVAT tinyint
0
Cash Based...(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