CM00002 - CM Unreconciled TEMP | Prospr - Dynamics GP Table Reference

CM00002 - CM Unreconciled TEMP

Select * from CM00002

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMRECNUM	Record Number	Currency	10	View
RECONUM	Reconcile Number	Currency	10	View
CMTrxNum	CM Trx Number	String	22	View
CMTrxType	CM Trx Type	Integer	2	View
CMLinkID	CMLinkID	String	16	View
TRXDATE	TRX Date	Date	4	View
TRXAMNT	TRX Amount	Currency	10	View
clearedate	Cleared Date	Date	4	View
ClrdAmt	Cleared Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
paidtorcvdfrom	Paid ToRcvd From	String	66	View
DSCRIPTN	Description	String	32	View
DEPTYPE	Deposit Type	Integer	2	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
SRCDOCTYP	Source Doc Type	Integer	2	View
SRCDOCNUM	Source Doc Number	String	22	View
UPDATED	Updated	Boolean	2	View
RECONFLG	ReconcileFlag	Boolean	2	View
CHGFLAG	ChangedFlag	Boolean	2	View
MARKED	Marked	Boolean	2	View
USERID	User ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View