Field mapping for exporting bank payment files

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.

CAUTION

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 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

Setting Up Data Exchange
Exchanging Data Electronically How to: Set Up the Bank Data Conversion Service
Make Payments with Bank Data Conversion Service or SEPA Credit Transfer



© 2017 Microsoft. All rights reserved.