{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Mapning","DigiResolver","Setup","Feltmapning","Dokumentation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mapning","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["SKATXML fil","SKATXML element","SKATXML type","OIO elementnavn","OIOXML type","OIO skemafilnavn","Noter","Transient","Path","Keywords"]
["AbonnementType.xsd","AbonnementTypeKode","fase2:KodeFireCifreStartEtType","513_AbonnementTypeKode","integer",{"$f":"IF(AND(D2<>\"\",B2<>\"-\",ISERROR(FIND(\"_\",D2))),CONCATENATE(D2,\".xsd\"),\"\")","v":""}]
["AbonnentType.xsd","AbonnentTypeKode","fase2:KodeFireCifreStartEtType","4790_AbonnentTypeKode","integer",{"$f":"IF(AND(D3<>\"\",B3<>\"-\",ISERROR(FIND(\"_\",D3))),CONCATENATE(D3,\".xsd\"),\"\")","v":""}]
["AdgangFormaalType.xsd","AdgangFormålTypeKode","fase2:KodeTreCifreStartEtType","4392_AdgangFormaalTypeKode","integer",""]
["AlternativAdresse.xsd","AlternativAdresseAdresseLinie1","fase2:AdresseLinieType","6448_PostalAddressFirstLineText","string",""]
["AlternativAdresse.xsd","AlternativAdresseAdresseLinie2","fase2:AdresseLinieType","5909_PostalAddressSecondLineText","string",""]
["AlternativAdresse.xsd","AlternativAdresseAdresseLinie3","fase2:AdresseLinieType","1572_PostalAddressThirdLineText","string",""]
["AlternativAdresse.xsd","AlternativAdresseAdresseLinie4","fase2:AdresseLinieType","4045_PostalAddressFourthLineText","string",""]
["AlternativAdresse.xsd","AlternativAdresseAdresseLinie5","fase2:AdresseLinieType","6906_PostalAddressFifthLineText","string",""]
["Angivelse.xsd","AngivelsePeriodeFra","fase2:DatoType","784_StartDate","date",""]
["Angivelse.xsd","AngivelsePeriodeTil","fase2:DatoType","3018_EndDate","date",""]
["Angivelse.xsd","AngivelseVirksomhedEgenID","fase2:VirksomhedEgenIDType","3542_AngivelseVirksomhedEgenIdentifikator","string",""]
["AngivelseFelt.xsd","AngivelseFeltIndhold","fase2:IndholdType","4455_AngivelseFeltIndholdTekst","string",""]
["AnsaettelseForhold.xsd","AnsættelseForholdMedarbejderNummer","fase2:IdentifikationNummer15Type","5085_AnsaettelseforholdMedarbejderIdentifikator","string",""]
["Blanket.xsd","BlanketNummer","fase2:BlanketNummerType","5378_BlanketNummerIdentifikator","string",""]
["BlanketFelt.xsd","BlanketFeltNummer","fase2:TalHelType","2307_BlanketFeltNummerIdentifikator","integer",""]
["FeltEnhedType.xsd","FeltEnhedTypeKode","fase2:KodeType","3750_FeltEnhedTypeKode","integer",""]
["IndkomstPersonGruppe.xsd","IndkomstPersonGruppeDispositionDato","fase2:DatoType","4335_IndkomstPersonGruppeDispositionDato","date",""]
["Land.xsd","LandKode","fase2:AdresseLandKodeType","3166_CountryIdentificationCode","string",""]
["Person.xsd","PersonCPRNummer","fase2:CPRNummerType","3541_PersonCivilRegistrationIdentifier","string",""]
["SupplerendePersonOplysning.xsd","SupplerendePersonOplysningNavn","fase2:Tekst300Type","2418_PersonName","string",""]
["SupplerendePersonOplysning.xsd","SupplerendePersonOplysningFødselDato","fase2:FødselDatoType","375614_SupplerendePersonOplysningFoedselTekst","string",""]
["SupplerendePersonOplysning.xsd","SupplerendePersonOplysningKøn","fase2:KønType","6170_PersonGenderCode","string",""]
["Virksomhed.xsd","VirksomhedSENummer","fase2:SENummerType","237613_SEnummerIdentifikator","string",""]
["IndkomstOplysningAdgangMedarbejderIdentifikation.xsd","IndkomstOplysningAdgangMedarbejderIdentifikation","fase2:TekstKortType","6267_IndkomstOplysningAdgangMedarbejderIdentifikator","string",""]
["IndkomstOplysningAdgangReferenceNummer.xsd","IndkomstOplysningAdgangReferenceNummer","fase2:ReferenceNummerType","1225_IndkomstOplysningAdgangReferenceNummerIdentifikator","string",""]
["SoegeDatoFra.xsd","SøgeDatoFra","fase2:DatoType","784_StartDate","date",""]
["SoegeDatoTil.xsd","SøgeDatoTil","fase2:DatoType","3018_EndDate","date",""]
["SoegeAArMaanedFra.xsd","SøgeÅrMånedFra","fase2:ÅrMånedType","4926473_SoegeAArMaanedFraKode","integer",""]
["SoegeAArMaanedTil.xsd","SøgeÅrMånedTil","fase2:ÅrMånedType","4926491_SoegeAArMaanedTilKode","integer",""]

{"sheet":"DigiResolver","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[79,2,79,3]]}
["Navn","Namespace","Url"]
["513_AbonnementTypeKode","http://rep.oio.dk/skat.dk/eindkomst/class/abonnementtype/xml/schemas/20071202/","http://www.digitaliser.dk/resource/513/artefact/SKAT_AbonnementTypeKode.xsd"]
["4790_AbonnentTypeKode","http://rep.oio.dk/skat.dk/eindkomst/class/abonnenttype/xml/schemas/20071202/","http://www.digitaliser.dk/resource/4790/artefact/SKAT_AbonnentTypeKode.xsd"]
["4392_AdgangFormaalTypeKode","http://rep.oio.dk/skat.dk/eindkomst/class/adgangformaaltype/xml/schemas/20071202/","http://digitaliser.dk/resource/4392/artefact/SKAT_AdgangFormaalTypeKode.xsd"]
["6448_PostalAddressFirstLineText","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2005/05/19/","http://www.digitaliser.dk/resource/6448/artefact/DKCC_PostalAddressFirstLineText.xsd"]
["5909_PostalAddressSecondLineText","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2005/05/19/","http://www.digitaliser.dk/resource/5909/artefact/DKCC_PostalAddressSecondLineText.xsd"]
["1572_PostalAddressThirdLineText","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2005/05/19/","http://www.digitaliser.dk/resource/1572/artefact/DKCC_PostalAddressThirdLineText.xsd"]
["4045_PostalAddressFourthLineText","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2005/05/19/","http://www.digitaliser.dk/resource/4045/artefact/DKCC_PostalAddressFourthLineText.xsd"]
["6906_PostalAddressFifthLineText","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2005/05/19/","http://www.digitaliser.dk/resource/6906/artefact/DKCC_PostalAddressFifthLineText.xsd"]
["784_StartDate","http://rep.oio.dk/xkom.dk/xml/schemas/2006/09/01/","http://www.digitaliser.dk/resource/784/artefact/XKOM_StartDate.xsd"]
["3018_EndDate","http://rep.oio.dk/xkom.dk/xml/schemas/2007/04/15/","http://www.digitaliser.dk/resource/3018/artefact/XKOM_EndDate.xsd"]
["3542_AngivelseVirksomhedEgenIdentifikator","http://rep.oio.dk/skat.dk/eindkomst/class/angivelse/xml/schemas/20071202/","http://www.digitaliser.dk/resource/3542/artefact/SKAT_AngivelseVirksomhedEgenIdentifikator.xsd"]
["4455_AngivelseFeltIndholdTekst","http://rep.oio.dk/skat.dk/eindkomst/class/angivelsefelt/xml/schemas/20071202/","http://www.digitaliser.dk/resource/4455/artefact/SKAT_AngivelseFeltIndholdTekst.xsd"]
["5085_AnsaettelseforholdMedarbejderIdentifikator","http://rep.oio.dk/skat.dk/eindkomst/class/ansaettelseforhold/xml/schemas/20071202/","http://www.digitaliser.dk/resource/5085/artefact/SKAT_AnsaettelseforholdMedarbejderIdentifikator.xsd"]
["5378_BlanketNummerIdentifikator","http://rep.oio.dk/skat.dk/eindkomst/class/blanket/xml/schemas/20071202/","http://www.digitaliser.dk/resource/5378/artefact/SKAT_BlanketNummerIdentifikator.xsd"]
["2307_BlanketFeltNummerIdentifikator","http://rep.oio.dk/skat.dk/eindkomst/class/blanketfelt/xml/schemas/20071202/","http://www.digitaliser.dk/resource/2307/artefact/SKAT_BlanketFeltNummerIdentifikator.xsd"]
["3750_FeltEnhedTypeKode","http://rep.oio.dk/skat.dk/eindkomst/class/feltenhedtype/xml/schemas/20071202/","http://www.digitaliser.dk/resource/3750/artefact/SKAT_FeltEnhedTypeKode.xsd"]
["4335_IndkomstPersonGruppeDispositionDato","http://rep.oio.dk/skat.dk/eindkomst/class/indkomstpersongruppe/xml/schemas/20071202/","http://www.digitaliser.dk/resource/4335/artefact/SKAT_IndkomstPersonGruppeDispositionDato.xsd"]
["3166_CountryIdentificationCode","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2003/02/13/","http://www.digitaliser.dk/resource/3166/artefact/DKCC_CountryIdentificationCode.xsd"]
["3541_PersonCivilRegistrationIdentifier","http://rep.oio.dk/cpr.dk/xml/schemas/core/2005/03/18/","http://www.digitaliser.dk/resource/3541/artefact/CPR_PersonCivilRegistrationIdentifier.xsd"]
["2418_PersonName","http://rep.oio.dk/itst.dk/xml/schemas/2006/01/17/","http://www.digitaliser.dk/resource/2418/artefact/ITST_PersonName.xsd"]
["375614_SupplerendePersonOplysningFoedselTekst","http://rep.oio.dk/skat.dk/eindkomst/class/supplerendepersonoplysning/xml/schemas/20071202/","http://www.digitaliser.dk/resource/375614/artefact/SKAT_SupplerendePersonOplysningFoedselTekst.xsd"]
["6170_PersonGenderCode","http://rep.oio.dk/ebxml/xml/schemas/dkcc/2006/01/23/","http://www.digitaliser.dk/resource/6170/artefact/DKCC_PersonGenderCode.xsd"]
["237613_SEnummerIdentifikator","http://rep.oio.dk/skat.dk/TSE/virksomhed/xml/schemas/2006/09/01/","http://www.digitaliser.dk/resource/237613/artefact/SKAT_SEnummerIdentifikator.xsd"]
["6267_IndkomstOplysningAdgangMedarbejderIdentifikator","http://rep.oio.dk/skat.dk/eindkomst/class/indkomstoplysningadgangmedarbejderidentifikator/xml/schemas/20071202/","http://www.digitaliser.dk/resource/6267/artefact/SKAT_IndkomstOplysningAdgangMedarbejderIdentifikator.xsd"]
["1225_IndkomstOplysningAdgangReferenceNummerIdentifikator","http://rep.oio.dk/skat.dk/eindkomst/class/indkomstoplysningadgangreferencenummer/xml/schemas/20071202/","http://www.digitaliser.dk/resource/1225/artefact/SKAT_IndkomstOplysningAdgangReferenceNummerIdentifikator.xsd"]
["4926473_SoegeAArMaanedFraKode","http://rep.oio.dk/skat.dk/eindkomst/class/soegeaarmaanedfrakode/xml/schemas/20071202/","http://www.digitaliser.dk/resource/4926473/artefact/SoegeAArMaanedFraKode.xsd"]
["4926491_SoegeAArMaanedTilKode","http://rep.oio.dk/skat.dk/eindkomst/class/soegeaarmaanedtilkode/xml/schemas/20071202/","http://www.digitaliser.dk/resource/4926491/artefact/SoegeAArMaanedTilKode.xsd"]

{"sheet":"Setup","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Makro-konfigurationsværdier"]
["Genererede schemaer følger NDR 3.2/4!"]
[]
[]
["Projekt","Load fra foldere"]
["eIndkomst","G:\\Relevante Dokumenter\\eIndkomst\\I GANG\\04_OIO_eIndkomst11_IOVH\\IndkomstOplysningVirksomhedHent.r20361\\package\\class"]
[]
["Generer i path"]
["G:\\Relevante Dokumenter\\eIndkomst\\I GANG\\04_OIO_eIndkomst11_IOVH\\generate","Verificer datastrukturer",null,"Materialet/leverance-mappe:"]
[null,"G:\\Relevante Dokumenter\\eIndkomst\\I GANG\\04_OIO_eIndkomst11_IOVH\\IndkomstOplysningVirksomhedHent.r20361\\package\\view"]
[]
[]
[]
["Target namespace (afledt af projektnavn)"]
["http://rep.oio.dk/skat.dk/eindkomst"]
[]
["SKAT namespace"]
["http://skat.dk/begrebsmodel/2008/01/01/"]
[]
["Bruger på digitaliser.dk"]
["muhammetturkcan"]

{"sheet":"Feltmapning","index":3,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Tilladte OIO-postfixes"]
["Amount"]
["Beloeb"]
["BeloebTekst"]
["Code"]
["Kode"]
["Date"]
["Dato"]
["DateTime"]
["DatoTid"]
["Identifier"]
["Identifikator"]
["Reference"]
["Indicator"]
["Indikator"]
["Measure"]
["Maal"]
["Name"]
["Navn"]
["Percent"]
["Procent"]
["Quantity"]
["Kvantitet"]
["Rate"]
["Text"]
["Tekst"]
["Periode"]
["Data"]
["Interval"]

{"sheet":"Dokumentation","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["SKATXML element","SKATXML type","OIO elementnavn","OIOXML type"]
["AbonnementTypeKode","fase2:KodeFireCifreStartEtType","SKAT_AbonnementTypeKode.xsd","xs:integer"]
["AbonnentTypeKode","fase2:KodeFireCifreStartEtType","SKAT_AbonnentTypeKode.xsd","xs:integer"]
["AdgangFormålTypeKode","fase2:KodeTreCifreStartEtType","SKAT_AdgangFormaalTypeKode.xsd","xs:integer"]
["AlternativAdresseAdresseLinie1","fase2:AdresseLinieType","DKCC_PostalAddressFirstLineText.xsd","cpr:CompletePostalLabelTextType"]
["AlternativAdresseAdresseLinie2","fase2:AdresseLinieType","DKCC_PostalAddressSecondLineText.xsd","cpr:CompletePostalLabelTextType"]
["AlternativAdresseAdresseLinie3","fase2:AdresseLinieType","DKCC_PostalAddressThirdLineText.xsd","cpr:CompletePostalLabelTextType"]
["AlternativAdresseAdresseLinie4","fase2:AdresseLinieType","DKCC_PostalAddressFourthLineText.xsd","cpr:CompletePostalLabelTextType"]
["AlternativAdresseAdresseLinie5","fase2:AdresseLinieType","DKCC_PostalAddressFifthLineText.xsd","cpr:CompletePostalLabelTextType"]
["AngivelsePeriodeFra","fase2:DatoType","XKOM_StartDate.xsd","xs:date"]
["AngivelsePeriodeTil","fase2:DatoType","XKOM_EndDate.xsd","xs:date"]
["AngivelseVirksomhedEgenID","fase2:VirksomhedEgenIDType","SKAT_AngivelseVirksomhedEgenIdentifikator.xsd","xs:string"]
["AngivelseFeltIndhold","fase2:IndholdType","SKAT_AngivelseFeltIndholdTekst.xsd","xs:string"]
["AnsættelseForholdMedarbejderNummer","fase2:IdentifikationNummer15Type","SKAT_AnsaettelseforholdMedarbejderIdentifikator.xsd","xs:string"]
["BlanketNummer","fase2:BlanketNummerType","SKAT_BlanketNummerIdentifikator.xsd","xs:string"]
["BlanketFeltNummer","fase2:TalHelType","SKAT_BlanketFeltNummerIdentifikator.xsd","xs:integer"]
["FeltEnhedTypeKode","fase2:KodeType","SKAT_FeltEnhedTypeKode.xsd","xs:integer"]
["IndkomstPersonGruppeDispositionDato","fase2:DatoType","SKAT_IndkomstPersonGruppeDispositionDato.xsd","xs:date"]
["LandKode","fase2:AdresseLandKodeType","DKCC_CountryIdentificationCode.xsd","dkcc:CountryIdentificationCodeType"]
["PersonCPRNummer","fase2:CPRNummerType","CPR_PersonCivilRegistrationIdentifier.xsd","cpr:PersonCivilRegistrationIdentifierType"]
["SupplerendePersonOplysningNavn","fase2:Tekst300Type","ITST_PersonName.xsd","itst:PersonNameType"]
["SupplerendePersonOplysningFødselDato","fase2:FødselDatoType","SKAT_SupplerendePersonOplysningFoedselTekst.xsd","xs:string"]
["SupplerendePersonOplysningKøn","fase2:KønType","DKCC_PersonGenderCode.xsd","dkcc:PersonGenderCodeType"]
["VirksomhedSENummer","fase2:SENummerType","SKAT_SEnummerIdentifikator.xsd","cvr:CVRnumberType"]
["IndkomstOplysningAdgangMedarbejderIdentifikation","fase2:TekstKortType","SKAT_IndkomstOplysningAdgangMedarbejderIdentifikator.xsd","xs:string"]
["IndkomstOplysningAdgangReferenceNummer","fase2:ReferenceNummerType","SKAT_IndkomstOplysningAdgangReferenceNummerIdentifikator.xsd","xs:string"]
["SøgeDatoFra","fase2:DatoType","XKOM_StartDate.xsd","xs:date"]
["SøgeDatoTil","fase2:DatoType","XKOM_EndDate.xsd","xs:date"]
["SøgeÅrMånedFra","fase2:ÅrMånedType","SoegeAArMaanedFraKode.xsd","xs:integer"]
["SøgeÅrMånedTil","fase2:ÅrMånedType","SoegeAArMaanedTilKode.xsd","xs:integer"]