api_external.invoices

View

Invoices between an org and the caller's account, or the caller as an individual (Section 4.4.5): payables the party submitted or was self-billed, in every state, and receivables the org issued to it, once issued. Only while the party's engagement on the project has the money area open (Section 8.7). Totals are NULL while any line is unpriced.

Columns of api_external.invoices
Column	Type	Nullable	Description
id	uuid	Yes	Invoice.
org_id	uuid	Yes	Org.
org_name	text	Yes	Org name.
project_id	uuid	Yes	Project.
project_name	text	Yes	Project name.
direction	app.money_direction	Yes	Payable (the party bills the org) or Receivable (the org bills the party).
account_id	uuid	Yes	The caller's account; NULL for an individual's invoice.
invoice_number	text	Yes	Invoice number.
issued_on	date	Yes	Invoice date.
due_on	date	Yes	Due date.
currency_code	character(3)	Yes	Currency.
invoice_state	app.invoice_state	Yes	Invoice state.
total_minor	bigint	Yes	Total with tax in minor units; NULL while any line is unpriced.
applied_minor	bigint	Yes	Approved payments applied in minor units.
balance_minor	bigint	Yes	Total less approved payments applied; NULL while the total is unknown.
submitted_at	timestamp with time zone	Yes	When the invoice was recorded.
issued_at	timestamp with time zone	Yes	When the org issued it.
approved_at	timestamp with time zone	Yes	When the org approved it for payment.
disputed_at	timestamp with time zone	Yes	When it was last disputed.
canceled_at	timestamp with time zone	Yes	When it was canceled.
last_paid_on	date	Yes	Date of the latest approved payment applied.
payee_person_id	uuid	Yes	The caller, for an invoice billed by them as an individual.
engagement_id	uuid	Yes	Engagement the invoice bills.
scheduled_minor	bigint	Yes	Payments recorded against it and awaiting approval, in minor units.
scheduled_on	date	Yes	Payment date of the latest recorded payment awaiting approval.