PM10901 - PM Void Transaction WORK Temporary File
Dynamics GP table PM10901 (PM Void Transaction WORK Temporary File) contains 29 columns including USERID, TIME1, VENDORID....
SQL Query Builder
29 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| USERID | User ID | String | 16 | ||
| TIME1 | Time | Time | 4 | ||
| 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 | |||||
| VCHRNMBR | Voucher Number | String | 22 | ||
| PMVDMSGS | PM Void Messages | Long Integer | 4 | ||
| 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 | ||
| DISCDATE | Discount Date | Date | 4 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| TEN99AMNT | 1099 Amount | Currency | 10 | ||
| WROFAMNT | Write Off Amount | Currency | 10 | ||
| DISAMTAV | Discount Amount Available | Currency | 10 | ||
| 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 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| PSTGDATE | Posting Date | Date | 4 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| DEYDESCR | Key Description | String | 32 | ||
| VOIDDATE | Void Date | Date | 4 | ||
| VADCDTRO | Vendor Address Code - Remit To | String | 16 | ||
Related Tables
Tables that share columns with PM10901. Click "Join" to add to your query.