The Contract Stop Import Wizard allows you to import contract route stops directly to an X Route contract, set the schedule for the stops, and specify the assigned route.
...
| Field Name | Description |
|---|---|
| Billing Group | The billing group from the customer form. |
| GroupID | The group folder ID the stop should go to in route planning. |
| RouteID | Route ID to assign the stop to. If left blank the stop will go to unassigned. |
| Sequence | The order in which the stop will show up on the route. This value can be between 0 and 2,147,483,647. |
| OverRideCommissions | Whether or not to override commissions. If left blank, this will default to 0 (No).
|
| Name | Address Name. 50 character limit. |
| Address | The address for the stop. 50 character limit. |
| City | The city for the stop. 50 character limit. |
| State | The state of the stop. 3 character limit |
| Zip | The zip code for the stop. 5 character limit. |
| Plus4 | The plus for of the zip code. 4 character limit. |
| Phone | The contact phone number for the stop has a 50 character limit. |
| Attn | The Attn field has a 50 character limit. |
| LongRemarks | Long remarks for the stop. There is a 200 character limit. |
| ShortRemarks | Short remarks for the stop. There is a 200 character limit. |
| StopType | Specified stop type for the stop. This cannot have a NULL value.
|
| Pieces | The number of pieces on the stop. This cannot have a NULL value. |
| Weight | The total weight of pieces on the stop. If left blank it will default to 1. This cannot have a NULL value. |
| ParcelType | The parcel type ID. |
| Reference1 | References for the stop. There is a 50 character limit. It cannot have a NULL value but can be left blank. |
| Reference2 | |
| RatePerOccurrence | The dollar amount to charge the customer for this stop. |
| SettlementPerOccurrance | The dollar amount to pay the driver for this stop if using a per stop pay method. |
| Notes | Notes for the stop. There is a 2000 character limit. It cannot have a NULL value but can be left blank. |
| StopTimeMin | Min stop time entered in military time (XX:XX). If left blank, it will default to 22:00. ExampleEnter 16:00 for 4:00PM. |
| StopTimeMax | Max stop time entered in military time (XX:XX). If left blank, it will default to 22:00. ExampleEnter 16:00 for 4:00PM. |
| StopTimePreferred | Preferred stop time entered in military time (XX:XX). If left blank, it will default to 22:00. ExampleEnter 16:00 for 4:00PM. |
| ChildOf | The Load To Stop ID if using Stop Chaining. (Downstream) |
| Description | Description for the stop. There is a 250 character limit. It cannot have a NULL value but can be left blank. |
| RateMultiplier | Amount of times to multiply the per stop charge for this stop. This can be a decimal number. |
| Depot | The ID for the depot for the stop. |
| Lat | Latitudinal point for the address. |
| Lon | Longitudinal point for the address. |
| RouteSurchargeAdjustment | The numeric dollar amount of the route surcharge adjustment, or enter 0 for no adjustments. This will default to 0.00 if left blank. |
| CreatedBy | The User ID of the person performing the import. |
| CreatedWhen | The date and time of the import. |
| UpdatedBy | The User ID of the person performing the import if updating contract stops that already exist. |
| UpdatedWhen | The date and time if updating contract stops that already exist. |
| UserField1 | User fields. |
| UserFeild2 | |
| UserField3 | |
| UserFeild4 | |
| UserFeidl5 | |
| UserFeild6 | |
| ParentStopID | The Load From Stop ID if using Stop Chaining. (Upstream) |
| PostActive | Whether or not a post is active. If left blank, the stop will post as "Active" by default.
|
| ETA | This should be left blank/NULL. |
| MinOffSet | Offset for StopTimeMin in days. Example1=1day, 2=2days and so on. use 1 and it will put the StopMintime to the next day |
| MaxOffSet | Offsets for StopTimeMax in days. Example1=1day and it will put the StopmaxTime to the next day. |
| PreferredOffSet | Offsets for StopTimePreferred |
| LoadStop | This will mark a stop as the load stop for the route. This is best left as 0 value and assigned when placed on the route
|
| GlobalLoadStop | Whether or not to mark a stop as a global load stop for the route.
|
| Return Stop | Whether or not to mark a stop as the return stop for the route.
|
| GlobalReturnStop | Whether or not to mark the stop as a global return stop for the route.
|
| XMobileSecondaryLookup | Barcode information for the secondary lookup. There is a 50 charachter limit and this can be NULL or left blank. Example$cxt1234test$ (The barcode prefix and suffix may differ depending on your set up.) |
| CustomerStopID | Reference stop ID. |
| CustomerAccountID | Customer account ID to reference this stop/route/location. |
| IsParent | Whether or not the stop is a parent stop.
|
| ParentStop | The parent stop ID. This parent/child relationship can be used for activating or deactivating posted routes on the dispatch board. If the parent is marked as inactive, any children will also be marked inactive, and if the parent is marked as active, all of the associated children stops will be activated. This is not for route/parcel chaining. Please see ParentStopID and ChildStopID above for route /parcel chaining. |
| Sun | Whether or not to post on the day of the week.
|
| Mon | |
| Tue | |
| Wed | |
| Thu | |
| Fri | |
| Sat | |
| StartDate | The date you would like this stop to begin posting |
| EndDate | The date that you would like this stop to end posting |
Troubleshooting
This error means that there is a required field that was left blank.
This error means that there is a field missing a required value.