# Inputs

# ColumnFilter


## Fields:

  - `values` ([String]): List of string values to filter by (logical OR).
  - `notValues` ([String]): List of string values to exclude (logical AND NOT).


---

# DatePeriod


## Fields:

  - `fromIncluded` (String!): Start date and time of the query (inclusive), e.g., `2025-03-03T15:00:00.000Z` (UTC).
  - `toExcluded` (String!): End date and time of the query (exclusive), e.g., `2025-03-03T15:05:00.000Z` (UTC).


---

# FaxInColumnUdrFilters


## Fields:

  - `faxId` (ColumnFilter): Filter for fax reception record identifier.
  - `documentDeliveryStatus` (ColumnFilter): Filter for document delivery status code.
  - `calledNumber` (ColumnFilter): Filter for receiving phone number.
  - `archivingStatus` (ColumnFilter): Filter for document archiving status.
  - `billingCode` (ColumnFilter): Filter for billing code used for cost allocation.
  - `accountingService` (ColumnFilter): Filter for accounting service identifier.
  - `faxTransmitStatus` (ColumnFilter): Filter for fax transmission status.
  - `resolution` (ColumnFilter): Filter for fax reception quality/resolution.
  - `calledCountry` (ColumnFilter): Filter for originating country.
  - `callingTsId` (ColumnFilter): Filter for Transmitting Station Identifier of the sending fax machine.


---

# FaxOutColumnUdrFilters


## Fields:

  - `faxId` (ColumnFilter): Filter by fax transmission record identifier.
  - `statusName` (ColumnFilter): Filter by transmission status name.
  - `calledNumber` (ColumnFilter): Filter by destination phone number.
  - `jobCustomerRef` (ColumnFilter): Filter by job customer reference identifier.
  - `faxCustomerRef` (ColumnFilter): Filter by fax-specific customer reference identifier.
  - `jobBillingCode` (ColumnFilter): Filter by job billing code.
  - `accountService` (ColumnFilter): Filter by account service type.
  - `jobCustomerResolution` (ColumnFilter): Filter by fax resolution quality setting.
  - `calledCountry` (ColumnFilter): Filter by destination country of fax transmission.
  - `callingTsId` (ColumnFilter): Filter by Transmitting Station Identifier (TSI) of the sending fax machine.


---

# SmsInColumnUdrFilters

Filter options for SMS inbound usage detail records.


## Fields:

  - `senderCountryCodeIso3` (ColumnFilter): Filter for the senders country iso3-code.
  - `recipientCountryCodeIso3` (ColumnFilter): Filter for the recipients country iso3-code.
  - `recipient` (ColumnFilter): Filter for the recipient phone number.
  - `dataCenter` (ColumnFilter): Filter for the data-center.


---

# SmsOutColumnUdrFilters

Filter options for SMS outbound usage detail records.


## Fields:

  - `service` (ColumnFilter): Filter for the Retarus service used for sending (e.g., 'SMS4AREST').
  - `statusCode` (ColumnFilter): Filter for the status code of the SMS.
  - `recipient` (ColumnFilter): Filter for the recipient phone number.
  - `reference` (ColumnFilter): Filter for the job reference.


---

# TransactionalEmailColumnEventFilters


## Fields:

  - `usageId` (ColumnFilter): Filter by the value of the 'usageId' field.
  - `eventType` (ColumnFilter): Filter by event type. This can be either 'OPEN' or 'CLICK'.
  - `eventSubType` (ColumnFilter): Filter by event subtype. This can be 'LINK_CLICKED' for click event types or 'MAIL_OPENED' for mail event types.
  - `userId` (ColumnFilter): Filter for user ID (technical account) of the client using the service.


---

# TransactionalEmailColumnUdrFilters


## Fields:

  - `usageStatusCode` (ColumnFilter): Filter by usage status code.
  - `usageStatus` (ColumnFilter): Filter by usage status.
  - `usageSubStatus` (ColumnFilter): Filter by usage substatus.
  - `usageId` (ColumnFilter): Filter by the value of the 'usageId' field.
  - `usageType` (ColumnFilter): Filter by usage type. This can be either 'mail' or 'traceRecover'.
  - `userId` (ColumnFilter): Filter for user ID (technical account) of the client using the service.


---