CM00100 - CM Checkbook Master | Prospr - Dynamics GP Table Reference

CM00100 - CM Checkbook Master

Query Builder

Select * from CM00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CHEKBKID	Checkbook ID	String	16	View
DSCRIPTN	Description	String	32	View
BANKID	Bank ID	String	16	View
CURNCYID	Currency ID	String	16	View
ACTINDX	Account Index	Long Integer	4	View
BNKACTNM	Bank Account Number	String	16	View
NXTCHNUM	Next Check Number	String	22	View
Next_Deposit_Number	Next Deposit Number	String	22	View
INACTIVE	Inactive	Boolean	2	View
DYDEPCLR	Days Deposits To Clear	Integer	2	View
XCDMCHPW	Exceed Max Check Password	String	12	View
MXCHDLR	Maximum Check Dollar	Currency	10	View
DUPCHNUM	Duplicate Check Numbers	Boolean	2	View
OVCHNUM1	Override Check Number 1	Boolean	2	View
LOCATNID	Location ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
CMUSRDF1	CM User Defined 1	String	22	View
CMUSRDF2	CM User Defined 2	String	22	View
Last_Reconciled_Date	Last Reconciled Date	Date	4	View
Last_Reconciled_Balance	Last Reconciled Balance	Currency	10	View
CURRBLNC	Current Balance	Currency	10	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
Recond	Reconciled	Boolean	2	View
Reconcile_In_Progress	Reconcile In Progress	Currency	10	View
Deposit_In_Progress	Deposit In Progress	String	22	View
CHBKPSWD	Checkbook Password	String	16	View
CURNCYPD	Currency Paid	String	16	View
CRNCYRCD	Currency Received	String	16	View
ADPVADLR	Allow Deposit Variance Dollar	Currency	10	View
ADPVAPWD	Allow Deposit Variance Password	String	12	View
DYCHTCLR	Days Checks To Clear	Integer	2	View
CMPANYID	Company ID	Integer	2	View
CHKBKTYP	Checkbook Type	Integer	2	View
DDACTNUM	DD Account Number	String	18	View
DDINDNAM	DD Individual Name	String	24	View
DDTRANS	DD Transaction Code	String	4	View
PaymentRateTypeID	Payment Rate Type ID	String	16	View
DepositRateTypeID	Deposit Rate Type ID	String	16	View
CashInTransAcctIdx	Cash In Transit Account Index	Long Integer	4	View

CM00100 - CM Checkbook Master

Query Builder

Customer Service

Information

My Account

Contact Us