The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source). You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the adapter to get the desired data format and/or result in the PMI staging table where such have been applicable. An example of the source file data, format and structure is also attached below the table. This table will be updated whenever the source file or the adapter in question are changed throughout the interface life-cycle.
| Interface name incl. version | Comment |
|---|---|
| Opera_hb_V100 | |
| Opera_hb_V101 | Starts on line 5 (0-based) |
| Opera_hb_V102 | Same as Opera_hb_V101 but starts on line 4 (0-based) |
| Column | Name V100 | Name V101/V102 |
|---|---|---|
| 1 | Not used | Not used |
| 2 | Date | Date |
| 3 | Not used | Not used |
| 4 | Not used | Account |
| 5 | Not used | Department |
| 6 | Description | Description |
| 7 | Department | Not used |
| 8 – 9 | Not used | Not used |
| 10 | Account | Not used |
| 11 – 13 | Not used | Not used |
| 14 | Not used | Revenue |
| 15 | Revenue | Not used |
| Interface name incl. version | Comment |
|---|---|
| Opera_trial_balance_V001 | Tab delimited |
| Opera_trial_balance_V002 | Semicolon delimited. Works with Opera version 5.0.03.03e20. |
| Opera_trial_balance_V003 | Same as V002 and forces Revenue in Norwegian format |
| Interface name incl. version | Comment |
|---|---|
| Opera_Fb_V101 | Interface reading fixed column length file |
| Column | Name | Length |
|---|---|---|
| 1 | Date | 11 |
| 2 | Department | 5 |
| 3 | Account | 5 |
| 4 | Revenue | 19 |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | Directly mapped from source file | Date | In the format ddMMyy for V100 and yyyyMMdd for V101/V102 |
| 2 | Description | Description | M | Directly mapped from source system | Description | |
| 3 | Department | Description | M | Directly mapped from source system | Department | |
| 4 | Account | Description | M | Directly mapped from source system | Account | |
| 5 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | Revenue |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | Directly mapped from source file | TRX_DATE | In the format dd-MMM-yy for V001 and dd.MM.yy for V002/V003 |
| 2 | Description | Description | M | Directly mapped from source system | DESCRIPTION | |
| 3 | Department | Department | O | Directly mapped from source system | Not used | |
| 4 | Account | Account | M | Directly mapped from source system | TRX_CODE | |
| 5 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | TB_AMOUNT |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | Directly mapped from source file | Date | In the format dd/MM/yyyy |
| 2 | Description | Description | O | Directly mapped from source system | Not used | |
| 3 | Department | Department | M | Directly mapped from source system with 1 added at the beginning | Department | |
| 4 | Account | Account | M | Directly mapped from source system | Account | |
| 5 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | Revenue |
Output examples for download:
- Flat file CSV for Opera_restat interface:
File:Opera hb V100.txtFile:Opera hb V101.txt
- Flat file CSV for Opera_restat interface:
File:Opera trialbalance V001.txt
- Flat file fixed length for Opera_Fb interface: