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.

PMI data element (target) 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)
Columns 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
# 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 Mandatory Directly mapped from source file Date In the format ddMMyy for V100 and yyyyMMdd for V101/V102
2 Description Description Mandatory Directly mapped from source system Description
3 Department Description Mandatory Directly mapped from source system Department
4 Account Description Mandatory Directly mapped from source system Account
5 Revenue Revenue without authority charge rates Mandatory Directly mapped from source system Revenue
# PMI data element (target) Description Mandatory / Optional Data transformation/load rules Data element (source) Comment
1 Date Transaction Date Mandatory 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 Mandatory Directly mapped from source system DESCRIPTION
3 Department Department Optional Directly mapped from source system Not used
4 Account Account Mandatory Directly mapped from source system TRX_CODE
5 Revenue Revenue without authority charge rates Mandatory 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 Mandatory Directly mapped from source file Date In the format dd/MM/yyyy
2 Description Description Optional Directly mapped from source system Not used
3 Department Department Mandatory Directly mapped from source system with 1 added at the beginning Department
4 Account Account Mandatory Directly mapped from source system Account
5 Revenue Revenue without authority charge rates Mandatory 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:

  • File:Opera Fb V001.txt