OPplus to Continia Finance field mapping reference – Financial Reports

09.06.2026
9 Minuten Lesedauer

This article lists the source and target mappings for tables and fields involved in migrating data from OPplus to the Continia Finance Financial Reports module. 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.

Setup (Ext. Financial Reports Setup)

Source table	Source field	Target table	Target field
OPP Analysis Setup / OPP Views and Lists Setup	Assets/Liab. Calc. Type	CTS-CFI Ext.Fin.Reports Setup	Assets/Liab. Calc. Type
OPP Analysis Setup	Affiliation	CTS-CFI Ext.Fin.Reports Setup	Affiliation
OPP Analysis Setup	Use Section Lining	CTS-CFI Ext.Fin.Reports Setup	Use Section Lining
OPP Analysis Setup	Bal. Account VAT Base	CTS-CFI Ext.Fin.Reports Setup	Bal. Account VAT Base
OPP Analysis Setup	Account VAT Base Next Month	CTS-CFI Ext.Fin.Reports Setup	Account VAT Base Next Month
OPP Analysis Setup	Account VAT Amount Last Month	CTS-CFI Ext.Fin.Reports Setup	Account VAT Amount Last Month
OPP Analysis Setup	Source Code VAT Correction	CTS-CFI Ext.Fin.Reports Setup	Source Code VAT Correction
OPP Analysis Setup	Enable VAT Correction	CTS-CFI Ext.Fin.Reports Setup	Enable VAT Correction
OPP Analysis Setup	VAT Correct Jnl. Template Name	CTS-CFI Ext.Fin.Reports Setup	VAT Correct Jnl. Template Name
OPP Analysis Setup	VAT Correct Jnl. Batch Name	CTS-CFI Ext.Fin.Reports Setup	VAT Correct Jnl. Batch Name
OPP Views and Lists Setup	Consider Field Show in Excel	CTS-CFI Ext.Fin.Reports Setup	Consider the Field Show
OPP Views and Lists Setup	Allow Doc. Entrance Date From	CTS-CFI Ext.Fin.Reports Setup	Allow Doc. Receipt Date From
OPP Views and Lists Setup	Allow Doc. Entrance Date To	CTS-CFI Ext.Fin.Reports Setup	Allow Doc. Receipt Date To
OPP Analysis Setup	G/L Account Group 1–4 Caption	CTS-CFI Ext.Fin.Reports Setup	G/L Account Group 1–4 Caption
OPP Analysis Setup	Update Version	CTS-CFI Ext.Fin.Reports Setup	Update Version
OPP Views and Lists Setup	Default Doc. Entrance Date	CTS-CFI Ext.Fin.Reports Setup	Default Doc. Receipt Date
OPP Analysis Setup	Hyperlink Color	CTS-CFI Ext.Fin.Reports Setup	Hyperlink Color
OPP Analysis Setup	Sales VAT Adv. Notif. Path	CTS-CFI Ext.Fin.Reports Setup	Sales VAT Adv. Notif. Path
OPP Analysis Setup	XML File Default Name	CTS-CFI Ext.Fin.Reports Setup	XML File Default Name
OPP Analysis Setup	Adjust Exch. Rate Differences	CTS-CFI Ext.Fin.Reports Setup	Adjust Exch. Rate Differences
OPP Analysis Setup	Bal. Account (Show)	CTS-CFI Ext.Fin.Reports Setup	Auto Calc. Bal. Account Show
OPP Analysis Setup	Search Bal. Account	CTS-CFI Ext.Fin.Reports Setup	Search Bal. Account
OPP Analysis Setup	Show with FA Postings	CTS-CFI Ext.Fin.Reports Setup	Show with FA Postings
OPP Views and Lists Setup	Cust. Ext. Doc. No. Changeable	CTS-CFI Ext.Fin.Reports Setup	Cust. Ext. Doc. No. Editable
OPP Views and Lists Setup	Vend. Ext. Doc. No. Changeable	CTS-CFI Ext.Fin.Reports Setup	Vend. Ext. Doc. No. Editable
OPP Views and Lists Setup	G/L Ext. Doc. No. Changeable	CTS-CFI Ext.Fin.Reports Setup	G/L Ext. Doc. No. Editable
OPP Views and Lists Setup	FA Ext. Doc. No. Changeable	CTS-CFI Ext.Fin.Reports Setup	FA Ext. Doc. No. Editable

G/L account group

Source table	Source field	Target table	Target field
OPP G/L Account Group	Code	CTS-CFI G/L Account Group	Code
OPP G/L Account Group	Description	CTS-CFI G/L Account Group	Description
OPP G/L Account Group	Acc. Sched. Line Grouping	CTS-CFI G/L Account Group	Acc. Sched. Grouping

G/L account mapping

