PM Vendor Master File (PM00200)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPM 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 TypeLength
1VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
2VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
3VNDCHKNM SearchVendor Check NameStringSTR64_Vendor_Name64
4VENDSHNM SearchVendor Short NameStringSTR1515
5VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
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 AddressStringSTR15_Address_Code15
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 FromStringSTR15_Address_Code15
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 ToStringSTR15_Address_Code15
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 IDStringSTR10_Class_ID10
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 ContactStringSTR6060
11ADDRESS1 SearchAddress 1StringSTR6060
12ADDRESS2 SearchAddress 2StringSTR6060
13ADDRESS3 SearchAddress 3StringSTR6060
14CITY SearchCityStringSTR3535
15STATE SearchStateStringSTR30_State29
16ZIPCODE SearchZip CodeStringSTR1010
17COUNTRY SearchCountryStringSTR6060
18PHNUMBR1 SearchPhone Number 1StringPhone_Number14
19PHNUMBR2 SearchPhone Number 2StringPhone_Number14
20PHONE3 SearchPhone 3StringPhone_Number314
21FAXNUMBR SearchFax NumberStringSTR14_FAX14
22UPSZONE SearchUPS ZoneStringSTR33
23SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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 IDStringSTR15_Tax_Schedule_ID15
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 VendorStringSTR2020
26TXIDNMBR SearchTax ID NumberStringTax_ID_Number11
27VENDSTTS SearchVendor StatusIntegerDDL_Vendor_Status0
28CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 NumberStringSTR2525
30PARVENID SearchParent Vendor IDStringSTR_15_Vendor_ID15
31TRDDISCT SearchTrade DiscountIntegerINT4_%24
32TEN99TYPE Search1099 TypeInteger1099_Type0
33TEN99BOXNUMBER Search1099 Box NumberIntegerDDL_1099_Box0
34MINORDER SearchMinimum OrderCurrencyDLR17_$U217
35PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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 TypeIntegerGB_Amt_Type0
37MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
38MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
39MXIAFVND SearchMaximum Invoice Amount For VendorsIntegerGB0
40MAXINDLR SearchMaximum Invoice DollarCurrencyDLR17_$U217
41COMMENT1 SearchComment1StringSTR3030
42COMMENT2 SearchComment2StringSTR3030
43USERDEF1 SearchUser Defined 1StringSTR2020
44USERDEF2 SearchUser Defined 2StringSTR2020
45CRLMTDLR SearchCredit Limit DollarCurrencyDLR17_$U217
46PYMNTPRI SearchPayment PriorityStringSTR33
47KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
48KGLDSTHS SearchKeep GL Dist HistoryBooleanCB_Keep_GL_Dist_History0
49KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
50KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
51HOLD SearchHoldBooleanCB_Hold0
52PTCSHACF SearchPost To Cash Account FromIntegerGB0
53CREDTLMT SearchCredit LimitIntegerGB0
54WRITEOFF SearchWriteoffIntegerGB0
55MXWOFAMT SearchMaximum Write Off AmountCurrencyDLR17_$U217
56SBPPSDED SearchSubject To PPS DeductionsBooleanCB_Subject_To_PPS_Deductions0
57PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
58DXVARNUM SearchDeduction Exemption/Variation NumberStringSTR2525
59CRTCOMDT SearchCertificate Commencing DateDateDT8
60CRTEXPDT SearchCertificate Expiration DateDateDT8
61RTOBUTKN SearchReporting Obligation UndertakenBooleanCB_Reporting_Obligation0
62XPDTOBLG SearchExpiration Date ObligationBooleanCB_Expiration_Date_Obligation0
63PRSPAYEE SearchPrescribed PayeeBooleanCB_Prescribed_Payee0
64PMAPINDX SearchPM AP IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexCurrencyDLR1414
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 IDStringSTR15_Checkbook_ID15
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 DateDateDT8
81CREATDDT SearchCreated DateDateDT8
82RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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 VendorBooleanCB Revalue Vendor0
84Post_Results_To SearchPost Results ToIntegerGB0
85FREEONBOARD SearchFree On BoardIntegerDDL_Free_On_Board0
86GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
87GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
88DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
89DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
90DOCFMTID SearchDocument Format IDStringSTR15_LBU15
91TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
92USERLANG SearchUser Language IDIntegerINT0
93WithholdingType SearchWithholding TypeIntegerDDL_WithholdingType0
94WithholdingFormType SearchWithholding Form TypeIntegerDDL_WithholdingFormType0
95WithholdingEntityType SearchWithholding Entity TypeIntegerDDL_WithholdingEntityType0
96TaxFileNumMode SearchTax File Number ModeIntegerDDL_TaxFileNumMode0
97BRTHDATE SearchBirth DateDateDT8
98LaborPmtType SearchLabor Payment TypeIntegerDDL_LaborPaymentType0
99CCode SearchCountry CodeStringSTR6_VAT6
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 IDStringSTR15_Address_Code15
101CBVAT SearchCash Based VATBooleanCB_CashBasedVAT0
102Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
103Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
104Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
105VADCD1099 SearchVendor Address Code - 1099StringSTR15_Address_Code15
106ONEPAYPERVENDINV SearchOne Pay Per Vendor InvoiceIntegerGB0
107VENDDBA SearchDBAStringSTR6565
azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPM Vendor Master File (PM00200)

1 thought on “PM Vendor Master File (PM00200)”

  1. Pingback: SQL Script to Insert Vendors - Microsoft Dynamics GP Community

Leave a Reply

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