Warehouse Order Document Format

Modified on Wed, 01 Mar 2017 at 11:03 AM

This solution outlines the list of common fields used in simple warehouse order integration. This is not a complete list of possible values, but instead is used for ideals when creating a document format to use with our simple order integration.

Techdinamics support different file format including flat file, XML, Excel, CSV, EDI. The list bellow does not describe the file format but identifies require fields.

Header

Order Number	Required	Unique identifier for the warehouse order. Could be your sales order number, delivery or any other unique reference
Order Date	Recommended	Date of the order. If not provided todays date, when the order was receive, will be used.
Purchase Order	Optional	Secondary reference, often use for purchase order or customer reference
Carrier Code, Service level	Recommended	This could be one or two fields. Code specifying the carrier to use, could include the service level in the same value.
Shipment Method of Payment	Optional	Specifies who pays for the shipment. Most common options are collect or prepaid
Requested Ship Date	Recommended	Date specifying when to ship the order
Requested Delivery Date	Optional	Date specifying when the order needs to be delivered to the destination.
Contact Information (Name, Phone, Email)	Optional	Person to contact in case of problem. Please include the phone number of email as well as additional fields.
Ship-To Address (Name, Address1, Address2, City, Province, Postal, Country)	Required	Address where the order needs to be shipped. We need to have different fields for Name, Address1, Address2, City, Province, Postal, Country
Bill-To Address (Name, Address1, Address2, City, Province, Postal, Country)	Optional	Address where the order needs to be billing. We need to have different fields for Name, Address1, Address2, City, Province, Postal, Country
References	Optional	Combination of pairs qualifier and value.

Details

Line Number	Recommended	Unique line identifier. Import to pass if you ever can have same SKU on repeated on multiple lines. Also required if you need to pass the line number back
Production Identification	Required	One or more product identifiers are support. Often used product identifiers include: SKU, UPC
Lot	Optional	Product lot number
Quantity	Required	Quantity to ship
Unit of Measure	Recommended	Default is Each
References	Optional	Combination of pairs qualifier and value.