When you perform a query or data export using an API tool such as Salesforce Data Loader or Workbench, a field called MasterRecordId appears in the results for Lead, Account, and Contact objects. This field is not visible in the Salesforce user interface on the object's field list in Setup, but it is accessible via the Salesforce API.
The MasterRecordId field is sometimes populated with a record ID, and sometimes empty. This article explains what this field means and when it is populated.
The MasterRecordId field is populated when a record merge is performed on Lead, Account, or Contact records. When two records are merged, the losing record is deleted. The MasterRecordId field on the deleted (losing) record is populated with the Salesforce record ID of the winning (master) record.
Example:
Consider two Account records:
0013D00000ZUufQQAT0013D00000ZB5ekQADIf these two records are merged and SFDC Test 1 is selected as the master record:
MasterRecordId value for the deleted Account 2 record shows as 0013D00000ZUufQQAT (the ID of the winning record, SFDC Test 1).When is MasterRecordId empty? The MasterRecordId is empty (null) when the record has never been involved in a merge operation. Most records will have an empty MasterRecordId.
000383966

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.