2022
To maintain the relationship for creation of new records from external system into Database Salesforce schema, the external application will have to establish relationship between the parent and child elements. To create a relationship in child or related table, the standard practice is to add a related column as REL[SF Table Name]ID to point to the primary key of "SYNC_ID" of the related / parent table.
Synchronization sequence example between Account and Contact:
The system will do a check on SFCONTACT table and retrieve two new records without SFID and updates those records with respective SFIDs. At the same time it will find the external id, RELACCOUNTID and associates it to the right parent record into salesforce.com
Note:
Create a column with the following convention: