Line-item detail rows for each financial transaction, with one row per transaction line.
Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions.
Column reference
Column | Type | Description |
|---|---|---|
tenant_id | NUMBER(38,0) | Identifier of the customer account (tenant) that owns the record. |
id | VARCHAR | Unique identifier of the transaction line. |
transaction_id | VARCHAR | Identifier of the parent transaction. |
date | DATE | The accounting date of the transaction this line belongs to. Every line of a transaction shows the same date as its header. |
name | VARCHAR | A short label for the line. For lines the system creates (for example sales summary lines) it starts with the GL account name. Many lines have no name. |
credit_amount | NUMBER(38,2) | Credit amount of the line. The value is zero when the line is a debit. |
debit_amount | NUMBER(38,2) | Debit amount of the line. The value is zero when the line is a credit. |
location_id | VARCHAR | Identifier of the location the line is recorded against. |
legal_entity_id | VARCHAR | Identifier of the legal entity the line is recorded against. |
gl_account_id | VARCHAR | Identifier of the GL account the line is posted to. |
inter_company_credit_account_id | VARCHAR | Identifier of the GL account on the credit side of an intercompany line. |
inter_company_debit_account_id | VARCHAR | Identifier of the GL account on the debit side of an intercompany line. |
offset_account_id | VARCHAR | Identifier of the GL account that offsets the line, such as the accounts payable account on AP invoice lines. |
inter_company_credit_legal_entity_id | VARCHAR | Identifier of the legal entity on the credit side of an intercompany line. |
inter_company_debit_legal_entity_id | VARCHAR | Identifier of the legal entity on the debit side of an intercompany line. |
transaction_legal_entity_id | VARCHAR | Identifier of the legal entity of the parent transaction (header), as opposed to the legal entity of the line. |
inter_company_credit_location_id | VARCHAR | Identifier of the location on the credit side of an intercompany line. |
inter_company_debit_location_id | VARCHAR | Identifier of the location on the debit side of an intercompany line. |
transaction_location_id | VARCHAR | Identifier of the location of the parent transaction (header), as opposed to the location of the line. |
adjustment | NUMBER(38,2) | Overhead amount on the line. |
comment | VARCHAR | Free-text comment entered on the transaction line. |
date_reference | TIMESTAMP_NTZ | Not currently used. Filled only on a small number of older lines (2013 to 2020). |
delivery_date | TIMESTAMP_NTZ | Currently not populated: this column is empty on every row. |
detail_sort | NUMBER(38,10) | Sort order of the line within the transaction. |
detail_type | NUMBER(38,0) | Type of the transaction line. 1 = Undeposited funds clearing, 2 = Tax, 3 = Credit expected, 4 = Checking, 5 = Detail, 6 = Inventory, 7 = Stock count storage location, 8 = Intercompany, 10 = Beginning balance reverse, 11 = Transfer to, 12 = Budget, 13 = Discount, 14 = Labor estimate clearing. |
each_amount | NUMBER(38,4) | Amount per single unit (each) of the item on the line. Multiplied by quantity it gives the line amount. |
each_amount_base | NUMBER(38,4) | The price or cost of one unit of the item on the line, kept as a second copy in the company's base currency. Where written it equals the each amount. Blank on lines with no unit price. |
is_excluded | BOOLEAN | True when the line is left out of bank reconciliation. Voided lines and lines removed from the undeposited funds list are excluded, and excluded deposits no longer show as available to deposit. |
is_inter_company | BOOLEAN | True when the line is part of an intercompany transaction. |
is_offset | BOOLEAN | Indicates whether the line is an offset line, such as the accounts payable offset. |
is_missing_receipt | BOOLEAN | True when the payment on the line was flagged as having no receipt (the 'No Rct' check box on the daily sales summary exceptions grid). |
previous_count_total | NUMBER(38,2) | For inventory count lines: the dollar value of this item and storage location at the previous count. Blank or zero on other lines. |
previous_count_total_base | NUMBER(38,4) | For inventory count lines: the cost per unit that applied at the previous count. Despite the name it is not a currency-converted total. Blank or zero on other lines. |
quantity | NUMBER(38,10) | Quantity of the item on the line. |
r365_category | NUMBER(38,0) | Category of a daily sales summary line. 1 = Sale, 2 = Payment, 3 = Paid out, 4 = Labor, 5 = Over/short, 6 = Deposit, 7 = History, 8 = Journal entry adjustment, 9 = Tips payable, 10 = Petty cash, 12 to 15 = Deposits 2 to 5. Other codes occur in the data and are not defined here. Blank or 0 on lines that did not come from a daily sales summary. |
is_reconciled | BOOLEAN | True when the line has been matched in a bank reconciliation. |
storage_location_id | VARCHAR | Name of the storage location where the counted item is stored, for example Freezer or Walk In. Despite the column name it holds the name, not an ID. |
is_taxable | BOOLEAN | True when the line is taxable. |
total_amount | NUMBER(38,2) | Total amount of the line. |
total_base | NUMBER(38,4) | The line total kept as a second copy in the company's base currency. Where written it equals the line total. Blank on most lines. |
unit_of_measure | VARCHAR | Name of the unit of measure of the line. |
vendor_item_number | VARCHAR | Vendor's item number for the item on the line. |
company_id | VARCHAR | The company (vendor or customer) the line relates to, as an identifier. Blank when the line has no company. |
attribute_1 | VARCHAR | Identifier of the first user-defined attribute on the line (a tag whose name each company sets in its preferences). Blank when no attribute is set. |
inter_company_credit_attribute_1 | VARCHAR | Identifier of the first user-defined attribute for the credit side of an intercompany line. Blank when no attribute is set. |
inter_company_debit_attribute_1 | VARCHAR | Identifier of the first user-defined attribute for the debit side of an intercompany line. Blank when no attribute is set. |
transaction_attribute_1 | VARCHAR | Identifier of the first user-defined attribute carried from the line to the transaction. Blank when no attribute is set. |
attribute_2 | VARCHAR | Currently not populated: this column is empty on every row. |
inter_company_credit_attribute_2 | VARCHAR | Currently not populated: this column is empty on every row. |
inter_company_debit_attribute_2 | VARCHAR | Currently not populated: this column is empty on every row. |
transaction_attribute_2 | VARCHAR | Currently not populated: this column is empty on every row. |
reconciled_to_activity | VARCHAR | The bank activity record (an imported bank statement line) that this line was matched to during bank reconciliation. Blank until the line is matched. |
bank_reconciliation_id | VARCHAR | Identifier of the bank reconciliation the line was reconciled in. |
item_id | VARCHAR | Identifier of the inventory item on the line, if any. |
deposit_id | VARCHAR | The bank deposit that this line was deposited into. Blank until the line is included in a deposit. |
invoice_id | VARCHAR | The invoice that was created to bill this line, used for franchise billing. Blank for lines not billed this way. |
transaction_apply_id | VARCHAR | Identifier of the payment application (the record that applies a payment or credit to an invoice) that a discount or intercompany line comes from. Blank on other lines. |
inter_company_link_id | VARCHAR | Currently not populated: this column is empty on every row. |
undeposited_fund_detail_id | VARCHAR | For an intercompany line created by a deposit, the undeposited funds line it offsets. Blank on other lines. |
unit_of_measure_id | VARCHAR | Identifier of the unit of measure of the line. |
fulfill_quantity | NUMBER(38,10) | The quantity of an item actually supplied when a commissary (central kitchen) order is fulfilled. Blank on lines not part of a commissary order. |
count_unit_of_measure_1 | VARCHAR | Identifier of count unit of measure 1 used to count the item. |
count_unit_of_measure_2 | VARCHAR | Identifier of count unit of measure 2 used to count the item. |
count_unit_of_measure_3 | VARCHAR | Identifier of count unit of measure 3 used to count the item. |
count_quantity_1 | NUMBER(38,10) | Quantity of the item counted in count unit of measure 1. |
count_quantity_2 | NUMBER(38,10) | Quantity of the item counted in count unit of measure 2. |
count_quantity_3 | NUMBER(38,10) | Quantity of the item counted in count unit of measure 3. |
log_entry_id | VARCHAR | Currently not populated: this column is empty on every row. |
fixed_asset_id | VARCHAR | Identifier of the fixed asset linked to the line. |
fulfill_cost | NUMBER(38,2) | The unit cost of the item at the moment a commissary order was fulfilled. Blank on lines not part of a commissary fulfillment. |
auto_match | NUMBER(38,0) | 1 when the line was matched automatically in bank reconciliation, 0 when it was matched manually. |
portion_quantity | NUMBER(38,2) | Currently not populated: this column is empty on every row. |
yield_quantity | NUMBER(38,2) | For a prep log line, the amount of the recipe produced per batch, in the unit shown in the yield unit of measure. Blank on other lines. |
station_id | VARCHAR | The prep station (kitchen station) on a prep log line. Blank on other lines. |
portion_cost | NUMBER(38,2) | Currently not populated: this column is empty on every row. |
yield_unit_of_measure | VARCHAR | The unit of measure (for example quart or case) for the yield quantity on a prep log line. Blank on other lines. |
accrual_start_date | DATE | Start date of the service period for accrual. |
accrual_end_date | DATE | End date of the service period for accrual. |
brand_item_number | VARCHAR | Brand item number of the item on the line. |
created_on | TIMESTAMP_NTZ | Date and time the line was created. |
created_by | VARCHAR | User who created the line. |
modified_on | TIMESTAMP_NTZ | Date and time the line was last modified. |
modified_by | VARCHAR | User who last modified the line. |