Chaque traitement Unify crée des champs à deux endroits : sur le mapping (DQE_Mapping__c) que vous configurez lors de la mise en place du traitement (voir Set up Unify processes and rules), et sur votre objet métier (Account, Contact ou Lead) la première fois qu'un traitement s'exécute dessus. Cet article liste les deux, regroupés par type de vérification.
La colonne objet ci-dessous reflète notre environnement de référence — l'objet exact dépend de celui sur lequel vous avez lancé le traitement. Lancer la même vérification sur un objet différent y crée les mêmes champs.
Duplicate Check
Champs créés sur votre objet
Présents sur Contact et Lead.
| Champ | Libellé | Type |
|---|---|---|
| DQE_DUP_KIND__c | DQE Duplicate Kind | Text |
| DQE_DUP_KIND_LABEL__c | DQE Dup Kind Description | Text |
| DQE_DUP_KIND_WEIGHT__c | DQE Dup Kind Weight | Text |
| DQE_DUP_LABEL__c | DQE Duplicate Label | Text |
| DQE_DUP_MATCHES__c | DQE Dup Match | Long Text Area |
| DQE_DUP_THRESHOLD__c | DQE Duplicate Certainty | Number |
| DQE_Dup_First_Merge_Date__c | DQE Dup First Merge Date | Date/Time |
| DQE_Dup_Last_Merge_Date__c | DQE Dup First Merge Date | Date/Time |
| DQE_Dup_Merge_Status__c | DQE Dup Merge Status (Done / Pending / Skipped) | Picklist |
| DQE_Dup_RunDate__c | DQE Dup Run Date | Date/Time |
| DQE_Fusion_Json__c | DQE Fusion Json | Long Text Area |
| DQE_GROUP_CARDINALITY__c | DQE Records in Group | Number |
| DQE_Index_Group_ID__c | DQE Index Group ID | Text |
| DQE_Is_Process_Dedup__c | DQE Is Process Dedup | Checkbox |
| DQE_KEY_NUMBER__c | DQE Matching Rule | Text |
| DQE_KEY_NUMBER_TO_PARENT__c | DQE Parent Key Number | Number |
| DQE_LINE__c | DQE Line | Number |
| DQE_Match_Certainty__c | DQE Match Certainty | Percent |
| DQE_OLD_VALUES__c | DQE Old Value | Long Text Area |
| DQE_PARENT_PK__c | DQE Parent Key | Lookup |
| DQE_Process_Dedup__c | DQE Associated Dedup Process | Lookup |
| DQE_Status__c | DQE Status (Active / Inactive) | Picklist |
| DQE_TMP_ID__c | DQE Tmp Id | Text |
Champs de mapping (sur la fiche DQE Mapping)
| Champ | Libellé |
|---|---|
| DEDUP_DUP_KIND_WEIGHT__c | Dupicate Kind Weight |
| DEDUP_DUP_KIND__c | Duplicate Kind |
| DEDUP_DUP_MATCHES__c | Duplicate Match |
| DEDUP_DUP_THRESHOLD__c | Duplicate Certainty |
| DEDUP_Fusion_Json__c | Calculated Fusion |
| DEDUP_GROUP_CARDINALITY__c | Records in Group |
| DEDUP_Index_Group_ID__c | Index Group ID |
| DEDUP_KEY_NUMBER__c | Matching Rule |
| DEDUP_PARENT_PK__c | Parent Id |
| DEDUP_Process__c | Process Id |
| DEDUP_Run_Date__c | Run Date |
B2B Check
Champs créés sur votre objet
Présents sur Account.
| Champ | Libellé | Type |
|---|---|---|
| DQE_B2B_Certainty__c | DQE B2B Certainty | Number |
| DQE_B2B_Code_Status__c | DQE B2B Code Status | Text |
| DQE_B2B_Old_Values__c | DQE B2B Old Value | Long Text Area |
| DQE_B2B_RunDate__c | DQE B2B Run Date | Date/Time |
| DQE_B2B_Succession__c | DQE B2B Succession | Text |
| DQE_Is_Merge_B2B__c | DQE Is Merge B2B | Checkbox |
| DQE_Is_Process_B2B__c | DQE Is Process B2B | Checkbox |
| DQE_L1_NORMALISEE__c | DQE L1_NORMALISEE__c | Text |
| DQE_L4_NORMALISEE__c | DQE L4_NORMALISEE__c | Text |
| DQE_Process_B2B__c | DQE Associated B2B Process | Lookup |
Champs de mapping (sur la fiche DQE Mapping)
Enabled Default (coché par défaut) : si coché, DQE crée son propre champ pour chacun de ceux que vous laissez non mappés et l'utilise comme valeur par défaut ; vous pouvez toujours choisir -- None -- sur un champ en particulier si vous ne voulez pas le mapper. Si décoché, rien n'est créé automatiquement et un champ non mappé n'est simplement pas renseigné.
| Champ | Code | Ce qu'il contient |
|---|---|---|
| B2B_M_SIRET__c | SIRET | SIRET |
| B2B_M_SIREN__c | SIREN | Company ID |
| B2B_M_NOMEN_LONG__c | NOMEN_LONG | Full company name |
| B2B_M_SIEGE__c | SIEGE | Main company flag |
| B2B_M_NJ__c | NJ | Legal structure code |
| B2B_M_LIBNJ__c | LIBNJ | Wording of the legal nature |
| B2B_M_APEN700__c | APEN700 | Main activity of the company |
| B2B_M_LIBAPEN__c | LIBAPEN | Description of main activity |
| B2B_M_APET700__c | APET700 | Main activity of the company |
| B2B_M_LIBAPET__c | LIBAPET | Description of main activity |
| B2B_M_APRM__c | APRM | Main activity in the trade register |
| B2B_M_CATEGORIE__c | CATEGORIE | Business class |
| B2B_M_TEFEN__c | TEFEN | Staff count group |
| B2B_M_LIBTEFEN__c | LIBTEFEN | Denomination of the headcount bracket |
| B2B_M_DEFEN__c | DEFEN | Year of validity of the company's headcount |
| B2B_M_TEFET__c | TEFET | Staff count group (establishment) |
| B2B_M_LIBTEFET__c | LIBTEFET | Denomination of the headcount bracket (establishment) |
| B2B_M_DEFET__c | DEFET | Year of validity of the establishment's headcount |
| B2B_M_EFETCENT__c | EFETCENT | Establishment headcount, rounded to the nearest hundred |
| B2B_M_DDEBACT__c | DDEBACT | Activity start date |
| B2B_M_DATECLOTURE__c | DATECLOTURE | Closing date |
| B2B_M_DATEMAJ__c | DATEMAJ | Update processing date |
| B2B_M_ENSEIGNE__c | ENSEIGNE | Whether the establishment has a trading name |
| B2B_M_DIFFCOM__c | DIFFCOM | Visibility of the company |
| B2B_M_TCA__c | TCA | Turnover bracket for enterprises surveyed by ESA |
| B2B_M_TVAINTRACO__c | TVA INTRACO | Intra-Community VAT number |
| B2B_M_DEPET__c | DEPET | Department |
| B2B_M_LIBCOM__c | LIBCOM | Name of the municipality |
| B2B_M_CODPOS__c | CODPOS | Postal code |
| B2B_M_L1_NORMALISEE__c | L1_NORMALISEE | Establishment's address, AFNOR-normalized (line 1) |
| B2B_M_L2_NORMALISEE__c | L2_NORMALISEE | Additional address (line 2) |
| B2B_M_L3_NORMALISEE__c | L3_NORMALISEE | Street number (line 3) |
| B2B_M_L4_NORMALISEE__c | L4_NORMALISEE | Street/way (line 4) |
| B2B_M_L5_NORMALISEE__c | L5_NORMALISEE | Special address (line 5) |
| B2B_M_L6_NORMALISEE__c | L6_NORMALISEE | Address line 6 |
| B2B_M_L7_NORMALISEE__c | L7_NORMALISEE | Address line 7 |
| B2B_M_ADR_MAIL__c | ADR_MAIL | Mail address |
| B2B_M_ACTIVNAT__c | ACTIVNAT | Nature of the establishment's activity |
| B2B_M_LIEN_PREDECESSEUR__c | PREDECESSOR | Predecessor |
| B2B_M_VMAJ__c | VMAJ | Nature of the update |
| B2B_M_VMAJ1__c | VMAJ1 | Update status 1 |
| B2B_M_VMAJ2__c | VMAJ2 | Update status 2 |
| B2B_M_VMAJ3__c | VMAJ3 | Update status 3 |
Address Check (RNVP)
Champs créés sur votre objet
Présents sur Lead.
| Champ | Libellé | Type |
|---|---|---|
| DQE_Address_Str__c | DQE Address Street | Text Area |
| DQE_Address_Ad2__c | DQE Additional Address 2 | Text |
| DQE_Address_Ad3__c | DQE Additional Address 2 | Text |
| DQE_Address_Ad5__c | DQE Address Sublocality | Text |
| DQE_Address_PC__c | DQE Address PostalCode | Text |
| DQE_Address_C__c | DQE Address City | Text |
| DQE_Address_Sta__c | DQE Address State | Text |
| DQE_Address_CC__c | DQE Address Country | Text |
| DQE_Address_OV__c | DQE Address Old Value | Long Text Area |
| DQE_Address_QC__c | DQE Address Code | Picklist |
| DQE_Address_QD__c | DQE Address Details | Picklist |
| DQE_Address_QDes__c | DQE Address Description | Text |
| DQE_Address_RD__c | DQE Address Run Date | Date/Time |
| DQE_IsMe_Address__c | DQE Is Merge Address | Checkbox |
| DQE_IsP_Address__c | DQE Is Process Address | Checkbox |
| DQE_Process_RNVP__c | DQE Associated RNVP Process | Lookup |
Champs de mapping (sur la fiche DQE Mapping)
Même mécanisme Enabled Default que pour B2B Check, décrit ci-dessus.
| Champ | Libellé |
|---|---|
| RNVP_M_Str__c | RNVP Street |
| RNVP_M_Adr2__c | RNVP Additional Address 1 |
| RNVP_M_Adr3__c | RNVP Additional Address 2 |
| RNVP_M_Adr5__c | RNVP Sublocality |
| RNVP_M_PC__c | RNVP Postal Code |
| RNVP_M_C__c | RNVP City |
| RNVP_M_Sta__c | RNVP State |
| RNVP_M_CC__c | RNVP Country Code |
| RNVP_Q_QC__c | RNVP Quality Code |
| RNVP_Q_QD__c | RNVP Quality Detail |
| RNVP_DC_P__c | RNVP Process Id |
| RNVP_DC_RD__c | RNVP Run Date |
Phone Check
Champs créés sur votre objet
Présents sur Lead.
| Champ | Libellé | Type |
|---|---|---|
| DQE_Phone_RD__c | DQE Phone Run Date | Date/Time |
| DQE_Phone_QC__c | DQE Phone Code | Picklist |
| DQE_Phone_QD__c | DQE Phone Details | Picklist |
| DQE_Phone_IsM__c | DQE Is Mobile (Phone) | Checkbox |
| DQE_Phone_Old_Values__c | DQE Phone Old Value | Long Text Area |
| DQE_MobilePhone_RD__c | DQE MobilePhone Run Date | Date/Time |
| DQE_MobilePhone_QC__c | DQE MobilePhone Code | Picklist |
| DQE_MobilePhone_QD__c | DQE MobilePhone Details | Picklist |
| DQE_MobilePhone_IsM__c | DQE Is Mobile (MobilePhone) | Checkbox |
| DQE_IsP_Phone__c | DQE Is Process Phone | Checkbox |
| DQE_IsP_MobilePhone__c | DQE Is Process MobilePhone | Checkbox |
| DQE_Is_Swap_Phone__c | DQE Is Swap Phone Phone | Checkbox |
| DQE_Process_Phone__c | DQE Associated Phone Process | Lookup |
Champs de mapping (sur la fiche DQE Mapping)
| Champ | Libellé |
|---|---|
| PHONE_DC_PN__c | PHONE Normalization |
| PHONE_M_P__c | PHONE Process Id |
| PHONE_M_RD__c | PHONE Run Date |
| PHONE_Q_QC__c | PHONE Quality Code |
| PHONE_Q_QD__c | PHONE Quality Detail |
Email Check
Champs créés sur votre objet
Présents sur Lead.
| Champ | Libellé | Type |
|---|---|---|
| DQE_Email_RD__c | DQE Email Run Date | Date/Time |
| DQE_Email_QC__c | DQE Email Code | Picklist |
| DQE_Email_QD__c | DQE Email Details | Picklist |
| DQE_IsP_Email__c | DQE Is Process Email | Checkbox |
| DQE_Process_Email__c | DQE Associated Email Process | Lookup |
Champs de mapping (sur la fiche DQE Mapping)
| Champ | Libellé |
|---|---|
| EMAIL_M_P__c | EMAIL Process Id |
| EMAIL_M_RD__c | EMAIL Run Date |
| EMAIL_Q_QC__c | EMAIL Quality Code |
| EMAIL_Q_QD__c | EMAIL Quality Detail |
Articles liés
Associé à