PM20000 - PM Transaction OPEN File | Prospr - Dynamics GP Table Reference

PM20000 - PM Transaction OPEN File

Query Builder

Select * from PM20000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VCHRNMBR	Voucher Number	String	22	View
VENDORID	Vendor ID	String	16	View
DOCTYPE	Document Type	Integer	2	View
DOCDATE	Document Date	Date	4	View
DOCNUMBR	Document Number	String	22	View
DOCAMNT	Document Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISCAMNT	Discount Amount	Currency	10	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
BACHNUMB	Batch Number	String	16	View
TRXSORCE	TRX Source	String	14	View
BCHSOURC	Batch Source	String	16	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
PORDNMBR	Purchase Order Number	String	22	View
TEN99AMNT	1099 Amount	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
DISAMTAV	Discount Amount Available	Currency	10	View
TRXDSCRN	Transaction Description	String	32	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
VOIDED	Voided	Boolean	2	View
HOLD	Hold	Boolean	2	View
CHEKBKID	Checkbook ID	String	16	View
DINVPDOF	Date Invoice Paid Off	Date	4	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
PGRAMSBJ	Percent Of Gross Amount Subject	Integer	2	View
GSTDSAMT	GST Discount Amount	Currency	10	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
PYENTTYP	Payment Entry Type	Integer	2	View
CARDNAME	Card Name	String	16	View
PRCHAMNT	Purchases Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
TTLPYMTS	Total Payments	Currency	10	View
CURNCYID	Currency ID	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
SHIPMTHD	Shipping Method	String	16	View
TAXSCHID	Tax Schedule ID	String	16	View
PCHSCHID	Purchase Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
PSTGDATE	Posting Date	Date	4	View
DISAVTKN	Discount Available Taken	Currency	10	View
CNTRLTYP	Control Type	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
PRCTDISC	Percent Discount	Integer	2	View
RETNAGAM	Retainage Amount	Currency	10	View
ICTRX	IC TRX	Boolean	2	View
Tax_Date	Tax Date	Date	4	View
PRCHDATE	Purchase Date	Date	4	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	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
VNDCHKNM	Vendor Check Name	String	66	View
BackoutTradeDisc	Backout Trade Discount Amount	Currency	10	View
CBVAT	Cash Based VAT	Boolean	2	View
VADCDTRO	Vendor Address Code - Remit To	String	16	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
PONUMBER	PO Number	String	18	View

PM20000 - PM Transaction OPEN File

Query Builder

Customer Service

Information

My Account

Contact Us