Transaction Detail

Prev Next

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.