1. Implementing Product Management
  2. When importing items via FBDI, how does the system identify the items that must be updated? What are the key columns?

When importing items via FBDI, how does the system identify the items that must be updated? What are the key columns?

The system identifies the items that must be updated based on the Transaction Type column. If Transaction Type is set to Sync, during import if the item exists in the database, then the item is updated. If the item doesn’t exist in the database, then it is created. The other key columns for updating the item are:
  • Item Number
  • Organization Code
  • Batch ID
  • Batch Number