OPplus to Continia Finance field mapping reference – Fixed Assets
This article lists the source and target mappings for tables and fields involved in migrating data from OPplus to the Continia Finance Fixed Assets 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.
Fixed Assets setup
A 1:1 field mapping from OPP FA Setup to CTS-CFI FA Setup, including: Update Version, Pmt. Disc. Acquisition Cost, Round Book Value in Per. Depr., Depr. until FA Posting Date, Depr. Acquisition Cost, Set Error Entry No in Cr. Memo, Set VAT in Correction Entry, Insert AccountNo Line in Corr., Post copies automatically, Fixed Asset Template Nos., Reclass. Journal Template, Reclass. Journal Batch, Use Section Lining, Depr. until FA Post. Disposal, Clear FA No. when reverse TA, Use Duplication List, Check Depr. on Corr. Acq. Cost, Do not use FA Allocations, Post copies autom. G/L, Check last Depr. Corr.Acq.Cost, Hyperlink Color, Copy Line Descr. to Entries.
Fixed Assets allocation
Source field | Target field | Notes |
|---|---|---|
| FA No. | FA No. | Direct |
| Allocation Type | Allocation Type | Enum conversion |
| Valid from | Valid from | Direct |
| Line No. | Line No. | Direct |
| Description | Description | Direct |
| Account No. | Account No. | Direct |
| Global Dimension 1 Code | Global Dimension 1 Code | Direct |
| Global Dimension 2 Code | Global Dimension 2 Code | Direct |
| Allocation % | Allocation % | Direct |
| Dimension Set ID | Dimension Set ID | Direct |
Fixed Assets posting setup
Source field | Target field |
|---|---|
| FA Posting Group | FA Posting Group |
| Gen. Bus. Posting Group | Gen. Bus. Posting Group |
| Sales Acc. on Disp. (Gain) | Sales Acc. on Disp. (Gain) |
| Sales Acc. on Disp. (Loss) | Sales Acc. on Disp. (Loss) |
Fixed Assets template depreciation book
A 1:1 field mapping from OPP FA Template Depr. Book to CTS-CFI FA Template Depr. Book, including: FA Template No., Depreciation Book Code, Depreciation Method (Enum), Straight-Line %, No. of Depreciation Years, No. of Depreciation Months, Fixed Depr. Amount, Declining-Balance %, Depreciation Table Code, Final Rounding Amount, Ending Book Value, FA Posting Group, FA Exchange Rate, Fixed Depr. Amount below Zero, Last Date Modified, Use FA Ledger Check, Depr. below Zero %, Description, FA Add.-Currency Factor, Use Half-Year Convention, Use DB% First Fiscal Year, Ignore Def. Ending Book Value, FA Under Construction, and all custom fields.
Fixed asset template
Source field | Target field |
|---|---|
| No. | No. |
| Description | Description |
| Search Description | Search Description |
| Description 2 | Description 2 |
| FA Class Code | FA Class Code |
| FA Subclass Code | FA Subclass Code |
| Global Dimension 1 Code | Global Dimension 1 Code |
| Global Dimension 2 Code | Global Dimension 2 Code |
| Location Code | Location Code |
| FA Location Code | FA Location Code |
| Vendor No. | Vendor No. |
| Responsible Employee | Responsible Employee |
| Last Date Modified | Last Date Modified |
| Maintenance Vendor No. | Maintenance Vendor No. |
| No. Series | No. Series |
| FA Posting Group | FA Posting Group |
| With Quantity | With Quantity |
Field transfers within existing tables
Fixed Assets Depreciation Book
Source field | Target field |
|---|---|
| OPP Scrapped at Date | CTS-CFI Scrapped at Date |
Fixed Assets Journal Line
Source field | Target field |
|---|---|
| OPP Scrapping | CTS-CFI Scrapping |
| OPP FA Quantity | CTS-CFI FA Quantity |
| OPP Skip FA Quantity Check | CTS-CFI Skip FA Quantity Check |
| OPP FA Payment Discount | CTS-CFI FA Payment Discount |
Fixed Assets Ledger Entry
Source field | Target field |
|---|---|
| OPP Scrapped | CTS-CFI Scrapped |
| OPP Pmt. Disc. Possible Gross | CTS-CFI PmtDiscPossibleGross |
| OPP Pmt. Disc. Possible % | CTS-CFI Pmt. Disc. Possible % |
| OPP Pmt. Disc. Possible Net | CTS-CFI PmtDiscPossibleNet |
| OPP Pmt. Disc. Realized Net | CTS-CFI PmtDiscRealizedNet |
| OPP Orig FA Entry No. | CTS-CFI Orig FA Entry No. |
| OPP FA Quantity | CTS-CFI FA Quantity |
| OPP Payment Discount | CTS-CFI Payment Discount |
Fixed Assets Posting Group
Source field | Target field |
|---|---|
| OPP Bk. Val. Acc. Scrap (Loss) | CTS-CFI BkValAccScrap (Loss) |
| OPP Losses Acc. on Scrapping | CTS-CFI LossesAcconScrapping |
Fixed Asset
Source field | Target field |
|---|---|
| OPP With Quantity | CTS-CFI With Quantity |
| OPP Inserted by FAT | CTS-CFI Inserted by FAT |
Purchase Line
Source field | Target field |
|---|---|
| OPP FA Error Entry No. | CTS-CFI FA Error Entry No. |
Sales Line
Source field | Target field |
|---|---|
| OPP FA Error Entry No. | CTS-CFI FA Error Entry No. |
Detailed Vendor Ledger Entry
Source field | Target field |
|---|---|
| OPP VAT Entry No. | CTS-CFI VAT Entry No. |