Creation or Updaition of Picklists with BODs from ERPs
The Inbound BOD (CodeDefinition) published from the ERP (for e.g., M3) to CRM performs
the below updates on the CRM side.
- The picklist (ListID on the BOD output) can be created (as code type), if its not available.
- If the picklist already exists, duplicates cannot be created
- The picklist item (CodeValue in the BOD output) can be created for the picklist.
- The first description in the BOD output is inserted as the picklist item text
- If the picklist item already exits, its text can be updated with the first description
- LanguageIDs and associated descriptions in the BOD output can be inserted in the Translations
- Descriptions without the language ID can be inserted with backoffice language ID
- With each subsequent BOD publish from the ERP, for the same picklist / picklist item, existing picklist item text and translations are updated, and new values appended
- Duplicate picklist items are allowed as per the logicalID and SORAccountingEntityID combination present in the BOD output.
- For a given picklist item and languageID, no duplicate translations are inserted