Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM20000
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Transaction OPEN File Group Display Name: Payables Transaction Logical File
Physical Name: PM20000
Technical Name: PM_Transaction_OPEN
Group Technical Name: PM_Transaction_Logical_File
| 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 Transaction OPEN File'].VCHRNMBR AS 'PM Transaction OPEN File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Transaction OPEN File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Transaction OPEN 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 Transaction OPEN File'].VENDORID AS 'PM Transaction OPEN File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].CHEKBKID AS 'PM Transaction OPEN File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].PTDUSRID AS 'PM Transaction OPEN File-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].MDFUSRID AS 'PM Transaction OPEN File-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].CURNCYID AS 'PM Transaction OPEN File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].PYMTRMID AS 'PM Transaction OPEN File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].SHIPMTHD AS 'PM Transaction OPEN File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].TAXSCHID AS 'PM Transaction OPEN File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].PCHSCHID AS 'PM Transaction OPEN File-Purchase Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].FRTSCHID AS 'PM Transaction OPEN File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].MSCSCHID AS 'PM Transaction OPEN File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction OPEN 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 Transaction OPEN File'].NOTEINDX AS 'PM Transaction OPEN File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PM Transaction OPEN File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 56 | PRCTDISC | Percent Discount | Integer | INT5_%2 | 5 | |
| 57 | RETNAGAM | Retainage Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 58 | ICTRX | IC TRX | Boolean | CB_IC_TRX | 0 | |
Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany | ||||||
| 59 | Tax_Date | Tax Date | Date | DT | 8 | |
| 60 | PRCHDATE | Purchase Date | Date | DT | 8 | |
| 61 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
| 62 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 63 | BNKRCAMT | Bank Receipts Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 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 Transaction OPEN File'].VADCDTRO AS 'PM Transaction OPEN File-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
PM20000 AS ['PM Transaction OPEN File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['PM Transaction OPEN File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['PM Transaction OPEN 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 | |