Skip to main content

ExpensesWhereColumns

The valid fields by which expenses can be queried.

enum ExpensesWhereColumns {
  ID
  NUMBER
  COMPANY
  PERSON
  STATUS
  PAYMENT_STATUS
  EFFECTIVE_AT
  DUE_AT
  IS_OVERDUE
  CURRENCY
  DISCOUNT
  SUBTOTAL
  SUBTOTAL_EXCLUDING_TAX
  TAX
  TOTAL
  AMOUNT_BASIS
  NOTES
  CREATED_AT
  UPDATED_AT
  DELETED_AT
}

Values​

ExpensesWhereColumns.ID​

Expense's unique identifier.

ExpensesWhereColumns.NUMBER​

The expense's number.

ExpensesWhereColumns.COMPANY​

The expense's company.

ExpensesWhereColumns.PERSON​

The expense's person.

ExpensesWhereColumns.STATUS​

The expense's status.

ExpensesWhereColumns.PAYMENT_STATUS​

Whether the expense is paid.

ExpensesWhereColumns.EFFECTIVE_AT​

Effective date of the expense.

ExpensesWhereColumns.DUE_AT​

Due date of the expense.

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

ExpensesWhereColumns.CURRENCY​

Currency of the expense.

ExpensesWhereColumns.DISCOUNT​

Discount of the expense.

ExpensesWhereColumns.SUBTOTAL​

Subtotal of the expense.

ExpensesWhereColumns.SUBTOTAL_EXCLUDING_TAX​

Subtotal of the expense excluding tax.

ExpensesWhereColumns.TAX​

Tax of the expense.

ExpensesWhereColumns.TOTAL​

Total of the expense.

ExpensesWhereColumns.AMOUNT_BASIS​

Whether the expense's amounts are computed or kept as the supplier's e-invoice stated them.

ExpensesWhereColumns.NOTES​

The expense's notes.

ExpensesWhereColumns.CREATED_AT​

The date and time when the expense was created.

ExpensesWhereColumns.UPDATED_AT​

The date and time when the expense was last updated.

ExpensesWhereColumns.DELETED_AT​

The date and time when the expense was deleted.

Member Of​

ContactExpensesWhereWhereConditions input ● ContractExpensesWhereWhereConditions input ● LetterExpensesWhereWhereConditions input ● ProjectExpensesWhereWhereConditions input ● PropertyExpensesWhereWhereConditions input ● QueryExpensesWhereWhereConditions input ● StructureExpensesWhereWhereConditions input ● TaskExpensesWhereWhereConditions input