FreightWise supports in addition to our Public API importing BOL's via CSV (*.txt) formats.
The process is that FreightWise parses a request file from the client and creates a response file back for the client to parse. In this exchange, there are two files that are defined in more detail below.
Request File:
Structure
| Group | Position | Name | Req. | Example | Description |
|
Info
|
1 |
Group ID |
Y |
123ABC |
See details below. |
|
2 |
PO Number |
N |
po1234ABCD |
PO Number |
|
|
3 |
SO Number |
N |
so1234ABCD |
SO Number |
|
|
4 |
Ship Date |
Y |
2021-05-02 | Year, Month, and Date that the BOL will ship Formatted as yyyy-mm-dd | |
| 5 | SCAC | N | ABCD | Standard Carrier Alpha Code | |
| 6 | Branch Number | N | 123ABC | Unique identifier in FreightWise | |
| 7 | Direction | Y | See details below | ||
| 8 | Mode | Y | See details below | ||
| 9 | Term | Y | See details below | ||
|
10 |
GL Code | N | |||
|
Shipper / Origin (From)
|
11 |
Org. Name 1 |
Y |
Origin Name | |
|
12 |
Org. Name 2 |
N |
|||
|
13 |
Org. Addr. 1 |
Y |
123 Main St | ||
|
14 |
Org. Addr. 2 |
N |
|||
|
15 |
Org. City |
Y |
Brentwood | ||
|
16 |
Org. State |
Y |
TN | The state in two letters | |
| 17 |
Org. Postal Code |
Y |
37027 | The ZIP or Postal Code | |
| 18 |
Org. Country |
Y |
USA | Country: USA or CAN or MEX | |
|
Consignee / Destination (To)
|
19 |
Dest. Name 1 |
Y |
Destination Name | |
| 20 |
Dest. Name 2 |
N |
|||
| 21 |
Dest. Addr. 1 |
Y |
123 Main St | ||
| 22 |
Dest. Addr. 2 |
N |
|||
| 23 |
Dest. City |
Y |
Brentwood | ||
| 24 |
Dest. State |
Y |
TN | The state in two letter | |
| 25 |
Dest. Postal Code |
Y |
37064 | The ZIP or Postal Code | |
| 26 |
Dest. Country |
Y |
USA | Country: USA or CAN or MEX | |
|
Bill To
|
27 |
Bill To Name 1 |
N |
Bill To Name | |
| 28 |
Bill To Name 2 |
N |
|||
| 29 |
Bill To Addr. 1 |
N |
123 Main St | ||
| 30 |
Bill To Addr. 2 |
N |
|||
| 31 |
Bill To City |
N |
Brentwood | ||
| 32 |
Bill To State |
N |
TN | The state in two letter | |
| 33 |
Bill To Postal Code |
N |
37064 | The ZIP or Postal Code | |
| 34 |
Bill To. Country |
N |
USA | Country: USA or CAN or MEX | |
| Commodity | 35 |
Name |
Y |
Commodity A | Name of the Product |
| 36 |
Description |
N |
Commodity A Description of the Product | Description of the Product | |
| 37 |
NMFC Class |
Y |
65 | Actual Class of the Commodity or Item for the associated line | |
| 38 |
Weight |
Y |
123 | Weight of the Commodity or Item of the associated line | |
| 39 |
Hazmat |
N |
Y |
Y or N (Yes or No) |
|
| 40 |
Part Number |
Y |
1234567 | ||
| 41 |
Qty |
N |
123 | Quantity of the Commodity being shipped on the corresponding line | |
| 42 |
UOM |
N |
Piece or 010 |
Unit of Measure of the Commodity This can be a numeric value or the text |
|
| 43 |
Dim L |
N |
|||
| 44 |
Dim W |
N |
|||
| 45 |
Dim H |
N |
|||
| Accessorial | 46 |
Accessorials |
N |
See details below |
Group ID Details:
The Group ID is used if there are multiple commodities that need to be rated. It allows the system to group multiple lines together so a single BOL can be created with one or more commodities.
Direction
The direction ID designates the direction. The following are the options:
- 1 = Inbound
- 2 = Outbound
- 3 = Third Party
- 5 = Transfer
Mode ID:
The mode id designates if LTL or parcel is the mode to transport on. The following are valid modes:
- 1 = LTL
- 2 = TL
- 18 = Parcel
Term:
The following term IDs are vaild for this import:
- 9 = PPD - PrePaid
- 10 = COL - Collect
- 12 = Third Party
- 13 = PPA - PrePaid & Add
UOM
The Unit of Measure of the Commodity
- 001 - Pallet
- 012 - Piece
- 010 - Box
Accessorials:
If accessorials are needed for quoting then these can be set by "comma" separating ACC-Codes in the field. Example of commonly used codes are:
- RES1 = Residential Delivery
- LG01 = Liftgate Delivery
- ID02 = Inside Delivery
When sending Accessorials and using the Group ID functionality the Accessorial(s) codes should be sent on the first line.
Response File:
| Group | Position | Name | Example | Description |
|
Info |
1 |
BOL # | 351755 | FreightWise BOL Number assigned upon Creation |
|
2 |
Current State | Ready for Manifest | Current State of the BOL at time of Extract | |
|
3 |
Terms | 9 | See Details for ID | |
|
4 |
Carrier | R+L Carriers | Name of Carrier | |
| 5 | SCAC | RLCA | SCAC | |
| 6 | PRO # | A1234567 | Carrier Pro Number | |
| 7 | SO # | 987654 | SO Number | |
| 8 | PO # | HARLOW | PO Number | |
| 9 | Pack # | 61677 | Pack Number | |
|
10 |
Cust # | Customer Number | ||
|
11 |
Est. Cost (incl. MU) | 120.29 | Estimated Cost of BOL including any Markup | |
|
12 |
Direction | 2 | Direction - See Details for ID | |
|
13 |
Branch # | ABC123 | Branch Number stored in FreightWise | |
|
14 |
GL Code | 123ABC | General Ledger Code | |
|
Shipper / Origin (From)
|
15 |
From | Origin Name | |
|
16 |
From City | Peosta | ||
| 17 | From State | IA | The state in two letter | |
| 18 | From Postal Code | 52068 | The ZIP or Postal Code | |
|
|
19 | To | Dest Name | |
| 20 | To City | Grand Rapids | ||
| 21 | To State | MN | The state in two letter | |
| 22 | To Postal Code | 55744 | The ZIP or Postal Code | |
| Dates | 23 | Created At | 2021-05-20 |
Date the BOL was created Format YYYY-MM-DD |
| 24 | Created By | User Name | User that created the BOL | |
| 25 | Updated At | 2021-05-21 |
Date the BOL was updated Format YYYY-MM-DD |
|
| 26 | Updated By | User Name | User that last Updated | |
| State | 27 | State Set At | 2021-05-21 | Date the most recent State for the BOL was created Format YYYY-MM-DD |
| 28 | State Set By | User Name | User that took the action to set the State |
Supported File Formats:
Text CSV:
A text CSV (*.txt) format. This is essentially a text file that uses a "|" (pipe character - ascii code 124) as a delimiter. The line breaks are delimited by a "\n" or "\r" or "\r\n".
0 Comments