1. Granularity

The d_general_ledger dbt table has information about Xero data on transactional level. This means that there is 1 row for each journal_line (journal_line_id is the unique identifier).

You will be able to find the following data for each client:

• journal_id
• created_date_utc
• journal_date
• journal_number
• reference
• source_id
• source_type
• journal_line_id
• account_code
• account_id
• account_name
• account_type
• description
• gross_amount
• net_amount
• tax_amount
• tax_name