Field mapping when exporting payment files using the AMC Banking 365 Fundamentals extension

When you export payment files using the AMC Banking 365 Fundamentals extension, the data that you export is exposed to the service provider. The service provider is responsible for the privacy of this data. Learn more in Use the AMC Banking 365 Fundamentals extension for more information about the AMC Banking 365 Fundamentals extension.

Caution


When you export payment files by using the AMC Banking 365 Fundamentals extension, 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. Learn more in AMC Privacy Policy.
[!NOTE] In the generic version of Business Central, a global provider of services to convert bank data to any file format that your bank requires is set up and connected. In North American versions, the same service can be used to send payment files as electronic funds transfer (EFT), for example the commonly used Automated Clearing House (ACH) network, however with a slightly different process.

The following table lists the fields in Business Central from which you can export data.

Mapped FieldField in TableTableDescription
Creditor No.Creditor No.Bank AccountThe identifier assigned to your company by your bank to collect payments
Sender Bank Account No.Bank Account No./IBANBank AccountYour company's bank account number (IBAN or other) that is specified on the bank account card
Sender Bank Clearing StandardBank Clearing StandardBank AccountThe national bank names register used for the sender bank account
Sender Bank Clearing CodeBank Clearing CodeBank AccountThe identifier of the sender's bank in relation to the bank names register used
Sender Bank BICSWIFT CodeBank AccountThe SWIFT identifier of the sender bank account
Sender Bank Account CurrencyCurrency CodeBank AccountThe sender bank account Currency Code
Document No.Document No.General Journal LineThe document number of the payment line
Applies-to Ext. Doc. No.Applies-to Ext. Doc. No.General Journal LineThe external document number of the invoice or credit memo that the payment line is applied to
Recipient IDAccount No.General Journal LineThe customer or vendor number that is specified on the payment line
Payment TypeBank Data Conversion Pmt. TypePayment MethodThe type of bank transfer, such as domestic or international
Payment ReferencePayment ReferenceGeneral Journal LineThe payment reference of the payment line
Recipient AddressAddressCustomer/VendorThe recipient address that is specified on the customer or vendor card
Recipient CityCityCustomer/VendorThe recipient city that is specified on the customer or vendor card
Recipient NameNameCustomer/VendorThe recipient name that is specified on the customer or vendor card
Recipient Country/Region CodeCountry/Region CodeCustomer/VendorThe recipient country/region code that is specified on the customer or vendor card
Recipient Post CodePost CodeCustomer/VendorThe recipient post code that is specified on the customer or vendor card
Recipient Bank Acc. No.Bank Account No./IBANCustomer Bank Account/Vendor Bank AccountThe recipient bank account number (IBAN or other) that is specified on the customer or vendor bank account card
Recipient Bank Clearing CodeBank Clearing StandardCustomer Bank Account/Vendor Bank AccountThe national bank names register used for the recipient bank account
Recipient Bank Clearing Std.Bank Clearing CodeCustomer Bank Account/Vendor Bank AccountThe identifier of the recipient bank account in relation to the bank names register that is used
Recipient Email AddressE-MailCustomer/VendorThe email address of the recipient
Message To Recipient 1Message to RecipientGeneral Journal LineThe message to recipient that is specified on the payment line
AmountAmountGeneral Journal LineThe amount on the payment line
Currency CodeCurrency CodeGeneral Journal LineThe currency code on the payment line
Transfer DatePosting DateGeneral Journal LineThe posting date of the payment line
Invoice AmountOriginal AmountCustomer/Vendor Ledger EntryThe amount on the entry that the payment is applied to
Invoice DateDocument DateCustomer/Vendor Ledger EntryThe invoice date on the entry that the payment is applied to
Recipient Bank AddressAddressCustomer Bank Account/Vendor Bank AccountThe 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 cardCityCustomer Bank Account/Vendor Bank AccountThe recipient bank account city that is specified on the customer or vendor bank account card
Recipient Bank NameNameCustomer Bank Account/Vendor Bank AccountThe recipient bank account name that is specified on the customer or vendor bank account card
Recipient Bank Country/RegionCountry/Region CodeCustomer Bank Account/Vendor Bank AccountThe recipient bank account country/region that is specified on the customer or vendor bank account card
Recipient Bank Post CodePost CodeCustomer Bank Account/Vendor Bank AccountThe recipient bank account post code that is specified on the customer or vendor bank account card
Sender Bank AddressAddressBank AccountThe sender bank account address that is specified on the bank account card
Sender Bank CityCityBank AccountThe sender bank account city that is specified on the bank account card
Sender Bank NameNameBank AccountThe sender bank account name that is specified on the bank account card
Sender Bank Country/RegionCountry/Region CodeBank AccountThe sender bank account country/region that is specified on the bank account card
Sender Bank Post CodePost CodeBank AccountThe sender bank account post code that is specified on the bank account card
General Journal TemplateJournal Template NameGeneral Journal LineThe general journal template that is used for the payment line
General Journal Batch NameJournal Batch NameGeneral Journal LineThe general journal batch name that is used for the payment line
Sender Bank Name - Data Conv.Bank Name – Data Conv.Bank AccountThe sender bank account name that is requested by the AMC Banking 365 Fundamentals extension and specified on the bank account card

Set Up Data Exchange
Exchange Data Electronically
Use the AMC Banking 365 Fundamentals extension
Make Payments with AMC Banking 365 Fundamentals extension or SEPA Credit Transfer

Find free e-learning modules for Business Central here