Columns
Column | Type | Children | Parents | Comments |
---|---|---|---|---|
id | int8 |
|
|
|
name | varchar |
|
|
|
description | varchar |
|
|
|
external_id | varchar |
|
|
|
suggested_price_cents | int4 |
|
|
|
suggested_price_currency | varchar |
|
|
|
fgf_rate | numeric |
|
|
|
xero_item_code | varchar |
|
|
|
xero_item_code_tax | varchar |
|
|
|
archived_at | timestamp |
|
|
|
company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
registered_tax_id | int8 |
|
|
|
unregistered_tax_id | int8 |
|
|
|
created_at | timestamp |
|
|
|
updated_at | timestamp |
|
|
|
propagating_updates | bool |
|
|
|
price_limit_min_cents | int4 |
|
|
|
price_limit_min_currency | varchar |
|
|
|
price_limit_max_cents | int4 |
|
|
|
price_limit_max_currency | varchar |
|
|
|
archived_at_in_company_tz | timestamp |
|
|
|
created_at_in_company_tz | timestamp |
|
|
|
updated_at_in_company_tz | timestamp |
|
|
|
company_timezone | varchar |
|
|