PMI Knowledge base

Back to Knowledge base
Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
Filter by Custom Post Type
PMI Knowledge Base
Article contents (TOC)
Print

PMS – Skidata

May 31, 2020
UpdatedAugust 16, 2024
ByAndreas Engkvist
Views624
Please Share Your Feedback
How Can We Improve This Article?
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.

The imported files are in XML format and follow the file name pattern: *PMITICKET*

Interface name incl. version
Skidata_Pos_V001
Comment
The file is in XML format
1
2
3
4
5
6
PMI data element (target)
Date
Department
Account
Description
Revenue
Covers
Description
Transaction date
Name of the department
ID or name of the account
Description
Revenue without authority charge rates
Number of covers
Mandatory / Optional
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Data transformation/load rules
Date
Directly mapped from source file
Directly mapped from source system
Directly mapped from source system
Directly mapped from source file
Directly mapped from source file
Comment
Transformed to date format yyyy-MM-dd

Download an example of the source file format: File:Skidata Pos V001.zip

Tags: