Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00202
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Vendor Master Period Summary Group Display Name: Payables Vendor Master Logical File
Physical Name: PM00202
Technical Name: PM_Vendor_MSTR_Period_SUM
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 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PM Vendor Master Period Summary'].VENDORID AS 'PM Vendor Master Period Summary-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM00202 AS ['PM Vendor Master Period Summary']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Vendor Master Period Summary'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | PERIODID | Period ID | Integer | INT3 | 3 | |
| 3 | YEAR1 | Year | Integer | Year | 4 | |
| 4 | HISTTYPE | History Type | Integer | GB | 0 | |
| 5 | AMBLDLIF | Amount Billed LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 6 | AMTPDLIF | Amount Paid LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 7 | TEN99ALIF | 1099 Amount LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 8 | DISAVLIF | Discount Available LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 9 | DISTKNLF | Discount Taken LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 10 | DISLSTLF | Discount Lost LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 11 | FINCHLIF | Finance Charge LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 12 | WROFSLIF | Write Offs LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 13 | RTRNSLIF | Returns LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 14 | TRDTKLIF | Trade Discounts Taken LIFE | Currency | DLR19_RBSO_STR$ | 19 | |
| 15 | NFNCHLIF | Number of Finance Charges LIFE | Long Integer | LI_9U0 | 9 | |
| 16 | NOINVLIF | Number of Invoices LIFE | Long Integer | LI_9U0 | 9 | |
| 17 | Withholding_LIFE | Withholding LIFE | Currency | DLR19_RBS0_STR$ | 19 | |