Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00100
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Class Master File Group Display Name: Payables Vendor Master Logical File
Physical Name: PM00100
Technical Name: PM_Class_MSTR
Group Technical Name: PM_Vendor_Master_Logical_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | VNDCLSID ![]() | Vendor Class ID | STR10_Class_ID | String | 10 | |
2 | VNDCLDSC ![]() | Vendor Class Description | STR30 | String | 30 | |
3 | DEFLTCLS ![]() | Default Class | CB_Default | Boolean | 0 | |
4 | MXIAFVND ![]() | Maximum Invoice Amount For Vendors | GB | Integer | 0 | |
5 | MXINVAMT ![]() | Maximum Invoice Amount | DLR17_$U2 | Currency | 17 | |
6 | WRITEOFF ![]() | Writeoff | GB | Integer | 0 | |
7 | CREDTLMT ![]() | Credit Limit | GB | Integer | 0 | |
8 | TEN99TYPE ![]() | 1099 Type | 1099_Type | Integer | 0 | |
9 | PTCSHACF ![]() | Post To Cash Account From | GB | Integer | 0 | |
10 | MXWOFAMT ![]() | Maximum Write Off Amount | DLR17_$U2 | Currency | 17 | |
11 | MINORDER ![]() | Minimum Order | DLR17_$U2 | Currency | 17 | |
12 | CRLMTDLR ![]() | Credit Limit Dollar | DLR17_$U2 | Currency | 17 | |
13 | PYMNTPRI ![]() | Payment Priority | STR3 | String | 3 | |
14 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['PM Class Master File'].SHIPMTHD AS 'PM Class Master File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PM Class Master File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
15 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['PM Class Master File'].PYMTRMID AS 'PM Class Master File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PM Class Master File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
16 | MINPYTYP ![]() | Minimum Payment Type | GB_Amt_Type | Integer | 0 | |
17 | MINPYDLR ![]() | Minimum Payment Dollar | DLR17_RBS0_UTR$ | Currency | 17 | |
18 | MINPYPCT ![]() | Minimum Payment Percent | INT5_%2 | Integer | 5 | |
19 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PM Class Master File'].CURNCYID AS 'PM Class Master File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Class Master File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
20 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PM Class Master File'].TAXSCHID AS 'PM Class Master File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Class Master File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
21 | KPCALHST ![]() | Keep Calendar History | CB_Keep_Calendar_History | Boolean | 0 | |
22 | KGLDSTHS ![]() | Keep GL Dist History | CB_Keep_GL_Dist_History | Boolean | 0 | |
23 | KPERHIST ![]() | Keep Period History | CB_Keep_Period_History | Boolean | 0 | |
24 | KPTRXHST ![]() | Keep Trx History | CB_Keep_Trx_History | Boolean | 0 | |
25 | TRDDISCT ![]() | Trade Discount | INT4_%2 | Integer | 4 | |
26 | USERDEF1 ![]() | User Defined 1 | STR20 | String | 20 | |
27 | USERDEF2 ![]() | User Defined 2 | STR20 | String | 20 | |
28 | PMAPINDX ![]() | PM AP Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMAPINDX AS 'PM Class Master File-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMAPINDX = ['Account Index Master'].ACTINDX | ||||||
29 | PMCSHIDX ![]() | PM Cash Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMCSHIDX AS 'PM Class Master File-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMCSHIDX = ['Account Index Master'].ACTINDX | ||||||
30 | PMDAVIDX ![]() | PM Discount Available Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMDAVIDX AS 'PM Class Master File-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMDAVIDX = ['Account Index Master'].ACTINDX | ||||||
31 | PMDTKIDX ![]() | PM Discount Taken Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMDTKIDX AS 'PM Class Master File-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMDTKIDX = ['Account Index Master'].ACTINDX | ||||||
32 | PMFINIDX ![]() | PM Finance Charge Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMFINIDX AS 'PM Class Master File-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMFINIDX = ['Account Index Master'].ACTINDX | ||||||
33 | PMMSCHIX ![]() | PM Misc Charges Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMMSCHIX AS 'PM Class Master File-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMMSCHIX = ['Account Index Master'].ACTINDX | ||||||
34 | PMFRTIDX ![]() | PM Freight Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMFRTIDX AS 'PM Class Master File-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMFRTIDX = ['Account Index Master'].ACTINDX | ||||||
35 | PMTAXIDX ![]() | PM Tax Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMTAXIDX AS 'PM Class Master File-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMTAXIDX = ['Account Index Master'].ACTINDX | ||||||
36 | PMWRTIDX ![]() | PM Write Offs Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMWRTIDX AS 'PM Class Master File-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMWRTIDX = ['Account Index Master'].ACTINDX | ||||||
37 | PMPRCHIX ![]() | PM Purchases Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMPRCHIX AS 'PM Class Master File-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMPRCHIX = ['Account Index Master'].ACTINDX | ||||||
38 | PMRTNGIX ![]() | PM Retainage Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMRTNGIX AS 'PM Class Master File-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMRTNGIX = ['Account Index Master'].ACTINDX | ||||||
39 | PMTDSCIX ![]() | PM Trade Discount Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PMTDSCIX AS 'PM Class Master File-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMTDSCIX = ['Account Index Master'].ACTINDX | ||||||
40 | ACPURIDX ![]() | Accrued Purchases Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].ACPURIDX AS 'PM Class Master File-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].ACPURIDX = ['Account Index Master'].ACTINDX | ||||||
41 | PURPVIDX ![]() | Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PM Class Master File'].PURPVIDX AS 'PM Class Master File-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PURPVIDX = ['Account Index Master'].ACTINDX | ||||||
42 | CHEKBKID ![]() | Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PM Class Master File'].CHEKBKID AS 'PM Class Master File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Class Master File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
43 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
44 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
45 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['PM Class Master File'].RATETPID AS 'PM Class Master File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PM Class Master File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
46 | Revalue_Vendor ![]() | Revalue Vendor | CB Revalue Vendor | Boolean | 0 | |
47 | Post_Results_To ![]() | Post Results To | GB | Integer | 0 | |
48 | FREEONBOARD ![]() | Free On Board | DDL_Free_On_Board | Integer | 0 | |
49 | DISGRPER ![]() | Discount Grace Period | INT2_U0 | Integer | 2 | |
50 | DUEGRPER ![]() | Due Date Grace Period | INT2_U0 | Integer | 2 | |
51 | TaxInvRecvd ![]() | Tax Invoice Received | CB_Tax_Invoice_Received | Boolean | 0 | |
52 | CBVAT ![]() | Cash Based VAT | CB_CashBasedVAT | Boolean | 0 | |
53 | ONEPAYPERVENDINV ![]() | One Pay Per Vendor Invoice | GB | Integer | 0 | |
54 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |