Update Sales Item Import to use xRef for Country

As a system I want the Sales Item Import to be updated to use the Country Codes that CFA pass to us so that the zones are no longer hard coded

Notes

• Sales Item Import
• Use zone xref to identify Location - CountryName zone
  • Currently it's hardcoded to look at the UN and Canada zone
• 

Current process to generate Sales Item Import
Input

• CFA Sends -> Sales Item csv
  • CFA will start to include the Country Code in this file, see CFAMX-8169

Sales Item csv gets Run thru SSIS Package

Output of SSIS Package

• Sales Item Master csv
  • This file will include the Country Code that was in the Sales Item csv (this is already implemented)
  • The import process needs to be updated, to not translate the Country Codes directly to the Zones (which is hard coded), but instead look at tbZone.ZoneExtRef and identify the zone that way
• POS Item Mapping csv
• Sales Item Change csv

Database

• Ensure that Puerto Rico is available in Entity Manager

Confluence: https://cfacorp.atlassian.net/wiki/spaces/IN/pages/609157821/Sales+Item+Import

Acceptance Criteria

1. Confirm that after the deployment of Code, that Puerto Rico is created and available as a Country in Entity Manager
2. Confirm that a script is made available to the Delivery Team to update the ZoneExtRef in tbZone
3. Confirm when a Sales Item Import is processed and the new zone field is not supplied, that an entity sales item is created at all entities and marked as Active at all entities
4. Confirm when a Sales Item Import is processed and the new zone field is supplied, and the data in the field corresponds to a zone in InFORM, based on the ZoneExtRef, an entity sales item is created at all entities but marked as Active only at the stores within that zone
5. Confirm when a Sales Item Import is processed and the new zone field is supplied, if the data supplied in the zone field does not correspond to a zone in InFORM, based on the ZoneExtRef, the record is rejected and skipped, with the error being written to the log file
6. Notes about the Status: Can be Y, 1, A, ACTIVE, TRUE, or T to set status to "Active". Any other value sets status to "Inactive".
7. Confirm that if the Status is set to D for a Sales Item the all associated Entity Sales Item are set to Inactive
8. Confirm that Confluence is updated to reflect the new zone column