CM20501 - CM Reconcile Adjustments | Prospr - Dynamics GP Table Reference

CM20501 - CM Reconcile Adjustments

Query Builder

Select * from CM20501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CHEKBKID	Checkbook ID	String	16	View
CMRECNUM	Record Number	Currency	10	View
RECONUM	Reconcile Number	Currency	10	View
DSTSQNUM	Distribution Sequence Number	Long Integer	4	View
DSTINDX	Distribution Account Index	Long Integer	4	View
TRXDATE	TRX Date	Date	4	View
CMTrxType	CM Trx Type	Integer	2	View
TRXAMNT	TRX Amount	Currency	10	View
POSTED	Posted	Boolean	2	View
DistRef	Distribution Reference	String	32	View
CMTrxNum	CM Trx Number	String	22	View
GLPOSTDT	GL Posting Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	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
EXPNDATE	Expiration Date	Date	4	View
DECPLCUR	Decimal Places Currency	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

CM20501 - CM Reconcile Adjustments

Query Builder

Customer Service

Information

My Account

Contact Us