ebilling solutions - dhl express canada v4 - loomis … solutions... · we've made changes...

28
September 2, 2008 Version 4.2

Upload: duongtu

Post on 04-May-2018

219 views

Category:

Documents


5 download

TRANSCRIPT

Page 1: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

September 2, 2008 Version 4.2

Page 2: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

What's New? -New E-bill formats includ-New layout for E-billing -No time to download? De What's the same NO MORE PAPER E-billing is a hassle free THE POWER OF CHOICE-billing is now availableYou can also choose to r NO MORE WAITING FOThe invoices you receive

By signing up for E-Billin VIEW INVOICES ONLINOur Delimited Text File omorning by 10:00am East 7 days a week. DETAILED INFORMATNeed to know the exact binformation of every char SIMPLE AND FLEXIBLDelimited Text E-Billing fWe offer a 10-Step impor

WE'VE MADE CHANGES

ing E-bill Express. to reflect more detailed information limited files can be now emailed and sent via FTP*

?

way to view your DHL Express Canada invoices.

E in 2 formats: Delimited Text and Adobe Acrobat PDF format. eceive all formats via e-mail.

R THE MAIL in the mail can be sent to you via e-mail in PDF format.

g, you can help the environment by reducing the use of paper.

E ANY TIME r PDF version of your invoice is uploaded to www.dhl.ca every Monday ern Standard Time. Once they are up, they stay up; available 24 hours a day

ION reakdown of each charge? E-billing is a powerful tool that gives detailed ge for every shipping transaction.

E FORMAT iles are flexible and easy to import into most database systems. ting tutorial for Excel users not familiar with text files.

ii

Page 3: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

TABLE OF CONTENTS

4 . F R E Q U E N T L Y A S K E D Q U E S T I O N S 6 . E - B I L L S T A N D A R D L A Y O U T A N D D E S C R I P T I O N 1 1 . E - B I L L E X P R E S S L A Y O U T A N D D E S C R I P T I O N 1 4 . E - I M A G E L A Y O U T A N D D E S C R I P T I O N 1 7 . E D I L A Y O U T A N D D E S C R I P T I O N 2 3 . A P P E N D I X 2 8 . D H L E x p r e s s E - B i l l R e q u e s t F o r m

iii

Page 4: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

FREQUENTLY ASKED QUESTIONS

What's New? The Standard Delimited Text File (E-Bill Standard) has expanded from 90 columns to 120. This expansion was done to reflect DHL's latest services and to display an even more comprehensive breakdown of DHL charges and information. DHL now introduces E-Bill Express. This version of the Delimited Text File is a simplified version of the Standard E-Bill. This version is recommended for users who do not require the detailed breakdown of all DHL charges. Plus, it’s more printer-friendly. You can now receive your Delimited Text E-Bills via e-mail & FTP, both E-Bill Standard and E-Bill Express. How Many Types of E-Bills Are There? There are 4 types of E-Billing: Standard: The Delimited Text Flat File Express: The Simplified Delimited Text File E-Image: An exact image of the paper invoice in Adobe Acrobat PDF format EDI 110: ANSI ASC X12 Industry Standard Air Freight Details and Invoice How Can I Receive My E-Billing? E-Bills can be delivered via Email, the DHL.CA website and FTP depending on which type of E-Billing service you have. See the below chart to see which E-Bill service does what.

4

Page 5: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

FREQUENTLY ASKED QUESTIONS (continued)

Which Is Best For Me? Standard, Express, Image or EDI? We recommend E-Image or E-Bill Express for customers who do not ship high volumes and want a simple to read and itemized list of weekly transactions. E-Bill Standard is recommended for those who require a complete and comprehensive cost breakdown of each shipment, or users who need to simply import the invoice data into a database. (E-Bill Express can also be imported into any database like Excel.) EDI is recommended for those who already have the infrastructure in place to receive EDI. I Want To Be Set Up On E-Billing! How Long Does It Take?Please allow up to 10 business days for an E-bill set up to be completed. You will be notified of its completion via email. When Can I Access My E-Bills? When Do New E-Bills Become Available? For users who signed up for E-Bill Standard/Express or E-Image through the web, you can view the invoices at any time. Every Monday morning at 10:00am a new E-Bill file is posted to the www.dhl.ca website. E-mails arrive in your inbox first thing Monday morning. I Was Just Set Up On E-Billing, But I Would Like To View Invoices From Several Months Previous. Is There Any Way To Get Older Invoices Reposted Or Resent To Me? Yes. Notify your DHL Sales Representative regarding which invoices you require and the request will be fulfilled. Average turnaround time for receiving past invoices is 1 week. For users who get their E-bills via email, all the historical invoices will be emailed to you one at a time. Can I Use E-Billing If I’m Doing All My Shipping with Handwritten Waybills? Yes. Webship, Handwritten, Easyship, 3rd Party Shipping Platforms: E-Billing supports all these shipping interfaces and more. Will My Reference Numbers and Cost Centres Be In the E-Bill File? E-Bill Standard and Express will capture all your Reference Numbers and Cost Centres for Domestic or Outbound Canadian shipments. For Import Express, please talk to your DHL Sales Representative. The PDF version captures Reference Numbers, but NOT Cost Centres. Will E-Billing Show International/US Shipments? Yes. Is E-Billing a Summary Invoice or Does It Show Each Shipment? E-Billing breaks down all transactions to the shipment level. With the E-Image version of E-Billing, you get both a summary and a detailed breakdown. I Need To See Every Charge Separated And Broken Down. Does E-Billing Show the Breakdown of Each Charge? Yes. Please see the Appendix on page 23 to see the list of all charge breakdowns and DHL Service Codes.

5

Page 6: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

E-BILL STANDARD

E-Bill Standard is DHL’s most comprehensive invoice structure to date. Featuring 109 columns o r auditors and customers

In the following pages you will find the layout and description of E-Bill Standard.

f invoicing information, E-Bill Standard is ideal fowho require highly detailed information.

E-BILL STANDARD

E-Bill Standard is DHL’s most comprehensive invoice structure to date. Featuring 109 columns of invoicing information, E-Bill Standard is ideal for auditors and

Customers who require highly detailed information. In the following pages you will find the layout and description of E-Bill Standard.

6

Page 7: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

E-BILL STANDARD DELIMITED FILE LAYOUT

Field # Type Length Start End Description Comment

1 A 9 1 9 DHL Account Number DHL Account Number 2 A 1 10 10 Comma 3 A 25 11 35 Customer Name Billing Customer Name 4 A 1 36 36 Comma 5 A 25 37 61 Address 1 Billing Customer Address 6 A 1 62 62 Comma 7 A 25 63 87 City Billing Customer City Name 8 A 1 88 88 Comma 9 A 2 89 90 Province Code Billing Customer Province Code

10 A 1 91 91 Comma 11 A 10 92 101 Postal Code Billing Customer Postal Code 12 A 1 102 102 Comma 13 A 8 103 110 Invoice # Billing Customer Invoice Number 14 A 1 111 111 Comma 15 A 6 112 117 Invoice Line # Billing Customer Invoice Line Number 16 A 1 118 118 Comma 17 A 8 119 126 Invoice Date Billing Customer Invoice Date (yyyymmdd) 18 A 1 127 127 Comma 19 N 13 128 140 Invoice Charge Total Invoice Charge Less Tax 20 A 1 141 141 Comma 21 N 13 142 154 Invoice PST Total Invoice Provincial Sales Tax 22 A 1 155 155 Comma 23 N 13 156 168 Invoice HST Total Invoice Harmonized Sales Tax 24 A 1 169 169 Comma 25 N 13 170 182 Invoice GST Total Invoice Goods & Services Tax 26 A 1 183 183 Comma 27 N 13 184 196 Invoice Total Total Invoice Charge Including Tax 28 A 1 197 197 Comma 29 A 12 198 209 Waybill # Individual DHL Waybill Number 30 A 1 210 210 Comma 31 A 30 211 240 Customer Reference Customer Reference Number 32 A 1 241 241 Comma 33 A 2 242 243 Service Code DHL Service Code – See Appendix - A 34 A 1 244 244 Comma 35 A 2 245 246 Product Code DHL Product Code – See Appendix - C 36 A 1 247 247 Comma 37 A 2 248 249 Service Downgrade DHL Service Code – See Appendix - A 38 A 1 250 250 Comma 39 A 2 251 252 Product Downgrade DHL Product Code – See Appendix - C 40 A 1 253 253 Comma 41 A 1 254 254 Prepaid or Collect Payment Type – P or C 42 A 1 255 255 Comma 43 N 7 256 262 Customer Declared Weight Shipment Weight, Declared by Customer 44 A 1 263 263 Comma 45 A 1 264 264 Declared & Cube Weight UOM Shipment UOM Declared by Customer (I=Imperial or M=Metric) 46 A 1 265 265 Comma 47 A 7 266 272 Customer Dimension Length Shipment Length Declared by Customer (Always in Inches) 48 A 1 273 273 Comma 49 A 7 274 280 Customer Dimension Width Shipment Width Declared by Customer (Always in Inches) 50 A 1 281 281 Comma 51 A 7 282 288 Customer Dimension Height Shipment Height Declared by Customer (Always in Inches) 52 A 1 289 289 Comma 53 N 7 290 296 Customer Cubed Weight Shipment Cubed Weight Declared by Customer 54 A 1 297 297 Comma 55 A 8 298 305 DHL Dimension Height Shipment Height Measured by DHL (Always in Inches) 56 A 1 306 306 Comma

7

Page 8: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

Field # Type Length Start End Description Comment 57 A 8 307 314 DHL Dimension Length Shipment Length Measured by DHL (Always in Inches) 58 A 1 315 315 Comma 59 A 8 316 323 DHL Dimension Width Shipment Width Measured by DHL (Always in Inches) 60 A 1 324 324 Comma 61 N 7 325 331 DHL Cubed Weight Shipment Cubed Weight Measured by DHL 62 A 1 332 332 Comma 63 N 7 333 339 DHL Re-Weigh Weight Shipment Re-Weigh Weight 64 A 1 340 340 Comma 65 N 7 341 347 Weight for pricing Final Weight for Pricing 66 A 1 348 348 Comma 67 A 1 349 349 UOM for Invoicing UOM for Invoicing 68 A 1 350 350 Comma 69 N 4 351 354 Number of Pieces Total Pieces in the Waybill 70 A 1 355 355 Comma 71 A 3 356 358 Billing Currency Type of Billing Currency – CAD or USD 72 A 1 359 359 Comma 73 N 13 360 372 Waybill Invoiced Charge Individual Waybill Charge Less Tax 74 A 1 373 373 Comma 75 N 13 374 386 Liability Charge Insurance Charge 76 A 1 387 387 Comma 77 N 13 388 400 Waybill GST Amount Individual Waybill Goods & Services Tax (GST) Charge 78 A 1 401 401 Comma 79 13 402 414 Waybill HST Amount Individual Waybill Harmonized Sales Tax (HST) Charge 80 A 1 415 415 Comma 81 A 13 416 428 Waybill PST Amount Individual Waybill Provincial Sales Tax (PST) Charge 82 A 1 429 429 Comma 83 A 2 430 431 PST Province Code PST Province Code 84 A 1 432 432 Comma 85 N 13 433 445 Waybill Total Charge Individual Waybill Charge Including Tax 86 A 1 446 446 Comma 87 A 40 447 486 Shipper name Pickup Customer Name 88 A 1 487 487 Comma 89 A 30 488 517 Shipper Address 1 Pickup Customer Address 90 A 1 518 518 Comma 91 A 20 519 538 Shipper City Pickup Customer City Name 92 A 1 539 539 Comma 93 A 2 540 541 Shipper Province Pickup Customer Province Code 94 A 1 542 542 Comma 95 A 10 543 552 Shipper Postal Code Pickup Customer Postal Code 96 A 1 553 553 Comma 97 A 3 554 556 Shipper Country Pickup Customer Country Code 98 A 1 557 557 Comma 99 A 3 558 560 From IATA Code Origin IATA/Airport Code

100 A 1 561 561 Comma 101 A 3 562 564 From Zone Origin Pricing Zone Code 102 A 1 565 565 Comma 103 A 8 566 573 Pickup Date Shipment Pickup Date (yyyymmdd) 104 A 1 574 574 Comma 105 A 40 575 614 Receiver name Destination Customer Name 106 A 1 615 615 Comma 107 A 30 616 645 Receiver Address 1 Destination Customer Address 108 A 1 646 646 Comma 109 A 20 647 666 Receiver City Destination Customer City Name 110 A 1 667 667 Comma 111 A 2 668 669 Receiver Province Destination Customer Province Code 112 A 1 670 670 Comma 113 A 10 671 680 Receiver Postal Code Destination Customer Postal Code

8

Page 9: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

9

Field # Type Length Start End Description Comment 114 A 1 681 681 Comma 115 A 3 682 684 Delivery Country Destination Customer Country Code 116 A 1 685 685 Comma 117 A 3 686 688 To IATA Code Destination IATA/Airport Code 118 A 1 689 689 Comma 119 A 3 690 692 To Zone Destination Pricing Zone Code 120 A 1 693 693 Comma 121 A 8 694 701 Delivery date Shipment Delivery Date (yyyymmdd) 122 A 1 702 702 Comma 123 A 4 703 706 Delivery time Shipment Delivery Time (hhmmss) 124 A 1 707 707 Comma 125 A 30 708 747 Received By Shipment Receiver Name at Destination 126 A 1 748 748 Comma 127 A 2 749 750 Charge type AF AF – Air Fuel Surcharge 128 A 1 751 751 Comma 129 N 13 752 764 Invoiced Charge AF Invoiced AF Surcharge Amount 130 A 1 765 765 Comma 131 N 2 766 767 Charge type CO CO – Collect Surcharge 132 A 1 768 768 Comma 133 N 13 769 781 Invoiced Charge CO Invoiced CO Surcharge Amount 134 A 1 782 782 Comma 135 N 2 783 784 Charge type DG DG – Dangerous Goods Surcharge 136 A 1 785 785 Comma 137 N 13 786 798 Invoiced Charge DG Invoiced DG Surcharge Amount 138 A 1 799 799 Comma 139 N 2 800 801 Charge type FR FR – Fragile Surcharge 140 A 1 802 802 Comma 141 N 13 803 815 Invoiced Charge FR Invoiced FR Surcharge Amount 142 A 1 816 816 Comma 143 N 2 817 818 Charge type GF GF – Ground Fuel Surcharge 144 A 1 819 819 Comma 145 N 13 820 832 Invoiced Charge GF Invoiced GF Surcharge Amount 146 A 1 833 833 Comma 147 N 2 834 835 Charge type OV/RP/NP OV –Over Sized, RP – Re Pack, NP – Non Pack Surcharge 148 A 1 836 836 Comma 149 N 13 837 849 Invoiced Charge OV/NP/RP Invoiced OV/NP/RP Surcharge Amount 150 A 1 850 850 Comma 151 N 2 851 852 Charge type MA MA – Missing Account Fee Surcharge 152 A 1 853 853 Comma 153 N 13 854 866 Invoiced Charge MA Invoiced MA Surcharge Amount 154 A 1 867 867 Comma 155 N 2 868 869 Charge type IA IA – Invalid Account Fee Surcharge 156 A 1 870 870 Comma 157 N 13 871 883 Invoiced Charge IA Invoiced IA Surcharge Amount 158 A 1 884 884 Comma 159 N 2 885 886 Charge type NV NV – NAV Canada Surcharge 160 A 1 887 887 Comma 161 N 13 888 900 Invoiced Charge NV Invoiced NA Surcharge Amount 162 A 1 901 901 Comma 163 N 2 902 903 Charge type R R – Residential Surcharge 164 A 1 904 904 Comma 165 N 13 905 917 Invoiced Charge R Invoiced R Surcharge Amount 166 A 1 918 918 Comma 167 N 2 919 920 Charge type RC RC – Return Cheque Surcharge 168 A 1 921 921 Comma 169 N 13 922 934 Invoiced Charge RC Invoiced RC Surcharge Amount

