customerContact = {  # Mapping pour le fichier DATA_CUSTOMERCONT_2678.CSV
    "CCT_CCT_ID" : "contactId",
    "CCT_CCT_CONTACT_CTT_GENRE" : "contactCivility",
    "CONTACT_NOM" : "contactLastName",
    "CCT_CCT_CONTACT_CTT_PRENOM" : "contactFirstName",
    "CCT_CCT_CONTACT_CTT_TEL" : "contactPhone",
    "CCT_CCT_CONTACT_CTT_EMAIL" : "contactEmail",
    "CCT_CCT_CONTACT_CTT_FONCTION" : "contactFunction",
    "CCT_CCT_CONTACT_CTT_SERVICE" : "contactService",
    "CCT_CCT_GESTION" : "contactManagement",
    "TYPE_CONTACT" : "contactType",
    "CCT_CCT_CLT_ID" : "companyId"
}

companyData = { #Mapping pour le fichier DATA_CUSTOMER_CLI_2680.CSV
    "CLT_CLT_TYPE" : "companyType",
    "CLT_CLT_ID" : "companyId",
    "CLT_CLT_REFERENCE" : "companyReference",
    "CLT_CLT_NOM" : "companyName",
    "CLT_CLT_COM_CODE_CATEG" : "companyCategoryCode",
    "CLT_CLT_SOC_TVA_INTRACOM" : "companyTvaNumber",
    "CCT_CCT_CONTACT_CTT_TEL" : "companyPhone",
    "CCT_CCT_CONTACT_CTT_PORTABLE" : "companyMobile",
    "NUM_TYPE_VOIE" : "companyAdress",
    "CAL_CAL_ADR_ADR_MENTION_SPE" : "companyAdressComplement",
    "CAL_CAL_ADR_ADR_CODE_POSTAL" : "companyZipCode",
    "CAL_CAL_ADR_ADR_COMMUNE" : "companyCity",
    "CAL_CAL_ADR_ADR_PAYS" : "companyCountry",
    "CCT_CCT_CONTACT_CTT_EMAIL" : "companyEmail",
    "CLT_CLT_COM_NOTES_AFFICHABLE" : "companyNotes",
    "CLT_CLT_COM_NOTES_IMPRIMABLE" : "companyPrintableNotes",
    "ETAT2" : "companyState",
    "CLT_CLT_ETAT_CPLT_ID" : "companyStateId",
    "CLT_CLT_FAC_MODE_PAIEMENT" : "companyPaymentMode",
    "CLT_CLT_FAC_DELAI_PAIEMENT" : "companyPaymentDelay",
    "GPV" : "companyGPV",
    "CLT_CLT_FAC_DEVISE" : "companyCurrency",
    "CLT_CLT_DATE_CREATION" : "companyCreationDate",
    "CLT_CLT_GRP_CLT_ID" : "companyGroupId",
    "CLT_CLT_SOC_SIRET" : "companySiret",
    "CLT_CLT_COM_MODE_EXPEDITION" : "companyShippingMode",
}

customerAdresses = { #Mapping pour le fichier DATA_CUSTOMERADDR_2677.CSV
    "CAL_CAL_ADR_ADR_DESTINATAIRE" : "recipientName",
    "NUM_TYPE_VOIE" : "adress",
    "CAL_CAL_ADR_ADR_MENTION_SPE" : "adressComplement",
    "CAL_CAL_ADR_ADR_CODE_POSTAL" : "zipCode",
    "CAL_CAL_ADR_ADR_COMMUNE" : "city",
    "CAL_CAL_ADR_ADR_PAYS" : "country",
    "CAL_CAL_CLT_ID" : "contactId"
}

companyRepresentative = { #Mapping pour le fichier SW_DATA_CUSTOMER_REP_2679.CSV
    "CAG_CAG_USR_ID" : "representativeId",
    "CAG_CAG_CLT_ID": "companyId",
    "USR_USR_NOM" : "representativeLastName",
}

companyGroup = { # Mapping pour le fichier SW_GT_CUSTOMERGROUP_2669.CSV
    "CLT_CLT_ID" : "companyId",
    "CLT_CLT_REFERENCE" : "companyReference",
}