CM00001 - CM_DepRcpt_RGLCash_LINE_TEMP | Prospr

CM00001 - CM_DepRcpt_RGLCash_LINE_TEMP

Select * from CM00001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
depositnumber	Deposit Number	String	22	View
RCPTNMBR	Receipt Number	String	22	View
CURNCYID	Currency ID	String	16	View
ACTINDX	Account Index	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
DSCRIPTN	Description	String	32	View
REFRENCE	Reference	String	32	View
GLPOSTDT	GL Posting Date	Date	4	View
VOIDED	Voided	Boolean	2	View
CURRNIDX	Currency Index	Integer	2	View
DECPLACS	Decimal Places	Integer	2	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
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View