OPplus to Continia Finance field mapping reference – Financial Reports
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 |