GP Tables

PM00200 - PM Vendor Master File

Dynamics GP table PM00200 (PM Vendor Master File) contains 104 columns including VENDORID, VENDNAME, VNDCHKNM....

SQL Query Builder

104 Columns

Column Description Type Length
VENDORID Vendor ID String 16
VENDNAME Vendor Name String 66
VNDCHKNM Vendor Check Name String 66
VENDSHNM Vendor Short Name String 16
VADDCDPR Vendor Address Code - Primary String 16
VADCDPAD Vendor Address Code - Purchase Address String 16
VADCDSFR Vendor Address Code - Ship From String 16
VADCDTRO Vendor Address Code - Remit To String 16
VNDCLSID Vendor Class ID String 12
VNDCNTCT Vendor Contact String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
COUNTRY Country String 62
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
PHONE3 Phone 3 String 22
FAXNUMBR Fax Number String 22
UPSZONE UPS Zone String 4
SHIPMTHD Shipping Method String 16
TAXSCHID Tax Schedule ID String 16
ACNMVNDR Account Number With Vendor String 22
TXIDNMBR Tax ID Number String 12
VENDSTTS Vendor Status1. Active2. Inactive3. Temporary Integer 2
Vendor Status values (3)
1 = Active2 = Inactive3 = Temporary
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
TXRGNNUM Tax Registration Number String 26
PARVENID Parent Vendor ID String 16
TRDDISCT Trade Discount Integer 2
TEN99TYPE 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous Integer 2
1099 Type values (5)
1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation
TEN99BOXNUMBER 1099 Box Number Integer 2
MINORDER Minimum Order Currency 10
PYMTRMID Payment Terms ID String 22
MINPYTYP Minimum Payment Type Integer 2
MINPYPCT Minimum Payment Percent Integer 2
MINPYDLR Minimum Payment Dollar Currency 10
MXIAFVND Maximum Invoice Amount For Vendors Integer 2
MAXINDLR Maximum Invoice Dollar Currency 10
COMMENT1 Comment1 String 32
COMMENT2 Comment2 String 32
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
CRLMTDLR Credit Limit Dollar Currency 10
PYMNTPRI Payment Priority String 4
KPCALHST Keep Calendar History Boolean 2
KGLDSTHS Keep GL Dist History Boolean 2
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
HOLD Hold Boolean 2
Hold Status values (2)
0 = Not on hold1 = On hold
PTCSHACF Post To Cash Account From Integer 2
CREDTLMT Credit Limit Integer 2
Credit Limit Type values (3)
0 = No Credit1 = Unlimited2 = Amount (see CRLMTDLR)
WRITEOFF Writeoff Integer 2
MXWOFAMT Maximum Write Off Amount Currency 10
SBPPSDED Subject To PPS Deductions Boolean 2
PPSTAXRT PPS Tax Rate Integer 2
DXVARNUM Deduction Exemption/Variation Number String 26
CRTCOMDT Certificate Commencing Date Date 4
CRTEXPDT Certificate Expiration Date Date 4
RTOBUTKN Reporting Obligation Undertaken Boolean 2
XPDTOBLG Expiration Date Obligation Boolean 2
PRSPAYEE Prescribed Payee Boolean 2
PMAPINDX PM AP Index Long Integer 4
PMCSHIDX PM Cash Index Long Integer 4
PMDAVIDX PM Discount Available Index Long Integer 4
PMDTKIDX PM Discount Taken Index Long Integer 4
PMFINIDX PM Finance Charge Index Long Integer 4
PMMSCHIX PM Misc Charges Index Long Integer 4
PMFRTIDX PM Freight Index Long Integer 4
PMTAXIDX PM Tax Index Long Integer 4
PMWRTIDX PM Write Offs Index Long Integer 4
PMPRCHIX PM Purchases Index Long Integer 4
PMRTNGIX PM Retainage Index Long Integer 4
PMTDSCIX PM Trade Discount Index Long Integer 4
ACPURIDX Accrued Purchases Index Long Integer 4
PURPVIDX Purchase Price Variance Index Long Integer 4
NOTEINDX Note Index Currency 10
CHEKBKID Checkbook ID String 16
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 4
RATETPID Rate Type ID String 16
Revalue_Vendor Revalue Vendor Boolean 2
Post_Results_To Post Results To Integer 2
FREEONBOARD Free On Board Integer 2
GOVCRPID Governmental Corporate ID String 32
GOVINDID Governmental Individual ID String 32
DISGRPER Discount Grace Period Integer 2
DUEGRPER Due Date Grace Period Integer 2
DOCFMTID Document Format ID String 16
TaxInvRecvd Tax Invoice Received Boolean 2
USERLANG User Language ID Integer 2
WithholdingType Withholding Type Integer 2
WithholdingFormType Withholding Form Type Integer 2
WithholdingEntityType Withholding Entity Type Integer 2
TaxFileNumMode Tax File Number Mode Integer 2
BRTHDATE Birth Date Date 4
LaborPmtType Labor Payment Type Integer 2
CCode Country Code String 8
DECLID Declarant ID String 16
CBVAT Cash Based VAT Boolean 2
Workflow_Approval_Status Workflow Approval Status1 – Not Submitted2 – Submitted3 – No Approval Needed4 – Pending Approval5 – Pending Changes6 – Approved7 – Rejected8 – Workflow Ended9 – Workflow Not Activated10 – Workflow Deactivated Integer 2
Workflow_Priority Workflow Priority Integer 2
VADCD1099 Vendor Address Code - 1099 String 16

Related Tables

Tables that share columns with PM00200. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12

SHIPMTHD

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

PYMTRMID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08