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 interface in question are changed throughout the interface life-cycle.
Te file name pattern is like CJ*.txt

Interface name incl. versionComment
Vsp_Revenue_V001Retrieving actual data
2Not used
3Not used
6Not used
7Not used
8Not used
9Not used (Inconsistent)
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesData element (source)Comment
1DateTransaction dateMDirectly mapped from source fileDate
2DepartmentID or name of the departmentONot available in source file
3AccountID or name of the accountMDirectly mapped from source fileAccount
4DescriptionAccount descriptionONot available in source file
5RevenueRevenue without authority charge ratesMDirectly mapped from source fileRevenueRevenue is including VAT

Download an example of the source file format: File:CJx.txt

Was this article helpful?

Related Articles