When the routing interface downloads order data, the system places a file called ROUT~branch#.RNC in the Eclipse system's msg-out shared folder. The file contains the information listed in the following table for each invoiced sales order generation that is selected.
RouteView might automatically detect files with .RNC extensions in the msg-out folder, or a user might have to manually move the file into the routing software.
If a file with the same name already exists in the msg-out folder, the system overwrites the existing file.
Note: Shipping address changes made on the sales order Header are not communicated in the interface. The system always downloads customer address information from the entity record.
|
Export File Information |
|||
|
Field |
Field Name |
Data Type |
Description |
|
01 |
Bill ID* |
Character |
Bill number must be unique and cannot contain spaces (key field). (Order ID) |
|
02 |
Location ID* |
Character |
Location ID must be unique for each customer. (Customer ID) |
|
03 |
Location Code |
Character |
Location ID extension / suffix |
|
04 |
Location |
Character |
Location name (customer's name) |
|
05 |
Address* |
Character |
Primary ship-to address (physical address) |
|
06 |
Address2 |
Character |
Secondary street address (description of primary address) |
|
07 |
City* |
Character |
Ship-to city |
|
08 |
State* |
Character |
Ship-to state |
|
09 |
Zip* |
Character |
5-digit ship-to postal code (6 digits for Canada) |
|
10 |
Plus4 |
Character |
4-digit postal code extension |
|
11 |
ArrivalDate* |
Character |
Format: MM/DD/YYYY (must include the / delimiters ) |
|
12 |
Shipper |
Character |
Name of the shipper (this field can also be used for a primary telephone number) |
|
13 |
Pieces |
Integer |
Total pieces for each bill (qty on order) |
|
14 |
Weight |
Integer |
Total weight for each bill |
|
15 |
Cube |
Decimal |
Total cube for each bill |
|
16 |
Units |
Decimal |
Relative unit of measurement |
|
17 |
Units2 |
Decimal |
Additional relative unit of measurement |
|
18 |
Domicile* |
Character |
Abbreviation for the terminal handling the deliveries (this must start with an alpha character - usually DC - Distribution Center) |
|
19 |
CargoType |
Character |
Cargo type code (D = Delivery) |
|
20 |
Appointment Time |
Integer |
Appointment time Format = HHMM in military time (no colon) |
|
21 |
Required Time |
Character |
Indicate a request time or time window, such as "B10" or "Before 10" |
|
22 |
Standard Trip ID |
Character |
This field is intentionally left blank. |
|
23 |
Note1 |
Character |
Comment, such as delivery instructions |
|
24 |
Note2 |
Character |
Comment |
|
25 |
Note3 |
Character |
Comment |
* Denotes fields that must contain data.
See Also: