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 | 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. |