Page 10: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

Field # Type Length Start End Description Comment 170 A 1 935 935 Comma 171 N 2 936 937 Charge type AI AI – Aviation Insurance Surcharge 172 A 1 938 938 Comma 173 N 13 939 951 Invoiced Charge AI Invoiced AI Surcharge Amount 174 A 1 952 952 Comma 175 N 2 953 954 Charge type SD SD – Saturday Delivery Surcharge 176 A 1 955 955 Comma 177 N 13 956 968 Invoiced Charge SD Invoiced SD Surcharge Amount 178 A 1 969 969 Comma 179 N 2 970 971 Charge type SS SS – Security Shipment Surcharge (Chain of Signature) 180 A 1 972 972 Comma 181 N 13 973 985 Invoiced Charge SS Invoiced SS Surcharge Amount 182 A 1 986 986 Comma 183 N 2 987 988 Charge type NR NR – E-Return Unable to Pickup Surcharge 184 A 1 989 989 Comma 185 N 13 990 1002 Invoiced Charge NR Invoiced NR Surcharge Amount 186 A 1 1003 1003 Comma 187 N 2 1004 1005 Charge type XN XN – Other Surcharge 188 A 1 1006 1006 Comma 189 N 13 1007 1019 Invoiced Charge XN Invoiced XN Surcharge Amount 190 A 1 1020 1020 Comma 191 N 2 1021 1022 Charge type XY XY – Duties & Taxes 192 A 1 1023 1023 Comma 193 N 13 1024 1036 Invoiced Charge XY Invoiced XY Surcharge Amount 194 A 1 1037 1037 Comma 195 N 2 1038 1039 Charge Type IF IF – International Fuel Surcharge 196 A 1 1040 1040 Comma 197 N 13 1041 1053 Invoiced Charge IF Invoiced IF Surcharge Amount 198 A 1 1054 1054 Comma 199 N 2 1055 1056 Change Type RU/RA RU – Rural Area US, RA – Rural Area International Surcharge 200 A 1 1057 1057 Comma 201 N 13 1058 1070 Invoiced Charge RU/RA Invoiced RU/RA Surcharge Amount 202 A 1 1071 1071 Comma 203 A 2 1072 1073 Weight Used for Pricing Weight Used for Pricing – See the Legend at Appendix H 204 A 1 1074 1074 Comma 205 N 3 1075 1077 Invoice Sequence Invoice Sequence Number 206 A 1 1078 1078 Comma 207 A 30 1079 1108 Cost Centre Cost Centre 208 A 1 1109 1109 Comma 209 N 13 1110 1122 Beyond / Interline Charge Beyond / Interline Charge Amount (Note: Information Only) 210 A 1 1123 1123 Comma 211 N 9 1124 1132 Quote Number Quote Number 212 A 1 1133 1133 Comma 213 N 3 1134 1136 Quote Version Quote Version 214 A 1 1137 1137 Comma 215 A 3 1138 1140 Invoice Type Invoice Type – See the Legend at Appendix B 216 A 1 1141 1141 Comma 217 A 7 1142 1148 Internal Account Number Internal Billing Customer Number

10

Page 11: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

E-BILL EXPRESS

E-Bill Express is DHL’s latest invoice solution for customers who do not require intensive cost breakdowns. Featuring 42 columns,

E-Bill Express gives you the basics of your shipping transactions.

11

Page 12: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

Field # Type Length Start End Description Comment 1 A 9 1 9 DHL Account Number Billing Customer Number 2 A 1 10 10 Comma 3 A 8 11 18 Invoice # Billing Customer Invoice Number 4 A 1 19 19 Comma 5 A 6 20 25 Invoice Line # Billing Customer Invoice Line Number 6 A 1 26 26 Comma 7 A 8 27 34 Invoice Date Billing Customer Invoice Date 8 A 1 35 35 Comma 9 N 13 36 48 Invoice Charge Billing Customer Invoice Charge Less Tax

