Table: dim_transaction_type

Type: Dimension Columns: 9

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 Type Description
transaction_type_key int32

Surrogate key integer

transaction_type_id string

Identifier for the transaction type associated with the transaction. Note it needs to be combined with business_id to be unique

transaction_type string

The name of the transaction type

entry_type string

The nature of the transaction type in terms of credit or debit; enumerated: 'Credit' or 'Debit'

current_status string

Indicates whether the transaction type is currently active; enumerated: 'Active' or 'Archived'

transaction_type_source string

The entity that have created the transaction type; enumerated: 'System' or 'Business'

business_id string

Unique identifier for the business

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.