Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| issued_on | date |
|
|
|
| reference | text |
|
|
Optional invoice reference. This is often the purchase order number, but can be any free-form text. @note This is available in BYOBI but is null in Lookout Analytics (because it may contain PII). @example: ‘987654’. |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| helper_id | int8 |
|
|
|
| received_at | timestamp |
|
|
|
| billing_run_id | int8 |
|
|
|
| company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
| external_id | varchar |
|
|
External identifier field for supplier invoices. Optional. @example: ‘EXT-123’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| received_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. `Australia/Brisbane |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_supplier_generated_invoices_pkey | Primary key | Asc | id |