api_external.invoices

Vista

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.

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