ER design domain specific data model

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The following steps explain how a user in the System Administrator or Electronic Reporting Developer role can create a new Electronic reporting (ER) configuration that contains a data model for electronic payment documents. You use this data model as a data source when you create the format of the payment documents.

In this example, you create a configuration for sample company, Litware, Inc. You can perform these steps in any company because ER configurations are shared among companies. To complete these steps, you must first complete the steps in the "Create a configuration provider and mark it as active" procedure.

Go to Organization administration > Workspaces > Electronic reporting.

Select the configuration provider for sample company, Litware, Inc. If you don't see this configuration provider, you must first complete the steps in the "Create a configuration provider and mark it as active" procedure.
Select Reporting configurations.

You create a configuration that contains a data model for electronic payment documents. You use this data model as a data source when you create the format for the payment documents.

Create a new data model configuration

Select Create configuration to open the dialog.
In the Name field, type Payments (simplified model).
In the Description field, type Payment model configuration.

The active configuration provider is automatically entered here. This provider can maintain this configuration. Other providers can use this configuration, but can't maintain it.
Select Create configuration to complete the configuration creation task.

Create a data model

Create a new data model for the selected configuration. This configuration version has a status of Draft.

Select Designer.

Define the structure of a party participating in a payment process

Select New to open the drop dialog.
In the Name field, type Party.
Select Add.
Select New to open the drop dialog.
In the Name field, type Name.
In the Item type field, select String.
Select Add.
In the Find field, type Party.
Select Find previous.

Define the bank structure for this model

Select New to open the drop dialog.
In the Name field, type Agent.
In the Item type field, select Record.
Select Add.
In the Description field, enter Financial institution (for instance, a bank) servicing an account for the party (debtor/creditor)..

Financial institution (for instance, a bank) servicing an account for the party (debtor/creditor).
Select New to open the drop dialog.
In the Name field, type Name.
In the Item type field, select String.
Select Add.
Select New to open the drop dialog.
In the Name field, type SWIFT.
Select Add.
In the Description field, enter Bank identification code.
Select New to open the drop dialog.
In the Name field, type RoutingNumber.
Select Add.
In the Description field, enter Routing number.
Select Find previous.

Define the bank account structure for this model

Select New to open the drop dialog.
In the Name field, type Account.
In the Item type field, select Record.
Select Add.
In the Description field, enter Identification of an account of a party in a financial institution (for instance, a bank)..

Identification of an account of a party in a financial institution (for instance, a bank).
Select New to open the drop dialog.
In the Name field, type Currency.
In the Item type field, select String.
Select Add.
In the Description field, enter Currency code.
Select New to open the drop dialog.
In the Name field, type Number.
Select Add.
Select New to open the drop dialog.
In the Name field, type IBAN.
Select Add.
In the Description field, enter International bank account number.

Define the payment message structure for credit transfer payment type

Select New to open the drop dialog.
In New node as a field, enter Model root.
In Name, type CustomerCreditTransferInitiation.
Select Add.
In Find, type CustomerCreditTransferInitiation.
Select Find previous.
Select New to open the drop dialog.
In Name, type MessageIdentification.
Select Add.
In Description, enter The point-to-point reference assigned by the instructing party (and sent to the next party) to identify a message..

The point-to-point reference assigned by the instructing party (and sent to the next party) to identify a message.
Select New to open the drop dialog.
In Name, type ProcessingDateTime.
In Item type, select DateTime.
Select Add.
In Description, enter Date and time at which the payment message was created..
Select New to open the drop dialog.

Define the payment transaction structure for this model.
In Name, type Payments.
In Item type, select Record list.
Select Add.
In Description, enter Payment lines of the current message.
Select New to open the drop dialog.
In Name, type Creditor.
In the Item type field, select Record.
Select Add.
In Description, enter Party to which an amount of money is due..
Select Switch item reference.
In the Find field, type Party.
Select Find next.
Select OK.
In Find, type Payments.
Select Find next.
Select New to open the drop dialog.
In Name, type Debtor.
Select Add.
In Description, enter Party that owes an amount of money to the (ultimate) creditor..
Select Switch item reference.
In the Find field, type Party.
Select Find next.
Select OK.
Select Find next.
Select New to open the drop dialog.
In Name, type Description.
In the Item type field, select String.
Select Add.
Select New to open the drop dialog.
In the Name field, type Currency.
Select Add.
In the Description field, enter Currency code.
Select New to open the drop dialog.
In Name, type TransactionDate.
In Item type, select Date.
Select Add.
In the Description field, enter Transaction date.
Select New to open the drop dialog.
In the Name field, type InstructedAmount.
In the Item type field, select Real.
Select Add.
In the Description field, enter The amount of money to be moved between the debtor and creditor, before deduction of charges. The amount should be expressed in the currency as ordered by the initiating party.

The amount of money to be moved between the debtor and creditor, before deduction of charges. The amount should be expressed in the currency as ordered by the initiating party.
Select New to open the drop dialog.
In the Name field, type End2EndID.
In the Item type field, select String.
Select Add.
In the Description field, enter The unique identification assigned by the initiating party. This identification is passed on, unchanged, throughout the entire end-to-end chain.
In the Name field, type PaymentModel.

The PaymentModel name aligns with predefined interfaces of payment forms.
Select Save.
Close the page.

Feedback

Was this page helpful?

Last updated on 2026-04-13