...
| Gliffy |
|---|
| |
|---|
| name | External Fulfillment Process |
|---|
|
Order file
Order File format
| Fields | Labels |
|---|
| Order Number | Order Number |
| Facility Code | Facility Code |
| Product Code | Product Code |
| Quantity Ordered | Quantity Ordered |
| Pack Size | Pack Size |
Order file Name
Order file is generate with name ‘O’ + order number.csv
Validations
- One order file generated per Requisition
- Quantity Ordered = Packs to ship
- Any product with Quantity Ordered as zero is excluded from the file
- If Quantity Ordered for all product in an order is zero no file is generated
Still to play
- Genarting order file and placing it on configured FTP server
- Logic to place file as per supplying depot
Shipment file
Shipment File format
| Fields | Labels | Mandatory? |
|---|
| Order Number | Order Number | Y |
| Product Code | Product Code | Y |
| Quantity Shipped | Quantity Shipped | Y |
Shipment file Name
Any file with .csv extension is Picked up for processing from configured folder
Validations
- One Shipment file can accept multiple orders
- If any order has error, complete file is errored out
- Any other columns in shipment file are ignored
- Mandatory fields required for success processing
- Valid Order number, Product code is checked
- Quantity Shipped – If decimal,is trimmed to Integer and accepted
- File with duplicate entry of order number and product code combination – Accept the last entry
Architecture and User flow
