DynDeveloper.com

DynDeveloper.com

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

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..PM09200 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 = PM09200.VENDORID
VENDNAMEchar(65) Vendor Nam...(more) Join Now POP10100.VENDNAME
GP 2010
VNDCHKNMchar(65) Vendor Che...(more) Join Now PM20000.VNDCHKNM
GP 2010
VENDSHNMchar(15) Vendor Sho...(more) Join Now
GP 2010
VADDCDPRchar(15) Vendor Add...(more) Join Now PM10000.VADDCDPR
GP 2010
VADCDPADchar(15) Vendor Add...(more) Join Now POP10100.VADCDPAD
GP 2010
VADCDSFRchar(15) Vendor Add...(more) Join Now PM00200.VADCDSFR
GP 2010
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 2010
VNDCLSIDchar(11) Vendor Cla...(more) Join Now PM00200.VNDCLSID
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
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
UPSZONEchar(3) UPS Zone: ...(more) Join Now RM00101.UPSZONE
GP 2010
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 2010
join SY03000 on SY03000.SHIPMTHD = PM09200.SHIPMTHD
TAXSCHIDchar(15) Tax Schedu...(more) Join Now PM10000.TAXSCHID
GP 2010
join TX00101 on TX00101.TAXSCHID = PM09200.TAXSCHID
ACNMVNDRchar(21) Account Nu...(more) Join Now PM00200.ACNMVNDR
GP 2010
TXIDNMBRchar(11) Tax ID Num...(more) Join Now PM00200.TXIDNMBR
GP 2010
VENDSTTSsmallint Vendor Sta...(more) Join Now PM00200.VENDSTTS
GP 2010
CURNCYIDchar(15) Currency I...(more) Join Now
GP 2010
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM09200.CURNCYID
TXRGNNUMchar(25) Tax Regist...(more) Join Now RM00101.TXRGNNUM
GP 2010
PARVENIDchar(15) Parent Ven...(more) Join Now PM00200.PARVENID
GP 2010
TRDDISCTsmallint Trade Disc...(more) Join Now RM10301.TRDDISCT
GP 2010
TEN99TYPEsmallint 1099 Type:...(more) Join Now
GP 2010
MINORDERnumeric(19,5) Minimum Or...(more) Join Now
GP 2010
PYMTRMIDchar(21) Payment Te...(more) Join Now PM10000.PYMTRMID
GP 2010
join SY03300 on SY03300.PYMTRMID = PM09200.PYMTRMID
MINPYTYPsmallint Minimum ...(more) Join Now RM00101.MINPYTYP
GP 2010
MINPYPCTsmallint Finance Ch...(more) Join Now RM00101.MINPYPCT
GP 2010
MINPYDLRnumeric(19,5) Minimum Pa...(more) Join Now
GP 2010
MXIAFVNDsmallint Maximum In...(more) Join Now PM00200.MXIAFVND
GP 2010
MAXINDLRnumeric(19,5) Maximum In...(more) Join Now
GP 2010
COMMENT1char(31) Comment 1:...(more) Join Now RM00101.COMMENT1
GP 2010
COMMENT2char(31) Comment 2:...(more) Join Now RM00101.COMMENT2
GP 2010
USERDEF1char(21) UserDefine...(more) Join Now
GP 2010
USERDEF2char(21) UserDefine...(more) Join Now
GP 2010
CRLMTDLRnumeric(19,5) Credit Lim...(more) Join Now
GP 2010
PYMNTPRIchar(3) Payment Pr...(more) Join Now PM00200.PYMNTPRI
GP 2010
KPCALHSTtinyint Keep Calen...(more) Join Now RM00101.KPCALHST
GP 2010
KGLDSTHStinyint Keep GL Di...(more) Join Now PM00200.KGLDSTHS
GP 2010
KPERHISTtinyint Keep Perio...(more) Join Now RM00101.KPERHIST
GP 2010
KPTRXHSTtinyint Keep Trx H...(more) Join Now RM00101.KPTRXHST
GP 2010
HOLDtinyint Hold: 1 i...(more) Join Now RM00101.HOLD
GP 2010
PTCSHACFsmallint Post To Ca...(more) Join Now PM00200.PTCSHACF
GP 2010
CREDTLMTsmallint Credit Lim...(more) Join Now PM00200.CREDTLMT
GP 2010
WRITEOFFsmallint Writeoff: ...(more) Join Now PM00200.WRITEOFF
GP 2010
MXWOFAMTnumeric(19,5) Maximum Wr...(more) Join Now
GP 2010
SBPPSDEDtinyint Subject to...(more) Join Now PM00200.SBPPSDED
GP 2010
PPSTAXRTsmallint PPS Tax Ra...(more) Join Now
GP 2010
DXVARNUMchar(25) Deduction ...(more) Join Now PM00200.DXVARNUM
GP 2010
CRTCOMDTdatetime Certificat...(more) Join Now PM00200.CRTCOMDT
GP 2010
CRTEXPDTdatetime Certificat...(more) Join Now PM00200.CRTEXPDT
GP 2010
RTOBUTKNtinyint Reporting ...(more) Join Now PM00200.RTOBUTKN
GP 2010
XPDTOBLGtinyint Expiration...(more) Join Now PM00200.XPDTOBLG
GP 2010
PRSPAYEEtinyint Prescribed...(more) Join Now PM00200.PRSPAYEE
GP 2010
PM_AP_Stringchar(129)
GP 2010
PM_Cash_Stringchar(129)
GP 2010
PM_Discount_Available_Stchar(129)
GP 2010
PM_Discount_Taken_Stringchar(129)
GP 2010
PM_Finance_Charge_Stringchar(129)
GP 2010
PM_Misc_Charges_Stringchar(129)
GP 2010
PM_Freight_Stringchar(129)
GP 2010
PM_Tax_Stringchar(129)
GP 2010
PM_Write_Offs_Stringchar(129)
GP 2010
PM_Purchases_Stringchar(129)
GP 2010
PM_Retainage_Stringchar(129)
GP 2010
PM_Trade_Discount_Stringchar(129)
GP 2010
Accrued_Purchases_Stringchar(129)
GP 2010
Purchase_Price_Variance_char(129)
GP 2010
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 2010
join CM00100 on CM00100.CHEKBKID = PM09200.CHEKBKID
MODIFDTdatetime Date the r...(more) Join Now
GP 2010
CREATDDTdatetime Created Da...(more) Join Now RM00101.CREATDDT
GP 2010
RATETPIDchar(15) A valid Ra...(more) Join Now
GP 2010
Revalue_Vendortinyint Revalue Ve...(more) Join Now PM00200.Revalue_Vendor
GP 2010
Post_Results_Tosmallint Post Resul...(more) Join Now RM00101.Post_Results_To
GP 2010
FREEONBOARDsmallint Free On Bo...(more) Join Now IV00103.FREEONBOARD
GP 2010
GOVCRPIDchar(31) Government...(more) Join Now RM00101.GOVCRPID
GP 2010
GOVINDIDchar(31) Government...(more) Join Now RM00101.GOVINDID
GP 2010
DISGRPERsmallint Discount G...(more) Join Now RM10301.DISGRPER
GP 2010
DUEGRPERsmallint Due Date G...(more) Join Now RM10301.DUEGRPER
GP 2010
DOCFMTIDchar(15) Document F...(more) Join Now RM00101.DOCFMTID
GP 2010
TaxInvRecvdtinyint Tax Invoic...(more) Join Now POP30300.TaxInvRecvd
GP 2010
DUETYPEsmallint PAMINVPR.DUETYPE
GP 2010
DUEDTDSsmallint PAMINVPR.DUEDTDS
GP 2010
DISCTYPEsmallint =1 if Days...(more) Join Now SY03300.DISCTYPE
GP 2010
DSCLCTYPsmallint
GP 2010
DSCPCTAMsmallint Discount P...(more) Join Now RM20101.DSCPCTAM
GP 2010
DSCDLRAMnumeric(19,5) Discount D...(more) Join Now
GP 2010
DISCDTDSsmallint
GP 2010
USEGRPERtinyint
GP 2010
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
UMA_Text_Fieldchar(255)
GP 2010
DEX_ROW_IDint Unique aut...(more) Join Now
GP 2010