OPplus to Continia Banking field mapping reference

  • 03.06.2026
  • 10 Minuten Lesedauer

This article lists the source and target mappings for tables and fields involved in migrating data from OPplus to Continia Banking. Use this reference when verifying that data has been transferred correctly after running the migration tool.

For the prerequisites and steps involved in the migration, see Migrating OPplus data to Continia Banking.

SEPA mandate

Source table
Source field
Target table
Target field
OPP Bank Account MandateMandate IDSEPA Direct Debit MandateID
OPP Bank Account MandateAccount No.SEPA Direct Debit MandateCustomer No.
OPP Bank Account MandateCodeSEPA Direct Debit MandateCustomer Bank Account Code
OPP Bank Account MandateMandate DateSEPA Direct Debit MandateDate of Signature
OPP Bank Account MandateMandate Frequency = One-offSEPA Direct Debit MandateType of Payment = OneOff
OPP Bank Account MandateMandate Frequency = RecurrentSEPA Direct Debit MandateType of Payment = Recurrent
OPP Bank Account MandateValid from DateSEPA Direct Debit MandateValid From
OPP Bank Account MandateValid to DateSEPA Direct Debit MandateValid To
OPP Bank Account MandateMaximum UsageSEPA Direct Debit MandateExpected Number of Debits
OPP Bank Account MandateUsageSEPA Direct Debit MandateDebit Counter

Hinweis

If Maximum Usage = 0, the field Ignore Expected Number of Debits is set to true on the target record.

Mandate usage

Source table
Source field
Target table
Target field
OPP Bank Acc. Mandate UsageMandate IDCTS-CB Dir. Deb. Mandate UsageSEPA Mandate Id
OPP Bank Acc. Mandate UsageJournal Template NameCTS-CB Dir. Deb. Mandate UsageJournal Template Name
OPP Bank Acc. Mandate UsageJournal Batch NameCTS-CB Dir. Deb. Mandate UsageJournal Batch Name
OPP Bank Acc. Mandate UsageDateCTS-CB Dir. Deb. Mandate UsageUsage Date

Hinweis

Fixed values set on all migrated records: Used Sequence Type = RCUR; Entry No. = 0; Payment Register No. = 0.

Customer ledger entry: Direct Debit Mandate ID

Source table
Source field
Target table
Target field
Cust. Ledger EntryOPP Mandate IDCust. Ledger Entry (update)Direct Debit Mandate ID

Remittance advice shipping type

Source/Target tableConditionTarget field
Customer/VendorOPP Advice Shipping Type = EmailCTS-CB Send Remittance Advice = Bank & Email

Payment text templates

OPplus payment type codes and payment methods are migrated indirectly into CTS-BMI Text Template records. The following placeholder tokens are mapped to new field references:

OPP CodeTarget field
%1Applies-to Doc. No.
%2Amount to Pay
%3Payment Discount
%4Payment Discount %
%5Account No.
%6External Document No.
%9Document Date
%10Payment Date
%13Currency Code
%14Payment Currency Code
%15Applies-to Doc. Type
%16Our Account No.
%17SEPA Mandate Id
%18SEPA Mandate Date of Signature

Hinweis

The translated text is stored as a text pattern in the CTS-BMI Text Template table.

Cost type

Source
Source field
Target
Target field
OPP Account SettingDefault Charges = BeneficiaryCustomer/VendorCTS-CB Cost Type = CRED
OPP Account SettingDefault Charges = OrdererCustomer/VendorCTS-CB Cost Type = DEBT
OPP Account SettingDefault Charges = ShareCustomer/VendorCTS-CB Cost Type = SHAR

Remittance advice after entries

Source table
Source field
Target
Target field
OPP Account SettingMin. Pos. Payment NoteCustomer / VendorCTS-CB Remit. Adv. After Entr.
OPP Payment Export SetupMin. Pos. Payment NoteCTS-PE Banking Export SetupRemittance Advice After Entr.

Document layout

Source table
Source field
Target
Target field
Custom Report SelectionSource TypeCustom Report Selection (new)Source Type
Custom Report SelectionSource No.Custom Report Selection (new)Source No.
Custom Report SelectionSend To EmailCustom Report Selection (new)Send To Email

Hinweis

Fixed values: Usage is mapped from OPP-Advice to CTS-PE Remittance Advice; Report is set to CTS-PE Remittance Advice.

Bank closing days

Source table
Source field
Target table
Target field
OPP Target CalendarDateCTS-PE Bank Closing DayDate
OPP Target CalendarDescriptionCTS-PE Bank Closing DayDescription

Hinweis

The Country Code is additionally populated from Company Information.

Payment suggestion templates

Source table
Source field
Target table
Target field
OPP Payment Proposal TemplateDescriptionCTS-PE Pmt. Sugg. TemplateDescription
OPP Payment Proposal TemplateTypeCTS-PE Pmt. Sugg. TemplateAccount Type
OPP Payment Proposal TemplateSummarize Per Pmt. HeadCTS-PE Pmt. Sugg. TemplateSummarize per Account
OPP Payment Proposal TemplateCust. / Vend. Linking AccountCTS-PE Pmt. Sugg. TemplateLinking Payment
OPP Payment Proposal TemplateAssociation PaymentCTS-PE Pmt. Sugg. TemplateAssociation Payment
OPP Payment Proposal TemplateWith BacklogCTS-PE Pmt. Sugg. TemplateIncluding Backlog
OPP Payment Proposal TemplateInclude AllCTS-PE Pmt. Sugg. TemplateInclude All Entries
OPP Payment Proposal TemplateInclude on HoldCTS-PE Pmt. Sugg. TemplateInclude on Hold
OPP Payment Proposal TemplateAccount Filter 1–4CTS-PE Pmt. Sugg. TemplateAccount Filter
OPP Payment Proposal TemplateLedger Entry Filter 1–2CTS-PE Pmt. Sugg. TemplateLedger Entry Filter

New payment head

Source table
Source field
Target table
Target field
OPP Account SettingLimit Lines per HeadCustomer / VendorCTS-CB New Payment After Entr.

Payment allocation

Source table
Source field
Target table
Target field
Vendor / Bank AccountsVendor No.CTS-CB Payment AllocationAccount No.
Vendor / Bank AccountsOPP CLI % Calculation Base AmountCTS-CB Payment AllocationCalculation Base Amount
Vendor / Bank AccountsDepot CodeCTS-CB Payment AllocationRecipient Bank Account

Single payments (vendor and customer bank accounts)

Source table
Source field
Target table
Target field
OPP Single Pmt. Bank AccountAccount No.Vendor / Customer Bank AccountVendor/Customer No.
OPP Single Pmt. Bank AccountBank NameVendor / Customer Bank AccountName
OPP Single Pmt. Bank AccountBank Branch No.Vendor / Customer Bank AccountBank Branch No.
OPP Single Pmt. Bank AccountBank Account No.Vendor / Customer Bank AccountBank Account No.
OPP Single Pmt. Bank AccountBank BIC CodeVendor / Customer Bank AccountSWIFT Code
OPP Single Pmt. Bank AccountBank IBAN CodeVendor / Customer Bank AccountIBAN
OPP Single Pmt. Bank AccountBank Name 2Vendor / Customer Bank AccountName 2
OPP Single Pmt. Bank AccountBank AddressVendor / Customer Bank AccountAddress
OPP Single Pmt. Bank AccountBank Address 2Vendor / Customer Bank AccountAddress 2
OPP Single Pmt. Bank AccountBank CityVendor / Customer Bank AccountCity
OPP Single Pmt. Bank AccountBank Post CodeVendor / Customer Bank AccountPost Code
OPP Single Pmt. Bank AccountBank Country/Region CodeVendor / Customer Bank AccountCountry/Region Code
OPP Single Pmt. Bank AccountBank Account OwnerVendor / Customer Bank AccountCTS-CB Alt. Account Owner

Hinweis

In addition, the corresponding Ledger Entry is updated with the Recipient Bank Account.

Bank account verification

All vendor bank accounts, customer bank accounts, and employee bank accounts are verified via a codeunit call. The following fixed values are written to Verification Entries:

FieldValue
Verification MethodOther
CommentMigrated Bank Account Verification

Other direct changes

The following changes are applied without a field-level mapping:

  • IBAN - spaces are removed from IBAN values on all bank account records.
  • Summarize Payments - set to true for all relevant records.
  • Compress Remittance Text - set to true for all relevant records.