The GL Account Detail Report shows general ledger (GL) posting detail for each posting line. It contains the transaction amounts, GL account details, and the location and legal entity names for every primary, offset, intercompany, and statistical posting.
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 |
| date | DATE | GL posting date. For statistical rows this is the transaction header date. Use report_filter_date for the statistical date. |
| report_filter_date | DATE | Date to use when filtering report windows: the statistical date on statistical rows and the transaction date on financial rows. |
| transaction_id | VARCHAR | Transaction header identifier |
| transaction_detail_id | VARCHAR | Identifier of the transaction line. Blank on statistical rows. Use statistical_transaction_detail_id on those rows. |
| transaction_type | NUMBER(38,0) | Numeric transaction type code |
| transaction_type_name | VARCHAR | Human-readable transaction type label |
| number | VARCHAR | Document or reference number |
| comment | VARCHAR | Header-level transaction comment |
| line_comment | VARCHAR | Line-level transaction detail comment. On statistical rows this is the transaction header comment. |
| is_voided | BOOLEAN | True if the transaction has been voided |
| is_voiding | BOOLEAN | True if this transaction is itself the voiding entry for another transaction |
| vendor_id | VARCHAR | Vendor or customer identifier tied to the transaction, where applicable. Blank for transaction types with no vendor or customer link. |
| company_text | VARCHAR | Free-text company or vendor name entered on the transaction. Used for older or manually entered transactions that do not link to a vendor record. |
| approval_status | NUMBER(38,0) | Approval status (1=Unapproved, 2=Approved) |
| is_beginning_balance | BOOLEAN | True when this line is an opening balance entry rather than an activity transaction. Filter this column to exclude opening balance entries. |
| posting_role | VARCHAR(19) | Posting role: PRIMARY, OFFSET, INTERCOMPANY_DEBIT, INTERCOMPANY_CREDIT, or STATISTICAL. This shows where the row came from. It is separate from the statistical account flag. |
| 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 if the account appears on the balance sheet |
| 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 |
| statistical_transaction_detail_id | VARCHAR | Identifier of the statistical transaction line. Blank on financial rows. |