LettersWhereColumns

The valid fields by which letters can be queried.

enum LettersWhereColumns {
  ID
  CORRESPONDENCE_NUMBER
  EXTERNAL_ID
  CORRESPONDENCE_ID
  SEQUENCE_NUMBER
  NUMBER
  SUBJECT
  BODY
  SUMMARY
  DIRECTION
  TYPE
  SOURCE
  STATUS
  SENT_AT
  DUE_AT
  IS_OVERDUE
  CREATED_AT
  UPDATED_AT
  COMPLETED_AT
  DELETED_AT
}

Values​

LettersWhereColumns.ID​

Letter's unique identifier.

LettersWhereColumns.CORRESPONDENCE_NUMBER​

The letter's correspondence number.

LettersWhereColumns.EXTERNAL_ID​

The letter's external unique identifier.

LettersWhereColumns.CORRESPONDENCE_ID​

The letter's correspondence unique identifier.

LettersWhereColumns.SEQUENCE_NUMBER​

The letter's sequence number.

LettersWhereColumns.NUMBER​

The letter's number.

LettersWhereColumns.SUBJECT​

The letter's subject.

LettersWhereColumns.BODY​

The letter's subject.

LettersWhereColumns.SUMMARY​

The letter's summary.

LettersWhereColumns.DIRECTION​

The letter's direction.

LettersWhereColumns.TYPE​

The letter's type.

LettersWhereColumns.SOURCE​

The letter's source.

LettersWhereColumns.STATUS​

The letter's status.

LettersWhereColumns.SENT_AT​

Sent date of the letter.

LettersWhereColumns.DUE_AT​

Due date of the letter.

LettersWhereColumns.IS_OVERDUE​

Whether the due date has passed and the record is not settled yet. Filter it with EQ or NEQ and true or false.

LettersWhereColumns.CREATED_AT​

The date and time when the letter was created.

LettersWhereColumns.UPDATED_AT​

The date and time when the letter was last updated.

LettersWhereColumns.COMPLETED_AT​

The date and time when the letter was completed.

LettersWhereColumns.DELETED_AT​

The date and time when the letter was deleted.

Member Of​

ActLettersWhereWhereConditions input ● CompanyLettersWhereWhereConditions input ● ContactLettersWhereWhereConditions input ● ContractLettersWhereWhereConditions input ● CoordinationLettersWhereWhereConditions input ● EasementLettersWhereWhereConditions input ● ExpenseLettersWhereWhereConditions input ● GovernanceDocumentLettersWhereWhereConditions input ● InvoiceLettersWhereWhereConditions input ● MeterLettersWhereWhereConditions input ● OrdinanceLettersWhereWhereConditions input ● PersonLettersWhereWhereConditions input ● ProjectLettersWhereWhereConditions input ● PropertyLettersWhereWhereConditions input ● QueryCorrespondencesWhereWhereConditions input ● QueryLettersWhereWhereConditions input ● QuoteLettersWhereWhereConditions input ● SpecificationLettersWhereWhereConditions input ● StructureLettersWhereWhereConditions input ● SubmissionLettersWhereWhereConditions input ● TaskLettersWhereWhereConditions input