Export the mst Supplier list in the E2OPEN import format
User Story
As a CATALOG MANAGER (global), I want to be able to export the MST SUPPLIER list in the E2OPEN format so that I may import changes/updates into the GFPVAN.
Background Documents
-
https://drive.google.com/drive/folders/1avI8xHUDzA_OtDoHiHU8KdJkzLMEn6oH
-
Format Issue 66:
The mst_suppliers export is more complicated as it requires a join for the connections between the supplier r and the country/bucket combintations.
...
Result would be
- supplierA; CountryAA; Bucket-A; details........
- supplierA; CountryAA; Bucket-Other; details........
Acceptance Criteria
-
There is an export (xlsx) -
The ux of the export is the same as seen in the mockups of #66 (closed). -
The ux of the export does not include family choices -
The columns should be in specific order -
Only attributes and sku from both families should be in excel file -
The exported excel file is the combination of the supplier list and country/bucket combinations. (MD_HUB and MD_SUPPLIER_MASTER) -
Header columns have "#" in the very first cell -
Optimize step Hash first cell -
Families should be hardcoded in MVP -
Ability to create mst_supplier job instance in Exports tab
Definition of Done
-
User Story can be broken down no further -
Acceptance Criteria and Story Points are agreed upon by development team and PO -
UI Mockups are created and reviewed -
Code is written, automated tests are added, reviewed, all tests pass -
Documentation is updated
Edited by Krzysztof Grabowski