PM10000 - PM Transaction WORK File | Prospr - Dynamics GP Table Reference

PM10000 - PM Transaction WORK File

Query Builder

Select * from PM10000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
VCHNUMWK	Voucher Number - WORK	String	18	View
VENDORID	Vendor ID	String	16	View
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
DOCAMNT	Document Amount	Currency	10	View
DOCDATE	Document Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
VADDCDPR	Vendor Address Code - Primary	String	16	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
TAXSCHID	Tax Schedule ID	String	16	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
PRCHAMNT	Purchases Amount	Currency	10	View
CHRGAMNT	Charge Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
CAMCBKID	Cash Amount Checkbook ID	String	16	View
CDOCNMBR	Cash Document Number	String	22	View
CAMTDATE	Cash Amount Date	Date	4	View
CAMPMTNM	Cash Amount Payment Number	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CHAMCBID	Check Amount Checkbook ID	String	16	View
CHEKDATE	Check Date	Date	4	View
CAMPYNBR	Check Amount Payment Number	String	22	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CCAMPYNM	Credit Card Amount Payment Number	String	22	View
CHEKNMBR	Check Number	String	22	View
CARDNAME	Card Name	String	16	View
CCRCTNUM	Credit Card Receipt Number	String	22	View
CRCARDDT	Credit Card Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View
TRXDSCRN	Transaction Description	String	32	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
PORDNMBR	Purchase Order Number	String	22	View
SHIPMTHD	Shipping Method	String	16	View
DISAMTAV	Discount Amount Available	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
APDSTKAM	Applied Discount Taken Amount	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
PMWRKMSG	PM WORK Messages	Long Integer	4	View
PMDSTMSG	PM Distribution Messages	Long Integer	4	View
GSTDSAMT	GST Discount Amount	Currency	10	View
PGRAMSBJ	Percent Of Gross Amount Subject	Integer	2	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
POSTED	Posted	Boolean	2	View
APPLDAMT	Applied Amount	Currency	10	View
VCHRNMBR	Voucher Number	String	22	View
CNTRLTYP	Control Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
PCHSCHID	Purchase Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
PRINTED	Printed	Boolean	2	View
PRCTDISC	Percent Discount	Integer	2	View
RETNAGAM	Retainage Amount	Currency	10	View
ICTRX	IC TRX	Boolean	2	View
ICDISTS	ICDists	Boolean	2	View
PMICMSGS	ICMessages 1 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	View
Tax_Date	Tax Date	Date	4	View
PRCHDATE	Purchase Date	Date	4	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
CORRNXST	Correction to Nonexisting Transaction	Boolean	2	View
VCHRNCOR	Voucher Number Corrected	String	22	View
PMWRKMS2	PM WORK Messages 2	Long Integer	4	View
BNKRCAMT	Bank Receipts Amount	Currency	10	View
APLYWITH	Apply Withholding	Boolean	2	View
Electronic	Electronic	Boolean	2	View
ECTRX	EC Transaction	Boolean	2	View
DocPrinted	DocPrinted	Boolean	2	View
TaxInvReqd	Tax Invoice Required	Boolean	2	View
BackoutTradeDisc	Backout Trade Discount Amount	Currency	10	View
CBVAT	Cash Based VAT	Boolean	2	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
TEN99BOXNUMBER	1099 Box Number	Integer	2	View

PM10000 - PM Transaction WORK File

Query Builder

Customer Service

Information

My Account

Contact Us