maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
GL accounts typed for MergeTree marts. Control accounts are the AR/AP balances subledgers must tie to.
11 of 11
Column
Description
Tests · PII
gl_account_id
Primary key — UInt64.
9 tests
account_code
Account code. Unique.
2 tests
account_name
Account name (renamed from `name`).
account_type
Top-level type — asset / liability / equity / revenue / expense.
1 test
account_subtype
Finer classification. Nullable.
normal_balance
Side that increases the account — debit / credit.
1 test
is_control_account
True for AR/AP control accounts.
is_active
True for active accounts.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.