PM10100 - PM Distribution WORK OPEN | Prospr - Dynamics GP Table Reference

PM10100 - PM Distribution WORK OPEN

Query Builder

Select * from PM10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VCHRNMBR	Voucher Number	String	22	View
DSTSQNUM	Distribution Sequence Number	Long Integer	4	View
CNTRLTYP	Control Type	Integer	2	View
CRDTAMNT	Credit Amount	Currency	10	View
DEBITAMT	Debit Amount	Currency	10	View
DSTINDX	Distribution Account Index	Long Integer	4	View
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	Integer	2	View
CHANGED	Changed	Boolean	2	View
USERID	User ID	String	16	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
VENDORID	Vendor ID	String	16	View
TRXSORCE	TRX Source	String	14	View
PSTGDATE	Posting Date	Date	4	View
INTERID	Intercompany ID	String	6	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
APTVCHNM	Apply To Voucher Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
SPCLDIST	Specialized Distribution	Integer	2	View
DistRef	Distribution Reference	String	32	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DECPLACS	Decimal Places	Integer	2	View
EXPNDATE	Expiration Date	Date	4	View
ICCURRID	ICCurrencyID	String	16	View
ICCURRIX	ICCurrencyIndex	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = 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	View
CorrespondingUnit	CorrespondingUnit	String	6	View

PM10100 - PM Distribution WORK OPEN

Query Builder

Customer Service

Information

My Account

Contact Us