Field Mapping When Exporting Payment Files Using Bank Data Conversion Service

When you export payment files using the Bank Data Conversion Service feature, the data that you export is exposed to the provider of the bank data conversion service. The service provider is responsible for the privacy of this data. For more information about how the Bank Data Conversion Service feature works, see About the Data Exchange Framework.

Warning

When you export payment files by using the Bank Data Conversion Service feature, some of your business data will be exposed to the provider of the service. The service provider, AMC Consult A/S, is responsible for the privacy of this data. For more information, see AMC Privacy Policy.

The following table lists the fields in Microsoft Dynamics NAV from which data can be exported to the service provider.

Mapped Field Field in Table Table Description

Creditor No.

Creditor No.

Bank Account

The identifier assigned to your company by your bank to collect payments

Sender Bank Account No.

Bank Account No./IBAN

Bank Account

Your company's bank account number (IBAN or other) that is specified on the bank account card

Sender Bank Clearing Standard

Bank Clearing Standard

Bank Account

The national bank names register used for the sender bank account

Sender Bank Clearing Code

Bank Clearing Code

Bank Account

The identifier of the sender's bank in relation to the bank names register used

Sender Bank BIC

SWIFT Code

Bank Account

The SWIFT identifier of the sender bank account

Sender Bank Account Currency

Currency Code

Bank Account

The sender bank account Currency Code

Document No.

Document No.

General Journal Line

The document number of the payment line

Applies-to Ext. Doc. No.

Applies-to Ext. Doc. No.

General Journal Line

The external document number of the invoice or credit memo that the payment line is applied to

Recipient ID

Account No.

General Journal Line

The customer or vendor number that is specified on the payment line

Payment Type

Bank Data Conversion Pmt. Type

Payment Method

The type of bank transfer, such as domestic or international

Payment Reference

Payment Reference

General Journal Line

The payment reference of the payment line

Recipient Address

Address

Customer/Vendor

The recipient address that is specified on the customer or vendor card

Recipient City

City

Customer/Vendor

The recipient city that is specified on the customer or vendor card

Recipient Name

Name

Customer/Vendor

The recipient name that is specified on the customer or vendor card

Recipient Country/Region Code

Country/Region Code

Customer/Vendor

The recipient country/region code that is specified on the customer or vendor card

Recipient Post Code

Post Code

Customer/Vendor

The recipient post code that is specified on the customer or vendor card

Recipient Bank Acc. No.

Bank Account No./IBAN

Customer Bank Account/Vendor Bank Account

The recipient bank account number (IBAN or other) that is specified on the customer or vendor bank account card

Recipient Bank Clearing Code

Bank Clearing Standard

Customer Bank Account/Vendor Bank Account

The national bank names register used for the recipient bank account

Recipient Bank Clearing Std.

Bank Clearing Code

Customer Bank Account/Vendor Bank Account

The identifier of the recipient bank account in relation to the bank names register that is used

Recipient Email Address

E-Mail

Customer/Vendor

The email address of the recipient

Message To Recipient 1

Message to Recipient

General Journal Line

The message to recipient that is specified on the payment line

Amount

Amount

General Journal Line

The amount on the payment line

Currency Code

Currency Code

General Journal Line

The currency code on the payment line

Transfer Date

Posting Date

General Journal Line

The posting date of the payment line

Invoice Amount

Original Amount

Customer/Vendor Ledger Entry

The amount on the entry that the payment is applied to

Invoice Date

Document Date

Customer/Vendor Ledger Entry

The invoice date on the entry that the payment is applied to

Recipient Bank Address

Address

Customer Bank Account/Vendor Bank Account

The recipient bank account address that is specified on the customer or vendor bank account card

The recipient bank account address that is specified on the customer or vendor bank account card

City

Customer Bank Account/Vendor Bank Account

The recipient bank account city that is specified on the customer or vendor bank account card

Recipient Bank Name

Name

Customer Bank Account/Vendor Bank Account

The recipient bank account name that is specified on the customer or vendor bank account card

Recipient Bank Country/Region

Country/Region Code

Customer Bank Account/Vendor Bank Account

The recipient bank account country/region that is specified on the customer or vendor bank account card

Recipient Bank Post Code

Post Code

Customer Bank Account/Vendor Bank Account

The recipient bank account post code that is specified on the customer or vendor bank account card

Sender Bank Address

Address

Bank Account

The sender bank account address that is specified on the bank account card

Sender Bank City

City

Bank Account

The sender bank account city that is specified on the bank account card

Sender Bank Name

Name

Bank Account

The sender bank account name that is specified on the bank account card

Sender Bank Country/Region

Country/Region Code

Bank Account

The sender bank account country/region that is specified on the bank account card

Sender Bank Post Code

Post Code

Bank Account

The sender bank account post code that is specified on the bank account card

General Journal Template

Journal Template Name

General Journal Line

The general journal template that is used for the payment line

General Journal Batch Name

Journal Batch Name

General Journal Line

The general journal batch name that is used for the payment line

Sender Bank Name - Data Conv.

Bank Name – Data Conv.

Bank Account

The sender bank account name that is requested by the bank data conversion service and specified on the bank account card

See Also

Tasks

How to: Set Up Bank Data Conversion Service

Concepts

About the Data Exchange Framework
Data Exchange

Other Resources

Make Payments with Bank Data Conversion Service or SEPA Credit Transfer