Agreement Payment MethodAnniversary DateFirst Due DateMoney Scheduler DescrMoney Scheduler End DateMoney Scheduler Start DateNext Due DateRepeat Rt
| Business Data Model Data Model |
| Description | A definition of how the money will be paid, when it will be paid and who will pay and receive it. |
| Attributes | |
| Agreement Payment Method |
|
| Anniversary Date |
|
| First Due Date |
|
| Money Scheduler Descr |
|
| Money Scheduler End Date |
|
| Money Scheduler Start Date |
|
| Next Due Date |
|
| Repeat Rt |
|
| Relationship | |
 Party is payer in Money Scheduler |
|
| Money Scheduler_Agreement_FK |
|
| Party is payee in Money Scheduler |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Agreement Payment Method
| Description | Indicates the way the money will be paid by the payer to the receiver. For example: Bank transfer Cash Credit card Direct debit Offset Payroll deduction Standing order Transfer Via intermediary Check |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Anniversary Date
| Description | The day and month that are used to calculate the payment due dates for the payments and payment dues created by the money scheduler. |
| 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 |
First Due Date
| Description | The date upon which the first amount of money is due for this money scheduler. This first amount of money itself is derived from the elements of the money provisions related to this money scheduler. |
| 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 |
Money Scheduler Descr
| Description | A textual statement used to explain the meaning of this money scheduler. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Money Scheduler End Date
| Description | The date upon which the money scheduler ceases to be active. |
| 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 |
Money Scheduler Start Date
| Description | The date upon which the money scheduler becomes active. |
| 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 |
Next Due Date
| Description | The date upon which the next amount of money is due for the money scheduler. |
| 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 |
Repeat Rt
| Description | Indicates the repeat rate of money scheduler. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Party is payer in Money Scheduler
| Is Identifying Relationship | false |
| Child Table | Money Scheduler |
| Child Role Name | has payer of |
| 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 | Party |
| Parent Role Name | is payer in |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Money Scheduler_Agreement_FK
| Is Identifying Relationship | false |
| Child Table | Money Scheduler |
| 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 | Agreement |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Party is payee in Money Scheduler
| Is Identifying Relationship | false |
| Child Table | Money Scheduler |
| Child Role Name | has payee of |
| 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 | Party |
| Parent Role Name | is payee in |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |