PM10900 - Void Payment WORK Temporary File
Dynamics GP table PM10900 (Void Payment WORK Temporary File) contains 43 columns including USERID, TIME1, VENDORID....
SQL Query Builder
43 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 | ||
| ORDOCAMT | Originating Document Amount | Currency | 10 | ||
| CURTRXAM | Current Trx Amount | Currency | 10 | ||
| ORCTRXAM | Originating Current Trx Amount | Currency | 10 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| ORDISTKN | Originating 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 | ||
| OR1099AM | Originating 1099 Amount | Currency | 10 | ||
| WROFAMNT | Write Off Amount | Currency | 10 | ||
| ORWROFAM | Originating Write Off Amount | Currency | 10 | ||
| DISAMTAV | Discount Amount Available | Currency | 10 | ||
| ODISAMTAV | Originating Discount Amount Available | Currency | 10 | ||
| PRCHAMNT | Purchases Amount | Currency | 10 | ||
| OPURAMT | Originating Purchases Amount | Currency | 10 | ||
| TRDISAMT | Trade Discount Amount | Currency | 10 | ||
| ORTDISAM | Originating Trade Discount Amount | Currency | 10 | ||
| MSCCHAMT | Misc Charges Amount | Currency | 10 | ||
| ORMISCAMT | Originating Misc Amount | Currency | 10 | ||
| FRTAMNT | Freight Amount | Currency | 10 | ||
| ORFRTAMT | Originating Freight Amount | Currency | 10 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| ORTAXAMT | Originating Tax Amount | Currency | 10 | ||
| TTLPYMTS | Total Payments | Currency | 10 | ||
| OTOTPAY | Originating Total Payments | Currency | 10 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| CHANGED | Changed | Boolean | 2 | ||
| PSTGSTUS | Posting Status1 = Work2 = Open3 = History4 = Originating | Integer | 2 | ||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| 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 | ||
Related Tables
Tables that share columns with PM10900. Click "Join" to add to your query.