DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Vendor Master File)

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
VENDNAMEchar(65) Vendor Nam...(more) Join Now
GP 9
VNDCHKNMchar(65) Vendor Che...(more) Join Now
GP 9
VENDSHNMchar(15) Vendor Sho...(more) Join Now
GP 9
VADDCDPRchar(15) Vendor Add...(more) Join Now
GP 9
VADCDPADchar(15) Vendor Add...(more) Join Now
GP 9
VADCDSFRchar(15) Vendor Add...(more) Join Now
GP 9
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 9
VNDCLSIDchar(11) Vendor Cla...(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
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
UPSZONEchar(3) UPS Zone:...(more) Join Now
GP 9
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 9
join SY03000 on SY03000.SHIPMTHD = PM00200.SHIPMTHD
TAXSCHIDchar(15) Tax Schedu...(more) Join Now
GP 9
join TX00101 on TX00101.TAXSCHID = PM00200.TAXSCHID
ACNMVNDRchar(21) Account Nu...(more) Join Now
GP 9
TXIDNMBRchar(11) Tax ID Num...(more) Join Now
GP 9
VENDSTTSsmallint Vendor Sta...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM00200.CURNCYID
TXRGNNUMchar(25) Tax Regist...(more) Join Now
GP 9
PARVENIDchar(15) Parent Ven...(more) Join Now
GP 9
TRDDISCTsmallint Trade Disc...(more) Join Now
GP 9
TEN99TYPEsmallint 1099 Type:...(more) Join Now
GP 9
TEN99BOXNUMBERsmallint 1099 Box N...(more) Join Now
GP 10
MINORDERnumeric(19,5) Minimum Or...(more) Join Now
GP 9
PYMTRMIDchar(21) Payment Te...(more) Join Now
GP 9
join SY03300 on SY03300.PYMTRMID = PM00200.PYMTRMID
MINPYTYPsmallint Minimum ...(more) Join Now
GP 9
MINPYPCTsmallint Minimum Pa...(more) Join Now
GP 9
MINPYDLRnumeric(19,5) Minimum Pa...(more) Join Now
GP 9
MXIAFVNDsmallint Maximum In...(more) Join Now
GP 9
MAXINDLRnumeric(19,5) Maximum In...(more) Join Now
GP 9
COMMENT1char(31) Comment 1:...(more) Join Now
GP 9
COMMENT2char(31) Comment 2:...(more) Join Now
GP 9
USERDEF1char(21) UserDefine...(more) Join Now
GP 9
USERDEF2char(21) UserDefine...(more) Join Now
GP 9
CRLMTDLRnumeric(19,5) Credit Lim...(more) Join Now
GP 9
PYMNTPRIchar(3) Payment Pr...(more) Join Now
GP 9
KPCALHSTtinyint Keep Calen...(more) Join Now
GP 9
KGLDSTHStinyint Keep GL Di...(more) Join Now
GP 9
KPERHISTtinyint Keep Perio...(more) Join Now
GP 9
KPTRXHSTtinyint Keep Trx H...(more) Join Now
GP 9
HOLDtinyint Hold: 1 i...(more) Join Now
GP 9
PTCSHACFsmallint Post To Ca...(more) Join Now
GP 9
CREDTLMTsmallint Credit Lim...(more) Join Now
GP 9
WRITEOFFsmallint Writeoff: ...(more) Join Now
GP 9
MXWOFAMTnumeric(19,5) Maximum Wr...(more) Join Now
GP 9
SBPPSDEDtinyint Subject to...(more) Join Now
GP 9
PPSTAXRTsmallint PPS Tax Ra...(more) Join Now
GP 9
DXVARNUMchar(25) Deduction ...(more) Join Now
GP 9
CRTCOMDTdatetime Certificat...(more) Join Now
GP 9
CRTEXPDTdatetime Certificat...(more) Join Now
GP 9
RTOBUTKNtinyint Reporting ...(more) Join Now
GP 9
XPDTOBLGtinyint Expiration...(more) Join Now
GP 9
PRSPAYEEtinyint Prescribed...(more) Join Now
GP 9
PMAPINDXint PM AP Inde...(more) Join Now
GP 9
PMCSHIDXint PM Cash In...(more) Join Now
GP 9
PMDAVIDXint PM Discoun...(more) Join Now
GP 9
PMDTKIDXint PM Discoun...(more) Join Now
GP 9
PMFINIDXint PM Finance...(more) Join Now
GP 9
PMMSCHIXint PM Misc Ch...(more) Join Now
GP 9
PMFRTIDXint PM Freight...(more) Join Now
GP 9
PMTAXIDXint PM Tax Ind...(more) Join Now
GP 9
PMWRTIDXint PM Writeof...(more) Join Now
GP 9
PMPRCHIXint PM Purchas...(more) Join Now
GP 9
PMRTNGIXint PM Retaina...(more) Join Now
GP 9
PMTDSCIXint PM Trade ...(more) Join Now
GP 9
ACPURIDXint Accrued Pu...(more) Join Now
GP 9
PURPVIDXint Purchase P...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM00200.NOTEINDX
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM00200.CHEKBKID
MODIFDTdatetime Date the r...(more) Join Now
GP 9
CREATDDTdatetime Created Da...(more) Join Now
GP 9
RATETPIDchar(15) Rate Type ...(more) Join Now
GP 9
Revalue_Vendortinyint Revalue Ve...(more) Join Now
GP 9
Post_Results_Tosmallint Post Resul...(more) Join Now
GP 9
FREEONBOARDsmallint Free On Bo...(more) Join Now
GP 9
GOVCRPIDchar(31) Government...(more) Join Now
GP 9
GOVINDIDchar(31) Government...(more) Join Now
GP 9
DISGRPERsmallint Discount G...(more) Join Now
GP 9
DUEGRPERsmallint Due Date G...(more) Join Now
GP 9
DOCFMTIDchar(15) Document F...(more) Join Now
GP 9
TaxInvRecvdtinyint Tax Invoic...(more) Join Now
GP 9
USERLANGsmallint User Langu...(more) Join Now
GP 9
WithholdingTypesmallint Withholdin...(more) Join Now
GP 9
WithholdingFormTypesmallint Withholdin...(more) Join Now
GP 9
WithholdingEntityTypesmallint Withholdin...(more) Join Now
GP 9
TaxFileNumModesmallint Tax File N...(more) Join Now
GP 9
BRTHDATEdatetime Birth Date...(more) Join Now
GP 9
LaborPmtTypesmallint Labor Paym...(more) Join Now
GP 9
CCodechar(7) Country Co...(more) Join Now
GP 9
DECLIDchar(15) Declarant ...(more) Join Now
GP 9
CBVATtinyint Cash Based...(more) Join Now
GP 9
Workflow_Approval_Statussmallint Workflow A...(more) Join Now
GP 10
Workflow_Prioritysmallint Workflow P...(more) Join Now
GP 10
Workflow_Statussmallint
GP 2013
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9
VADCD1099char
GP 2013