Description
Information about the type of transaction. Transaction types can be a system default type or user created. The data grain is transaction type at the business level.
Columns
| Column Name | Description |
|---|---|
transaction_type_key |
Surrogate key integer |
transaction_type_id |
Identifier for the transaction type associated with the transaction. Note it needs to be combined with business_id to be unique |
transaction_type |
The name of the transaction type |
entry_type |
The nature of the transaction type in terms of credit or debit; enumerated: 'Credit' or 'Debit' |
current_status |
Indicates whether the transaction type is currently active; enumerated: 'Active' or 'Archived' |
transaction_type_source |
The entity that have created the transaction type; enumerated: 'System' or 'Business' |
business_id |
Unique identifier for the business |