/*1.0.0.46*/
Ac_AccessVerificationCustomer.AccessVerificationCustomerId.LONG
Ac_AccessVerificationCustomer.TenantId.LONG
Ac_AccessVerificationCustomer.CompanyId.LONG
Ac_AccessVerificationCustomer.MemberId.LONG
Ac_AccessVerificationCustomer.MemberName.TEXT(255)
Ac_AccessVerificationCustomer.ProductId.LONG
Ac_AccessVerificationCustomer.ProductName.TEXT(255)
Ac_AccessVerificationCustomer.ValidFrom.DATETIME
Ac_AccessVerificationCustomer.ValidTo.DATETIME
Ac_AccessVerificationCustomer.ProductType.LONG
Ac_AccessVerificationCustomer.Status.TEXT(255)
Ac_AccessVerificationCustomer.MemberProductInfoId.LONG
Ac_AccessVerificationCustomer.CreatedDate.DATETIME
Ac_AccessVerificationCustomer.UpdatedDate.DATETIME
Ac_AccessVerificationCustomer.TimingFrom1.TEXT(255)
Ac_AccessVerificationCustomer.TimingsTo1.TEXT(255)
Ac_AccessVerificationCustomer.TimingFrom2.TEXT(255)
Ac_AccessVerificationCustomer.TimingsTo2.TEXT(255)
Ac_AccessVerificationCustomer.TimingFrom3.TEXT(255)
Ac_AccessVerificationCustomer.TimingsTo3.TEXT(255)
Ac_AccessVerificationCustomer.TimingFrom4.TEXT(255)
Ac_AccessVerificationCustomer.TimingsTo4.TEXT(255)
Ac_AccessVerificationCustomer.TimingFrom5.TEXT(255)
Ac_AccessVerificationCustomer.TimingsTo5.TEXT(255)
Ac_AccessVerificationCustomer.UseableDays.LONG
Ac_AccessVerificationCustomer.UsedDays.LONG
Ac_AccessVerificationCustomer.ReciprocityUsableDays.LONG
Ac_AccessVerificationCustomer.ReciprocityUsedDays.LONG
Ac_AccessVerificationCustomer.SessionDuration.LONG
Ac_AccessVerificationCustomer.NoOfSessions.LONG
Ac_AccessVerificationCustomer.SessionOwnerId.LONG
Ac_AccessVerificationCustomer.SessionOwnerName.TEXT(255)
Ac_AccessVerificationCustomer.Sync_Type.TEXT(255)
Ac_AccessVerificationCustomer.EventId.LONG
Ac_AccessVerificationCustomer.Max_Freezing_day.LONG
Ac_AccessVerificationCustomer.Min_Freezing_day.LONG
Ac_AccessVerificationCustomer.SessionType.TEXT(255)
Ac_AccessVerificationCustomer.ProductTypeName.TEXT(255)
Ac_AccessVerificationCustomer.BasePrty1.INT
Ac_AccessVerificationCustomer.BasePrty2.INT
Ac_AccessVerificationCustomer.BasePrty3.INT
Ac_AuthMachineTenantConfig.MachineId.LONG
Ac_AuthMachineTenantConfig.CompanyId.LONG
Ac_AuthMachineTenantConfig.TenantId.LONG
Ac_AuthMachineTenantConfig.FriendlyName.TEXT(255)
Ac_AuthMachineTenantConfig.Description.TEXT(255)
Ac_AuthMachineTenantConfig.Modelid.INTEGER
Ac_AuthMachineTenantConfig.ModelName.TEXT(255)
Ac_AuthMachineTenantConfig.SupportiveProductType.MEMO
Ac_AuthMachineTenantConfig.Status.YESNO
Ac_AuthMachineTenantConfig.MachineKey.TEXT(255)
Ac_AuthMachineTenantConfig.Used.YESNO
Ac_AuthMachineTenantConfig.FirstStartDate.DATETIME
Ac_AuthMachineTenantConfig.LastUsedDate.DATETIME
Ac_AuthMachineTenantConfig.MACAddress.TEXT(255)
Ac_AuthMachineTenantConfig.IPAddress.TEXT(255)
Ac_AuthMachineTenantConfig.SoftwareVersion.TEXT(255)
Ac_AuthMachineTenantConfig.CreatedBy.LONG
Ac_AuthMachineTenantConfig.UpdatedBy.LONG
Ac_AuthMachineTenantConfig.CreatedDate.DATETIME
Ac_AuthMachineTenantConfig.UpdatedDate.DATETIME
Ac_AuthMachineTenantConfig.AuthGroupName.TEXT(255)
Ac_AuthMachineTenantConfig.AuthGroupId.LONG
Ac_AuthMachineTenantConfig.TenantImagePath.TEXT(255)
Ac_AuthMachineTenantConfig.TenantName.TEXT(255)
Ac_AuthMachineTenantConfig.PortAddress.TEXT(255)
Ac_AuthMachineTenantConfig.VerificationMode.TEXT(255)
Ac_AuthMachineTenantConfig.ShowContainer.YESNO
Ac_AuthMachineTenantConfig.SecurityLevel.TEXT(255)
Ac_AuthMachineTenantConfig.ScreenOptions.TEXT(255)
Ac_AuthMachineTenantConfig.Localization.TEXT(255)
Ac_AuthMachineTenantConfig.Sync_Type.TEXT(255)
Ac_AuthMachineTenantConfig.Last_Sync_Date.DATETIME
Ac_AuthMachineTenantConfig.Appointment_Attendance.TEXT(255)
Ac_AuthMachineTenantConfig.DBVersion.TEXT(255)
Ac_AuthMachineTenantConfig.PortName.TEXT(255)
Ac_AuthMachineTenantConfig.BaudRate.LONG
Ac_AuthMachineTenantConfig.Parity.TEXT(255)
Ac_AuthMachineTenantConfig.StopBit.TEXT(255)
Ac_AuthMachineTenantConfig.DataBit.LONG
Ac_AuthMachineTenantConfig.PortAccessThrough.TEXT(255)
Ac_AuthMachineTenantConfig.RelayDevice.TEXT(255)
Ac_AuthMachineTenantConfig.DefaultProductType.LONG
Ac_AuthMachineTenantConfig.BarcodeReadFrom.TEXT(255)
Ac_AuthMachineTenantConfig.MultipleMembershipPopup.YESNO
Ac_AuthMachineTenantConfig.RegistrationSecurityLevel.TEXT(255)
Ac_AuthMachineTenantConfig.EditableShiftTiming.YESNO
Ac_AuthMachineTenantConfig.HostUrl.TEXT(255)
Ac_AuthMachineTenantConfig.ReaderType.TEXT(255)
Ac_AuthMachineTenantConfig.FFModelName.TEXT(255)
Ac_AuthMachineTenantConfig.FingerQuality.LONG
Ac_ErrorLog.Erlo_Id.COUNTER
Ac_ErrorLog.Erlo_ErrorMessage.MEMO
Ac_ErrorLog.Erlo_MachineId.TEXT(255)
Ac_ErrorLog.Erlo_CreatedDate.DATETIME
Ac_ErrorLog.Erlo_TenantId.LONG
Ac_ErrorLog.Erlo_SoftwareVersion.TEXT(255)
Ac_ErrorLog.Erlo_ExceptionCategory.TEXT(255)
Ac_ErrorLog.Erlo_EventId.LONG
Ac_ErrorLog.Erlo_Sync_Type.TEXT(255)
Ac_MemberEnrollment.ID.COUNTER
Ac_MemberEnrollment.MemberEnrollmentID.LONG
Ac_MemberEnrollment.TenantId.LONG
Ac_MemberEnrollment.MemberId.LONG
Ac_MemberEnrollment.MemberName.TEXT(255)
Ac_MemberEnrollment.MemberImagePath.TEXT(255)
Ac_MemberEnrollment.AuthGroupId.LONG
Ac_MemberEnrollment.Template.LONGBINARY
Ac_MemberEnrollment.Template2.LONGBINARY
Ac_MemberEnrollment.Template3.LONGBINARY
Ac_MemberEnrollment.RegistrationToTenantId.LONG
Ac_MemberEnrollment.MemberEnrollmentKey.TEXT(255)
Ac_MemberEnrollment.MemberEnrollmentKey_New.TEXT(255)
Ac_MemberEnrollment.MemberType.TEXT(255)
Ac_MemberEnrollment.BirthDate.DATETIME
Ac_MemberEnrollment.ClientRepName.TEXT(255)
Ac_MemberEnrollment.ClientRepId.LONG
Ac_MemberEnrollment.ReferredByName.TEXT(255)
Ac_MemberEnrollment.ReferredById.LONG
Ac_MemberEnrollment.OfficeTelNo.TEXT(255)
Ac_MemberEnrollment.HomeNo.TEXT(255)
Ac_MemberEnrollment.MobileNo.TEXT(255)
Ac_MemberEnrollment.SecondMobileNo.TEXT(255)
Ac_MemberEnrollment.SecondLandLineNo.TEXT(255)
Ac_MemberEnrollment.Email.TEXT(255)
Ac_MemberEnrollment.PersonalizedMessage.MEMO
Ac_MemberEnrollment.MedicalAlert.MEMO
Ac_MemberEnrollment.GeneralInfo.MEMO
Ac_MemberEnrollment.RegistrationDateTime.DATETIME
Ac_MemberEnrollment.AnniversaryDate.DATETIME
Ac_MemberEnrollment.CreatedBy.LONG
Ac_MemberEnrollment.UpdatedBy.LONG
Ac_MemberEnrollment.CreatedDate.DATETIME
Ac_MemberEnrollment.UpdatedDate.DATETIME
Ac_MemberEnrollment.MachineId.LONG
Ac_MemberEnrollment.Gender.TEXT(255)
Ac_MemberEnrollment.Balance_Due.CURRENCY
Ac_MemberEnrollment.EventId.LONG
Ac_MemberEnrollment.Sync_Type.TEXT(255)
Ac_MemberEnrollment.Status.YESNO
Ac_MemberEnrollment.Meco_Status.TEXT(255)
Ac_MemberEnrollment.CardNumber.TEXT(255)
Ac_MemberTimeStamp.MemberTimeStampId.COUNTER
Ac_MemberTimeStamp.TimeStampTenantId.LONG
Ac_MemberTimeStamp.MemberTenantId.LONG
Ac_MemberTimeStamp.MemberId.LONG
Ac_MemberTimeStamp.AuthMachineType.LONG
Ac_MemberTimeStamp.ProductType.LONG
Ac_MemberTimeStamp.ProductId.LONG
Ac_MemberTimeStamp.AccessStatus.YESNO
Ac_MemberTimeStamp.MemberProductInfoId.LONG
Ac_MemberTimeStamp.AccessVerificationId.LONG
Ac_MemberTimeStamp.AccessStatusReason.TEXT(255)
Ac_MemberTimeStamp.TimeStamp.DATETIME
Ac_MemberTimeStamp.IN.YESNO
Ac_MemberTimeStamp.Out.YESNO
Ac_MemberTimeStamp.CreatedDate.DATETIME
Ac_MemberTimeStamp.MachineId.LONG
Ac_MemberTimeStamp.EventId.LONG
Ac_MemberTimeStamp.Sync_Type.TEXT(255)
Ac_MemberTimeStamp.MachineTime.DATETIME
Ac_MemberTimeStamp.ServerTime.DATETIME
Ac_MemberTimeStamp.TimeType.TEXT(255)
Ac_MemberTimeStamp.MachineTimeVerifiedby.LONG
Ac_MemberTimeStamp.VerifiedTime.DATETIME
Ac_MemberTimeStamp.VerifiedComments.TEXT(255)
Ac_MemberTimeStamp.IsInstantIntimationSent.YESNO
AC_ReciprocityTenantGroup.ReciprocityId.LONG
AC_ReciprocityTenantGroup.GroupName.TEXT(255)
AC_ReciprocityTenantGroup.TenantId.LONG
AC_ReciprocityTenantGroup.TenantName.TEXT(255)
AC_ReciprocityTenantGroup.CompanyId.LONG
AC_ReciprocityTenantGroup.Status.YESNO
AC_ReciprocityTenantGroup.CountryId.LONG
AC_ReciprocityTenantGroup.StateId.LONG
AC_ReciprocityTenantGroup.CityId.LONG
AC_ReciprocityTenantGroup.CreatedDate.DATETIME
AC_ReciprocityTenantGroup.UpdatedDate.DATETIME
AC_ReciprocityTenantGroup.SupportiveProductType.MEMO
Ac_Users.ID.COUNTER
Ac_Users.CompanyId.LONG
Ac_Users.Userid.LONG
Ac_Users.TenantId.LONG
Ac_Users.FirstName.TEXT(255)
Ac_Users.LastName.TEXT(255)
Ac_Users.UserName.TEXT(255)
Ac_Users.Logon.TEXT(255)
Ac_Users.EmailId.TEXT(255)
Ac_Users.Status.YESNO
Ac_Users.AccessTemplateRights.YESNO
Ac_Users.Notification.YESNO
Ac_Users.Role.LONG
Ac_Users.Department.TEXT(255)
Ac_Users.Designation.TEXT(255)
Ac_Users.MobileNo.TEXT(255)
Ac_Users.MobileCountryCode.TEXT(255)
Ac_Users.DefaultLanguage.TEXT(255)
Ac_Users.BirthDate.DATETIME
Ac_Users.Template.LONGBINARY
Ac_Users.Template2.LONGBINARY
Ac_Users.Template3.LONGBINARY
Ac_Users.EmployeeEnrollmentKey.TEXT(255)
Ac_Users.TemplateUpdatedby.LONG
Ac_Users.TemplateUpdatedby2.LONG
Ac_Users.TemplateUpdatedby3.LONG
Ac_Users.TemplateUpdateddate.DATETIME
Ac_Users.TemplateUpdateddate2.DATETIME
Ac_Users.TemplateUpdateddate3.DATETIME
Ac_Users.EmployeeImagePath.TEXT(255)
Ac_Users.AuthGroupid.LONG
Ac_Users.RegistrationToTenantid.LONG
Ac_Users.EmployeeEnrollmentKey_new.LONG
Ac_Users.Privilege.TEXT(255)
Ac_Users.MachineId.LONG
Ac_Users.Createdby.LONG
Ac_Users.Updatedby.LONG
Ac_Users.Createddate.DATETIME
Ac_Users.Updateddate.DATETIME
Ac_Users.TemplateClearedBy.LONG
Ac_Users.TemplateClearedDate.DATETIME
Ac_Users.PasswordUpdatedDate.DATETIME
Ac_Users.IpSetting.TEXT(255)
Ac_Users.Eventid.LONG
Ac_Users.Sync_Type.TEXT(255)
Ac_Users.shiftId.TEXT(255)
Ac_Users.shiftName.TEXT(255)
Ac_Users.subShiftID.TEXT(255)
Ac_Users.subShiftName.TEXT(255)
Ac_Users.password.TEXT(255)
Ac_Users.CardNumber.TEXT(255)
Ac_UserShift.userShiftId.COUNTER
Ac_UserShift.shiftId.TEXT(255)
Ac_UserShift.shiftName.TEXT(255)
Ac_UserShift.userShiftDate.DATETIME
Ac_UserShift.userID.LONG
Ac_UserShift.type.TEXT(255)
Ac_UserShift.comments.MEMO
Ac_UserShift.MachineID.LONG
Ac_UserShift.EventID.LONG
Ac_UserShift.CenterID.LONG
Ac_UserShift.Sync_Type.TEXT(255)
Ac_UserShiftTimeStamp.userShiftTimeStampAutoId.COUNTER
Ac_UserShiftTimeStamp.userShiftID.LONG
Ac_UserShiftTimeStamp.subShiftID.TEXT(255)
Ac_UserShiftTimeStamp.subShiftName.TEXT(255)
Ac_UserShiftTimeStamp.UserShiftTimeStamp.DATETIME
Ac_UserShiftTimeStamp.timeInOut.TEXT(255)
Ac_UserShiftTimeStamp.LateReason.TEXT(255)
Ac_UserShiftTimeStamp.LateComments.MEMO
Ac_UserShiftTimeStamp.CenterID.LONG
Ac_UserShiftTimeStamp.CenterName.TEXT(255)
Ac_UserShiftTimeStamp.EventID.LONG
Ac_UserShiftTimeStamp.MachineId.LONG
Ac_UserShiftTimeStamp.Sync_Type.TEXT(255)
Ac_UserShiftTimeStamp.ShiftId.TEXT(255)
Ac_UserShiftTimeStamp.UserShiftDate.DATETIME
Ac_UserShiftTimeStamp.userID.TEXT(255)
Ac_UserShiftTimeStamp.EarlyReason.TEXT(255)
Ac_UserShiftTimeStamp.EarlyComments.MEMO
Ac_UserShiftTimeStamp.MachineTime.DATETIME
Ac_UserShiftTimeStamp.ServerTime.DATETIME
Ac_UserShiftTimeStamp.TimeType.TEXT(255)
Ac_UserShiftTimeStamp.MachineTimeVerifiedby.LONG
Ac_UserShiftTimeStamp.VerifiedTime.DATETIME
Ac_UserShiftTimeStamp.VerifiedComments.TEXT(255)
Ac_UserTimestamp.UserTimeStampId.COUNTER
Ac_UserTimestamp.TimeStampTenantid.LONG
Ac_UserTimestamp.UserTenantId.LONG
Ac_UserTimestamp.UserID.LONG
Ac_UserTimestamp.AuthMachineType.LONG
Ac_UserTimestamp.AccessStatus.YESNO
Ac_UserTimestamp.AccessStatusReason.TEXT(255)
Ac_UserTimestamp.TimeStamp.DATETIME
Ac_UserTimestamp.IN.YESNO
Ac_UserTimestamp.Out.YESNO
Ac_UserTimestamp.CreatedDate.DATETIME
Ac_UserTimestamp.MachineId.LONG
Ac_UserTimestamp.EventId.LONG
Ac_UserTimestamp.Sync_Type.TEXT(255)
Ac_UserTimestamp.MachineTime.DATETIME
Ac_UserTimestamp.ServerTime.DATETIME
Ac_UserTimestamp.TimeType.TEXT(255)
Ac_UserTimestamp.MachineTimeVerifiedby.LONG
Ac_UserTimestamp.VerifiedTime.DATETIME
Ac_UserTimestamp.VerifiedComments.TEXT(255)
CityMaster.Cima_CityCode.LONG
CityMaster.Cima_CityName.TEXT(255)
CityMaster.Cima_StateCode.LONG
CityMaster.Cima_CountryCode.LONG
CityMaster.Cima_City_StdCode.TEXT(255)
CityMaster.Cima_CreatedDate.DATETIME
CityMaster.Cima_UpdatedDate.DATETIME
CityMaster.EventId.LONG
CityMaster.Sync_Type.TEXT(255)
CountryMaster.Coma_Id.LONG
CountryMaster.Coma_Name.TEXT(255)
CountryMaster.Coma_Status.YESNO
CountryMaster.Coma_StdCode.TEXT(255)
CountryMaster.Coma_CreatedDate.DATETIME
CountryMaster.Coma_UpdatedDate.DATETIME
CountryMaster.Coma_Nationality.TEXT(255)
CountryMaster.EventId.LONG
CountryMaster.Sync_Type.TEXT(255)
Schedule.ClientXref_ScheduleId.COUNTER
Schedule.Xref_ScheduleId.LONG
Schedule.ScheduleId.LONG
Schedule.HostUserId.LONG
Schedule.PurposeId.LONG
Schedule.PurposeName.TEXT(255)
Schedule.StartDate.DATETIME
Schedule.EndDate.DATETIME
Schedule.IsSchedule.YESNO
Schedule.CreatedDate.DATETIME
Schedule.UpdatedDate.DATETIME
Schedule.CreatedBy.LONG
Schedule.UpdatedBy.LONG
Schedule.IsAllDay.YESNO
Schedule.Comments.MEMO
Schedule.CompanyId.LONG
Schedule.IsMember.YESNO
Schedule.TenantId.LONG
Schedule.TenantName.TEXT(255)
Schedule.ParentId.LONG
Schedule.Guid.TEXT(255)
Schedule.Title.TEXT(255)
Schedule.CancellationReason.MEMO
Schedule.Roomid.LONG
Schedule.RoomName.TEXT(255)
Schedule.Sync_Type.TEXT(255)
Schedule.MachineTime.DATETIME
Schedule.ServerTime.DATETIME
Schedule.TimeType.TEXT(255)
Schedule.MachineTimeVerifiedby.LONG
Schedule.VerifiedTime.DATETIME
Schedule.VerifiedComments.TEXT(255)
Schedule.StatusMsg.MEMO
Schedule.RecordType.TEXT(255)
Schedule.ClassStatus.TEXT(255)
Schedule_Purpose.PurposeId.LONG
Schedule_Purpose.PurposeName.TEXT(255)
Schedule_Purpose.DarkColor.TEXT(255)
Schedule_Purpose.LightColor.TEXT(255)
Schedule_Purpose.CompanyId.LONG
Schedule_Purpose.PurposeDescription.TEXT(255)
Schedule_Purpose.PurposeStatus.YESNO
Schedule_Purpose.SessionType.TEXT(255)
Schedule_Purpose.CreatedBy.LONG
Schedule_Purpose.UpdatedBy.LONG
Schedule_Purpose.CreatedDate.DATETIME
Schedule_Purpose.UpdatedDate.DATETIME
Schedule_Purpose.Sync_Type.TEXT(255)
Schedule_Room.ID.LONG
Schedule_Room.TenantId.LONG
Schedule_Room.RoomName.TEXT(255)
Schedule_Room.RoomValue.TEXT(255)
Schedule_Room.CreatedDate.DATETIME
Schedule_Room.UpdatedDate.DATETIME
Schedule_Room.CreatedBy.LONG
Schedule_Room.UpdatedBy.LONG
Schedule_Room.Sync_Type.TEXT(255)
Schedule_Users.UserId.LONG
Schedule_Users.User_Name.TEXT(255)
Schedule_Users.User_Department.TEXT(255)
Schedule_Users.User_Designation.TEXT(255)
Schedule_Users.User_Status.YESNO
Schedule_Users.Can_Take_Appointment.YESNO
Schedule_Users.User_EmployeeEnrollmentKey.TEXT(255)
Schedule_Users.User_EmployeeEnrollmentKey_New.TEXT(255)
Schedule_Users.Sync_Type.TEXT(255)
ScheduleXref_Members.ID.COUNTER
ScheduleXref_Members.ScheduleXref_MemberId.LONG
ScheduleXref_Members.Xref_ScheduleId.LONG
ScheduleXref_Members.ScheduleId.LONG
ScheduleXref_Members.MemberId.LONG
ScheduleXref_Members.StartDate.DATETIME
ScheduleXref_Members.EndDate.DATETIME
ScheduleXref_Members.PurposeId.LONG
ScheduleXref_Members.PurposeName.TEXT(255)
ScheduleXref_Members.TenantId.LONG
ScheduleXref_Members.TenantName.TEXT(255)
ScheduleXref_Members.StatusId.LONG
ScheduleXref_Members.UpdatedBy.LONG
ScheduleXref_Members.UpdatedDate.DATETIME
ScheduleXref_Members.Reason.MEMO
ScheduleXref_Members.MemberProductInfoId.LONG
ScheduleXref_Members.UnChargeableNoShow.LONG
ScheduleXref_Members.Used.YESNO
ScheduleXref_Members.TotalUsed.LONG
ScheduleXref_Members.TotalBooked.LONG
ScheduleXref_Members.TotalNoShow.LONG
ScheduleXref_Members.IsLatest.YESNO
ScheduleXref_Members.Sync_Type.TEXT(255)
ScheduleXref_Members.MachineTime.DATETIME
ScheduleXref_Members.ServerTime.DATETIME
ScheduleXref_Members.TimeType.TEXT(255)
ScheduleXref_Members.MachineTimeVerifiedby.LONG
ScheduleXref_Members.VerifiedTime.DATETIME
ScheduleXref_Members.VerifiedComments.TEXT(255)
ScheduleXref_Members.ClientXref_ScheduleId.LONG
ScheduleXref_Members.StatusMsg.MEMO
ScheduleXref_Members.RecordType.TEXT(255)
ScheduleXref_Members.ClassStatus.TEXT(255)
ScheduleXref_Users.ID.COUNTER
ScheduleXref_Users.ScheduleXref_UserId.LONG
ScheduleXref_Users.Xref_ScheduleId.LONG
ScheduleXref_Users.ScheduleId.LONG
ScheduleXref_Users.UserId.LONG
ScheduleXref_Users.StartDate.DATETIME
ScheduleXref_Users.EndDate.DATETIME
ScheduleXref_Users.PurposeId.LONG
ScheduleXref_Users.PurposeName.TEXT(255)
ScheduleXref_Users.TenantId.LONG
ScheduleXref_Users.TenantName.TEXT(255)
ScheduleXref_Users.IsSchedule.YESNO
ScheduleXref_Users.StatusId.LONG
ScheduleXref_Users.UpdatedBy.LONG
ScheduleXref_Users.UpdatedDate.DATETIME
ScheduleXref_Users.Reason.MEMO
ScheduleXref_Users.Sync_Type.TEXT(255)
ScheduleXref_Users.MachineTime.DATETIME
ScheduleXref_Users.ServerTime.DATETIME
ScheduleXref_Users.TimeType.TEXT(255)
ScheduleXref_Users.MachineTimeVerifiedby.LONG
ScheduleXref_Users.VerifiedTime.DATETIME
ScheduleXref_Users.VerifiedComments.TEXT(255)
ScheduleXref_Users.ClientXref_ScheduleId.LONG
ScheduleXref_Users.StatusMsg.MEMO
ScheduleXref_Users.RecordType.TEXT(255)
ScheduleXref_Users.ClassStatus.TEXT(255)
ShiftMaster.shiftAutoId.LONG
ShiftMaster.TenantID.LONG
ShiftMaster.ShiftId.TEXT(255)
ShiftMaster.ShiftName.TEXT(255)
ShiftMaster.SubShiftID.TEXT(255)
ShiftMaster.SubShiftName.TEXT(255)
ShiftMaster.StartTime.DATETIME
ShiftMaster.EndTime.DATETIME
ShiftMaster.BufferTime.TEXT(255)
ShiftMaster.Status.YESNO
ShiftMaster.Sync_type.TEXT(255)
ShiftMaster.IsOpenShift.LONG
StateMaster.Stma_StateCode.LONG
StateMaster.Stma_StateName.TEXT(255)
StateMaster.Stma_CountryCode.LONG
StateMaster.Stma_CreatedDate.DATETIME
StateMaster.Stma_UpdatedDate.DATETIME
StateMaster.EventId.LONG
StateMaster.Sync_Type.TEXT(255)
Ac_PalmMatchingDetails.ID.COUNTER
Ac_PalmMatchingDetails.MemberId.Text(255)
Ac_PalmMatchingDetails.MemberName.Text(255)
Ac_PalmMatchingDetails.MatchingMemberid.Text(255)
Ac_PalmMatchingDetails.MatchingMemberName.Text(255)
Ac_PalmMatchingDetails.CreatedDate.DATETIME
Ac_PalmMatchingDetails.RecordType.Text(255)
Ac_PalmMatchingDetails.Tenantid.LONG
ac_devices.MachineId.Counter
ac_devices.friendlyname.Text(255)
ac_devices.ipaddress.Text(255)
ac_devices.lastsyncdate.DATETIME
ac_syncdevice.AutoNo.Counter
ac_syncdevice.MachineId.LONG
ac_syncdevice.EventId.LONG
ac_syncdevice.SyncDate.TEXT(255)
ac_syncdevice.TableName.TEXT(255)
ac_deviceexistingdata.devicedata.LONG
ac_deviceexistingdata.machineid.LONG
ac_deviceexistingdata.recordtype.TEXT(255)
ac_syncmembertimestamp.MemberTimeStampId.Counter
ac_syncmembertimestamp.TimeStampTenantId.LONG
ac_syncmembertimestamp.MemberTenantId.LONG
ac_syncmembertimestamp.MemberId.LONG
ac_syncmembertimestamp.ProductType.LONG
ac_syncmembertimestamp.ProductId.LONG
ac_syncmembertimestamp.AccessStatus.YESNO
ac_syncmembertimestamp.MemberProductInfoId.LONG
ac_syncmembertimestamp.AccessStatusReason.TEXT(255)
ac_syncmembertimestamp.TimeStamp.DATETIME
ac_syncmembertimestamp.IN.YESNO
ac_syncmembertimestamp.Out.YESNO
ac_syncmembertimestamp.CreatedDate.DATETIME
ac_syncmembertimestamp.MachineId.LONG
ac_syncmembertimestamp.LogDeviceId.LONG
ac_syncmembertimestamp.LogRecordId.LONG
ac_syncmembertimestamp.RecordType.TEXT(50)
ac_membertemplatedata.AutoNo.Counter
ac_membertemplatedata.MemberId.LONG
ac_membertemplatedata.Template.LONGBINARY
ac_memberaccessstatus.Id.Counter
ac_memberaccessstatus.Memberid.LONG
ac_memberaccessstatus.Membername.TEXT(255)
ac_memberaccessstatus.ValidFrom.DATETIME
ac_memberaccessstatus.ValidTo.DATETIME
ac_memberaccessstatus.TimingFrom1.TEXT(10)
ac_memberaccessstatus.TimingsTo1.TEXT(10)
ac_memberaccessstatus.TimingFrom2.TEXT(10)
ac_memberaccessstatus.TimingsTo2.TEXT(10)
ac_memberaccessstatus.TimingFrom3.TEXT(10)
ac_memberaccessstatus.TimingsTo3.TEXT(10)
ac_memberaccessstatus.TimingFrom4.TEXT(10)
ac_memberaccessstatus.TimingsTo4.TEXT(10)
ac_memberaccessstatus.TimingFrom5.TEXT(10)
ac_memberaccessstatus.TimingsTo5.TEXT(10)
ac_memberaccessstatus.UseableDays.LONG
ac_memberaccessstatus.UsedDays.LONG
ac_memberaccessstatus.SessionType.TEXT(255)
ac_memberaccessstatus.Template.LONGBINARY
ac_memberaccessstatus.DeniedStatus.TEXT(255)
ac_memberaccessstatus.StatusId.LONG
ac_memberaccessstatus.ProductTypeid.INT
ac_memberaccessstatus.ProductTypeName.TEXT(255)
ac_memberaccessstatus.MemberProductinfoid.LONG
ac_memberaccessstatus.ProductId.INT
ac_memberaccessstatus.ClearTemplate.INT
ac_devicesyncdata.AutoNo.Counter
ac_devicesyncdata.Memberid.LONG
ac_devicesyncdata.Machineid.TEXT(255)
ac_devicesyncdata.SyncDate.DATETIME
ac_devicesyncdata.RecordType.TEXT(255)
ac_syncstatus.AutoNo.AUTOINCREMENT
ac_syncstatus.SyncInProgress.YESNO
ac_syncstatus.StartDateTime.CHAR(255)
ac_syncstatus.EndDateTime.CHAR(255)
ac_syncstatus.SyncInitBy.CHAR(255)
ac_machinetp.ID.LONG
ac_machinetp.Tp.TEXT(255)
ac_machinetp.MachineId.TEXT(255)
ac_dooropencomments.AutoID.AUTOINCREMENT
ac_dooropencomments.Comments.TEXT(255)
ac_dooropencomments.CreatedDate.DATETIME
ac_dooropencomments.TenantId.LONG
ac_dooropencomments.CommentsBy.TEXT(255)