Source table	Source field	Target table	Target field
OPP G/L Account Mapping	G/L Account No.	CTS-CFI G/L Account Mapping	G/L Account No.
OPP G/L Account Mapping	Name	CTS-CFI G/L Account Mapping	Name
OPP G/L Account Mapping	Global Dimension 1 Code	CTS-CFI G/L Account Mapping	Global Dimension 1 Code
OPP G/L Account Mapping	Global Dimension 2 Code	CTS-CFI G/L Account Mapping	Global Dimension 2 Code
OPP G/L Account Mapping	Job No.	CTS-CFI G/L Account Mapping	Job No.
OPP G/L Account Mapping	Dimension Entry No.	CTS-CFI G/L Account Mapping	Dimension Entry No.
OPP G/L Account Mapping	Reason Code	CTS-CFI G/L Account Mapping	Reason Code
OPP G/L Account Mapping	Gen. Posting Type	CTS-CFI G/L Account Mapping	Gen. Posting Type
OPP G/L Account Mapping	Gen. Bus. Posting Group	CTS-CFI G/L Account Mapping	Gen. Bus. Posting Group
OPP G/L Account Mapping	Gen. Prod. Posting Group	CTS-CFI G/L Account Mapping	Gen. Prod. Posting Group
OPP G/L Account Mapping	VAT Bus. Posting Group	CTS-CFI G/L Account Mapping	VAT Bus. Posting Group
OPP G/L Account Mapping	VAT Prod. Posting Group	CTS-CFI G/L Account Mapping	VAT Prod. Posting Group
OPP G/L Account Mapping	Company	CTS-CFI G/L Account Mapping	Company
OPP G/L Account Mapping	Mapped Account No.	CTS-CFI G/L Account Mapping	Mapped Account No.

Aged account column layout

Source table	Source field	Target table	Target field
OPP Aged Acc. Column Layout	Column Layout Name	CTS-CFI Aged AccColumnLayout	Column Layout Name
OPP Aged Acc. Column Layout	Line No.	CTS-CFI Aged AccColumnLayout	Line No.
OPP Aged Acc. Column Layout	Column No.	CTS-CFI Aged AccColumnLayout	Column No.
OPP Aged Acc. Column Layout	Column Header	CTS-CFI Aged AccColumnLayout	Column Header
OPP Aged Acc. Column Layout	Column Type	CTS-CFI Aged AccColumnLayout	Column Type
OPP Aged Acc. Column Layout	Date Formula	CTS-CFI Aged AccColumnLayout	Date Formula
OPP Aged Acc. Column Layout	Allowance %	CTS-CFI Aged AccColumnLayout	Allowance %
OPP Aged Acc. Column Layout	Not Due Entries	CTS-CFI Aged AccColumnLayout	Not Due Entries
OPP Aged Acc. Column Layout	Starting Date	CTS-CFI Aged AccColumnLayout	Starting Date
OPP Aged Acc. Column Layout	Ending Date	CTS-CFI Aged AccColumnLayout	Ending Date

Aged account column layout name

Source table	Source field	Target table	Target field
OPP Aged Acc. Col. Layout Name	Name	CTS-CFI Aged AccColLayoutName	Name
OPP Aged Acc. Col. Layout Name	Description	CTS-CFI Aged AccColLayoutName	Description

Field transfers within existing tables

These fields are migrated within their existing tables (no new table is created).

Acc. Schedule Line

Source table	Target table
OPP Balance Position	CTS-CFI Balance Position
OPP Separate Recv. and Pay.	CTS-CFI Sep. Recv. and Pay.
OPP Detailed Export	CTS-CFI Detailed Export
OPP Structure	CTS-CFI Structure
OPP Line No. Base	CTS-CFI Line No. Base

Acc. Schedule Name

Source table	Target table
OPP Assets/Liab. Calc. Type	CTS-CFI Assets/Liab. CalcType

Document Receipt Date (recurring pattern across multiple tables)

Table	Source table	Target table
Gen. Jnl. Allocation	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date
Purch. Rcpt. Header	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date
Purchase Header	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date
Purchase Header Archive	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date
VAT Entry	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date
Vendor Ledger Entry	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date
G/L Entry	OPP Invoice Entrance Date	CTS-CFI Document Receipt Date

VAT Statement Line

Source table	Target table
OPP From Company	CTS-CFI From Company

VAT Statement Name

Source table	Target table
OPP Affiliation	CTS-CFI Affiliation

G/L Account

Source table	Target table
OPP Last Posting at	CTS-CFI Last Posting at
OPP Account Group 1–4	CTS-CFI Account Group 1–4

VAT Posting Setup

Source table	Target table
OPP Income Date VAT Post. Grp.	CTS-CFI Inc. Date VATPostGrp
OPP Shift Post.Type Sal/Prch.	CTS-CFI Shift Posting Type

Customer and Vendor (identical pattern)

Source table	Target table
OPP Last Posting at	CTS-CFI Last Posting at
OPP Bal. Ack. Shipping Type	CTS-CFI BalConfShippingType

Inhaltsverzeichnis