PM10801 - PM Payment Stub Duplicate
Dynamics GP table PM10801 (PM Payment Stub Duplicate) contains 33 columns including PMNTNMBR, SEQNUMBR, DSTSQNUM....
SQL Query Builder
33 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PMNTNMBR | Payment Number | String | 22 | |
| SEQNUMBR | Sequence Number | Long Integer | 4 | |
| DSTSQNUM | Distribution Sequence Number | Long Integer | 4 | |
| DiscTknTot | Discount Taken Total | Currency | 10 | |
| NetCkAmt | Net Check Amount | Currency | 10 | |
| PdTot | Paid Total | Currency | 10 | |
| NegTot | Negative Total | Currency | 10 | |
| CrdDocAmt | Credit Document Amount | Currency | 10 | |
| TotDocAmt | Total Document Amount | Currency | 10 | |
| WrOffTot | Write Off Total | Currency | 10 | |
| CrdtDesc | Credit Description | String | 32 | |
| TRXDSCRN | Transaction Description | String | 32 | |
| PrtOnStb | Print On Stub | Boolean | 2 | |
| APTVCHNM | Apply To Voucher Number | String | 22 | |
| DOCNUMBR | Document Number | String | 22 | |
| DOCDATE | Document Date | Date | 4 | |
| AMNTPAID | Amount Paid | Currency | 10 | |
| CRDTAMNT | Credit Amount | Currency | 10 | |
| DocDueDate | Document Due Date | Date | 4 | |
| DOCAMNT | Document Amount | Currency | 10 | |
| DISCDATE | Discount Date | Date | 4 | |
| DISTKNAM | Discount Taken Amount | Currency | 10 | |
| WROFAMNT | Write Off Amount | Currency | 10 | |
| PPSAMDED | PPS Amount Deducted | Currency | 10 | |
| GSTDSAMT | GST Discount Amount | Currency | 10 | |
| APFVCHNM | Apply From Voucher Number | String | 22 | |
| APFRDCTY | Apply From Document Type | Integer | 2 | |
| APTODCTY | Apply To Document Type | Integer | 2 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| Outstanding_Amount | Outstanding Amount | Currency | 10 | |
| Net_Paid_Amount | Net Paid Amount | Currency | 10 | |
| VCHRNMBR | Voucher Number | String | 22 | |
| PONUMBER | PO Number | String | 18 |
Related Tables
Tables that share columns with PM10801. Click "Join" to add to your query.