10 A 1 49 49 Comma 11 N 13 50 62 Invoice PST Total Invoice Provincial Sales Tax 12 A 1 63 63 Comma 13 N 13 64 76 Invoice HST Total Invoice Harmonized Sales Tax 14 A 1 77 77 Comma 15 N 13 78 90 Invoice GST Total Invoice Goods & Services Tax 16 A 1 91 91 Comma 17 N 13 92 104 Invoice Total Total Invoice Charge Including Tax 18 A 1 105 105 Comma 19 A 12 106 117 Waybill # Individual DHL Waybill Number 20 A 1 118 118 Comma 21 A 30 119 148 Customer Reference Customer Reference Number 22 A 1 149 149 Comma 23 A 2 150 151 Service Code DHL Service Code – See Appendix - A 24 A 1 152 152 Comma 25 A 1 153 153 Prepaid or Collect Payment Type – P or C 26 A 1 154 154 Comma 27 N 7 155 161 Weight for pricing Shipment Final Weight for Pricing 28 A 1 162 162 Comma 29 A 1 163 163 UOM for Invoicing Unit of Measurement – I = Imperial (Pounds) or M = Metric (Kilos) 30 A 1 164 164 Comma 31 N 4 165 168 Number of Pieces Total Pieces in the Waybill 32 A 1 169 169 Comma 33 A 3 170 172 Billing Currency Type of Billing Currency – CAD or USD 34 A 1 173 173 Comma 35 N 13 174 186 Waybill Invoiced Charge Individual Waybill Charge Less Tax 36 A 1 187 187 Comma 37 N 13 188 200 Total "other" charges Total Other Charges in a Waybill 38 A 1 201 201 Comma 39 N 13 202 214 Waybill GST Amount Individual Waybill Goods & Services Tax (GST) Charge 40 A 1 215 215 Comma 41 N 13 216 228 Waybill HST Amount Individual Waybill Harmonized Tax (HST) Charge 42 A 1 229 229 Comma 43 N 13 230 242 Waybill PST Amount Individual Waybill Provincial Sales Tax (PST) Charge 44 A 1 243 243 Comma 45 A 2 244 245 PST Province Code PST Province Code 46 A 1 246 246 Comma 47 N 13 247 259 Waybill Total Charge Individual Waybill Charge Including Tax 48 A 1 260 260 Comma 49 A 40 261 300 Shipper name Pickup Customer Name 50 A 1 301 301 Comma 51 A 20 302 321 Shipper City Pickup Customer City Name 52 A 1 322 322 Comma 53 A 2 323 324 Shipper Province Pickup Customer Province Code

E-BILL EXPRESS DELIMITED FILE LAYOUT

12

Page 13: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

Field # Type Length Start End Description Comment 54 A 1 325 325 Comma 55 A 10 326 335 Shipper Postal Code Pickup Customer Postal Code Number 56 A 1 336 336 Comma 57 A 3 337 339 Shipper Country Pickup Customer Country Code 58 A 1 340 340 Comma 59 A 8 341 348 Pickup Date Shipment Pickup Date (yyyymmdd) 60 A 1 349 349 Comma 61 A 40 350 389 Receiver name Destination Customer Name 62 A 1 390 390 Comma 63 A 20 391 410 Receiver City Destination Customer City Name 64 A 1 411 411 Comma 65 A 2 412 413 Receiver Province Destination Customer Province Code 66 A 1 414 414 Comma 67 A 10 415 424 Receiver Postal Code Destination Customer Postal Code 68 A 1 425 425 Comma 69 A 3 426 428 Delivery Country Destination Customer Country Code 70 A 1 429 429 Comma 71 A 8 430 437 Delivery date Shipment Delivery Date (yyyymmdd) 72 A 1 438 438 Comma 73 A 4 439 442 Delivery time Shipment Delivery Time (hhmmss) 74 A 1 443 443 Comma 75 A 40 444 483 Received By Shipment Receiver Name at Destination 76 A 1 484 484 Comma 77 A 3 485 487 Billing Sequence Billing Sequence Number 78 A 1 488 488 Comma 79 A 30 489 518 Cost Center Cost Centre 80 A 1 519 519 Comma 81 A 3 520 522 Invoice Type Invoice Type – See Appendix - B 82 A 1 523 523 Comma 83 A 7 524 530 Internal Account Number Billing Customer Internal Account Number

13

Page 14: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

E-IMAGE

We have become environmentally conscious and now strive towards greener solutions.

One solution is to reduce the use of paper products.

E-Image is an exact scanned copy of the paper invoice that is emailed to you. E-Image is recommended for users who prefer the layout of a tradit ional

paper invoice over the delimited layout of E-Bil l Standard, and E-Bil l Express.

E-Images are emailed to you by 10:00am EST Monday. You will need Adobe Acrobat Reader (4.0 and up) in order to view E-Images.

14

Page 15: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

15

Page 16: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

16

Page 17: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

EDI INVOICING

EDI (Electronic Data Interchange) is one of the oldest and most effective ways of sending and receiving electronic data.

The X12 EDI 110 document is an internationally agreed upon data format

for air and ground freight transport invoicing information. This format has been in use for freight, transport and logistics information for over 35 years.

If you are a customer that uses a third party auditor, the auditor

most likely would require the EDI 110 format.

To keep costs down for both you and DHL Canada, we prefer to FTP the 110 documents directly to you. Please contact DHL Canada’s EDI Department for the 110 Specification.

17

Page 18: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

Header Information ST Transaction Set Header Segment Identifier ST ST01Transaction Set Identifier 110 ID 3 3 M Transaction id. Non modifiable ST02Transaction Set Control Num *CNTL# AN 4 9 M Non modifiable B3 Beginning Segment for Carrier Invoice Segment Identifier B3 B302 Invoice Number AN 1 22 B304 Shipment Method of Payment ID 2 2 MX = Mixed B306 Date DT 8 8 Billing/Invoice date B307 Net Amount Due N2 1 12 Invoice total (Including Tax) B311 Standard Carrier Alpha Code ID 2 4 DHLD B3A Invoice Type Segment Identifier B3A B3A01 Transaction Type Code MM ID 2 2 MM = Multiple Shipper, Multiple Consignees B3A02 Number of Shipments N0 1 5 # of Waybills included in the

Invoice

