---
title: "Transaction Detail"
slug: "transaction-detail"
status: "new"
updated: 2026-10-27T17:31:04Z
published: 2026-10-27T17:44:04Z
canonical: "docs.restaurant365.com/transaction-detail"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Transaction Detail

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](/developer-hub/apidocs/snowflake-data-share-setup) for step-by-step instructions.

## Column reference

| Column | Type | Description |
| --- | --- | --- |
| tenant_id | UUID | Unique identifier of the R365 tenant account. |
| id | UUID | Unique identifier for the transaction detail (line item) record. |
| transaction_id | UUID | Unique identifier of the parent transaction. |
| date | DATE | Date of the transaction detail. |
| name | VARCHAR | Name or description of this line item. |
| credit_amount | NUMBER | Credit amount for this line item. |
| debit_amount | NUMBER | Debit amount for this line item. |
| location_id | UUID | Unique identifier of the location this line item is associated with. |
| legal_entity_id | UUID | Unique identifier of the legal entity this line item belongs to. |
| gl_account_id | UUID | Unique identifier of the GL account this line item is posted to. |
| inter_company_credit_account_id | UUID | Unique identifier of the intercompany credit GL account for this line item. |
| inter_company_debit_account_id | UUID | Unique identifier of the intercompany debit GL account for this line item. |
| offset_account_id | UUID | Unique identifier of the offset GL account for this line item. |
| inter_company_credit_legal_entity_id | UUID | Unique identifier of the legal entity on the credit side of an intercompany entry. |
| inter_company_debit_legal_entity_id | UUID | Unique identifier of the legal entity on the debit side of an intercompany entry. |
| transaction_legal_entity_id | UUID | Unique identifier of the legal entity associated with the parent transaction. |
| inter_company_credit_location_id | UUID | Unique identifier of the location on the credit side of an intercompany entry. |
| inter_company_debit_location_id | UUID | Unique identifier of the location on the debit side of an intercompany entry. |
| transaction_location_id | UUID | Unique identifier of the location associated with the parent transaction. |
| adjustment | NUMBER | Adjustment amount applied to this line item. |
| comment | VARCHAR | Free-text comment on this line item. |
| date_reference | DATE | Reference date for this line item, used in accrual accounting. |
| delivery_date | DATE | Delivery date for this line item, used for inventory transactions. |
| detail_sort | INTEGER | Sort order for this line item within the transaction. |
| detail_type | INTEGER | Type of detail record, used internally to classify line items. |
| each_amount | NUMBER | Unit cost for this line item. |
| each_amount_base | NUMBER | Unit cost in the base currency for this line item. |
| is_excluded | BOOLEAN | Indicates whether this line item is excluded from reporting. |
| is_inter_company | BOOLEAN | Indicates whether this is an intercompany line item. |
| is_offset | BOOLEAN | Indicates whether this is an offset line item. |
| is_missing_receipt | BOOLEAN | Indicates whether the associated receipt is missing. |
| previous_count_total | NUMBER | Previous count total for inventory line items. |
| previous_count_total_base | NUMBER | Previous count total in the base currency for inventory line items. |
| quantity | NUMBER | Quantity for this line item. |
| r365_category | VARCHAR | R365 internal category classification for this line item. |
| is_reconciled | BOOLEAN | Indicates whether this line item has been reconciled. |
| storage_location_id | UUID | Unique identifier of the storage location for inventory line items. |
| is_taxable | BOOLEAN | Indicates whether this line item is subject to tax. |
| total_amount | NUMBER | Total amount for this line item (quantity × unit cost). |
| total_base | NUMBER | Total amount in the base currency for this line item. |
| unit_of_measure | VARCHAR | Unit of measure for this line item. |
| vendor_item_number | VARCHAR | Vendor's item number or SKU for this line item. |
| company_id | UUID | Unique identifier of the company associated with this line item. |
| attribute_1 | VARCHAR | User-defined attribute 1 for this line item. |
| inter_company_credit_attribute_1 | VARCHAR | Attribute 1 for the credit side of an intercompany entry. |
| inter_company_debit_attribute_1 | VARCHAR | Attribute 1 for the debit side of an intercompany entry. |
| transaction_attribute_1 | VARCHAR | Attribute 1 from the parent transaction. |
| attribute_2 | VARCHAR | User-defined attribute 2 for this line item. |
| inter_company_credit_attribute_2 | VARCHAR | Attribute 2 for the credit side of an intercompany entry. |
| inter_company_debit_attribute_2 | VARCHAR | Attribute 2 for the debit side of an intercompany entry. |
| transaction_attribute_2 | VARCHAR | Attribute 2 from the parent transaction. |
| reconciled_to_activity | VARCHAR | Activity this line item was reconciled to. |
| bank_reconciliation_id | UUID | Unique identifier of the bank reconciliation this line item is part of. |
| item_id | UUID | Unique identifier of the inventory item associated with this line item. |
| deposit_id | UUID | Unique identifier of the deposit this line item belongs to. |
| invoice_id | UUID | Unique identifier of the invoice this line item is associated with. |
| transaction_apply_id | UUID | Unique identifier of the transaction apply record linking this line item to a payment. |
| inter_company_link_id | UUID | Unique identifier linking the two sides of an intercompany entry. |
| undeposited_fund_detail_id | UUID | Unique identifier of the undeposited funds detail record for this line item. |
| unit_of_measure_id | UUID | Unique identifier of the unit of measure record. |
| fulfill_quantity | NUMBER | Fulfilled quantity for this line item. |
| count_unit_of_measure_1 | VARCHAR | First unit of measure used in counting for inventory line items. |
| count_quantity_1 | NUMBER | Quantity counted in the first unit of measure. |
| count_unit_of_measure_2 | VARCHAR | Second unit of measure used in counting for inventory line items. |
| count_quantity_2 | NUMBER | Quantity counted in the second unit of measure. |
| count_unit_of_measure_3 | VARCHAR | Third unit of measure used in counting for inventory line items. |
| count_quantity_3 | NUMBER | Quantity counted in the third unit of measure. |
| log_entry_id | UUID | Unique identifier of the log entry associated with this line item. |
| fixed_asset_id | UUID | Unique identifier of the fixed asset associated with this line item. |
| fulfill_cost | NUMBER | Cost of the fulfilled quantity for this line item. |
| auto_match | BOOLEAN | Indicates whether this line item was automatically matched during reconciliation. |
| portion_quantity | NUMBER | Portion quantity for recipe or production line items. |
| yield_quantity | NUMBER | Yield quantity for recipe or production line items. |
| station_id | UUID | Unique identifier of the production station associated with this line item. |
| portion_cost | NUMBER | Cost of a single portion for recipe line items. |
| yield_unit_of_measure | VARCHAR | Unit of measure for the yield quantity. |
| accrual_start_date | DATE | Start date for accrual-period line items. |
| accrual_end_date | DATE | End date for accrual-period line items. |
| brand_item_number | VARCHAR | Brand-level item number for this line item. |
| created_on | TIMESTAMP_NTZ | Date and time the record was created. |
| created_by | UUID | Unique identifier of the user who created the record. |
| modified_on | TIMESTAMP_NTZ | Date and time the record was last modified. |
| modified_by | UUID | Unique identifier of the user who last modified the record. |