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 |
|---|---|
| Protel_Rev_V101 | Imports a text report file with file pattern: Rev<ddMMyyyy>.ttx Customized import. The date is taken from the file name. Only lines with 3 columns are taken into account after cutting columns like “(NOK)” or “NOK”. |
| Protel_RevHistory_V001 | Imports an XML file with file pattern: RevHist* |
| Column | Name |
|---|---|
| 1 | Split into accountNumber and itemDescription |
| 2 | not used |
| 3 | FBRevenue |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | Taken from the Day element | Date attribute | |
| 2 | Description | Description | M | Taken from the TAA element within the Day element | Name attribute | |
| 3 | Department | Department | O | Not used | ||
| 4 | Account | Account | M | Taken from the TAA element within the Day element | No attribute | |
| 5 | Revenue | Revenue without authority charge rates | M | Taken from the TAA element within the Day element | RevNet attribute |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | Taken from file name | revenueDate | |
| 2 | Description | Description | M | Directly mapped from source system | itemDescription | |
| 3 | Department | Department | O | Directly mapped from source system | Not used | |
| 4 | Account | Account | M | Directly mapped from source system | accountNumber | |
| 5 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | FBAmount |
Output examples for download:
- XML file for Protel_RevHistory interface:
File:Protel RevHistory V001.txt
- Flat file for Protel_Rev interface: