PM30600 - PM Distribution History File
Dynamics GP table PM30600 (PM Distribution History File) contains 22 columns including DOCTYPE, VCHRNMBR, DSTSQNUM....
SQL Query Builder
22 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| 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 | ||
| DSTSQNUM | Distribution Sequence Number | Long Integer | 4 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| 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 | |||||
| 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 | |||||
| VENDORID | Vendor ID | String | 16 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| 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 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| ORCRDAMT | Originating Credit Amount | Currency | 10 | ||
| ORDBTAMT | Originating Debit Amount | Currency | 10 | ||
| APTVCHNM | Apply To Voucher Number | String | 22 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| SPCLDIST | Specialized Distribution | Integer | 2 | ||
| DistRef | Distribution Reference | String | 32 | ||
Related Tables
Tables that share columns with PM30600. Click "Join" to add to your query.