mission_invoice_lines
NEW
In short
Details on the invoice lines associated to missions signed by an accounting firm.
A mission line is a promise an accounting firm makes to a client to deliver a specific service on a specific product.
Mission lines are created manually or automatically, for example when entering time sheets on an activity, or when invoicing the client. When created manually, a budget can be planned as well as a revenue to help the firm manage its resources effectively. In this table we provide details on the invoice lines associated to missions signed by an accounting firm.
Filter key(s)
company_id
Available Columns
firm_id
bigint
The unique identifier of the firm owning the company associated with the invoice line.
firm_name
character varying
The name of the firm owning the company associated with the invoice line.
id
bigint
UNIQUE
The unique identifier of the invoice line.
mission_line_id
bigint
The unique identifier of the mission line associated with the invoice line, if any
invoice_id
bigint
The unique identifier of the customer invoice where this invoice line appears.
company_id
bigint
The unique identifier of the company associated with the invoice line.
product_id
bigint
The unique identifier of the product associated with the invoice line, if any.
product_name
character varying
The name of the product associated with the invoice line, if any.
label
character varying
The label or description of the invoice line.
vat_rate
character varying
The VAT rate applicable to this invoice line.
amount_eur
numeric
The total amount (including VAT) billed in this invoice line, in euros.
tax_eur
numeric
The VAT amount billed in this invoice line, in euros.
amount
numeric
The total amount (including VAT) billed in this invoice line, in the invoice currency.
tax
numeric
The VAT amount billed in this invoice line, in the invoice currency.
currency
character varying
The currency code of the invoice line (e.g., EUR, USD).
quantity
DOUBLE PRECISION
The quantity of products or services billed in this invoice line.
unit
character varying
The unit of measurement for the quantity billed in this invoice line.
invoice_deadline
date
Invoice due date, in YYYY-MM-DD format.
invoice_issue_date
date
The date of the customer invoice where this invoice line appears. in YYYY-MM-DD format. In rare situations, an invoice may be received late after the books for the associated fiscal period are closed. In this case, the issue date will default to the first day of the next open fiscal period.
invoice_number
character varying
The human-readable number of the customer invoice where this invoice line appears, as specified on the invoice.
Examples: "F-2023-05-118", "F-2022-06-426"
invoice_is_paid
boolean
Whether the customer invoice where this invoice line appears has been fully paid. true the invoice has already been reconciled with its payment.
false otherwise.
An invoice can be set as paid automatically in the following cases:
- when the payment is made via the Pro Account, Qonto or an SEPA XML file export;
- when a payment is scheduled.
invoice_is_draft
boolean
Whether the customer invoice where this invoice line appears is still a draft.
outstanding_balance
numeric
Remaining amount to be paid for the invoice where this invoice line appears, in euros.
agreement_year
integer
Year of the engagement letter associated to this entry.
mission
character varying
The name of the mission associated with the invoice line, if any.
customer_id
bigint
The unique identifier of the customer associated with line, referring to customers.id.
customer_name
character varying
Name of the company's customer, as configured on Pennylane. This name may differ slightly from the one displayed on the invoice.
customer_code
character varying
The registration number of the company's customer, as configured on Pennylane, if any.
created_at
timestamp without time zone
The timestamp when the invoice line was created.
updated_at
timestamp without time zone
The timestamp when the invoice line was last updated.
updated_by
bigint
The unique identifier of the user who last updated the invoice line, if any.