Details
-
Story
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
-
ACQ Sprint 150, ACQ Sprint 151
-
3
-
Thunderjet
-
Orchid (R1 2023)
-
TBD
Description
Purpose/Overview:
New API to get Export History for given PO Line should be implemented
Requirements/Scope:
- Adjust export history functionality in orders-storage to store more required fields connected with export
- Allow user to query orders-storage to get all required fields(Vendor Name, File Name, Export Method, Export Date) for provided PO Line id
Approach:{}
Required changes in mod-orders-storage:
Mod-orders-storage already has REST API and DAO methods to work with this table export_history.
- Need to provide a meachanism to search export history records by order line id.
Need Modify mod-orders-storage to save data into 2 tables:
- Save export history info in already existed table export_history
- Create new table for stroring exportJobId and poLineId and SN: poId pair
- Extract PO Line ids SN: PO Ids from kafka payload and save into new table using batch operation.
Required changes in mod-orders:
Provide new API to call mod-orders-storage to find export history by PO Line Id
Do we need to provide migration scipt: No
Create new complex Karate test in scope of another story
TestRail: Results
Attachments
Issue Links
- clones
-
MODEXPW-240 Populate kafka payload with required fileds for Export History
-
- Closed
-
- defines
-
UXPROD-3498 Allow user to Download or resend EDIFACT order exports
-
- Closed
-
- has to be done before
-
UIOR-884 Re-export order via export
-
- Closed
-
-
UIOR-1034 Use Orders Export History API (mod-orders)
-
- Closed
-
- is cloned by
-
MODAUD-138 Spike: Define schema how to store fields for acquisitions audit logs
-
- Closed
-