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 | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | VNDCLSID  | Vendor Class ID | STR10_Class_ID | String | 12 | 10 |
| 2 | VNDCLDSC | Vendor Class Description | STR30 | String | 32 | 30 |
| 3 | DEFLTCLS | Default Class | CB_Default | Boolean | 2 | 0 |
| 4 | MXIAFVND | Maximum Invoice Amount For Vendors | GB | Integer | 2 | 0 |
| 5 | MXINVAMT | Maximum Invoice Amount | DLR17_$U2 | Currency | 10 | 17 |
| 6 | WRITEOFF | Writeoff | GB | Integer | 2 | 0 |
| 7 | CREDTLMT | Credit Limit | GB | Integer | 2 | 0 |
| 8 | TEN99TYPE | 1099 Type | 1099_Type | Integer | 2 | 0 |
| 9 | PTCSHACF | Post To Cash Account From | GB | Integer | 2 | 0 |
| 10 | MXWOFAMT | Maximum Write Off Amount | DLR17_$U2 | Currency | 10 | 17 |
| 11 | MINORDER | Minimum Order | DLR17_$U2 | Currency | 10 | 17 |
| 12 | CRLMTDLR | Credit Limit Dollar | DLR17_$U2 | Currency | 10 | 17 |
| 13 | PYMNTPRI | Payment Priority | STR3 | String | 4 | 3 |
| 14 | SHIPMTHD | Shipping Method | STR15_Shipping_Method | String | 16 | 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 | 22 | 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 | 2 | 0 |
| 17 | MINPYDLR | Minimum Payment Dollar | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 18 | MINPYPCT | Minimum Payment Percent | INT5_%2 | Integer | 2 | 5 |
| 19 | CURNCYID | Currency ID | STR15_Currency_ID | String | 16 | 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 | 16 | 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 | 2 | 0 |
| 22 | KGLDSTHS | Keep GL Dist History | CB_Keep_GL_Dist_History | Boolean | 2 | 0 |
| 23 | KPERHIST | Keep Period History | CB_Keep_Period_History | Boolean | 2 | 0 |
| 24 | KPTRXHST | Keep Trx History | CB_Keep_Trx_History | Boolean | 2 | 0 |
| 25 | TRDDISCT | Trade Discount | INT4_%2 | Integer | 2 | 4 |
| 26 | USERDEF1 | User Defined 1 | STR20 | String | 22 | 20 |
| 27 | USERDEF2 | User Defined 2 | STR20 | String | 22 | 20 |
| 28 | PMAPINDX | PM AP Index | LI_14 | Long Integer | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 4 | 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 | 16 | 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 | 4 | 8 |
| 44 | CREATDDT | Created Date | DT | Date | 4 | 8 |
| 45 | RATETPID | Rate Type ID | STR15_Rate_Type_ID | String | 16 | 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 | 2 | 0 |
| 47 | Post_Results_To | Post Results To | GB | Integer | 2 | 0 |
| 48 | FREEONBOARD | Free On Board | DDL_Free_On_Board | Integer | 2 | 0 |
| 49 | DISGRPER | Discount Grace Period | INT2_U0 | Integer | 2 | 2 |
| 50 | DUEGRPER | Due Date Grace Period | INT2_U0 | Integer | 2 | 2 |
| 51 | TaxInvRecvd | Tax Invoice Received | CB_Tax_Invoice_Received | Boolean | 2 | 0 |
| 52 | CBVAT | Cash Based VAT | CB_CashBasedVAT | Boolean | 2 | 0 |
| 53 | ONEPAYPERVENDINV | One Pay Per Vendor Invoice | GB | Integer | 2 | 0 |
| 54 | DEX_ROW_ID | int | int | 10 | 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. | ||||||