DQE One Field Reference

Support DQE
Support DQE
  • Updated

Each Unify process creates fields in two places: on the mapping (DQE_Mapping__c) you configure when setting up the process (see Set up Unify processes and rules), and on your business object (Account, Contact or Lead) the first time a process runs against it. This article lists both, grouped by check type.

The object column below reflects our reference environment — the exact object depends on which one you ran the process against. Running the same check on a different object creates the same fields there.

Duplicate Check

Fields created on your object

Found on Contact and Lead.

Field Label 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

Mapping fields (on the DQE Mapping record)

Field Label
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

Fields created on your object

Found on Account.

Field Label 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

Mapping fields (on the DQE Mapping record)

Enabled Default (checked by default): if checked, DQE creates its own field for any of these you leave unmapped and uses it as the default; you can still pick -- None -- on a specific one if you don't want it mapped. If unchecked, nothing is created automatically and an unmapped field is simply not populated.

Field Code What it holds
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)

Fields created on your object

Found on Lead.

Field Label 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

Mapping fields (on the DQE Mapping record)

Same Enabled Default mechanism as B2B Check, described above.

Field Label
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

Fields created on your object

Found on Lead.

Field Label 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

Mapping fields (on the DQE Mapping record)

Field Label
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

Fields created on your object

Found on Lead.

Field Label 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

Mapping fields (on the DQE Mapping record)

Field Label
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

Related articles

Related to

Was this article helpful?

0 out of 0 found this helpful