PM30200 - PM Paid Transaction History File
Dynamics GP table PM30200 (PM Paid Transaction History File) contains 75 columns including VCHRNMBR, VENDORID, DOCTYPE....
SQL Query Builder
75 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| VCHRNMBR | Voucher Number | String | 22 | ||
| VENDORID | Vendor ID | String | 16 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| DOCDATE | Document Date | Date | 4 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| DOCAMNT | Document Amount | Currency | 10 | ||
| CURTRXAM | Current Trx Amount | Currency | 10 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| DISCAMNT | Discount Amount | Currency | 10 | ||
| DSCDLRAM | Discount Dollar Amount | Currency | 10 | ||
| BACHNUMB | Batch Number | String | 16 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| DISCDATE | Discount Date | Date | 4 | ||
| DUEDATE | Due Date | Date | 4 | ||
| PORDNMBR | Purchase Order Number | String | 22 | ||
| TEN99AMNT | 1099 Amount | Currency | 10 | ||
| WROFAMNT | Write Off Amount | Currency | 10 | ||
| DISAMTAV | Discount Amount Available | Currency | 10 | ||
| TRXDSCRN | Transaction Description | String | 32 | ||
| UN1099AM | Unapplied 1099 Amount | Currency | 10 | ||
| BKTPURAM | Backout Purchases Amount | Currency | 10 | ||
| BKTFRTAM | Backout Freight Amount | Currency | 10 | ||
| BKTMSCAM | Backout Misc Amount | Currency | 10 | ||
| VOIDED | Voided | Boolean | 2 | ||
| HOLD | Hold | Boolean | 2 | ||
Hold Status values (2) 0 = Not on hold1 = On hold | |||||
| CHEKBKID | Checkbook ID | String | 16 | ||
| DINVPDOF | Date Invoice Paid Off | Date | 4 | ||
| PPSAMDED | PPS Amount Deducted | Currency | 10 | ||
| PPSTAXRT | PPS Tax Rate | Integer | 2 | ||
| PGRAMSBJ | Percent Of Gross Amount Subject | Integer | 2 | ||
| GSTDSAMT | GST Discount Amount | Currency | 10 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| PTDUSRID | Posted User ID | String | 16 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| MDFUSRID | Modified User ID | String | 16 | ||
| PYENTTYP | Payment Entry Type | Integer | 2 | ||
Payment Type values (4) 0 = Check1 = Cash2 = Credit Card3 = EFT | |||||
| CARDNAME | Card Name | String | 16 | ||
| PRCHAMNT | Purchases Amount | Currency | 10 | ||
| TRDISAMT | Trade Discount Amount | Currency | 10 | ||
| MSCCHAMT | Misc Charges Amount | Currency | 10 | ||
| FRTAMNT | Freight Amount | Currency | 10 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| TTLPYMTS | Total Payments | Currency | 10 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| PYMTRMID | Payment Terms ID | String | 22 | ||
| SHIPMTHD | Shipping Method | String | 16 | ||
| TAXSCHID | Tax Schedule ID | String | 16 | ||
| PCHSCHID | Purchase Schedule ID | String | 16 | ||
| FRTSCHID | Freight Schedule ID | String | 16 | ||
| MSCSCHID | Misc Schedule ID | String | 16 | ||
| PSTGDATE | Posting Date | Date | 4 | ||
| DISAVTKN | Discount Available Taken | Currency | 10 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| NOTEINDX | Note Index | Currency | 10 | ||
| PRCTDISC | Percent Discount | Integer | 2 | ||
| RETNAGAM | Retainage Amount | Currency | 10 | ||
| VOIDPDATE | Void GL Posting Date | Date | 4 | ||
| ICTRX | IC TRX | Boolean | 2 | ||
| Tax_Date | Tax Date | Date | 4 | ||
| PRCHDATE | Purchase Date | Date | 4 | ||
| CORRCTN | Correction | Boolean | 2 | ||
| SIMPLIFD | Simplified | Boolean | 2 | ||
| APLYWITH | Apply Withholding | Boolean | 2 | ||
| Electronic | Electronic | Boolean | 2 | ||
| ECTRX | EC Transaction | Boolean | 2 | ||
| DocPrinted | DocPrinted | Boolean | 2 | ||
| TaxInvReqd | Tax Invoice Required | Boolean | 2 | ||
| VNDCHKNM | Vendor Check Name | String | 66 | ||
| BackoutTradeDisc | Backout Trade Discount Amount | Currency | 10 | ||
| CBVAT | Cash Based VAT | Boolean | 2 | ||
| VADCDTRO | Vendor Address Code - Remit To | String | 16 | ||
| TEN99TYPE | 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous | Integer | 2 | ||
1099 Type values (5) 1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation | |||||
| TEN99BOXNUMBER | 1099 Box Number | Integer | 2 | ||
| PONUMBER | PO Number | String | 18 | ||
Related Tables
Tables that share columns with PM30200. Click "Join" to add to your query.