Bronze Models¶
14 models in the epm_bronze schema. Raw D365 OData data, type-cast to ClickHouse types and renamed to snake_case. No business logic applied.
All Bronze models source from Airbyte-managed tables in the epm_bronze database.
General Ledger¶
bronze_general_journal_account_entries¶
GL line items — debits and credits.
| Column | Type | Description | Test |
|---|---|---|---|
recid |
Int64 | D365 record ID | not_null |
data_area_id |
String | Legal entity | not_null |
main_account |
String | Account code | |
debit_amount |
Decimal(18,2) | Debit in accounting currency | |
credit_amount |
Decimal(18,2) | Credit in accounting currency | |
accounting_currency_amount |
Decimal(18,2) | Net amount | |
general_journal_entry_recid |
Int64 | FK to journal headers |
bronze_general_journal_entries¶
Journal headers.
| Column | Type | Description | Test |
|---|---|---|---|
recid |
Int64 | D365 record ID | not_null |
journal_number |
String | Journal entry number | |
accounting_date |
Date | Posting date | |
subledger_voucher |
String | Voucher number |
Chart of Accounts¶
bronze_main_accounts¶
Account master data.
| Column | Type | Description | Test |
|---|---|---|---|
main_account_id |
String | Account code | not_null |
name |
String | Account name | |
type |
String | Account type (D365 enum: 0–7 or string) |
bronze_main_account_categories¶
Account category mapping.
| Column | Type | Description | Test |
|---|---|---|---|
recid |
Int64 | Record ID | not_null |
account_category |
String | Category name |
Organization¶
bronze_legal_entities¶
Legal entity / company master.
| Column | Type | Description | Test |
|---|---|---|---|
data_area |
String | Entity code | not_null, unique |
name |
String | Company name | |
accounting_currency |
String | Functional currency |
Fiscal Calendar¶
bronze_fiscal_calendars¶
Calendar definitions.
| Column | Type | Description |
|---|---|---|
calendar_id |
String | Calendar identifier |
description |
String | Calendar name |
bronze_fiscal_calendar_years¶
Year definitions within a calendar.
| Column | Type | Description |
|---|---|---|
fiscal_calendar_id |
String | FK to calendar |
start_date |
Date | Year start date |
end_date |
Date | Year end date |
name |
String | Year label |
Financial Dimensions¶
bronze_financial_dimensions¶
Dimension definitions.
| Column | Type | Description |
|---|---|---|
dimension_name |
String | Dimension name (e.g., CostCenter, Department) |
bronze_financial_dimension_values¶
Dimension value master.
| Column | Type | Description |
|---|---|---|
dimension_name |
String | Parent dimension |
dimension_value |
String | Value code |
description |
String | Display description |
is_active |
UInt8 | Active flag |
Exchange Rates¶
bronze_exchange_rate_currency_pairs¶
Exchange rate data.
| Column | Type | Description |
|---|---|---|
from_currency |
String | Source currency |
to_currency |
String | Target currency |
exchange_rate |
Float64 | Rate (D365 stores × 100) |
valid_from |
Date | Effective start |
valid_to |
Date | Effective end |
bronze_exchange_rate_types¶
Rate type definitions.
| Column | Type | Description |
|---|---|---|
name |
String | Rate type name (e.g., Default) |
description |
String | Description |
Budget¶
bronze_budget_register_entries¶
Budget register headers.
| Column | Type | Description |
|---|---|---|
entry_number |
String | Register entry number |
budget_model_id |
String | Budget model identifier |
status |
String | Entry status |
bronze_budget_transaction_lines¶
Budget line items.
| Column | Type | Description |
|---|---|---|
main_account |
String | Account code |
amount |
Decimal(18,2) | Budget amount |
date |
Date | Budget date |
data_area_id |
String | Legal entity |
Consolidation¶
bronze_consolidation_account_groups¶
Consolidation account group mapping.
| Column | Type | Description |
|---|---|---|
consolidation_account_group |
String | Group identifier |
Trial Balance Snapshot¶
bronze_trial_balance_snapshot¶
Pre-built trial balance from D365 (fiscal year snapshots).
| Column | Type | Description |
|---|---|---|
data_area_id |
String | Legal entity |
fiscal_year |
UInt16 | Year |
main_account |
String | Account code |
debit_amount |
Decimal(18,2) | Annual debit |
credit_amount |
Decimal(18,2) | Annual credit |