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.