GP Tables

PM10000 - PM Transaction WORK File

Dynamics GP table PM10000 (PM Transaction WORK File) contains 96 columns including BACHNUMB, BCHSOURC, VCHNUMWK....

SQL Query Builder

96 Columns

Column Description Type Length
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
VCHNUMWK Voucher Number - WORK String 18
VENDORID Vendor ID String 16
DOCNUMBR Document 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
SOURCDOC Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo String 12
DOCAMNT Document Amount Currency 10
DOCDATE Document Date Date 4
PSTGDATE Posting Date Date 4
VADDCDPR Vendor Address Code - Primary String 16
VADCDTRO Vendor Address Code - Remit To String 16
PYMTRMID Payment Terms ID String 22
TAXSCHID Tax Schedule ID String 16
DUEDATE Due Date Date 4
DSCDLRAM Discount Dollar Amount Currency 10
DISCDATE Discount Date Date 4
PRCHAMNT Purchases Amount Currency 10
CHRGAMNT Charge Amount Currency 10
CASHAMNT Cash Amount Currency 10
CAMCBKID Cash Amount Checkbook ID String 16
CDOCNMBR Cash Document Number String 22
CAMTDATE Cash Amount Date Date 4
CAMPMTNM Cash Amount Payment Number String 22
CHEKAMNT Check Amount Currency 10
CHAMCBID Check Amount Checkbook ID String 16
CHEKDATE Check Date Date 4
CAMPYNBR Check Amount Payment Number String 22
CRCRDAMT Credit Card Amount Currency 10
CCAMPYNM Credit Card Amount Payment Number String 22
CHEKNMBR Check Number String 22
CARDNAME Card Name String 16
CCRCTNUM Credit Card Receipt Number String 22
CRCARDDT Credit Card Date Date 4
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CHEKBKID Checkbook ID String 16
TRXDSCRN Transaction Description String 32
UN1099AM Unapplied 1099 Amount Currency 10
TRDISAMT Trade Discount Amount Currency 10
TAXAMNT Tax Amount Currency 10
FRTAMNT Freight Amount Currency 10
TEN99AMNT 1099 Amount Currency 10
MSCCHAMT Misc Charges Amount Currency 10
PORDNMBR Purchase Order Number String 22
SHIPMTHD Shipping Method String 16
DISAMTAV Discount Amount Available Currency 10
DISTKNAM Discount Taken Amount Currency 10
APDSTKAM Applied Discount Taken Amount Currency 10
WROFAMNT Write Off Amount Currency 10
CURTRXAM Current Trx Amount Currency 10
TXENGCLD Tax Engine Called Boolean 2
PMWRKMSG PM WORK Messages Long Integer 4
PMDSTMSG PM Distribution Messages Long Integer 4
GSTDSAMT GST Discount Amount Currency 10
PGRAMSBJ Percent Of Gross Amount Subject Integer 2
PPSAMDED PPS Amount Deducted Currency 10
PPSTAXRT PPS Tax Rate Integer 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
POSTED Posted Boolean 2
APPLDAMT Applied Amount Currency 10
VCHRNMBR Voucher Number String 22
CNTRLTYP Control Type Integer 2
Control Type values (3)
0 = Voucher types1 = Payment types2 = Printed alignment forms
MODIFDT Modified Date Date 4
MDFUSRID Modified User ID String 16
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
NOTEINDX Note Index Currency 10
BKTFRTAM Backout Freight Amount Currency 10
BKTMSCAM Backout Misc Amount Currency 10
BKTPURAM Backout Purchases Amount Currency 10
PCHSCHID Purchase Schedule ID String 16
FRTSCHID Freight Schedule ID String 16
MSCSCHID Misc Schedule ID String 16
PRINTED Printed Boolean 2
PRCTDISC Percent Discount Integer 2
RETNAGAM Retainage Amount Currency 10
ICTRX IC TRX Boolean 2
ICDISTS ICDists Boolean 2
PMICMSGS ICMessages1 The currency ID is missing.2 A destination company does not have access to this currency ID.3 The currency ID is inactive for a destination company.4 A rate type ID is missing for a destination company.5 Rate type ID is not associated with the currency ID for a destination company.6 An exchange table ID is missing for a destination company.7 A destination company does not have access to an exchange table ID.8 An exchange table ID is inactive for a destination company.9 An exchange rate does not exist for a destination company.10 An exchange rate has expired for a destination company.11 Cannot post intercompany multicurrency transactions to a recurring batch.12 A rounding account missing for a destination company.13 A distribution type is invalid for a destination company distribution.14 A destination company distribution contains MDA information.15 A destination company ID does not exist; please select another company ID.16 The user does not have access to a destination company.17 A destination company does not have a functional currency set up.18 Destination functional currency doesn't match originating functional currency.19 No relationship exists between originating company and a destination company.20 Due To / Due From account not specified.21 The rounding account does not exist for the originating company.22 Unknown SQL error occurred.23 Intrastat information is missing or invalid.24 The goods value for Intrastat exceeds the document total.25 Transaction has successfully posted. Long Integer 4
Tax_Date Tax Date Date 4
PRCHDATE Purchase Date Date 4
CORRCTN Correction Boolean 2
SIMPLIFD Simplified Boolean 2
CORRNXST Correction to Nonexisting Transaction Boolean 2
VCHRNCOR Voucher Number Corrected String 22
PMWRKMS2 PM WORK Messages 2 Long Integer 4
BNKRCAMT Bank Receipts Amount Currency 10
APLYWITH Apply Withholding Boolean 2
Electronic Electronic Boolean 2
ECTRX EC Transaction Boolean 2
DocPrinted DocPrinted Boolean 2
TaxInvReqd Tax Invoice Required Boolean 2
BackoutTradeDisc Backout Trade Discount Amount Currency 10
CBVAT Cash Based VAT Boolean 2
TEN99TYPE 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous Integer 2
1099 Type values (5)
1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation
TEN99BOXNUMBER 1099 Box Number Integer 2

Related Tables

Tables that share columns with PM10000. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27

DOCDATE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP21

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

BCHSOURC

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27

DOCTYPE

ASIEXP09 ASIEXP10 ASIEXP18 ASIEXP21 ASIEXP25 ASIEXP26 ASIEXP29 EDCEI016

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15