Skip to main content

InvoicesWhereColumns

The valid fields by which invoices can be queried.

enum InvoicesWhereColumns {
ID
NUMBER
CLIENT
PERSON
ISSUER
STATUS
TYPE
EFFECTIVE_AT
DUE_AT
IS_OVERDUE
PRICE_LIST
CURRENCY
DISCOUNT
SUBTOTAL
SUBTOTAL_EXCLUDING_TAX
TAX
TOTAL
NOTES
CREATED_AT
UPDATED_AT
DELETED_AT
}

Values​

InvoicesWhereColumns.ID​

Invoice's unique identifier.

InvoicesWhereColumns.NUMBER​

The invoice's number.

InvoicesWhereColumns.CLIENT​

The invoice's client.

InvoicesWhereColumns.PERSON​

The invoice's person.

InvoicesWhereColumns.ISSUER​

The invoice's issuer.

InvoicesWhereColumns.STATUS​

The invoice's status.

InvoicesWhereColumns.TYPE​

The invoice's type.

InvoicesWhereColumns.EFFECTIVE_AT​

Effective date of the invoice.

InvoicesWhereColumns.DUE_AT​

Due date of the invoice.

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

InvoicesWhereColumns.PRICE_LIST​

Price list of the invoice.

InvoicesWhereColumns.CURRENCY​

Currency of the invoice.

InvoicesWhereColumns.DISCOUNT​

Discount of the invoice.

InvoicesWhereColumns.SUBTOTAL​

Subtotal of the invoice.

InvoicesWhereColumns.SUBTOTAL_EXCLUDING_TAX​

Subtotal of the invoice excluding tax.

InvoicesWhereColumns.TAX​

Tax of the invoice.

InvoicesWhereColumns.TOTAL​

Total of the invoice.

InvoicesWhereColumns.NOTES​

The invoice's notes.

InvoicesWhereColumns.CREATED_AT​

The date and time when the invoice was created.

InvoicesWhereColumns.UPDATED_AT​

The date and time when the invoice was last updated.

InvoicesWhereColumns.DELETED_AT​

The date and time when the invoice was deleted.

Member Of​

ActInvoicesWhereWhereConditions input ● ContactInvoicesWhereWhereConditions input ● ContractInvoicesWhereWhereConditions input ● LetterInvoicesWhereWhereConditions input ● ProjectInvoicesWhereWhereConditions input ● PropertyInvoicesWhereWhereConditions input ● QueryInvoicesWhereWhereConditions input ● QuoteInvoicesWhereWhereConditions input ● SpecificationInvoicesWhereWhereConditions input ● StructureInvoicesWhereWhereConditions input ● TaskInvoicesWhereWhereConditions input