PM10201 - PM Payment Apply To Work File
Dynamics GP table PM10201 (PM Payment Apply To Work File) contains 34 columns including DiscTknTot, NetCkAmt, PdTot....
SQL Query Builder
34 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| 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 | ||
| PMNTNMBR | Payment Number | String | 22 | ||
| KEYFIELD | Key Field | String | 22 | ||
| APFVCHNM | Apply From Voucher Number | String | 22 | ||
| APTVCHNM | Apply To Voucher Number | String | 22 | ||
| APFRDCTY | Apply From Document Type | Integer | 2 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| 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 | ||
| 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 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| Selected_To_Print | Selected To Print | Boolean | 2 | ||
| PONUMBER | PO Number | String | 18 | ||
Related Tables
Tables that share columns with PM10201. Click "Join" to add to your query.