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 TypeSQL DB LengthKeyable Length
1VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
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 IDSTR_15_Vendor_IDString1615
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 TypeDDL_Document_TypeInteger20

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
4DOCDATE SearchDocument DateDTDate48
5DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
6DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
7CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
8DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
9DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency1017
10DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
11BACHNUMB SearchBatch NumberSTR15_LBAUString1615
12TRXSORCE SearchTRX SourceSTR13String1413
13BCHSOURC SearchBatch SourceSTR15String1615
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 DateDTDate48
15DUEDATE SearchDue DateDTDate48
16PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
17TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
18WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
19DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
20TRXDSCRN SearchTransaction DescriptionSTR30String3230
21UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency1017
22BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
23BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
24BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
25VOIDED SearchVoidedCBBoolean20
26HOLD SearchHoldCB_HoldBoolean20
27CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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 OffDTDate48
29PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
30PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
31PGRAMSBJ SearchPercent Of Gross Amount SubjectINT5_RBS2_U%Integer25
32GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
33POSTEDDT SearchPosted DateDATEDate46
34PTDUSRID SearchPosted User IDSTR15String1615
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 DateDTDate48
36MDFUSRID SearchModified User IDSTR15String1615
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 TypeGBInteger20

Click to show/hide Payment Entry Type


0	Check
1	Cash
2	Credit Card
38CARDNAME SearchCard NameSTR15_Card_NameString1615
39PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency1017
40TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
41MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
42FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
43TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
44TTLPYMTS SearchTotal PaymentsDLR19_RBS0_UTR$Currency1019
45CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IDSTR20_Payment_Terms_IDString2220
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 MethodSTR15_Shipping_MethodString1615
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 IDSTR15_Tax_Schedule_IDString1615
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 IDSTR15_LBAUString1615
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 IDSTR15_LBAUString1615
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 IDSTR15_LBAUString1615
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 DateDTDate48
53DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
54CNTRLTYP SearchControl TypeINT1Integer21
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 IndexDLR14Currency1014
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 DiscountINT5_%2Integer25
57RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
58VOIDPDATE SearchVoid GL Posting DateDTDate48
59ICTRX SearchIC TRXCB_IC_TRXBoolean20

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
60Tax_Date SearchTax DateDTDate48
61PRCHDATE SearchPurchase DateDTDate48
62CORRCTN SearchCorrectionCB_CorrectionBoolean20
63SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
64APLYWITH SearchApply WithholdingBooleanBoolean20
65Electronic SearchElectronicCB_ElectronicBoolean20
66ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
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 SearchDocPrintedCB_DocPrintedBoolean20

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
68TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
69VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
70BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
71CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
72VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
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 Type1099_TypeInteger20
74TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger20
75PONUMBER SearchPO NumberSTR17_POP_NumberString1817
76Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
77InvoiceReceiptDate SearchInvoice Receipt DateDTDate48
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.
78DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
79DEX_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.

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

Leave a Reply

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