DepositFilter Model

Filters that can be applied over Deposit data direct from the sales data (not using aggregate tables)

Nullable
IsTraining : bool

Whether to filter on the "IsTraining" property. Null to perform no filtering

Nullable
IsRedeemed : bool

Whether to filter on DateTimeConsumed being null or not. Null to perform no filtering

Nullable
DBGen : RangeFilterCondition`1

Whether to filter on the "DBGen" property. The DBGen is an internal (incrementing) identifier for marking when data has been inserted/updated. Filtering will
allow the access to all the new/changed data from particular point in time.

Nullable
DepositID : ValueFilterCondition`1

Whether to filter on the "DepositID" property

Nullable
DateTimeCreated : RangeFilterCondition`1

Whether to filter on the "DateTimeCreated" property.

Nullable
DateTimeCreatedPart : DateStartPartFilterCondition

Whether to filter on the "DateTimeCreated" property via DatePart

Nullable
DateTimeConsumed : RangeFilterCondition`1

Whether to filter on the "DateTimeConsumed" property.

Nullable
DateTimeConsumedPart : DateStartPartFilterCondition

Whether to filter on the "DateTimeConsumed" property via DatePart

Nullable
TradingDateTimeCreated : RangeFilterCondition`1

Whether to filter on the combination of the date from Created_TradingDate and time from "DateTimeCreated" property.

Nullable
TradingDateCreatedPart : DateStartPartFilterCondition

Whether to filter on the combination of the date from Created_TradingDate and time from "DateTimeCreated" property via DatePart

Nullable
TradingDateTimeConsumed : RangeFilterCondition`1

Whether to filter on the combination of the date from Consumed_TradingDate and time from "DateTimeConsumed" property.

Nullable
TradingDateTimeConsumedPart : DateStartPartFilterCondition

Whether to filter on the combination of the date from Consumed_TradingDate and time from "DateTimeConsumed" property via DatePart

Nullable
DepositCode : ValueFilterCondition`1

Whether to filter on the "DepositCode" property

Nullable
Amount : RangeFilterCondition`1

Whether to filter on the Amount field.

Nullable
Covers : RangeFilterCondition`1

Whether to filter on the Covers field.

Nullable
ApplicationClientID : ValueFilterCondition`1

Whether to filter on the internal ClientID that was used to submit the sale in the first place

Nullable
ApplicationClientStringIDs : StringFilterCondition`1

Application client String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
ServiceModeStringIDs : StringFilterCondition`1

Service Mode String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
Created_TerminalStringIDs : StringFilterCondition`1

Created Terminal String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
Consumed_TerminalStringIDs : StringFilterCondition`1

Consumed Terminal String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
EventStringIDs : StringFilterCondition`1

Event String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
CurrencyStringIDs : StringFilterCondition`1

Currency String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
CreatedBy_EmployeeStringIDs : StringFilterCondition`1

Created By Employee String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
ConsumedBy_EmployeeStringIDs : StringFilterCondition`1

Consumed By Employee String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
Created_ZReportStringIDs : StringFilterCondition`1

ZReport String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Nullable
Consumed_ZReportStringIDs : StringFilterCondition`1

ZReport String ID's to Filter (or null if any are acceptable)

Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property

Example
{
  "IsTraining": true,
  "IsRedeemed": true,
  "DBGen": {},
  "DepositID": {},
  "DateTimeCreated": {},
  "DateTimeCreatedPart": {},
  "DateTimeConsumed": {},
  "DateTimeConsumedPart": {},
  "TradingDateTimeCreated": {},
  "TradingDateCreatedPart": {},
  "TradingDateTimeConsumed": {},
  "TradingDateTimeConsumedPart": {},
  "DepositCode": {},
  "Amount": {},
  "Covers": {},
  "ApplicationClientID": {},
  "ApplicationClientStringIDs": {},
  "ServiceModeStringIDs": {},
  "Created_TerminalStringIDs": {},
  "Consumed_TerminalStringIDs": {},
  "EventStringIDs": {},
  "CurrencyStringIDs": {},
  "CreatedBy_EmployeeStringIDs": {},
  "ConsumedBy_EmployeeStringIDs": {},
  "Created_ZReportStringIDs": {},
  "Consumed_ZReportStringIDs": {}
}