The Salesforce IDs that are being synced to NetSuite are different than the IDs that are visible in Salesforce, yet, they reference the same record. Typically, a Salesforce ID is 15 characters long, but Celigo references a Salesforce ID that is amended with an additional three digits (Ex: Salesforce ID = a6614000000PCAq, but syncs to NetSuite as a6614000000PCAqAAO). This may cause problems when you try to sync existing records between the two systems using a custom data flow.
There are two versions of every record ID in Salesforce:
- a 15 digit case-sensitive version which is referenced in the UI
- an 18 digit case-insensitive version which is referenced through the API
The last 3 digits of the 18 digit ID are a checksum of the capitalizations of the first 15 characters. This ID length was created as a workaround to legacy systems that were not compatible with case-sensitive IDs. The API will accept the 15 digit ID as input but will always return the 18 digit ID. To easily convert a 15 digit record ID to an 18 digit record ID, click here.