Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM30800
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Tax Invoices Group Display Name: Payables Transaction Logical File
Physical Name: PM30800
Technical Name: PM_Tax_Invoices
Group Technical Name: PM_Transaction_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 Tax Invoices'].VENDORID AS 'PM Tax Invoices-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM30800 AS ['PM Tax Invoices']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Tax Invoices'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['PM Tax Invoices'].VCHRNMBR AS 'PM Tax Invoices-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM30800 AS ['PM Tax Invoices']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Tax Invoices'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Tax Invoices'].DOCTYPE = ['PM Key Master File'].DOCTYPE | ||||||
| 3 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo | ||||||
| 4 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 5 | POPRCTNM | POP Receipt Number | String | STR17_POP_Number | 17 | |
| 6 | Tax_Date | Tax Date | Date | DT | 8 | |
| 7 | TaxInvRecvd | Tax Invoice Received | Boolean | CB_Tax_Invoice_Received | 0 | |
| 8 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |