Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| purchase_order_line_service_id | int8 |
|
|
The unique identifier for the purchase order line service record. E.g. 526. |
|||
| updated_at | timestamp |
|
|
The timestamp when this record was last updated (in UTC). E.g.: 2021-03-02 00:12:59.996101. |
|||
| created_at | timestamp |
|
|
The timestamp when this record was created (in UTC). E.g.: 2021-03-02 00:12:59.996101. |
|||
| service_id | int8 |
|
|
The ID of the service associated with this purchase order line. E.g. 123. |
|||
| purchase_order_line_id | int8 |
|
|
The ID of the purchase order line this service is associated with. E.g. 789. |
|||
| company_timezone | varchar |
|
|
The timezone of the company that owns this record. E.g. “Australia/Sydney”. |
|||
| created_at_in_company_tz | timestamp |
|
|
The timestamp when this record was created (in the company’s local timezone). E.g.: 2021-03-02 10:12:59.996101. |
|||
| updated_at_in_company_tz | timestamp |
|
|
The timestamp when this record was last updated (in the company’s local timezone). E.g.: 2021-03-02 10:12:59.996101. |
|||
| company_id | int8 |
|
|
The company ID. E.g. 456. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_purchase_order_lines_services_pkey | Primary key | Asc | purchase_order_line_service_id |
| fct_purchase_order_lines_services_company_id_idx | Performance | Asc | company_id |