PM20200 - PM Distribution OPEN OPEN Temporary File
Dynamics GP table PM20200 (PM Distribution OPEN OPEN Temporary File) contains 18 columns including KEYSOURC, VCHRNMBR, DOCTYPE....
SQL Query Builder
18 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| KEYSOURC | Key Source | String | 42 | ||
| 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 | |||||
| DSTSQNUM | Distribution Sequence Number | Long Integer | 4 | ||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| DSTINDX | Distribution Account Index | Long Integer | 4 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| APTVCHNM | Apply To Voucher Number | String | 22 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| CHANGED | Changed | Boolean | 2 | ||
| USERID | User ID | String | 16 | ||
| 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 | |||||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| ORCRDAMT | Originating Credit Amount | Currency | 10 | ||
| ORDBTAMT | Originating Debit Amount | Currency | 10 | ||
Related Tables
Tables that share columns with PM20200. Click "Join" to add to your query.