The Trial Balance Report shows general ledger (GL) posting detail for the trial balance. It contains one row for each posting line, with the GL account, location, legal entity, and fiscal period. Totals of debits and credits give the beginning balance, period activity, and ending balance.
Column reference
Column | Type | Description |
|---|---|---|
tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
legal_entity_id | VARCHAR | Legal entity identifier |
legal_entity_name | VARCHAR | Legal entity name |
location_id | VARCHAR | Location identifier |
location_name | VARCHAR | Name of the location |
transaction_date | DATE | GL posting date |
operational_period | NUMBER(2,0) | Fiscal period within the operational year (1-12, 4-4-5 calendar) |
operational_quarter | NUMBER(9,0) | Fiscal quarter within the operational year (1-4) |
operational_year | NUMBER(4,0) | Fiscal year based on the 4-4-5 calendar |
transaction_id | VARCHAR | Transaction header identifier |
transaction_detail_id | VARCHAR | Identifier of the transaction line |
transaction_type | NUMBER(38,0) | Numeric transaction type code |
transaction_type_name | VARCHAR | Human-readable transaction type label |
transaction_number | VARCHAR | Document or reference number |
comment | VARCHAR | Header-level transaction comment |
line_comment | VARCHAR | Line-level transaction detail comment |
approval_status | NUMBER(38,0) | Approval status (1=Unapproved, 2=Approved) |
is_beginning_balance | BOOLEAN | True when this line represents an opening balance entry rather than an activity transaction |
posting_role | VARCHAR(19) | Posting role: PRIMARY, OFFSET, INTERCOMPANY_DEBIT, or INTERCOMPANY_CREDIT |
gl_account_id | VARCHAR | GL account identifier for this posting line |
gl_account_number | VARCHAR | GL account number |
gl_account_name | VARCHAR | GL account name |
typical_balance_is_credit | BOOLEAN | True if the account's typical balance is credit |
is_financial_report | BOOLEAN | True for profit and loss (income statement) accounts, and false for balance sheet accounts. |
is_retained_earnings | BOOLEAN | True if this is the retained earnings account. Prior-year profit and loss balances roll into this account. |
is_statistical_account | BOOLEAN | True if this is a statistical (non-financial) account |
parent_gl_account_id | VARCHAR | Direct parent GL account identifier |
parent1_gl_account_id | VARCHAR | Level-1 parent GL account identifier |
parent_account_name | VARCHAR | Level-1 parent GL account name |
parent_account_number | VARCHAR | Level-1 parent GL account number |
debit_amount | NUMBER(38,4) | Debit amount for this posting line |
credit_amount | NUMBER(38,4) | Credit amount for this posting line |