Story

As an admin, I would like to update how distribution centers are assigned to vendors via the Location File import process.

Details

CFA is changing systems on their end and have reproduced the Location files from the data in this new system. The syntax of the file is the same but CFA would like to send the data differently.

Update Goal

The goal of this update is to only change the reference for how we know a distribution center is assigned to a vendor. The rest of the functionality

Existing Process

When CFA sends the Location file, they include an abbreviated prefix in the <dist:DistributionCenter> attribute.

We then use that abbreviation to determine that "MBM" is "MCLANE COMPANY INC" and we add that distribution center to the correct vendor.

Updated Process

CFA will no longer send us "-" in the prefix <dist:DistributionCenter> attribute. They will only send us the Distribution Center name from now on.

As such, we have to use a different element of the file to assign the distribution center to the vendor.

Moving forward, we should reference the "<dist:ShortName>" attribute to assign the distribution center to the vendor. We know that CFA will always send the the full vendor name in this field. Using this as a reference will allow us CFA to send whatever they want in the DC field and we can confidently assign that DC to the correct zone.

What should happen moving forward is a follows:

Assuming the data is formatted correctly and the vendor and short name exist already in our system:

• CFA sends a Location file with a new distribution center.
• InFORM recognizes that there is new data to insert that is formatted correctly.
• InFORM references the short name to determine what vendor to assign the distribution center to
• The distribution center is correctly assigned to the vendor using the updated reference.

Note

With the abbreviated names going away, we will have to map a new set of "Short Names" to the existing abbreviated prefixes. As soon as I have that list I will attach it to this ticket

Schema Change Details

In Progress I will provide the these details ASAP.

AC

1. DCs are correctly assigned to Vendors based on "Short Name" attribute in the location file.
   1. This is true for the location all file and the incremental location file.
2. Existing functionality for the location file does not change.
   1. It fails for the same reasons it does now and it successfully imports when the data is all correct.