PM Class Master File (PM00100)

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
Physical Name: PM00100
Technical Name: PM_Class_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
1VNDCLSID SearchVendor Class IDSTR10_Class_IDString1210
2VNDCLDSC SearchVendor Class DescriptionSTR30String3230
3DEFLTCLS SearchDefault ClassCB_DefaultBoolean20
4MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
5MXINVAMT SearchMaximum Invoice AmountDLR17_$U2Currency1017
6WRITEOFF SearchWriteoffGBInteger20
7CREDTLMT SearchCredit LimitGBInteger20
8TEN99TYPE Search1099 Type1099_TypeInteger20
9PTCSHACF SearchPost To Cash Account FromGBInteger20
10MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
11MINORDER SearchMinimum OrderDLR17_$U2Currency1017
12CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
13PYMNTPRI SearchPayment PrioritySTR3String43
14SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['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
15PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['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
16MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
17MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
18MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
19CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['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
20TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['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
21KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
22KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
23KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
24KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
25TRDDISCT SearchTrade DiscountINT4_%2Integer24
26USERDEF1 SearchUser Defined 1STR20String2220
27USERDEF2 SearchUser Defined 2STR20String2220
28PMAPINDX SearchPM AP IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
29PMCSHIDX SearchPM Cash IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
30PMDAVIDX SearchPM Discount Available IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
31PMDTKIDX SearchPM Discount Taken IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
32PMFINIDX SearchPM Finance Charge IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
33PMMSCHIX SearchPM Misc Charges IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
34PMFRTIDX SearchPM Freight IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
35PMTAXIDX SearchPM Tax IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
36PMWRTIDX SearchPM Write Offs IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
37PMPRCHIX SearchPM Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
38PMRTNGIX SearchPM Retainage IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
39PMTDSCIX SearchPM Trade Discount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
40ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
41PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
42CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['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
43MODIFDT SearchModified DateDTDate48
44CREATDDT SearchCreated DateDTDate48
45RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['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
46Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean20
47Post_Results_To SearchPost Results ToGBInteger20
48FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
49DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
50DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
51TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
52CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
53ONEPAYPERVENDINV SearchOne Pay Per Vendor InvoiceGBInteger20
54DEX_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 *