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 Group Display Name: Payables History Logical Files
Physical Name: PM30200
Technical Name: PM_Paid_Transaction_HIST
Group Technical Name: PM_History_Logical_Files
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['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 | ||||||
2 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['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 | ||||||
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 | DOCDATE | Document Date | Date | DT | 8 | |
5 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
6 | DOCAMNT | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
7 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
8 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
9 | DISCAMNT | Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
10 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
11 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
12 | TRXSORCE | TRX Source | String | STR13 | 13 | |
13 | BCHSOURC | Batch Source | String | STR15 | 15 | |
Records whether the transaction was entered in a batch or not.Click to show/hide the Batch SourcesPM_Trxent Batch
XXPM_Trxent No batch (real-time)
| ||||||
14 | DISCDATE | Discount Date | Date | DT | 8 | |
15 | DUEDATE | Due Date | Date | DT | 8 | |
16 | PORDNMBR | Purchase Order Number | String | Purchase Order Number | 20 | |
17 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
18 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
19 | DISAMTAV | Discount Amount Available | Currency | DLR17_RBS0_UTR$ | 17 | |
20 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |
21 | UN1099AM | Unapplied 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
22 | BKTPURAM | Backout Purchases Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
23 | BKTFRTAM | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
24 | BKTMSCAM | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
25 | VOIDED | Voided | Boolean | CB | 0 | |
26 | HOLD | Hold | Boolean | CB_Hold | 0 | |
27 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['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 | ||||||
28 | DINVPDOF | Date Invoice Paid Off | Date | DT | 8 | |
29 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
30 | PPSTAXRT | PPS Tax Rate | Integer | INT5_%2 | 5 | |
31 | PGRAMSBJ | Percent Of Gross Amount Subject | Integer | INT5_RBS2_U% | 5 | |
32 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
33 | POSTEDDT | Posted Date | Date | DATE | 6 | |
34 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
35 | MODIFDT | Modified Date | Date | DT | 8 | |
36 | MDFUSRID | Modified User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
37 | PYENTTYP | Payment Entry Type | Integer | GB | 0 | |
Click to show/hide Payment Entry Type
0 Check
1 Cash
2 Credit Card | ||||||
38 | CARDNAME | Card Name | String | STR15_Card_Name | 15 | |
39 | PRCHAMNT | Purchases Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
40 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
41 | MSCCHAMT | Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
42 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
43 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
44 | TTLPYMTS | Total Payments | Currency | DLR19_RBS0_UTR$ | 19 | |
45 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
46 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['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 | ||||||
47 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['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 | ||||||
48 | 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 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 | ||||||
49 | PCHSCHID | Purchase Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
50 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
51 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
52 | PSTGDATE | Posting Date | Date | DT | 8 | |
53 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
54 | CNTRLTYP | Control Type | Integer | INT1 | 1 | |
The Control Type records the type of transaction.
Click to show/hide Control Types0 Voucher types
1 Payment types
2 Printed alignment forms | ||||||
55 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
56 | PRCTDISC | Percent Discount | Integer | INT5_%2 | 5 | |
57 | RETNAGAM | Retainage Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
58 | VOIDPDATE | Void GL Posting Date | Date | DT | 8 | |
59 | ICTRX | IC TRX | Boolean | CB_IC_TRX | 0 | |
Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany | ||||||
60 | Tax_Date | Tax Date | Date | DT | 8 | |
61 | PRCHDATE | Purchase Date | Date | DT | 8 | |
62 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
63 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
64 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
65 | Electronic | Electronic | Boolean | CB_Electronic | 0 | |
66 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
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. | ||||||
67 | DocPrinted | DocPrinted | Boolean | CB_DocPrinted | 0 | |
Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
68 | TaxInvReqd | Tax Invoice Required | Boolean | CB_Tax_Invoice_Required | 0 | |
69 | VNDCHKNM | Vendor Check Name | String | STR64_Vendor_Name | 64 | |
70 | BackoutTradeDisc | Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
71 | CBVAT | Cash Based VAT | Boolean | CB_CashBasedVAT | 0 | |
72 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['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 | ||||||
73 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 | |
74 | TEN99BOXNUMBER | 1099 Box Number | Integer | DDL_1099_Box | 0 | |
75 | PONUMBER | PO Number | String | STR17_POP_Number | 17 | |
76 | Workflow_Status | Workflow Status | Integer | Workflow Status | 0 | |
77 | InvoiceReceiptDate | Invoice Receipt Date | Date | DT | 8 | |
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. | ||||||
78 | LNGDESC | Long Description2 | String | STR200 | 200 |