HAWB lines can be imported from an XLS file (save as tab delimited TXT file). First register an Import Air Consol. The columns must be in this order:-
Line 1 is a header and data from line 1 is not imported so add a heading or leave empty.
Field | Comments | Col |
HAWB | HAWB number. Mandatory | A |
Customer code | Account code in TW Freight. | B |
Customer Name | Customer name | C |
Customer Address | Customer address | D |
City | Customer city | E |
State | Customer State | F |
Postcode | Customer postcode | G |
Country | Customer country (2 characters, e.g. AU, NZ) | H |
Description of goods | Description of the goods | I |
Count | Number of packages manifested. | J |
Landed | Number of packages landed | K |
Weight | Total weight on this HAWB. | L |
Shipper code | Account code in TW Freight. | M |
Shipper Name | Shipper name | N |
Shipper Address | Shipper address | O |
Shipper City | Shipper city | P |
Shipper State | Shipper state | Q |
Shipper Postcode | Shipper postcode | R |
Shipper Country | Shipper country (2 characters, e.g. AU, NZ) | S |
Origin Port | Origin port. UN port code, e.g. USLAX. Note that this field is not used – the Origin Port from the Consol is used. | T |
Dest Port | Destination port. UN port code, e.g. NZAKL. Note that this field is not used – the Origin Port from the Consol is used. | U |
Total Value | Value of the goods on this HAWB. | V |
Goods currency | Currency for the goods value. E.g. USD | W |
SAC (Y/N) | Is this HAWB a SAC, Y or N. | X |
Reference/Barcode | Any client or shipper reference but for eCommerce, the Barcode. For multiple parcels per HAWB, separate the individual parcels barcodes with a comma(,) - example 1234-1,1234-2. | Y |
SubMaster | If this HAWB is a house master then M, if a sub master then S, otherwise empty. | Z |
Package Type | 2 character package type. E.g. PK, CT | AA |
Country of Origin | Country of origin for the goods (2 characters, e.g. AU, NZ) | AB |
Cyber Vendor Account | Account code in TW Freight. | AC |
Vendor Customs Code | Supplier code as registered with Customs. | AD |
Cyber Importer Account | Account code in TW Freight. For eCommerce, leave empty or same as Customer code above. | AE |
Importer ABN | Importer’s ABN. Not required for SACs. | AF |
Importer CAC | Importer’s ABN. Not required for SACs. | AG |
Cyber Supplier Account | Account code in TW Freight. | AH |
Supplier Customs Code | The Supplier code as registered with Customs. | AI |
If you have multiple parcels per house bill and you cannot get multiple barcodes in the same field, separated by comma, repeat the line with the same details (total KG, packs, M3, etc.) but have the next barcode in the Reference (column Y) field. The logic for loading the manifest is:-
Read line from file.
Does House Bill exist in manifest:-
NO - create new job with details from the line.
YES - get Barcode and add to Reference in existing job.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article