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