CM10100 - CM Deposit Work | Prospr - Dynamics GP Table Reference

CM10100 - CM Deposit Work

Query Builder

Select * from CM10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CHEKBKID	Checkbook ID	String	16	View
depositnumber	Deposit Number	String	22	View
DEPTYPE	Deposit Type	Integer	2	View
DEPWTHRCT	Deposit With Receipts	Boolean	2	View
DEPDATE	Deposit Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
DepAmt	Deposit Amount	Currency	10	View
MDFUSRID	Modified User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
CURNCYID	Currency ID	String	16	View
DSCRIPTN	Description	String	32	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
NOTEINDX	Note Index	Currency	10	View
RCRDSTTS	Record Status	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
CURRNIDX	Currency Index	Integer	2	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

CM10100 - CM Deposit Work

Query Builder

Customer Service

Information

My Account

Contact Us