EDP - Bygglov - Testformulär

Testformulär uppsatt enligt underlag gjort av @Andreas Linnér och ligger på följande adress:

https://minasidor.kalmar.se/bygglov-testversion-alpha (@Robin von Bothmer ansvarar för denna och jobbar fortsatt med formulärets utformning integration mot EDP kan fungera begränsat)
https://minasidor.kalmar.se/bygglov-testversion-alpha-integration (@Mattias Johansson ansvarar för denna, här funkar end-2-end-tester med integration mot EDP)

FamilyID: 402

Integrationsmotorn gör sedan ett API-anrop och kort därefter lägger EDP upp en XML-fil i följande inkorg:

\\t402\opene\Inkorg

Produktionsmiljö

\\s402\opene\Inkorg

Mappning Fält och XML-elementnamn

Jag tolkar ärendenummer: 118934 som ett ärende av typen: https://cesamh.atlassian.net/wiki/x/hgAZkg

Problem som behöver lösas

Privatperson/företag (kontaktuppgifter)
Fastighet gatuadress, postnummer, postort
Enligt Nordic Peak (https://cesamh.atlassian.net/wiki/x/CQDepg ) så behöver behöver enbart fastighetsbeteckning och kommun skickas med (se https://cesamh.atlassian.net/wiki/x/CgAYkQ ). Vi kan alltså skippa koordinater m.m. också.
Ägare Jag eller Annan person, flera ägare?
Huvudfastighet - Välj huvudfastighet (i steg 2 lämpligen?)
- Adresser kopplat till fastigheter?
Land - enbart Sverige? Rullista lämpligen? Eidas?
Kommun - Jag hårdkodar 'KALMAR' överallt, antar att kommun avser fastighetens kommun?
Skillnad Fil och Filnamn? - Hittade beskrivning längst ner på denna sida…

Exempel mappning

Jag har utgått från följande:

Innehåll i EDP’s exempel som vi testat med i inledande tester: https://cesamh.atlassian.net/wiki/x/OIARkQ
Beskrivning av XML-filens innehåll: https://cesamh.atlassian.net/wiki/x/AYAZkQ

--System_SystemId - 'E-tjänstkoppling'
--System_Ansokningstyp - 'Anmälan'
--System_ArendeKategori - 'Byggärende'
--System_EArendeId - ÄRENDE_NUMMER_OEP
--Arende_Arendetypkod - 'BANM'
--Arende_Kommun - 'KALMAR'

--Kontakt_KontaktInfo_Fornamn_1 - textfieldprovider_muleAttributeApplicantName
--Kontakt_KontaktInfo_Efternamn_1 - textfieldprovider_muleAttributeApplicantName
--Kontakt_KontaktInfo_PersonOrgNummer_1 - textfieldprovider_muleAttributeApplicantID
--Kontakt_KontaktInfo_Gatuadress_1 - textfieldprovider_muleAttributeApplicantAddress
--Kontakt_KontaktInfo_Postnummer_1 - textfieldprovider_muleAttributeApplicantPostalcode
--Kontakt_KontaktInfo_Postort_1 - textfieldprovider_muleAttributeApplicantCity
--Kontakt_KontaktInfo_Land_1 - textfieldprovider_muleAttributeApplicantCountry
--Kontakt_KontaktInfo_Kontakttyp_1 - 'Person'
--Kontakt_KontaktInfo_Huvudkontakt_1 - 'True'
--Kontakt_KontaktInfo_Roll_1 - 'Sökande'
--Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_1_Typ - 'Mobil'
--Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_1_Varde - textfieldprovider_muleAttributeApplicantPhone
--Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_1_Beskrivning - 'Beskrivning Mobil Test'
--Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_2_Typ - 'E-Post'
--Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_2_Varde - textfieldprovider_muleAttributeApplicantEmail
--Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_2_Beskrivning - 'Beskrivning E-post Test'

--Fastigheter_FastighetsInfo_Fastighetsbeteckning_1 - REPLACE(pudquery_muleAttributeProperty_PropertyUnitDesignation, 'KALMAR ', '')
--Fastigheter_FastighetsInfo_Trakt_1 - 'Trakt'
--Fastigheter_FastighetsInfo_Block_1 - '1'
--Fastigheter_FastighetsInfo_Tecken_1 - ':'
--Fastigheter_FastighetsInfo_Enhet_1 - '1'
--Fastigheter_FastighetsInfo_Fnr_1 - pudquery_muleAttributeProperty_PropertyUnitNumber
--Fastigheter_FastighetsInfo_Kommun_1 - 'KALMAR'
--Fastigheter_FastighetsInfo_Huvudfastighet_1 - 'True'
--SKIPPAR--Fastigheter_FastighetsInfo_Fastighetsadresser_1_FastighetsadressInfo_Gatuadress_1 - textfieldprovider_muleAttributeApplicantAddress
--SKIPPAR--Fastigheter_FastighetsInfo_Fastighetsadresser_1_FastighetsadressInfo_Postnummer_1 - textfieldprovider_muleAttributeApplicantPostalcode
--SKIPPAR--Fastigheter_FastighetsInfo_Fastighetsadresser_1_FastighetsadressInfo_Postort_1 - textfieldprovider_muleAttributeApplicantCity
--SKIPPAR--Fastigheter_FastighetsInfo_Koordinater_1_KoordinatInfo_XKoordinat_1 - STRINGSPLIT(iconmapquery_muleAttributeFastighetesInfo_Geometries_Geometry_WKT_0)
--SKIPPAR--Fastigheter_FastighetsInfo_Koordinater_1_KoordinatInfo_YKoordinat_1 - STRINGSPLIT(iconmapquery_muleAttributeFastighetesInfo_Geometries_Geometry_WKT_0)
--SKIPPAR--Fastigheter_FastighetsInfo_Koordinater_1_KoordinatInfo_Punkttyp_1 - 'Centralpunkt'

--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Namn_1 - textfieldprovider_muleAttributeApplicantName
--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_PersonOrgNummer_1 - textfieldprovider_muleAttributeApplicantID
--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Gatuadress_1 - textfieldprovider_muleAttributeApplicantAddress
--SKIPPAR--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Gatuadress2_1
--SKIPPAR--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_CO_1
--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Postnummer_1 - textfieldprovider_muleAttributeApplicantPostalcode
--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Postort_1 - textfieldprovider_muleAttributeApplicantCity
--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Land_1 - textfieldprovider_muleAttributeApplicantCountry
--Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Kommun_1 - 'KALMAR'


--Filer_FilInfo_EFilId_1 - fileuploadquery_muleAttributeAttachments_ID_0 (unikt id för filen inuti e-tjänsteplattformen)
--Filer_FilInfo_Fil_1 - CONCAT(fileuploadquery_muleAttributeAttachments_ID_0 , '_', fileuploadquery_muleAttributeAttachments_Name_0) (måste vara ett unikt namn i den mapp där den läggs)
--Filer_FilInfo_Filnamn_1 - fileuploadquery_muleAttributeAttachments_Name_0 (original filnamn)
--Filer_FilInfo_Fildata_1 - fileuploadquery_muleAttributeAttachments_EncodedData_0
--SKIPPAR--Filer_FilInfo_Handlingstyp_1
--SKIPPAR--Filer_FilInfo_Beskrivning_1

Regler för mappning

/*
update muleattributes_rules_replicated set ParametersList = '
SELECT ''adapter'' AS parameter_key, ''visionapi-test'' AS parameter_value, ''string'' AS parameter_type
UNION SELECT ''municipality'', REPLACE(LOWER(EntryValue), '' '', ''''), ''string'' FROM settings WHERE Section = ''general'' AND EntryKey = ''municipality''
UNION SELECT ''System_SystemId_1'', ''Open ePlatform'', ''string''
UNION SELECT ''System_Ansokningstyp_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeSystemAnsokningstyp''
UNION SELECT ''System_ArendeKategori_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeSystemArendeKategori''
UNION SELECT ''System_EArendeId_1'', CAST(IssueId AS varchar), ''string'' FROM muleattributes WHERE Id = MULE_MAGIC_ATTRIBUTE_ID
UNION SELECT ''Arende_Arendetypkod_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeArendeArendetypkod''
UNION SELECT ''Arende_Kommun_1'', ''KALMAR'', ''string''
UNION SELECT ''Filer_FilInfo_EFilId_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_0''
UNION SELECT ''Filer_FilInfo_Fil_1'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_0'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_0''
UNION SELECT ''Filer_FilInfo_Filnamn_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_0''
UNION SELECT ''Filer_FilInfo_Fildata_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_0''
UNION SELECT ''Filer_FilInfo_EFilId_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_1''
UNION SELECT ''Filer_FilInfo_Fil_2'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_1'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_1''
UNION SELECT ''Filer_FilInfo_Filnamn_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_1''
UNION SELECT ''Filer_FilInfo_Fildata_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_1''
UNION SELECT ''Filer_FilInfo_EFilId_3'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_2''
UNION SELECT ''Filer_FilInfo_Fil_3'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_2'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_2''
UNION SELECT ''Filer_FilInfo_Filnamn_3'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_2''
UNION SELECT ''Filer_FilInfo_Fildata_3'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_2''
UNION SELECT ''Filer_FilInfo_EFilId_4'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_3''
UNION SELECT ''Filer_FilInfo_Fil_4'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_3'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_3''
UNION SELECT ''Filer_FilInfo_Filnamn_4'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_3''
UNION SELECT ''Filer_FilInfo_Fildata_4'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_3''
UNION SELECT ''Filer_FilInfo_EFilId_5'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_4''
UNION SELECT ''Filer_FilInfo_Fil_5'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_4'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_4''
UNION SELECT ''Filer_FilInfo_Filnamn_5'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_4''
UNION SELECT ''Filer_FilInfo_Fildata_5'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_4''
UNION SELECT ''Filer_FilInfo_EFilId_6'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_5''
UNION SELECT ''Filer_FilInfo_Fil_6'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_5'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_5''
UNION SELECT ''Filer_FilInfo_Filnamn_6'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_5''
UNION SELECT ''Filer_FilInfo_Fildata_6'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_5''
UNION SELECT ''Filer_FilInfo_EFilId_7'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_6''
UNION SELECT ''Filer_FilInfo_Fil_7'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_6'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_6''
UNION SELECT ''Filer_FilInfo_Filnamn_7'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_6''
UNION SELECT ''Filer_FilInfo_Fildata_7'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_6''
UNION SELECT ''Filer_FilInfo_EFilId_8'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_7''
UNION SELECT ''Filer_FilInfo_Fil_8'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_7'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_7''
UNION SELECT ''Filer_FilInfo_Filnamn_8'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_7''
UNION SELECT ''Filer_FilInfo_Fildata_8'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_7''
UNION SELECT ''Filer_FilInfo_EFilId_9'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_8''
UNION SELECT ''Filer_FilInfo_Fil_9'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_8'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_8''
UNION SELECT ''Filer_FilInfo_Filnamn_9'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_8''
UNION SELECT ''Filer_FilInfo_Fildata_9'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_8''
UNION SELECT ''Filer_FilInfo_EFilId_10'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_9''
UNION SELECT ''Filer_FilInfo_Fil_10'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_9'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_9''
UNION SELECT ''Filer_FilInfo_Filnamn_10'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_9''
UNION SELECT ''Filer_FilInfo_Fildata_10'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_9''
UNION SELECT ''Filer_FilInfo_EFilId_11'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_10''
UNION SELECT ''Filer_FilInfo_Fil_11'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_10'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_10''
UNION SELECT ''Filer_FilInfo_Filnamn_11'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_10''
UNION SELECT ''Filer_FilInfo_Fildata_11'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_10''
UNION SELECT ''Filer_FilInfo_EFilId_12'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_11''
UNION SELECT ''Filer_FilInfo_Fil_12'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_11'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_11''
UNION SELECT ''Filer_FilInfo_Filnamn_12'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_11''
UNION SELECT ''Filer_FilInfo_Fildata_12'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_11''
UNION SELECT ''Filer_FilInfo_EFilId_13'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_12''
UNION SELECT ''Filer_FilInfo_Fil_13'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_12'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_12''
UNION SELECT ''Filer_FilInfo_Filnamn_13'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_12''
UNION SELECT ''Filer_FilInfo_Fildata_13'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_12''
UNION SELECT ''Filer_FilInfo_EFilId_14'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_13''
UNION SELECT ''Filer_FilInfo_Fil_14'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_13'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_13''
UNION SELECT ''Filer_FilInfo_Filnamn_14'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_13''
UNION SELECT ''Filer_FilInfo_Fildata_14'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_13''
UNION SELECT ''Filer_FilInfo_EFilId_15'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_14''
UNION SELECT ''Filer_FilInfo_Fil_15'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_14'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_14''
UNION SELECT ''Filer_FilInfo_Filnamn_15'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_14''
UNION SELECT ''Filer_FilInfo_Fildata_15'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_14''
UNION SELECT ''Filer_FilInfo_EFilId_16'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_15''
UNION SELECT ''Filer_FilInfo_Fil_16'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_15'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_15''
UNION SELECT ''Filer_FilInfo_Filnamn_16'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_15''
UNION SELECT ''Filer_FilInfo_Fildata_16'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_15''
UNION SELECT ''Filer_FilInfo_EFilId_17'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_16''
UNION SELECT ''Filer_FilInfo_Fil_17'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_16'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_16''
UNION SELECT ''Filer_FilInfo_Filnamn_17'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_16''
UNION SELECT ''Filer_FilInfo_Fildata_17'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_16''
UNION SELECT ''Filer_FilInfo_EFilId_18'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_17''
UNION SELECT ''Filer_FilInfo_Fil_18'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_17'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_17''
UNION SELECT ''Filer_FilInfo_Filnamn_18'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_17''
UNION SELECT ''Filer_FilInfo_Fildata_18'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_17''
UNION SELECT ''Filer_FilInfo_EFilId_19'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_18''
UNION SELECT ''Filer_FilInfo_Fil_19'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_18'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_18''
UNION SELECT ''Filer_FilInfo_Filnamn_19'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_18''
UNION SELECT ''Filer_FilInfo_Fildata_19'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_18''
UNION SELECT ''Filer_FilInfo_EFilId_20'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_19''
UNION SELECT ''Filer_FilInfo_Fil_20'', CONCAT(AttributeValue, ''_'', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_19'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_ID_19''
UNION SELECT ''Filer_FilInfo_Filnamn_20'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_Name_19''
UNION SELECT ''Filer_FilInfo_Fildata_20'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''fileuploadquery_muleAttributeAttachments_EncodedData_19''
UNION SELECT ''Kontakt_KontaktInfo_Fornamn_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Firstname''
UNION SELECT ''Kontakt_KontaktInfo_Efternamn_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Lastname''
UNION SELECT ''Kontakt_KontaktInfo_PersonOrgNummer_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_SocialSecurityNumber''
UNION SELECT ''Kontakt_KontaktInfo_Gatuadress_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Address''
UNION SELECT ''Kontakt_KontaktInfo_Postnummer_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_ZipCode''
UNION SELECT ''Kontakt_KontaktInfo_Postort_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_PostalAddress''
UNION SELECT ''Kontakt_KontaktInfo_Land_1'', ''Sverige'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Kontakttyp_1'', ''Person'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Huvudkontakt_1'', ''True'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Roll_1'', ''Sökande'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_Typ_1'', ''Mobil'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_Varde_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_MobilePhone''
UNION SELECT ''Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_Beskrivning_1'', ''Beskrivning Mobil Test'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_Typ_2'', ''E-Post'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_Varde_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Email''
UNION SELECT ''Kontakt_KontaktInfo_Kommunikation_1_KommunikationInfo_Beskrivning_2'', ''Beskrivning E-post Test'', ''string''
UNION SELECT ''Fastigheter_FastighetsInfo_Fastighetsbeteckning_1'', REPLACE(AttributeValue, ''KALMAR '', ''''), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''pudquery_muleAttributeProperty_PropertyUnitDesignation''
UNION SELECT ''Fastigheter_FastighetsInfo_Kommun_1'', ''KALMAR'', ''string''
UNION SELECT ''Fastigheter_FastighetsInfo_Huvudfastighet_1'', ''True'', ''string''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Namn_1'', CONCAT(AttributeValue, '' '', (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Lastname'')), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Firstname''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_PersonOrgNummer_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_SocialSecurityNumber''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Gatuadress_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Address''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Postnummer_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_ZipCode''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Postort_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_PostalAddress''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Land_1'', ''Sverige'', ''string''
UNION SELECT ''Fastigheter_FastighetsInfo_LagfarnaAgare_1_LagfarenAgareInfo_Kommun_1'', ''KALMAR'', ''string''
UNION SELECT ''Fakturamottagare_ReferensNummer_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingReferenceNumber''
UNION SELECT ''Fakturamottagare_KontaktInfo_Kontakttyp_1'', ''Person'', ''string''
UNION SELECT ''Fakturamottagare_KontaktInfo_Fornamn_1'', CASE WHEN AttributeValue = ''Fakturan ska gå till mig'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Firstname'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingFirstname'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeBillingMeOrOther''
UNION SELECT ''Fakturamottagare_KontaktInfo_Efternamn_1'', CASE WHEN AttributeValue = ''Fakturan ska gå till mig'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Lastname'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingLastname'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeBillingMeOrOther''
UNION SELECT ''Fakturamottagare_KontaktInfo_PersonOrgNummer_1'', CASE WHEN AttributeValue = ''Fakturan ska gå till mig'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_SocialSecurityNumber'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingID'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeBillingMeOrOther''
UNION SELECT ''Fakturamottagare_KontaktInfo_Gatuadress_1'', CASE WHEN AttributeValue = ''Fakturan ska gå till mig'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Address'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingAddress'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeBillingMeOrOther''
UNION SELECT ''Fakturamottagare_KontaktInfo_Postnummer_1'', CASE WHEN AttributeValue = ''Fakturan ska gå till mig'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_ZipCode'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingPostalcode'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeBillingMeOrOther''
UNION SELECT ''Fakturamottagare_KontaktInfo_Postort_1'', CASE WHEN AttributeValue = ''Fakturan ska gå till mig'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_PostalAddress'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeBillingCity'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeBillingMeOrOther''
UNION SELECT ''Byggarende_Atgardstyp_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeByggarendeAtgardstyp''
UNION SELECT ''Byggarende_Byggnadstyp_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeByggarendeByggnadstyp''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Fornamn_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeControllerFirstname''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Efternamn_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeControllerLastname''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Certifieringar_1_CertifieringsInfo_Cerifieringsnummer_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeControllerCertNumber''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Kommunikation_1_KommunikationInfo_Typ_1'', ''E-Post'', ''string''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Kommunikation_1_KommunikationInfo_Varde_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeControllerEmail''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Kommunikation_1_KommunikationInfo_Beskrivning_1'', ''Beskrivning E-post Sakkunnig Test'', ''string''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Kommunikation_1_KommunikationInfo_Typ_2'', ''Telefon'', ''string''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Kommunikation_1_KommunikationInfo_Varde_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeControllerPhone''
UNION SELECT ''Byggarende_Sakkunnig_SakkunnigInfo_Kommunikation_1_KommunikationInfo_Beskrivning_2'', ''Beskrivning Telefon Sakkunnig Test'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Fornamn_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeCoApplicantFirstName''
UNION SELECT ''Kontakt_KontaktInfo_Efternamn_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeCoApplicantLastName''
UNION SELECT ''Kontakt_KontaktInfo_PersonOrgNummer_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeCoApplicantCitizenIdentifier''
UNION SELECT ''Kontakt_KontaktInfo_Gatuadress_2'', CASE WHEN AttributeValue = ''Samma som sökande'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_Address'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeCoApplicantAddress'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeCoApplicantAddressSameAsMeOrOther''
UNION SELECT ''Kontakt_KontaktInfo_Postnummer_2'', CASE WHEN AttributeValue = ''Samma som sökande'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_ZipCode'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeCoApplicantPostalcode'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeCoApplicantAddressSameAsMeOrOther''
UNION SELECT ''Kontakt_KontaktInfo_Postort_2'', CASE WHEN AttributeValue = ''Samma som sökande'' THEN (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''contactdetails_muleAttributeAttributeApplicant_PostalAddress'') ELSE (SELECT AttributeValue FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeCoApplicantCity'') END, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''radiobuttonquery_muleAttributeCoApplicantAddressSameAsMeOrOther''
UNION SELECT ''Kontakt_KontaktInfo_Land_2'', ''Sverige'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Kontakttyp_2'', ''Person'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Huvudkontakt_2'', ''False'', ''string''
UNION SELECT ''Kontakt_KontaktInfo_Roll_2'', ''Medsökande'', ''string''
UNION SELECT ''Byggarende_Areor_AreaInfo_ByggnadAnlaggning_1'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeByggarendeByggnadstyp''
UNION SELECT ''Byggarende_Areor_AreaInfo_Areatyp_1'', ''Bruttoarea (BTA)'', ''string''
UNION SELECT ''Byggarende_Areor_AreaInfo_Area_1'', REPLACE(AttributeValue, '','', ''.''), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeAreaBrutto''
UNION SELECT ''Byggarende_Areor_AreaInfo_ByggnadAnlaggning_2'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeByggarendeByggnadstyp''
UNION SELECT ''Byggarende_Areor_AreaInfo_Areatyp_2'', ''Byggnadsarea (BYA)'', ''string''
UNION SELECT ''Byggarende_Areor_AreaInfo_Area_2'', REPLACE(AttributeValue, '','', ''.''), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeAreaBuilding''
UNION SELECT ''Byggarende_Areor_AreaInfo_ByggnadAnlaggning_3'', AttributeValue, ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeByggarendeByggnadstyp''
UNION SELECT ''Byggarende_Areor_AreaInfo_Areatyp_3'', ''Öppenarea (OPA)'', ''string''
UNION SELECT ''Byggarende_Areor_AreaInfo_Area_3'', REPLACE(AttributeValue, '','', ''.''), ''string'' FROM muleattributes WHERE LatestEvent = MULE_MAGIC_ATTRIBUTE_LATESTEVENT AND AttributeName = ''textfieldprovider_muleAttributeAreaOpen''
' where Id = 531;
*/
select * from muleattributes_rules_replicated where Id = 531;

      <System>
			<SystemId>E-tjänstkoppling</SystemId>
			<EArendeId>SYSTEM_EARENDEID</EArendeId>
			<Ansokningstyp>Ansökan</Ansokningstyp>
			<ArendeKategori>Ärende</ArendeKategori>
			<Tjanstenamn/>
		</System>
		<Arende>
			<Arendetypkod>ÄT1</Arendetypkod>
			<Kommun>Malmö</Kommun>
		</Arende>
		<Kontakt>
			<KontaktInfo> <!-- Kontakt 1 -->
					<Fornamn>KONTAKT_KONTAKT_INFO_1_FORNAMN</Fornamn>
					<Efternamn>KONTAKT_KONTAKT_INFO_1_EFTERNAMN</Efternamn>
					<PersonOrgNummer>1234567890</PersonOrgNummer>
					<Gatuadress>Testvägen 1</Gatuadress>
					<Postnummer>12345</Postnummer>
					<Postort>Testorten</Postort>
					<Land>Sverige</Land>
					<Kontakttyp>Person</Kontakttyp>
					<Huvudkontakt>True</Huvudkontakt>
					<Roll>Sökande</Roll>
					<Kommunikation>

Fält och XML-elementnamn

pudquery_muleAttributeProperty							= (Skall resultera i två strängar, Fastighetsbeteckning och Adress)
checkboxquery_muleAttributeApplicationType				= "1" ("Bygglov - Nybyggnad av enbostadshus" = ID 1)

textfieldprovider_muleAttributeApplicant
textfieldprovider_muleAttributeApplicantName			= "Förnamn Efternamn"
textfieldprovider_muleAttributeApplicantCompany			= "Ev. företagsnamn"
textfieldprovider_muleAttributeApplicantAddress			= "Gatuadress 123"
textfieldprovider_muleAttributeApplicantPostalcode		= "12345"
textfieldprovider_muleAttributeApplicantCity			= "Kalmar"
textfieldprovider_muleAttributeApplicantPhone			= "070-123 12 12"
textfieldprovider_muleAttributeApplicantEmail			= "test@test.com"
textfieldprovider_muleAttributeApplicantID				= "Person / Org.nummer"
textfieldprovider_muleAttributeApplicantCountry			= "Sverige"

textfieldprovider_muleAttributeCoApplicant
textfieldprovider_muleAttributeCoApplicantName			= "Förnamn Efternamn"
textfieldprovider_muleAttributeCoApplicantAddress 		= "Gatuadress 123"
textfieldprovider_muleAttributeCoApplicantPostalcode	= "12345"
textfieldprovider_muleAttributeCoApplicantCity			= "Kalmar"

textfieldprovider_muleAttributeBilling
textfieldprovider_muleAttributeBillingName				= "Förnamn Efternamn"
textfieldprovider_muleAttributeBillingReferenceNumber	= "Ev. referensnummer"
textfieldprovider_muleAttributeBillingID				= "Person / Org.nummer"
textfieldprovider_muleAttributeBillingAddress			= "Gatuadress 123"
textfieldprovider_muleAttributeBillingPostalcode		= "12345"
textfieldprovider_muleAttributeBillingCity				= "Kalmar"

textfieldprovider_muleAttributeController
textfieldprovider_muleAttributeControllerName			= "Förnamn Efternamn"
textfieldprovider_muleAttributeControllerPhone			= "070-123 12 12"
textfieldprovider_muleAttributeControllerEmail			= "test@test.com"
textfieldprovider_muleAttributeControllerCertNumber		= (sträng, okänd längd)

textfieldprovider_muleAttributeArea
textfieldprovider_muleAttributeAreaBruttoOpen			= "250 kvm"
textfieldprovider_muleAttributeAreaBuilding				= "100 kvm"

textarea_muleAttributeProjectDescription				= Beskrivning - Textarea-sträng

textfieldprovider_muleAttributeColorMaterial
textfieldprovider_muleAttributeColorMaterialFacade		= "Faluröd, trä"
textfieldprovider_muleAttributeColorMaterialRoof		= "Svart tegel"

fileuploadquery_muleAttributeAttachments				= Filuppladdningsfråga

Exempelfil för format - EDP

Nedanstående är taget från filen “ETjanstArendeFormatIn16.xml” (se sidan: EDP - API - ETjanstArende - Filer)

<?xml version="1.0" encoding="UTF-8"?>
<Message Version="1.0">
<!-- EDP Inkorg																				-->
<!-- Mall som definierar format för att kunna ta emot data i EDP Vision från externa system -->
<!-- 																						-->
	<Inkorg>
		<System>
			<!-- SystemId, tillåtet värde är E-tjänstkoppling -->
			<SystemId>string</SystemId>
			<!-- EArendeId är en unik identifierare i e-tjänsten för paket/ärende -->
			<EArendeId>string</EArendeId> 
			<!-- Ansökningstyp, tillåtna värden är Ansökan,Anmälan & Komplettering -->
			<Ansokningstyp>string</Ansokningstyp> 
			<!-- ArendeKategori, tillåtna värden är Ärende & Byggärende -->
			<ArendeKategori>string</ArendeKategori>
			<!-- Värde som man sedan kan filtrera tillgängliga meddelande för ärende, t.ex. Bygglov, Livsmedelslokal, Avlopp -->
			<Tjanstenamn>string</Tjanstenamn>
		</System>

		<!-- Information relaterad till Ärende -->
		<Arende>
			<Arendetypkod>string</Arendetypkod>		
			<Arendemening>string</Arendemening>
			<Text>string</Text> 
			<Kommun>string</Kommun> 
			<Avdelningskod>string</Avdelningskod>
			<Enhetskod>string</Enhetskod> 			
			<!-- Publicering, tillåtna värden är Visas, Skydd enligt PUL & Visa ej på webb -->
			<Publicering>string</Publicering> 
		</Arende>
		<!-- Riktning som appliceras på samtliga händelser som skapas, tillåtna värden är Inkommande, Utgående & Upprättad -->
		<Riktning>string</Riktning>
		<!-- Kommunikationssätt som appliceras på samtliga händelser som skapas -->
		<Kommunikationssatt>string</Kommunikationssatt>
		<!-- Information relaterad till en eller flera kontakter -->
		<Kontakter>
			<KontaktInfo>
				<Fornamn>string</Fornamn>
				<Efternamn>string</Efternamn>
				<PersonOrgNummer>string</PersonOrgNummer>
				<Foretag>string</Foretag>
				<CO>string</CO>				
				<Gatuadress>string</Gatuadress>
				<Postnummer>string</Postnummer>
				<Postort>string</Postort>
				<Land>string</Land>
				<Titel>string</Titel>
				<!-- Kontakttyp, tillåtna värden är Person & Företag -->
				<Kontakttyp>string</Kontakttyp>
				<Huvudkontakt>boolean</Huvudkontakt>
				<!-- Roll, t.ex. Sökande, Medsökande, Byggherre & Ombud -->
				<Roll>string</Roll>
				<Kommunikation>
					<KommunikationInfo>
						<!-- Typ, tillåtna värden är E-Post, Mobil, Telefon & Fax -->
						<Typ>string</Typ>
						<Varde>string</Varde>
						<!-- Beskrivning, fritt fält för kommentar om kommunikationsinfo, t.ex. Telefon arbetet, Telefon hem -->
						<Beskrivning>string</Beskrivning>						
					</KommunikationInfo>								
				</Kommunikation>
			</KontaktInfo>	
		</Kontakter>
		
		<!-- Information relaterad till fakturamottagare -->
		<Fakturamottagare>
			<KontaktInfo>
				<Fornamn>string</Fornamn>
				<Efternamn>string</Efternamn>
				<PersonOrgNummer>string</PersonOrgNummer>
				<Foretag>string</Foretag>
				<CO>string</CO>				
				<Gatuadress>string</Gatuadress>
				<Postnummer>string</Postnummer>
				<Postort>string</Postort>
				<Land>string</Land>
				<Titel>string</Titel>
				<!-- Kontakttyp, tillåtna värden är Person & Företag -->
				<Kontakttyp>string</Kontakttyp>
				<Kommunikation>
					<KommunikationInfo>
						<!-- Typ, tillåtna värden är E-Post, Mobil, Telefon & Fax -->
						<Typ>string</Typ>
						<Varde>string</Varde>
						<!-- Beskrivning, fritt fält för kommentar om kommunikationsinfo, t.ex. Telefon arbetet, Telefon hem -->
						<Beskrivning>string</Beskrivning>					
					</KommunikationInfo>								
				</Kommunikation>
			</KontaktInfo>
			<ReferensNummer>string</ReferensNummer>
			<!-- GLN (Global Location Number, GS1-lokaliseringsnummer) -->
			<GLN>string</GLN>				
		</Fakturamottagare>		

		<!-- Information relaterad till Fastighet -->
		<Fastigheter>
			<FastighetsInfo>
				<Fastighetsbeteckning>string</Fastighetsbeteckning>
				<Trakt>string</Trakt> 
				<Block>string</Block> 
				<Tecken>string</Tecken> 
				<Enhet>string</Enhet> 
				<Fnr>string</Fnr>
				<!-- UUID, Universal Unik Identitet  -->				
				<UUID>string</UUID>	
				<Kommun>string</Kommun>	
				<Huvudfastighet>boolean</Huvudfastighet> 				
				<Fastighetsadresser>
					<FastighetsadressInfo>
						<Gatuadress>string</Gatuadress>
						<Postnummer>string</Postnummer>
						<Postort>string</Postort>
					</FastighetsadressInfo>
				</Fastighetsadresser>	
				<Koordinater>
					<KoordinatInfo>
						<XKoordinat>string</XKoordinat> 
						<YKoordinat>string</YKoordinat>
						<!-- Punkttyp, t.ex. Centralpunkt  -->
						<Punkttyp>string</Punkttyp>
					</KoordinatInfo>
				</Koordinater>
				<LagfarnaAgare>
					<LagfarenAgareInfo>
						<Namn>string</Namn>
						<PersonOrgNummer>string</PersonOrgNummer>
						<Gatuadress>string</Gatuadress>
						<Gatuadress2>string</Gatuadress2>
						<CO>string</CO> 
						<Postnummer>string</Postnummer>
						<Postort>string</Postort>
						<Land>string</Land>
						<Kommun>string</Kommun>
					</LagfarenAgareInfo>
				</LagfarnaAgare>
			</FastighetsInfo>
		</Fastigheter>

		<!-- Information Byggärende -->
		<Byggarende>
			<!-- t.ex. Nybyggnad, Tillbyggnad -->
			<Atgardstyp>string</Atgardstyp>	
			<!-- t.ex. Enbostadshus, Komplementbyggnad -->
			<Byggnadstyp>string</Byggnadstyp>				
			<!-- Kan vara flera areor -->
			<Areor>
				<AreaInfo>
					<!-- ByggnadAnlaggning, t.ex. Enbostadshus, Komplementbyggnad, Parkering -->
					<ByggnadAnlaggning>string</ByggnadAnlaggning>
					<!-- Areatyp, tillåtna värden är Bostadsarea (BOA), Bruttoarea (BTA), Byggnadsarea (BYA), Öppenarea (OPA)  -->
					<Areatyp>string</Areatyp>
					<Area>string</Area>
				</AreaInfo>
			</Areor>
			<!-- Information relaterad till Sakkunnig (Kontrollansvarig) -->
			<Sakkunnig>
				<SakkunnigInfo>
					<Fornamn>string</Fornamn>
					<Efternamn>string</Efternamn>
					<PersonOrgNummer>string</PersonOrgNummer> 
					<Gatuadress>string</Gatuadress>
					<CO>string</CO> 
					<Postnummer>string</Postnummer>
					<Postort>string</Postort>
					<Land>string</Land>
					<Titel>string</Titel>
					<Huvudansvarig>boolean</Huvudansvarig>
					<Kommunikation>
						<KommunikationInfo>
							<!-- Typ, tillåtna värden är E-Post, Mobil, Telefon & Fax -->
							<Typ>string</Typ>
							<Varde>string</Varde>
							<!-- Beskrivning, fritt fält för kommentar om kommunikationsinfo, t.ex. Telefon arbetet, Telefon hem -->
							<Beskrivning>string</Beskrivning>
						</KommunikationInfo>				
					</Kommunikation>					
					<Certifieringar>
						<CertifieringsInfo>
							<Cerifieringsnummer>string</Cerifieringsnummer>
							<!-- Nivå, Tillåtna värden Normal & Komplicerad -->
							<Niva>string</Niva> 
							<!-- Certifieradfom, t.ex. 2017-10-06 -->
							<Certifieradfom>date</Certifieradfom>							
							<!-- Certifieradtom, t.ex. 2017-10-06 -->
							<Certifieradtom>date</Certifieradtom>
							<CertifieradAv>string</CertifieradAv>
						</CertifieringsInfo>
					</Certifieringar>
				</SakkunnigInfo>
			</Sakkunnig>
		</Byggarende>
		
		<!-- Information relaterad till medföljande Filer -->
		<Filer>
			<FilInfo>
				<!-- Ev. unikt id för filen i e-tjänst -->
				<EFilId>string</EFilId>
				<!-- Faktiskt namn på fil som måste vara unikt i mappen där den är placerad, t.ex. 12345.pdf -->
				<Fil>string</Fil>
				<!-- Filnamn som blivit inskickat till e-tjänst, t.ex. FasadNorr.pdf -->
				<Filnamn>string</Filnamn>
				<!-- Typ av handling, t.ex. Ansökan, Fasadritning, Egenkontrollprogram, Köldmediarapport -->
				<Handlingstyp>string</Handlingstyp> 
				<Beskrivning>string</Beskrivning>
				<Handelsekategorikod></Handelsekategorikod>
				<Handelserubrik></Handelserubrik>
				<Handelsetext></Handelsetext>
				<!-- Ordningsnummer anger i vilken ordning filen läggs till händelser -->
				<Ordningsnummer></Ordningsnummer>
			</FilInfo>	
		</Filer>

	</Inkorg>
</Message>

Space:	Cesam H	Browse the "CHPUB" space Add a page to "CHPUB"
Space:	Cesam H - EDP Vision - Integration	Browse the "CHEVI" space Add a page to "CHEVI"
Space:	Miljö, Transport, Fastighet Confluence Space created for Jira Project MBGRV	Browse the "MBGRVA" space Add a page to "MBGRVA"
Space:	Proceedo e-handelssystem	Browse the "PEdok" space Add a page to "PEdok"

Cesam H - EDP Vision - Integration

Viktiga dokument

Samarbetsytor