PM Paid Transaction History File (PM30200)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPM Paid Transaction History File (PM30200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM30200

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Paid Transaction History File
Physical Name: PM30200
Technical Name: PM_Paid_Transaction_HIST

Group Display Name: Payables History Logical Files
Group Technical Name: PM_History_Logical_Files

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].VCHRNMBR AS 'PM Paid Transaction History File-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['PM Paid Transaction History File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['PM Paid Transaction History File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
2VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].VENDORID AS 'PM Paid Transaction History File-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Paid Transaction History File'].VENDORID = ['PM Vendor Master File'].VENDORID
3DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
4DOCDATE SearchDocument DateDateDT8
5DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
6DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
7CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
8DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
9DISCAMNT SearchDiscount AmountCurrencyDLR17_RBS0_STR$17
10DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
11BACHNUMB SearchBatch NumberStringSTR15_LBAU15
12TRXSORCE SearchTRX SourceStringSTR1313
13BCHSOURC SearchBatch SourceStringSTR1515
Records whether the transaction was entered in a batch or not.

Click to show/hide the Batch Sources

PM_Trxent	Batch
XXPM_Trxent	No batch (real-time)
14DISCDATE SearchDiscount DateDateDT8
15DUEDATE SearchDue DateDateDT8
16PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
17TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
18WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
19DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
20TRXDSCRN SearchTransaction DescriptionStringSTR3030
21UN1099AM SearchUnapplied 1099 AmountCurrencyDLR17_RBS0_UTR$17
22BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
23BKTFRTAM SearchBackout Freight AmountCurrencyDLR19_RBS0_UTR$19
24BKTMSCAM SearchBackout Misc AmountCurrencyDLR19_RBS0_UTR$19
25VOIDED SearchVoidedBooleanCB0
26HOLD SearchHoldBooleanCB_Hold0
27CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].CHEKBKID AS 'PM Paid Transaction History File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM Paid Transaction History File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
28DINVPDOF SearchDate Invoice Paid OffDateDT8
29PPSAMDED SearchPPS Amount DeductedCurrencyDLR17_RBS0_UTR$17
30PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
31PGRAMSBJ SearchPercent Of Gross Amount SubjectIntegerINT5_RBS2_U%5
32GSTDSAMT SearchGST Discount AmountCurrencyDLR17_RBS0_STR$17
33POSTEDDT SearchPosted DateDateDATE6
34PTDUSRID SearchPosted User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].PTDUSRID AS 'PM Paid Transaction History File-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Paid Transaction History File'].PTDUSRID = ['Users Master'].USERID
35MODIFDT SearchModified DateDateDT8
36MDFUSRID SearchModified User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].MDFUSRID AS 'PM Paid Transaction History File-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Paid Transaction History File'].MDFUSRID = ['Users Master'].USERID
37PYENTTYP SearchPayment Entry TypeIntegerGB0

Click to show/hide Payment Entry Type


0	Check
1	Cash
2	Credit Card
38CARDNAME SearchCard NameStringSTR15_Card_Name15
39PRCHAMNT SearchPurchases AmountCurrencyDLR17_RBS0_UTR$17
40TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
41MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
42FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
43TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
44TTLPYMTS SearchTotal PaymentsCurrencyDLR19_RBS0_UTR$19
45CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].CURNCYID AS 'PM Paid Transaction History File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Paid Transaction History File'].CURNCYID = ['Currency Setup'].CURNCYID
46PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].PYMTRMID AS 'PM Paid Transaction History File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PM Paid Transaction History File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
47SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].SHIPMTHD AS 'PM Paid Transaction History File-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PM Paid Transaction History File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
48TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].TAXSCHID AS 'PM Paid Transaction History File-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Paid Transaction History File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49PCHSCHID SearchPurchase Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].PCHSCHID AS 'PM Paid Transaction History File-Purchase Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Paid Transaction History File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
50FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].FRTSCHID AS 'PM Paid Transaction History File-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Paid Transaction History File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
51MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].MSCSCHID AS 'PM Paid Transaction History File-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Paid Transaction History File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
52PSTGDATE SearchPosting DateDateDT8
53DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
54CNTRLTYP SearchControl TypeIntegerINT11
The Control Type records the type of transaction.

Click to show/hide Control Types

0	Voucher types
1	Payment types
2	Printed alignment forms
55NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].NOTEINDX AS 'PM Paid Transaction History File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PM Paid Transaction History File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
56PRCTDISC SearchPercent DiscountIntegerINT5_%25
57RETNAGAM SearchRetainage AmountCurrencyDLR17_RBS0_UTR$17
58VOIDPDATE SearchVoid GL Posting DateDateDT8
59ICTRX SearchIC TRXBooleanCB_IC_TRX0

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
60Tax_Date SearchTax DateDateDT8
61PRCHDATE SearchPurchase DateDateDT8
62CORRCTN SearchCorrectionBooleanCB_Correction0
63SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
64APLYWITH SearchApply WithholdingBooleanBoolean0
65Electronic SearchElectronicBooleanCB_Electronic0
66ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
67DocPrinted SearchDocPrintedBooleanCB_DocPrinted0

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
68TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
69VNDCHKNM SearchVendor Check NameStringSTR64_Vendor_Name64
70BackoutTradeDisc SearchBackout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
71CBVAT SearchCash Based VATBooleanCB_CashBasedVAT0
72VADCDTRO SearchVendor Address Code - Remit ToStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Paid Transaction History File'].VADCDTRO AS 'PM Paid Transaction History File-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM30200 AS ['PM Paid Transaction History File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Paid Transaction History File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Paid Transaction History File'].VENDORID = ['PM Address MSTR'].VENDORID
73TEN99TYPE Search1099 TypeInteger1099_Type0
74TEN99BOXNUMBER Search1099 Box NumberIntegerDDL_1099_Box0
75PONUMBER SearchPO NumberStringSTR17_POP_Number17
76Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
77InvoiceReceiptDate SearchInvoice Receipt DateDateDT8
Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
78LNGDESC SearchLong Description2StringSTR200200
azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPM Paid Transaction History File (PM30200)

Leave a Reply

Your email address will not be published. Required fields are marked *