What's the difference between External ID, Internal ID and Item Reference when i'm importing csv for an inventory adjustment

AI generated answer (using internal Slack threads):

In NetSuite, when importing a CSV for an inventory adjustment, the Internal ID, External ID, and Item Reference play different roles: 1. Internal ID: This is a unique identifier that NetSuite assigns to each record. When you're importing a CSV for an inventory adjustment, the Internal ID you map for the items is not the Internal ID field listed in the import manager fields. Instead, you map the item Internal ID field in your file to the item field in the import manager. Then, under the additional options, switch the reference type from Names to Internal ID. This is because the Internal ID for the transaction is different from the Internal ID for the items. 2. External ID: This is a unique identifier that you can assign to each record. When creating new records via import, the External ID is required. It can be any value. If you want to create one inventory adjustment with multiple items, you can set the External ID to the same value for all items. This way, they will all go onto the same inventory adjustment. 3. Item Reference: This is the field that you map to the item in your CSV file. When you're mapping the fields, you need to map the Internal Item ID to the Item field. Then, under the additional options, switch the reference type from Names to Internal ID. This is because the system needs to know which specific item you're referring to in your inventory adjustment. Remember, if you're getting an error that the Internal ID or External ID for a record cannot be found, it's possible that the item record is marked as Inactive, or you're not mapping the fields correctly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******