Before starting an upload, make sure you have read the information available in the Introduction to TDI and Importing data with TDI articles and followed the guidance provided.
Mandatory file:
Optional file:
- None
Prerequisite:
Customer is required. The recommended sequence should be followed prior to uploading orders.
Important Note: Fields bolded and marked with an asterisk (*) are mandatory.
Filename: order.csv
|
Field |
Description |
Values/codes |
Format/restrictions |
|
Id* |
Unique system ID for the entity. This ID is used anytime you would like to make updates or changes to the order in TDI or when using TDI to associate additional details to the order. If you do not have an existing ID to use in this field, you will need to create one. |
_ |
Important note: ID cannot contain any spaces. |
|
Order.Key* |
The primary key of the order; this key is unique across orders. |
_ |
No character restrictions. |
|
Order.Type |
Identifies the type of order. |
Transportation order: 33095 Warehouse order: 33096 Customer order: 33097 |
Enter the code for the appropriate type of order. |
|
Order.Direction |
Identifies the direction of the order. If the order is of type "Warehouse," the direction must be provided. Otherwise, the direction will be inferred based on whether LSP's location is at the order origin or destination. |
Inbound: 33003 Outbound: 33004 Transfer: 33005 |
Enter the code for the appropriate order direction. |
|
Order.Status |
Identifies the order status. Available statuses vary by order type. |
Enter the code for the appropriate order status. Order status codes are linked in the previous column. |
|
|
Order.Phase |
Identifies the order phase. The phase must be compatible with the status of the order. Phases vary by order type. |
Enter the code for the appropriate order phase. Order phase codes are linked in the previous column. |
|
|
Customer.Key* |
The customer ID for whom the order is created. |
_ |
No character restrictions. |
|
UpdatedBy.Username |
Email ID of the user who created or updated the order. |
_ |
No character restrictions. |
|
Requested.Pickup |
Requested pickup date for order. |
_ |
The date should be YYYY-MM-DD and the time in Coordinated Universal Time, or UTC (Also known as “Zulu time”). A “T” comes between the date and time, and a “Z” follows the time. The time is formatted as HH:MM:SS, using a 24 hour clock. This should correspond to UTC and not local time. Using a timezone calculator is recommended. |
|
Requested.Delivery |
Requested delivery date for order. |
_ | |
|
Planned.Pickup |
The pickup date/time as planned for by the service provider. |
_ | |
|
Planned.Delivery |
The delivery date/time planned for by the service provider. |
_ | |
|
Appointment.Pickup |
The pickup appointment date/time. |
_ | |
|
Appointment.Delivery |
The delivery appointment date/time. |
_ | |
|
Carrier.Key |
The ID of the carrier that is planned to transport the order. |
_ |
No character restrictions. |
|
Pickup.Key |
The custom location ID for the order origin location. |
_ |
No character restrictions. |
|
Destination.Key |
The custom location ID for the order destination location. |
_ |
No character restrictions. |
|
Equipment.Type.Key |
Type of equipment required on the order. |
Enter the code for the appropriate equipment type. Equipment type codes are linked in the previous column. |
|
|
Service.Key |
Type of service required for the order. |
_ |
No character restrictions. |
|
Item.Id* |
Unique Item identifier |
_ |
No character restrictions. Item IDs can be found in the ID column of the item.csv upload sheet. |
|
Item.Master.Item.Key |
Unique custom ID for item. |
_ |
No character restrictions. The item master item key is not in the UI, it is a unique record identifier for TDI purposes. |
|
Non.Item.Master.Item.Name |
Name of the item. |
_ |
No character restrictions. |
|
Item.Quantity |
Quantity of the Item. |
_ |
Only numbers are allowed. |
|
Item.Quantity.Unit |
The unit to be used to measure quantity of the item |
Enter the appropriate unit of measure code. Unit of measure codes are linked in the previous column. |
|
|
Item.Line.No |
Line number of the item. |
_ |
No character restrictions. |
|
Item.Lot.Number |
Lot number of the Item. |
_ |
No character restrictions. |
|
Item.Is.Hazmat |
Defines whether the item is hazardous. |
True/False |
Enter True if the item is hazardous or False if it is not. |
|
Item.Perishable |
Defines whether the item is perishable. |
True/False |
Enter True if the item is perishable or False if it is not. |
|
Item.Stackable |
Defines whether the item is stackable. |
True/False |
Enter True if the item is stackable or False if it is not. |
|
Item.Status |
Line item status. |
Pending Processing Complete |
Enter the line item status, using one of the terms in the previous column. |
|
Item.ActualQuantity |
Actual quantity picked for the line item. |
_ |
Only numbers are allowed. |
|
Item.ActualQuantity.Unit |
Enter the appropriate unit of measure code. Unit of measure codes are linked in the previous column. |
||
|
Item.HandlingQuantity |
Number of handling units for the item. |
_ |
No character restrictions. |
|
Item.HandlingQuantity.Unit |
Unit of measure that describes how the items are packaged for transport. |
_ |
No character restrictions. |
| Item.Temp.Min | Minimum allowable temperature for the item. |
_ |
No character restrictions. |
| Item.Temp.Max | Maximum allowable temperature for the item. |
_ |
No character restrictions. |
|
Costs.Type.Key |
Type of cost associated with the order. |
Use the table linked in the previous column. Find and enter the cost type’s code. |
|
|
Cost.Item.Qty |
Number of units of the cost line item. |
_ |
No character restrictions. |
|
Costs.Item.Price |
Price per unit of cost line item. |
_ |
No character restrictions. |
|
Costs.Line.Amount |
In the cost block, the quantity of cost units. |
_ |
No character restrictions. |
|
Costs.Item.Billable |
Identifies whether or not the costs item is billable. |
True/False |
Enter True if the costs item is billable or False if it is not. |
|
External.Id.Customer.PO.No |
External ID - Customer’s Purchase Order (PO) number. |
_ |
No character restrictions. |
|
External.Id.Reference.No |
External ID - Reference Number. |
_ |
No character restrictions. |
|
External.Id.BOL.No |
External ID - BOL Number. |
_ |
No character restrictions. |
|
External.Id.Scac.No |
External ID - SCAC Number. |
_ |
No character restrictions. |
|
External.Id.Route.No |
External ID - Route Number. |
_ |
No character restrictions. |
|
External.Id.PRO.No |
External ID - progressive number. |
_ |
No character restrictions. |
|
External.Id.Tracking.No |
External ID - Tracking Number. |
_ |
No character restrictions. |
|
External.Id.Container.No |
External ID - Container Number. |
_ |
No character restrictions. |
|
External.Id.Order.No |
External ID - Order Number. |
_ |
No character restrictions. |
|
External.Id.Batch.Invoice.No |
External ID - batch invoice number. |
_ |
No character restrictions. |
|
External.Id.Sales.Order.No |
External ID - sales order number. |
_ |
No character restrictions. |
|
External.Id.Warehouse.Order.No |
External ID - warehouse order number. |
_ |
No character restrictions. |
|
External.Id.Service_Order.No |
External ID - Service order number. |
_ |
No character restrictions. |
|
External.Id.Other.No |
External ID - other number. |
_ |
No character restrictions. |
<%= heading %>