PM Vendor Master File (PM00200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00200

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Vendor Master File
Physical Name: PM00200
Technical Name: PM_Vendor_MSTR

Group Display Name: Payables Vendor Master Logical File
Group Technical Name: PM_Vendor_Master_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
2VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
3VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
4VENDSHNM SearchVendor Short NameSTR15String1615
5VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Vendor Master File'].VADDCDPR AS 'PM Vendor Master File-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Vendor Master File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
6VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Vendor Master File'].VADCDPAD AS 'PM Vendor Master File-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Vendor Master File'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
7VADCDSFR SearchVendor Address Code - Ship FromSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Vendor Master File'].VADCDSFR AS 'PM Vendor Master File-Vendor Address Code - Ship From'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Vendor Master File'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
8VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Vendor Master File'].VADCDTRO AS 'PM Vendor Master File-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Vendor Master File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
9VNDCLSID SearchVendor Class IDSTR10_Class_IDString1210
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['PM Vendor Master File'].VNDCLSID AS 'PM Vendor Master File-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['PM Vendor Master File'].VNDCLSID = ['PM Class Master File'].VNDCLSID
10VNDCNTCT SearchVendor ContactSTR60String6260
11ADDRESS1 SearchAddress 1STR60String6260
12ADDRESS2 SearchAddress 2STR60String6260
13ADDRESS3 SearchAddress 3STR60String6260
14CITY SearchCitySTR35String3635
15STATE SearchStateSTR30_StateString3029
16ZIPCODE SearchZip CodeSTR10String1210
17COUNTRY SearchCountrySTR60String6260
18PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
19PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
20PHONE3 SearchPhone 3Phone_Number3String2214
21FAXNUMBR SearchFax NumberSTR14_FAXString2214
22UPSZONE SearchUPS ZoneSTR3String43
23SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PM Vendor Master File'].SHIPMTHD AS 'PM Vendor Master File-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PM Vendor Master File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
24TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Vendor Master File'].TAXSCHID AS 'PM Vendor Master File-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Vendor Master File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
25ACNMVNDR SearchAccount Number With VendorSTR20String2220
26TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
27VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
28CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Vendor Master File'].CURNCYID AS 'PM Vendor Master File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Vendor Master File'].CURNCYID = ['Currency Setup'].CURNCYID
29TXRGNNUM SearchTax Registration NumberSTR25String2625
30PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
31TRDDISCT SearchTrade DiscountINT4_%2Integer24
32TEN99TYPE Search1099 Type1099_TypeInteger20
33TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger20
34MINORDER SearchMinimum OrderDLR17_$U2Currency1017
35PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PYMTRMID AS 'PM Vendor Master File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PM Vendor Master File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
36MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
37MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
38MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
39MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
40MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
41COMMENT1 SearchComment1STR30String3230
42COMMENT2 SearchComment2STR30String3230
43USERDEF1 SearchUser Defined 1STR20String2220
44USERDEF2 SearchUser Defined 2STR20String2220
45CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
46PYMNTPRI SearchPayment PrioritySTR3String43
47KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
48KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
49KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
50KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
51HOLD SearchHoldCB_HoldBoolean20
52PTCSHACF SearchPost To Cash Account FromGBInteger20
53CREDTLMT SearchCredit LimitGBInteger20
54WRITEOFF SearchWriteoffGBInteger20
55MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
56SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
57PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
58DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
59CRTCOMDT SearchCertificate Commencing DateDTDate48
60CRTEXPDT SearchCertificate Expiration DateDTDate48
61RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
62XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
63PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
64PMAPINDX SearchPM AP IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMAPINDX AS 'PM Vendor Master File-PM AP Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMAPINDX = ['Account Index Master'].ACTINDX
65PMCSHIDX SearchPM Cash IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMCSHIDX AS 'PM Vendor Master File-PM Cash Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMCSHIDX = ['Account Index Master'].ACTINDX
66PMDAVIDX SearchPM Discount Available IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMDAVIDX AS 'PM Vendor Master File-PM Discount Available Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMDAVIDX = ['Account Index Master'].ACTINDX
67PMDTKIDX SearchPM Discount Taken IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMDTKIDX AS 'PM Vendor Master File-PM Discount Taken Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMDTKIDX = ['Account Index Master'].ACTINDX
68PMFINIDX SearchPM Finance Charge IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMFINIDX AS 'PM Vendor Master File-PM Finance Charge Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMFINIDX = ['Account Index Master'].ACTINDX
69PMMSCHIX SearchPM Misc Charges IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMMSCHIX AS 'PM Vendor Master File-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMMSCHIX = ['Account Index Master'].ACTINDX
70PMFRTIDX SearchPM Freight IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMFRTIDX AS 'PM Vendor Master File-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMFRTIDX = ['Account Index Master'].ACTINDX
71PMTAXIDX SearchPM Tax IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMTAXIDX AS 'PM Vendor Master File-PM Tax Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMTAXIDX = ['Account Index Master'].ACTINDX
72PMWRTIDX SearchPM Write Offs IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMWRTIDX AS 'PM Vendor Master File-PM Write Offs Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMWRTIDX = ['Account Index Master'].ACTINDX
73PMPRCHIX SearchPM Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMPRCHIX AS 'PM Vendor Master File-PM Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMPRCHIX = ['Account Index Master'].ACTINDX
74PMRTNGIX SearchPM Retainage IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMRTNGIX AS 'PM Vendor Master File-PM Retainage Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMRTNGIX = ['Account Index Master'].ACTINDX
75PMTDSCIX SearchPM Trade Discount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PMTDSCIX AS 'PM Vendor Master File-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PMTDSCIX = ['Account Index Master'].ACTINDX
76ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].ACPURIDX AS 'PM Vendor Master File-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].ACPURIDX = ['Account Index Master'].ACTINDX
77PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PM Vendor Master File'].PURPVIDX AS 'PM Vendor Master File-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PM Vendor Master File'].PURPVIDX = ['Account Index Master'].ACTINDX
78NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PM Vendor Master File'].NOTEINDX AS 'PM Vendor Master File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PM Vendor Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
79CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Vendor Master File'].CHEKBKID AS 'PM Vendor Master File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM Vendor Master File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
80MODIFDT SearchModified DateDTDate48
81CREATDDT SearchCreated DateDTDate48
82RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PM Vendor Master File'].RATETPID AS 'PM Vendor Master File-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PM Vendor Master File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
83Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean20
84Post_Results_To SearchPost Results ToGBInteger20
85FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
86GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
87GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
88DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
89DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
90DOCFMTID SearchDocument Format IDSTR15_LBUString1615
91TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
92USERLANG SearchUser Language IDINTInteger20
93WithholdingType SearchWithholding TypeDDL_WithholdingTypeInteger20
94WithholdingFormType SearchWithholding Form TypeDDL_WithholdingFormTypeInteger20
95WithholdingEntityType SearchWithholding Entity TypeDDL_WithholdingEntityTypeInteger20
96TaxFileNumMode SearchTax File Number ModeDDL_TaxFileNumModeInteger20
97BRTHDATE SearchBirth DateDTDate48
98LaborPmtType SearchLabor Payment TypeDDL_LaborPaymentTypeInteger20
99CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['PM Vendor Master File'].CCode AS 'PM Vendor Master File-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       PM00200 AS ['PM Vendor Master File']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['PM Vendor Master File'].CCode = ['VAT Country Code MSTR'].CCode
100DECLID SearchDeclarant IDSTR15_Address_CodeString1615
101CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
102Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger20
103Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger20
104Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
105VADCD1099 SearchVendor Address Code - 1099STR15_Address_CodeString1615
106ONEPAYPERVENDINV SearchOne Pay Per Vendor InvoiceGBInteger20
107DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
108DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *