CM20500 - CM Reconcile Header | Prospr - Dynamics GP Table Reference

CM20500 - CM Reconcile Header

Query Builder

Select * from CM20500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CHEKBKID	Checkbook ID	String	16	View
RECONUM	Reconcile Number	Currency	10	View
Recond	Reconciled	Boolean	2	View
StmntDate	Bank Statement Date	Date	4	View
StmntBal	Bank Statement Balance	Currency	10	View
CUTOFFBAL	Current_Balance_as_of_Cutoff	Currency	10	View
ClrdPay	Cleared Payments Count	Integer	2	View
ClrdDep	Cleared Deposits Count	Integer	2	View
ClrePayAmt	Cleared Payments Total	Currency	10	View
ClrdDepAmt	Cleared Deposits Total	Currency	10	View
Cleared_Difference	Cleared Difference	Currency	10	View
OUTPAYTOT	OutstandingPaymentsTotal	Currency	10	View
OUTDEPTOT	OutstandingDepositsTotal	Currency	10	View
IINADJTOT	Increase_Adjustments_Total	Currency	10	View
DECADJTOT	Decrease_Adjustments_Total	Currency	10	View
ASOFBAL	BookBalanceAsOfCutoff	Currency	10	View
CUTOFDAT	Cutoff Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
CURNCYID	Currency ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
RCRDSTTS	Record Status	Integer	2	View
Reconcile_Messages	Reconcile Messages	Long Integer	4	View
AUDITTRAIL	Audit Trail Code	String	14	View