PM Vendor Master File (PM00200)

azurecurve Products Microsoft 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
2	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
3	VNDCHKNM	Vendor Check Name	String	STR64_Vendor_Name	64
4	VENDSHNM	Vendor Short Name	String	STR15	15
5	VADDCDPR	Vendor Address Code - Primary	String	STR15_Address_Code	15
	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
6	VADCDPAD	Vendor Address Code - Purchase Address	String	STR15_Address_Code	15
	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
7	VADCDSFR	Vendor Address Code - Ship From	String	STR15_Address_Code	15
	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
8	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	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
9	VNDCLSID	Vendor Class ID	String	STR10_Class_ID	10
	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
10	VNDCNTCT	Vendor Contact	String	STR60	60
11	ADDRESS1	Address 1	String	STR60	60
12	ADDRESS2	Address 2	String	STR60	60
13	ADDRESS3	Address 3	String	STR60	60
14	CITY	City	String	STR35	35
15	STATE	State	String	STR30_State	29
16	ZIPCODE	Zip Code	String	STR10	10
17	COUNTRY	Country	String	STR60	60
18	PHNUMBR1	Phone Number 1	String	Phone_Number	14
19	PHNUMBR2	Phone Number 2	String	Phone_Number	14
20	PHONE3	Phone 3	String	Phone_Number3	14
21	FAXNUMBR	Fax Number	String	STR14_FAX	14
22	UPSZONE	UPS Zone	String	STR3	3
23	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	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
24	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	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
25	ACNMVNDR	Account Number With Vendor	String	STR20	20
26	TXIDNMBR	Tax ID Number	String	Tax_ID_Number	11
27	VENDSTTS	Vendor Status	Integer	DDL_Vendor_Status	0
28	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	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
29	TXRGNNUM	Tax Registration Number	String	STR25	25
30	PARVENID	Parent Vendor ID	String	STR_15_Vendor_ID	15
31	TRDDISCT	Trade Discount	Integer	INT4_%2	4
32	TEN99TYPE	1099 Type	Integer	1099_Type	0
33	TEN99BOXNUMBER	1099 Box Number	Integer	DDL_1099_Box	0
34	MINORDER	Minimum Order	Currency	DLR17_$U2	17
35	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	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
36	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
37	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
38	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
39	MXIAFVND	Maximum Invoice Amount For Vendors	Integer	GB	0
40	MAXINDLR	Maximum Invoice Dollar	Currency	DLR17_$U2	17
41	COMMENT1	Comment1	String	STR30	30
42	COMMENT2	Comment2	String	STR30	30
43	USERDEF1	User Defined 1	String	STR20	20
44	USERDEF2	User Defined 2	String	STR20	20
45	CRLMTDLR	Credit Limit Dollar	Currency	DLR17_$U2	17
46	PYMNTPRI	Payment Priority	String	STR3	3
47	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
48	KGLDSTHS	Keep GL Dist History	Boolean	CB_Keep_GL_Dist_History	0
49	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
50	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
51	HOLD	Hold	Boolean	CB_Hold	0
52	PTCSHACF	Post To Cash Account From	Integer	GB	0
53	CREDTLMT	Credit Limit	Integer	GB	0
54	WRITEOFF	Writeoff	Integer	GB	0
55	MXWOFAMT	Maximum Write Off Amount	Currency	DLR17_$U2	17
56	SBPPSDED	Subject To PPS Deductions	Boolean	CB_Subject_To_PPS_Deductions	0
57	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
58	DXVARNUM	Deduction Exemption/Variation Number	String	STR25	25
59	CRTCOMDT	Certificate Commencing Date	Date	DT	8
60	CRTEXPDT	Certificate Expiration Date	Date	DT	8
61	RTOBUTKN	Reporting Obligation Undertaken	Boolean	CB_Reporting_Obligation	0
62	XPDTOBLG	Expiration Date Obligation	Boolean	CB_Expiration_Date_Obligation	0
63	PRSPAYEE	Prescribed Payee	Boolean	CB_Prescribed_Payee	0
64	PMAPINDX	PM AP Index	Long Integer	LI_14	14
	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
65	PMCSHIDX	PM Cash Index	Long Integer	LI_14	14
	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
66	PMDAVIDX	PM Discount Available Index	Long Integer	LI_14	14
	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
67	PMDTKIDX	PM Discount Taken Index	Long Integer	LI_14	14
	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
68	PMFINIDX	PM Finance Charge Index	Long Integer	LI_14	14
	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
69	PMMSCHIX	PM Misc Charges Index	Long Integer	LI_14	14
	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
70	PMFRTIDX	PM Freight Index	Long Integer	LI_14	14
	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
71	PMTAXIDX	PM Tax Index	Long Integer	LI_14	14
	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
72	PMWRTIDX	PM Write Offs Index	Long Integer	LI_14	14
	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
73	PMPRCHIX	PM Purchases Index	Long Integer	LI_14	14
	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
74	PMRTNGIX	PM Retainage Index	Long Integer	LI_14	14
	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
75	PMTDSCIX	PM Trade Discount Index	Long Integer	LI_14	14
	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
76	ACPURIDX	Accrued Purchases Index	Long Integer	LI_14	14
	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
77	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	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
78	NOTEINDX	Note Index	Currency	DLR14	14
	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
79	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	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
80	MODIFDT	Modified Date	Date	DT	8
81	CREATDDT	Created Date	Date	DT	8
82	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	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
83	Revalue_Vendor	Revalue Vendor	Boolean	CB Revalue Vendor	0
84	Post_Results_To	Post Results To	Integer	GB	0
85	FREEONBOARD	Free On Board	Integer	DDL_Free_On_Board	0
86	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
87	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
88	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
89	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
90	DOCFMTID	Document Format ID	String	STR15_LBU	15
91	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
92	USERLANG	User Language ID	Integer	INT	0
93	WithholdingType	Withholding Type	Integer	DDL_WithholdingType	0
94	WithholdingFormType	Withholding Form Type	Integer	DDL_WithholdingFormType	0
95	WithholdingEntityType	Withholding Entity Type	Integer	DDL_WithholdingEntityType	0
96	TaxFileNumMode	Tax File Number Mode	Integer	DDL_TaxFileNumMode	0
97	BRTHDATE	Birth Date	Date	DT	8
98	LaborPmtType	Labor Payment Type	Integer	DDL_LaborPaymentType	0
99	CCode	Country Code	String	STR6_VAT	6
	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
100	DECLID	Declarant ID	String	STR15_Address_Code	15
101	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
102	Workflow_Approval_Status	Workflow Approval Status	Integer	DDL_WorkflowApprovalStatus	0
103	Workflow_Priority	Workflow Priority	Integer	DDL_WorkflowPriority	0
104	Workflow_Status	Workflow Status	Integer	Workflow Status	0
105	VADCD1099	Vendor Address Code - 1099	String	STR15_Address_Code	15
106	ONEPAYPERVENDINV	One Pay Per Vendor Invoice	Integer	GB	0
107	VENDDBA	DBA	String	STR65	65

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Vendor Master File (PM00200)

PM Vendor Master File (PM00200)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

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

Leave a Reply Cancel reply