DynDeveloper.com

DynDeveloper.com

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

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..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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
VNDCLSIDchar(11) Vendor Cla...(more) Join Now
GP 9
VNDCLDSCchar(31) Vendor Cla...(more) Join Now
GP 9
DEFLTCLStinyint Default Cl...(more) Join Now
GP 9
MXIAFVNDsmallint Maximum In...(more) Join Now PM00200.MXIAFVND
GP 9
MXINVAMTnumeric(19,5)
GP 9
WRITEOFFsmallint Writeoff: ...(more) Join Now PM00200.WRITEOFF
GP 9
CREDTLMTsmallint Credit Lim...(more) Join Now PM00200.CREDTLMT
GP 9
TEN99TYPEsmallint 1099 Type:...(more) Join Now
GP 9
PTCSHACFsmallint Post To Ca...(more) Join Now PM00200.PTCSHACF
GP 9
MXWOFAMTnumeric(19,5) Maximum Wr...(more) Join Now
GP 9
MINORDERnumeric(19,5) Minimum Or...(more) Join Now
GP 9
CRLMTDLRnumeric(19,5) Credit Lim...(more) Join Now
GP 9
PYMNTPRIchar(3) Payment Pr...(more) Join Now PM00200.PYMNTPRI
GP 9
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 9
join SY03000 on SY03000.SHIPMTHD = PM00100.SHIPMTHD
PYMTRMIDchar(21) Payment Te...(more) Join Now PM10000.PYMTRMID
GP 9
join SY03300 on SY03300.PYMTRMID = PM00100.PYMTRMID
MINPYTYPsmallint Minimum ...(more) Join Now RM00101.MINPYTYP
GP 9
MINPYDLRnumeric(19,5) Minimum Pa...(more) Join Now
GP 9
MINPYPCTsmallint Finance Ch...(more) Join Now RM00101.MINPYPCT
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM00100.CURNCYID
TAXSCHIDchar(15) Tax Schedu...(more) Join Now PM10000.TAXSCHID
GP 9
join TX00101 on TX00101.TAXSCHID = PM00100.TAXSCHID
KPCALHSTtinyint Keep Calen...(more) Join Now RM00101.KPCALHST
GP 9
KGLDSTHStinyint Keep GL Di...(more) Join Now PM00200.KGLDSTHS
GP 9
KPERHISTtinyint Keep Perio...(more) Join Now RM00101.KPERHIST
GP 9
KPTRXHSTtinyint Keep Trx H...(more) Join Now RM00101.KPTRXHST
GP 9
TRDDISCTsmallint Trade Disc...(more) Join Now RM10301.TRDDISCT
GP 9
USERDEF1char(21) UserDefine...(more) Join Now
GP 9
USERDEF2char(21) UserDefine...(more) Join Now
GP 9
PMAPINDXint PM AP Inde...(more) Join Now PM00200.PMAPINDX
GP 9
PMCSHIDXint PM Cash In...(more) Join Now PM00200.PMCSHIDX
GP 9
PMDAVIDXint PM Discoun...(more) Join Now PM00200.PMDAVIDX
GP 9
PMDTKIDXint PM Discoun...(more) Join Now PM00200.PMDTKIDX
GP 9
PMFINIDXint PM Finance...(more) Join Now PM00200.PMFINIDX
GP 9
PMMSCHIXint PM Misc Ch...(more) Join Now PM00200.PMMSCHIX
GP 9
PMFRTIDXint PM Freight...(more) Join Now PM00200.PMFRTIDX
GP 9
PMTAXIDXint PM Tax Ind...(more) Join Now PM00200.PMTAXIDX
GP 9
PMWRTIDXint PM Writeof...(more) Join Now PM00200.PMWRTIDX
GP 9
PMPRCHIXint PM Purchas...(more) Join Now PM00200.PMPRCHIX
GP 9
PMRTNGIXint PM Retaina...(more) Join Now PM00200.PMRTNGIX
GP 9
PMTDSCIXint PM Trade ...(more) Join Now PM00200.PMTDSCIX
GP 9
ACPURIDXint Accrued Pu...(more) Join Now PM00200.ACPURIDX
GP 9
PURPVIDXint Purchase P...(more) Join Now IV00101.PURPVIDX
GP 9
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM00100.CHEKBKID
MODIFDTdatetime Date the r...(more) Join Now
GP 9
CREATDDTdatetime Created Da...(more) Join Now RM00101.CREATDDT
GP 9
RATETPIDchar(15) A valid Ra...(more) Join Now
GP 9
Revalue_Vendortinyint Revalue Ve...(more) Join Now PM00200.Revalue_Vendor
GP 9
Post_Results_Tosmallint Post Resul...(more) Join Now RM00101.Post_Results_To
GP 9
FREEONBOARDsmallint Free On Bo...(more) Join Now IV00103.FREEONBOARD
GP 9
DISGRPERsmallint Discount G...(more) Join Now RM10301.DISGRPER
GP 9
DUEGRPERsmallint Due Date G...(more) Join Now RM10301.DUEGRPER
GP 9
TaxInvRecvdtinyint Tax Invoic...(more) Join Now POP10300.TaxInvRecvd
GP 9
CBVATtinyint Cash Based...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9