| Business Data Model Data Model |
| Description | A financial moment or transaction that is conducted through an account in a financial institution. |
| Relationship | |
 Monetary Account is Debited Account in Bank Account Transaction |
|
| Monetary Account is Credited Account in Bank Account Transaction |
|
| Generalization | |
 Bank Account Transaction - Financial Movement |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Bank Account Transaction Amount in Account Currency
| Description | The amount and currency of the transaction expressed in the currency of the bank account. In case that the original currency of the transaction was different from the currency of the bank account, a currency conversion for the amount is implied. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Bank Account Transaction Effective Date
| Description | Date upon which the transaction is executed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Bank Account Transaction Original Transaction Currency
| Description | The amount of the transaction and the identification of the currency that the amount of the transaction is expressed, at the time of the origin of the transaction. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Bank Account Transaction Origination Date
| Description | Date upon which the request for the financial transaction was made. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Bank Account Transaction Posted Date
| Description | Date upon which the financial transaction is posted into the bank account. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Bank Account Transaction Source
| Description | Indicates the party that originates the transaction. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Debit Credit Ind
| Description | Indicates whether the financial transaction was a debit or credit. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Monetary Account is Debited Account in Bank Account Transaction
| Is Identifying Relationship | false |
| Child Table | Bank Account Transaction |
| Child Role Name | has for debited account |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Monetary Account |
| Parent Role Name | is debited account in |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Monetary Account is Credited Account in Bank Account Transaction
| Is Identifying Relationship | false |
| Child Table | Bank Account Transaction |
| Child Role Name | has for credited account |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Monetary Account |
| Parent Role Name | is credited account in |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Bank Account Transaction - Financial Movement
| Supertype | Financial Movement |
| Subtype | Bank Account Transaction |
| Transform As | TABLE |
| Business Data Model Data Model |