General Ledger

tenant_id

integer

Customer 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 accounting transaction.

transaction_number

string

Human-readable reference number assigned to the accounting transaction.

transaction_type

integer

Classification of the accounting transaction (e.g., Invoice, Credit Memo, Journal Entry).

approval_status

integer

Current approval workflow status of the transaction (e.g., Approved, Pending, Rejected).

header_comment

string

Free-text notes entered at the transaction header level.

date

date

Posting date of the accounting transaction.

gl_type_name

string

Financial report classification for the general ledger account (e.g., Income Statement, Balance Sheet).

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 individual transaction line item.

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

Free-text notes entered at the transaction line level.

item_id

UUID

Unique identifier for the inventory item referenced in this transaction line, if applicable.

item_name

string

Display name of the inventory item referenced in this transaction line, if applicable.

credit_amount

number

Credit amount posted on this transaction line. Expressed in the customer's base currency.

debit_amount

number

Debit amount posted on this transaction line. Expressed in the customer's base currency.