PM10100 - PM Distribution WORK OPEN
Dynamics GP table PM10100 (PM Distribution WORK OPEN) contains 35 columns including VCHRNMBR, DSTSQNUM, CNTRLTYP....
SQL Query Builder
35 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| 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 | ||
| INTERID | Intercompany ID | String | 6 | ||
| 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 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| EXGTBLID | Exchange Table ID | String | 16 | ||
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | ||
| EXCHDATE | Exchange Date | Date | 4 | ||
| TIME1 | Time | Time | 4 | ||
| RTCLCMTD | Rate Calculation Method | Integer | 2 | ||
| DECPLACS | Decimal Places | Integer | 2 | ||
| EXPNDATE | Expiration Date | Date | 4 | ||
| ICCURRID | ICCurrencyID | String | 16 | ||
| ICCURRIX | ICCurrencyIndex | Integer | 2 | ||
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | ||
| MCTRXSTT | MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. | Integer | 2 | ||
| CorrespondingUnit | CorrespondingUnit | String | 6 | ||
Related Tables
Tables that share columns with PM10100. Click "Join" to add to your query.