Order & Shipment file Processing

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