The GL Account Activity view is the financial transaction record for R365. It contains debit and credit activity by general ledger account for each legal entity in an organization.
Gl Account Activity Columns
column_name | data_type | description |
|---|---|---|
tenant_id | integer | Customer's account identifier within the R365 platform. |
legal_entity_id | UUID | Unique identifier for the legal entity (business unit) associated with this transaction. |
legal_entity_name | string | Display name of the legal entity (business unit) associated with this transaction. |
transaction_id | UUID | Unique identifier for the transaction. |
transaction_number | string | Human-readable transaction number assigned to this transaction. |
transaction_type | integer | Numeric code identifying the type of transaction (e.g., invoice, payment, credit memo). |
approval_status | integer | Numeric code representing the current approval status of the transaction. |
header_comment | string | Optional free-text comment entered at the transaction header level. |
date | date | Date the transaction was recorded. |
gl_type_name | string | GL account type name (e.g. Assets, Liabilities, Revenue). |
gl_account_number | string | General ledger account number associated with this transaction line. |
gl_account_name | string | Display name of the general ledger account associated with this transaction line. |
transaction_detail_id | UUID | Unique identifier for the transaction detail (line-level record). |
location_id | UUID | Unique identifier for the restaurant location associated with this transaction line. |
location_name | string | Display name of the restaurant location associated with this transaction line. |
detail_comment | string | Optional free-text comment entered at the transaction detail (line) level. |
item_id | UUID | Unique identifier for the inventory item associated with this transaction line, if applicable. |
item_name | string | Display name of the inventory item associated with this transaction line, if applicable. |
credit_amount | number | Credit amount for this transaction line. Expressed in the customer's base currency. |
debit_amount | number | Debit amount for this transaction line. Expressed in the customer's base currency. |