C3 Currency Segment Identifier C3 C301 Currency Code ID 3 3 CAD = Canadian Dollars USD = US Dollars N1 Name Segment Identifier N1 N101 Entity Identifier Code BT ID 2 3 BT = Bill to Party N102 Name AN 1 60 Customer Name N103 Identification Code Qualifier 25 ID 1 2 25 = Carrier’s Customer Code N104 Identification Code AN 2 80 Billing Customer # N3 Address Information Segment Identifier N3 N301 Address Information AN 1 55 Bill to Address Line 1 N302 Address Information AN 1 55 Bill to Address Line 2 N4 Geographic Location Segment Identifier N4 N401 City Name AN 2 30 Bill to City N402 State or Province Code ID 2 2 Bill to Province/State Code N403 Postal Code ID 3 15 Bill to Postal Code/Zip Code N404 Country Code ID 2 3 Bill to Country Code

Detail Information about each Waybill LX Assigned Number Segment Identifier LX LX01 Assigned Number N0 1 6 Detail Line# N1 Name Segment Identifier N1 N101 Entity Identifier Code SH ID 2 3 SH = Shipper/Pickup N102 Name AN 1 60 Shipper Name N103 Identification Code Qualifier 25 ID 1 2 25 = Carrier’s Customer Code N104 Identification Code AN 2 80 Shipper DHL Acct# (Billing Cust #) if applicable

ED1 110 LAYOUT

18

Page 19: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

19

N3 Address Information Segment Identifier N3 N301 Address Information AN 1 55 Shipper Address Line 1 N302 Address Information AN 1 55 Shipper Address Line 2 N4 Geographic Location Segment Identifier N4 N401 City Name AN 2 30 Shipper City N402 State or Province Code ID 2 2 Shipper Province/State Code N403 Postal Code ID 3 15 Shipper Postal Code/Zip Code N404 Country Code ID 2 3 Shipper Country Code N405 Location Qualifier ZN ID 1 2 ZN = Zone Code N406 Location Identifier AN 1 30 Origin Pricing Zone

Waybill information N9 Reference Identification Segment Identifier N9 N901 Reference Id. Qualifier AW ID 2 3 AW = Waybill N902 Reference Identification AN 1 30 DHL Waybill Number N9 Reference Identification Segment Identifier N9 N901 Reference Id. Qualifier IT ID 2 3 IT = Internal Customer Number N902 Reference Identification AN 1 3 DHL International Customer ID N9 Reference Identification Segment Identifier N9 N901 Reference Id. Qualifier CR ID 2 3 CR = Customer’s Reference N902 Reference Identification AN 1 3 Reference Number N9 Reference Identification Segment Identifier N9 N901 Reference Id. Qualifier CA ID 2 3 CA = Cost Allocation Reference N902 Reference Identification AN 1 30 Cost Centre Code N1 Name Segment Identifier N1 N101 Entity Identifier Code CN ID 2 3 CN = Consignee N102 Name AN 1 60 Receiver Company Name N3 Address Information Segment Identifier N3 N301 Address Information AN 1 55 Consignee Address Line 1 N302 Address Information AN 1 55 Consignee Address Line 2 N4 Geographic Location Segment Identifier N4 N401 City Name AN 2 30 Receiver City N402 State or Province Code ID 2 2 Receiver Province N403 Postal Code ID 3 15 Receiver Postal Code/Zip code N404 Country Code ID 2 3 Receiver Country Code N405 Location Qualifier ZN ID 1 2 ZN = Zone Code N406 Location Identifier AN 1 30 Destination Pricing Zone

Page 20: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

20

Other information about the waybill P1 Pickup Information P101 Pick-up or Delivery Code SD ID 1 2 SD = Shipper’s door P102 Pick-up Date DT 8 8 Date picked up at shipper’s address P103 Date/Time Qualifier 118 ID 3 3 118 = Requested Pick-up P104 Pick-up Time TM 4 4 Time picked up at shipper’s address R1 Route Information (Air) R103 Airport Code ID 3 5 Origin Airport (IATA) Code R104 Air Carrier Code ID 3 3 DHL R105 Airport Code ID 3 5 Destination Airport (IATA) Code L5 Description, Marks and Numbers L501 Lading Line Item Number N0 1 3 Invoice Sequence Number L502 Lading Description AN 1 50 Invoice Type: ADJ = BALANCE ADJUSTMENT HPR = HAND-PRICED INVOICE I = INCREMENTAL IBS = IBS-CONVERSION INVOICES IC = INCREMENTAL: CUBING R = REGULAR INVOICE REB = REBILL INVOICE RBE = REBILL EXTERNAL REP = RE-PRICED INVOICE WO = WRITE-OFF Z = DHL SHIPPING SYS INVOICE L0 Line Item - Quantity and Weight Segment Identifier L0 L001 Lading Line Item Number N0 1 3 Invoice Line Number L002 Billed/Rates-as Quantity R 1 11 Billed Weight L003 Billed/Rates-as Qualifier ID 2 2 LB = Pounds, KG = Kilograms L004 Weight R 1 10 Weight L005 Weight Qualifier ID 1 2 A1 = Dimensional Weight A2 = Reweighed By Carrier

B = Billed Weight L008 Lading Quantity N0 1 7 Number of Pieces L009 Packaging Form Code ID 3 3 PCS = Pieces L011 Weight Unit Code L ID 2 2 L = Pounds, K = Kilograms L4 Measurement Segment Identifier L4 L401 Length R 1 8 Length L402 Width R 1 8 Width L403 Height R 1 8 Height L404 Measurement Unit Qualifier N ID 1 1 N = Inches L10 Weight Segment Identifier L10 L1001 Weight R 1 10 Billing Weight L1002 Weight Qualifier ID 1 2 B = Billed Weight

A3 = Shipper’s Weight L1003 Weight Unit Code ID 1 1 L = Pounds, K = Kilograms

Page 21: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

SL1 Tariff Reference Segment Identifier SL1 SL101 Service Level Code ID 2 2 CG = Domestic Ground 9A = Domestic Express 9:00 PN = Domestic Express 12:00 CX = Domestic Express 18:00 SG = International Ground IX = International Express IE = International Express 9:00 PA = International Express 10:30 PS = International Express 12:00 SL103 Commodity Code AN 1 30 Product Code:

EN = Envelope PA = Parcel H = DHL International Ground D = DHL Express Worldwide (document) P = DHL Express Worldwide (non-document) K = DHL Express Worldwide 9:00 / 10:30 USA (document) E = DHL Express Worldwide 9:00 / 10:30 USA (non-document) Y = DHL Express 12:00 (non-document) T = DHL Express 12:00 (document)

SL105 Date DT 8 8 Pick-up Date SL107 Shipment Method of Payment ID 2 2 CC = Collect, PP = Prepaid L1 Rate and Charges Repeated 24 Times Segment Identifier L1 L104 Charge N2 1 12 Charge amount L108 Special Charge or Allowance ID 3 3 Charge Code: BAS = Basic & Freight Charge

GST = Goods and Services Tax TAX = Provincial Sales Tax TAY = Harmonized Sales Tax FUE = Ground Fuel Surcharge SUR = IBS Fuel Surcharge 405 = Air Fuel Surcharge ZZZ = International Fuel Surcharge INC = Liability Charge 205 = Collect Surcharge HAZ = Dangerous Goods 690 = Fragile Service

OVR = Over Dimension PKS = Packing Surcharge RAG = Repack Surcharge 505 = Missing Account Fee 003 = Invalid Account Fee SAB = NavCan Surcharge RES = Residential RET = Return Cheque Service 445 = Aviation Insurance SAT = Saturday delivery SEV = Security Shipment WAR = Afghanistan / Iraq Surcharge WFT = E-Return unable to pickup 999 = IBS Charge BEY = International Remote Area Surcharge (USA) BEY = International Remote Area Surcharge (NON-USA)

L112 Special Charge Description AN 1 25 **See above for descriptions**

21

Page 22: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

22

Summary Information L3 Total Weight and Charges Segment Identifier L3 L301 Weight R 1 10 Total Weight L302 Weight Qualifier ID 1 2 B = Billed Weight L305 Charge N2 1 12 Total Charge L312 Weight Unit Code ID 1 1 L = Pounds, K = Kilograms NTE Notes Segment Identifier NTE NTE02 Description N2 1 12 Message ST Transaction Set Trailer Segment Identifier SE SE01 Number of Included Segments *SEG# N0 1 10 Total number of segments

in this transmission including ST & SE SE02 Transaction Set Control Number *CNTL# AN 4 9 Cannot be changed.

Page 23: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

23

APPENDIX

In the following pages you will find the listing and descriptions of all DHL Service and Product codes

Page 24: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

A . S e r v i c e C o d e L e g e n d SL# Code Description

1 DD DHL Domestic Ground 2 DE DHL Domestic Express 3 D9 DHL Domestic Express 09:00 4 DN DHL Domestic Express 12:00 5 WD DHL International Ground 6 WW DHL Express Worldwide 7 W9 DHL Express Worldwide 09:00 8 WN DHL Express Worldwide 10:30 9 WM DHL Express Worldwide 12:00

B . I n v o i ce T y p e L e g e n d SL# Code Description

1 A ADVANCE PURCHASE PRODUCT 2 ADJ ADJUSTMENT 3 C CONTRACT 4 D DEFAULT / UNAPPLIED 5 G OTHER A 6 HPR HAND-PRICED 7 I INCREMENTAL 8 IC INCREMENTAL: CUBING 9 R REGULAR

10 REB REBILL A 11 REP RE-PRICED 12 S SPECIAL CHARGES 13 Z EASYSHIP 14 IBS CONVERSION 15 RBE REBILL B 16 RP0 RE-PRICED 17 T99 REVERSAL 18 WO OTHER B

C . P r o d u c t C o d e L e g e n d SL# Code Description

1 K DHL Express 09:00 (DOC) 2 E DHL Express 09:00 (NON DOC) 3 K DHL Express 10:30 (DOC) 4 E DHL Express 10:30 (NON DOC) 5 T DHL Express 12:00 (DOC) 6 Y DHL Express 12:00 (NON DOC) 7 PA DHL Express Parcel 8 EN DHL Express Envelope 9 D DHL Express Worldwide Document (DOX)

10 P DHL Express Worldwide NON-Document (WPX)

24

Page 25: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

25

D. S e r v i c e S u r c h a r g e L e g e n d SL # Code Description

1 AF AIR FUEL 2 GF GROUND FUEL 3 NV NAV CANADA 4 AI AVIATION INSURANCE 5 XN DUTIES & TAXES 6 XY OTHER SERVICE 7 IF INTERNATIONAL FUEL 8 RA RURAL AREA INTERNATIONAL 9 RU RURAL AREA US

E. V a l u e A d d e d S e r v i c e S u r ch a r g e L e g e n d SL # Code Description

1 DG DANGEROUS GOODS 2 FR FRAGILE 3 R RESIDENTIAL 4 RC RETURN CHEQUE 5 SD SATURDAY DELIVERY 6 SS SECURITY SHIPMENT 7 CO COLLECT 8 OV OVERSIZED 9 NP NON PACK

10 RP RE-PACK 11 MA MISSING ACCOUNT 12 IA INVALID ACCOUNT 13 NR E-RETURNS UNABLE TO PICKUP

F . S e r v i ce T o S u r c h a r g e R e l a t i o n s h i p L e g e n d SURCHARGE SERVICE

SL # Code Description DD DE D9 DN WD WW W9 WN WM 1 AF AIR FUEL N Y Y Y N N N N N 2 GF GROUND FUEL Y N N N Y N N N N 3 NV NAV CANADA N Y Y Y N N N N N 4 AI AVIATION INSURANCE N Y Y Y N N N N N 5 XN DUTIES & TAXES N N N N Y Y Y Y Y 6 XY OTHER SERVICE N N N N Y Y Y Y Y 7 IF INTERNATIONAL FUEL N N N N N Y Y Y Y 8 RA RURAL AREA INTERNATIONAL N N N N N Y Y Y Y 9 RU RURAL AREA US N N N N Y Y Y Y Y

Page 26: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

26

G . S e r v i c e T o V a l u e A d d e d S e r v i c e R e l a t i o n s h i p L e g e n d VALUE ADD SERVICE SERVICE

SL # Code Description DD DE D9 DN WD WW W9 WN WM 1 DG DANGEROUS GOODS Y N N N Y N N N N 2 FR FRAGILE Y Y Y Y Y Y Y Y Y 3 R RESIDENTIAL Y Y Y Y N N N N N 4 RC RETURN CHEQUE Y Y Y Y N N N N N 5 SD SATURDAY DELIVERY Y Y Y Y Y N N N N 6 SS SECURITY SHIPMENT Y Y Y Y N N N N N 7 CO COLLECT Y Y Y Y N N N N N 8 OV OVERSIZED Y Y Y Y Y Y Y Y Y 9 NP NON PACK Y Y Y Y Y Y Y Y Y

10 RP RE-PACK Y Y Y Y Y Y Y Y Y 11 MA MISSING ACCOUNT Y Y Y Y Y Y Y Y Y 12 IA INVALID ACCOUNT Y Y Y Y Y Y Y Y Y 13 NR E-RETURNS UNABLE TO PICKUP Y Y Y Y N N N N N

H. W e i g h t U s e d f o r P r i c i n g C o d e L e g e n d SL # Code Description

1 CC CUSTOMER CUBE 2 CD CUSTOMER DECLARED 3 CT CUBE OTHER 4 CU DHL CUBE WEIGHT 5 DT CUSTOMER DECLARED OTHER 6 RW REWEIGH

Page 27: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

D o c u m e n t C r e a t e D a t e : S e p t 2 , 2 0 0 8 R E V 4 . 2 C h r i s t o p h e r K r u p e y e d i . c a n a d a @ d h l . c o m

Thank you for tak ing the t ime to v iew th is document and showing in te res t in DHL’s E -So lu t ions .

I f you are in te res ted in us ing any o f DHL’s E -B i l l app l ica t ions , p lease

f i l l ou t the fo rm on the fo l lowing page and emai l i t to :

ed i .canada@dhl .com

Or fax i t to 905 -452-8770 At tn : DHL Canada E-B i l l ing

I f you need any ass is tance p lease do not hes i ta te to contac t your DHL

Sa les Representa t ive .

Page 28: eBilling Solutions - DHL Express Canada v4 - Loomis … Solutions... · WE'VE MADE CHANGES What's New?-New E-bill formats including E-bill Express. -New layout for E-billing to reflect

C U S T O M E R I N F O R M A T I O N

C o m p a n y N a m e: A d d r e s s 1 A d d r e s s 2 C i t y / P r o v : T e l ep h o n e N u m b er : P o s t a l C o d e Ag r e e m e n t Nu m b e r : C o n t a c t N a m e : E m a i l A d d r e s s :

Please speci fy be low what Type and Del ivery of E-Bi l l ing needed. NOTE: You can only choose one Delivery per E-Bill Type. (Example: You cannot have E-Bill Standard via the Web AND E-Mail)

TYPE DELIVERY E - B I L L S T A N D A R D WEB E-MAIL FTP E - B I L L E X P R E S S WEB E-MAIL FTP

E - I M A G E WEB E-MAIL NOT AVAILABLE

E D I 1 1 0 WEB NOT AVAILABLE FTP (If you are unable to check any of the above boxes, click `Exit Design Mode’ in the Visual Basic Toolbar then try again)

Please specify if this set-up is to be by ACCOUNT or QUOTE. ACCOUNT QUOTE

If by QUOTE, specify the quote number: (Note: all accounts tied to the quote will be extracted and sent to the customer)

If by ACCOUNT specify all accounts numbers below: 1. 6. 11. 2. 7. 12. 3. 8. 13. 4. 9. 14. 5. 10. 15.

REQUESTED BY: DATE: Name: Phone: Email: Comments:

Please email the completed form to [email protected] or fax it to 905-452-8770 Attn: DHL Canada E-Billing