Skip to main content

ContractsWhereColumns

The valid fields by which contracts can be queried.

enum ContractsWhereColumns {
ID
PARENT_ID
NUMBER
NAME
TYPE
PRICE_LIST
EXTERNAL_CODE
IS_NOTARIZED
FILES_PATH
STATUS
DESCRIPTION
SIGNED_AT
START_AT
DUE_AT
IS_OVERDUE
COMPLETED_AT
WARRANTY_DUE_AT
CREATED_AT
UPDATED_AT
DELETED_AT
}

Values​

ContractsWhereColumns.ID​

Contract's unique identifier.

ContractsWhereColumns.PARENT_ID​

The contract's parent contract.

ContractsWhereColumns.NUMBER​

The contract's number.

ContractsWhereColumns.NAME​

The contract's name.

ContractsWhereColumns.TYPE​

The contract's type.

ContractsWhereColumns.PRICE_LIST​

Price list of the contract.

ContractsWhereColumns.EXTERNAL_CODE​

The contract's external code.

ContractsWhereColumns.IS_NOTARIZED​

Whether the easement has been notarized.

ContractsWhereColumns.FILES_PATH​

The contract's files path.

ContractsWhereColumns.STATUS​

The contract's status.

ContractsWhereColumns.DESCRIPTION​

The contract's description.

ContractsWhereColumns.SIGNED_AT​

Signed date of the contract.

ContractsWhereColumns.START_AT​

Start date of the contract.

ContractsWhereColumns.DUE_AT​

Due date of the contract.

ContractsWhereColumns.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.

ContractsWhereColumns.COMPLETED_AT​

Completed date of the contract.

ContractsWhereColumns.WARRANTY_DUE_AT​

Warranty due date of the contract.

ContractsWhereColumns.CREATED_AT​

The date and time when the contract was created.

ContractsWhereColumns.UPDATED_AT​

The date and time when the contract was last updated.

ContractsWhereColumns.DELETED_AT​

The date and time when the contract was deleted.

Member Of​

ActContractsWhereWhereConditions input ● CompanyContractsWhereWhereConditions input ● ContactContractsWhereWhereConditions input ● ContractChildrenWhereWhereConditions input ● CorrespondenceContractsWhereWhereConditions input ● ExpenseContractsWhereWhereConditions input ● InvoiceContractsWhereWhereConditions input ● LetterContractsWhereWhereConditions input ● MeterContractsWhereWhereConditions input ● PersonContractsWhereWhereConditions input ● ProjectContractsWhereWhereConditions input ● PropertyContractsWhereWhereConditions input ● QueryContractsWhereWhereConditions input ● QuoteContractsWhereWhereConditions input ● TaskContractsWhereWhereConditions input