Table: DayClose

Name	Type	Description	Remarks
CashDeposit	decimal(18,2)	deposits from Cash/Check
CloseTime	datetime	Holds the datetime value when the office was closed
Collection	bit	Amount being sent to Collection
CreditCardDeposit	decimal(18,2)	deposits from CreditCards	Does NOT include Gift Card, GIft certificate, Mail check or Customer Credit
EmployeeId	int	Employee ID who closes the day from the POS for the store
GiftCertificate	decimal(18,2)	Payments from the gift certificates
isItemSaleCalc	bit	This is set when the Calculate Itemsales Integration is run
MonthClosedID	int	Gets updated when Cash source is closed using the month close control
OfficeNum	varchar(8)	OfficeNum from Office table
PatientAR	decimal(18,2)	Customer Out of pocket	Retail - Discount - Allowance + Copay + Tax
Payments	decimal(18,2)	Computed amount for the office for the transaction date
PayOuts	decimal(18,2)	Payouts for the office for the transaction date, that will be billed.
PrePaid	decimal(18,2)	Prepaid amount - for the office for the transaction date	Portion of an insurance premium that has been paid in advance
Receivable	decimal(18,2)	Receivable for the office for the transaction date, that will be billed.
ReviewDate	datetime	The datetime when the employee reconciled
ReviewEmployeeID	int	Employee who reconciles the cash from the backoffice
Sales	decimal(18,2)	Net sale amount for the office for the transaction date
Tax	decimal(18,2)	Calculated tax for the day
TransDate	datetime	Transaction Date for the Day close record
TransmitDate	datetime	This value is set when client specific integrations are run to show that the value has been transmitted