Description:
Represents virtual wallets associated with users. Balances are updated over time through financial transactions and settlement attempts.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the balance record. |
name |
TEXT | Human-readable name or label for the balance (e.g., “default”, “business”). |
value |
NUMBER | Current value of the balance. |
owner_id |
NUMBER | Identifier for the owner of the balance. |
branch_id |
NUMBER | Branch to which the balance is associated, if applicable. |
last_settlement_attempt_at |
TIMESTAMP_TZ | Timestamp of the most recent attempt to settle this balance. |
settlement_attempts |
NUMBER | Count of how many times a settlement was attempted. |
type |
NUMBER | Code representing the type/category of the balance (0 => INTERNAL). |
type_name |
TEXT | String label for type. |
created_at |
TIMESTAMP_TZ | Timestamp when the balance was first created. |
updated_at |
TIMESTAMP_TZ | Timestamp of the most recent update. |
created_by |
NUMBER | User or system ID that initially created the balance. |
updated_by |
NUMBER | User or system ID that last updated the balance. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |