Description:
Stores individual line items associated with invoices. Each record represents a charge, fee, tax, or refund element linked to a booking or rental, allowing detailed financial breakdowns on invoices.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the invoice line item. |
dtype |
NUMBER | Discriminator type: 0 => LineItem (base), 1 => RentalLineItem. |
description |
TEXT | Description of the item. |
gross_price |
NUMBER | Total price including tax. |
net_price |
NUMBER | Price excluding tax. |
tax |
NUMBER | Absolute value of the tax applied. |
tax_percentage |
NUMBER | Tax rate applied to this line item. |
invoice_id |
NUMBER | Foreign key referencing the associated invoice. |
refunded_lineitem_id |
NUMBER | Reference to a previously charged line item that was refunded (nullable). |
template_id |
NUMBER | ID referencing a predefined line item template. |
rental_id |
NUMBER | Optional reference to the associated rental. |
booking_id |
NUMBER | Optional reference to the associated booking. |
details |
VARIANT | Flexible JSON field storing structured line-item detail records (e.g. breakdowns, source references). |
_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. |