BOL Import with CSV Files

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

  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


Consignee / Destination (To)

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".

Have more questions? Submit a request

0 Comments

Article is closed for comments.