Description:
Defines reusable templates for invoice line items. Each template specifies pricing, tax rules, and descriptions that can be applied when generating invoices. Supports override options for descriptions, prices, and tax percentages.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the invoice line item template. |
created_at |
TIMESTAMP_TZ | Timestamp when the template was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the template was last updated. |
created_by |
NUMBER | Identifier of the user who created the template. |
updated_by |
NUMBER | Identifier of the user who last updated the template. |
name |
TEXT | Name of the line item template. |
description |
TEXT | Default description of the line item. |
description_overrideable |
BOOLEAN | Indicates whether the description can be overridden when used. |
category |
TEXT | Category of the line item. |
gross_price |
NUMBER | Gross price (including taxes) of the line item. |
net_price |
NUMBER | Net price (excluding taxes) of the line item. |
price_overrideable |
BOOLEAN | Indicates whether the price can be overridden when used. |
tax_percentage |
NUMBER | Default tax percentage applied to the line item. |
tax_percentage_overrideable |
BOOLEAN | Indicates whether the tax percentage can be overridden when used. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |