Payment Management to Continia Banking data migration overview

The Continia Banking Data Migration app transfers data from Payment Management (CPM) to Continia Banking (CBA).

This article lists the source and target mappings for tables and fields. For the prerequisites and steps involved with migration from Payment Management to Continia Banking, see Migrating Payment Management data to Continia Banking

Vendor payment information

Source table
Source field
Target table
Target field
VendorCPM Allow Summarizing PaymentsVendorCTS-CB Allow Sum. Payments
VendorCPM Excl. Cr. M. Summ. Pmt.VendorCTS-CB Excl. Cr. M. Sum. Pmt.
VendorCPM Excl. Payments Summ. Pmt.VendorCTS-CB Excl. Pmts. Sum. Pmt.
VendorCPM Excl. Refunds Summ. Pmt.VendorCTS-CB Excl. Refunds Sum. Pmt.
VendorCPM Bal. Account No.VendorCTS-CB Bal. Account No.
VendorCPM Skip PaymentVendorCTS-CB Skip Payment
VendorCPM Recipient E-MailVendorCTS-CB Recipient Email
VendorCPM SSNVendorCTS-CB Social Security No.
VendorCPM Cost Type CodeVendorCTS-CB Cost Type
VendorCPM Notification MethodVendorCTS-CB Send Remittance Advice

Customer payment information

Source table
Source field
Target table
Target field
CustomerCPM Bal. Account No.CustomerCTS-CB Bal. Account No.
CustomerCPM Recipient E-MailCustomerCTS-CB Recipient Email
CustomerCPM Notification MethodCustomerCTS-CB Send Remittance Advice
CustomerCustomerCTS-CB Allow Sum. Payments (set to true)
CustomerCustomerCTS-CB Compress Remit. Text (set to true)

Employee payment information

Source table
Source field
Target table
Target field
EmployeeCPM Bal. Account No.EmployeeCTS-CB Bal. Account No.
EmployeeCPM Recipient E-MailEmployeeCTS-CB Recipient Email
EmployeeCPM Bank Country/Region CodeEmployeeCTS-CB Bank Country Code
EmployeeCPM Notification MethodEmployeeCTS-CB Send Remittance Advice

Alternative address information

Source table
Source field
Target table
Target field
CustomerCPM NameCustomerCTS-CB Alternative Name
CustomerCPM AddressCustomerCTS-CB Alternative Address
CustomerCPM Address 2CustomerCTS-CB Alternative Address 2
CustomerCPM Post CodeCustomerCTS-CB Alternative Post Code
CustomerCPM CityCustomerCTS-CB Alternative City
VendorCPM NameVendorCTS-CB Alternative Name
VendorCPM Name 2VendorCTS-CB Alternative Name 2
VendorCPM AddressVendorCTS-CB Alternative Address
VendorCPM Address 2VendorCTS-CB Alternative Address 2
VendorCPM Post CodeVendorCTS-CB Alternative Post Code
VendorCPM CityVendorCTS-CB Alternative City

Vendor ledger entry payment information

Source table
Source field
Target table
Target field
Vendor Ledger EntryCPM Bal. Account No.Vendor Ledger EntryCTS-CB Bank Account No.
Vendor Ledger EntryCPM Cost Type CodeVendor Ledger EntryCTS-CB Cost Type
Vendor Ledger EntryCPM Transaction IDVendor Ledger EntryCTS-CB End To End Id

Purchase document payment information

Source table
Source field
Target table
Target field
Purchase HeaderCPM Bal. Account No.Purchase HeaderCTS-CB Bank Account No.
Purchase HeaderCPM Recipient Bank Acc CodePurchase HeaderCTS-CB Pay-to Vend. Bank Acc.
Purchase HeaderCPM Cost Type CodePurchase HeaderCTS-CB Cost Type
Purchase HeaderCPM Pmt. Reference Def. CodePurchase HeaderCTS-CB Pmt. Reference Template

Sales document payment information

Source table
Source field
Target table
Target field
Sales HeaderCPM Bal. Account No.Sales HeaderCTS-CB Bank Account No.
Sales HeaderCPM External Payment ReferenceSales HeaderCTS-CB Ext. Payment Reference

Bank account verification

Source table
Source field
Target table
Target field
CPM Bank Account Ver. EntryAll matching fieldsCTS-PE Bank Account Ver. EntryCorresponding fields
CPM Bank Account Ver. EntryVerification MethodCTS-PE Bank Account Ver. EntryVerification Method (mapped)

Bank account change log

Source table
Source field
Target table
Target field
CPM Bank Account Change LogAccount TypeCTS-PE Bank Account Change LogAccount Type
CPM Bank Account Change LogAccount No.CTS-PE Bank Account Change LogAccount No.
CPM Bank Account Change LogBank Account CodeCTS-PE Bank Account Change LogBank Account Code
CPM Bank Account Change LogField No.CTS-PE Bank Account Change LogField No.
CPM Bank Account Change LogOriginal Field ValueCTS-PE Bank Account Change LogOriginal Field Value
CPM Bank Account Change LogApprovedCTS-PE Bank Account Change LogApproved

Bank closing dates

Source table
Source field
Target table
Target field
CPM Bank HolidayDateCTS-PE Bank Closing DayDate
CPM Bank HolidayDescriptionCTS-PE Bank Closing DayDescription
CPM Bank HolidayCountryCodeCTS-PE Bank Closing DayCountry/Region Code

Archived files

Source table
Source field
Target table
Target field
CPM Archived FileImported DateCTS-CB File ArchiveImport Date
CPM Archived FileTypeCTS-CB File ArchiveType (mapped)
CPM Archived FileFileCTS-CB File ArchiveFile
CPM Archived FileSystem CodeCTS-CB File ArchiveSystem Code
CPM Archived FileFileNameCTS-CB File ArchiveFileName
CPM Archived FileIdCTS-CB File ArchiveID
CPM Archived FileProcessedCTS-CB File ArchiveProcessed by Import
CPM Archived FileFile DirectionCTS-CB File ArchiveFile Direction (mapped)
CPM Archived FileHas ErrorCTS-CB File ArchiveProcessing Error
CPM Archived FileError MessageCTS-CB File ArchiveProcessing Error Message