eParcel Consignment Import Guide

March 2011 Version 3.8

1 eParcel Consignment Import Guide

Version 3.8

Confidentiality and copyright

2010 Australian Postal Corporation. All rights reserved. No part of this publication may be reproduced in any material form or distributed without written permission of Australia Post Disclaimer: This publication is designed to provide accurate and authoritative information in regard to the subject matter. Although every effort has been made to ensure the accuracy of the contents of this User Guide at the time of publication, Australia Post shall not be liable for any loss or damage whatsoever arising from errors or omissions in this Guide or reliance placed on all or part of its contents.

2 eParcel Consignment Import Guide

Version 3.8

TABLE OF CONTENTS
1 1.1 1.2 1.3 1.4 2 2.1 2.2 3 3.1 3.2 3.3 3.4 4 4.1 4.2 4.3 INTRODUCTION .................................................................................................................................................................... 4 THE PURPOSE OF THIS DOCUMENT ................................................................................................................................................... 4 INTENDED AUDIENCE ..................................................................................................................................................................... 4 ASSUMED KNOWLEDGE ................................................................................................................................................................. 4 HELP CONTACT DETAILS ................................................................................................................................................................ 4 EPARCEL IMPORT CONSIGNMENT FILE PROCEDURE .............................................................................................................. 5 IMPORT CONSIGNMENT ................................................................................................................................................................. 5 VIEW LOG FILE ............................................................................................................................................................................. 7 CONSIGNMENT IMPORT FILE FORMAT .................................................................................................................................. 8 CONSIGNMENT FILE FIELDS AND FORMAT.......................................................................................................................................... 8 CONSIGNMENT LINE...................................................................................................................................................................... 9 ARTICLE LINE ............................................................................................................................................................................. 12 GOODS LINE .............................................................................................................................................................................. 13 ADDITIONAL FEATURES TO THE FILE STRUCTURE ................................................................................................................ 14 NUMBER OF IDENTICAL ARTICLES .................................................................................................................................................. 14 ADD TO ADDRESS BOOK.............................................................................................................................................................. 14 EMAIL NOTIFICATION ................................................................................................................................................................... 15

APPENDIX A: LIST OF COUNTRY CODES ........................................................................................................................................ 21

3 eParcel Consignment Import Guide

Version 3.8

1 Introduction
1.1 The purpose of this Document
This document provides the Merchant with the required information to enable them to create a Consignment file using their own database or spreadsheet and import this file this file into the eParcel system. Also contained within this document is the CSV (comma separated values) file specification in detailed table format including descriptions of fields required, and a sample import file.

1.2 Intended Audience

This document is intended for: Australia Post customers (Merchant), and Australia Post representatives supporting their customers.

1.3 Assumed Knowledge

The following concepts are assumed knowledge for reading this document: CSV (Comma separated values) file formats, and eParcel Merchant Interface.

1.4 Help Contact Details

If you have enquires about your account charges please contact your Account Manager. Alternatively, you can contact the Australia Post National IT Service Desk on 1800 287 457 to log a request for your State eParcel Controller to contact you. Please explain to the agent the nature of your call (i.e. eParcel Integration) and your details will be forwarded to the appropriate person so that they may contact you.

4 eParcel Consignment Import Guide

Version 3.8

2 eParcel Import Consignment File Procedure

The eParcel system allows a Merchant to import consignment files that have been generated from their own system. The following outlines how a Merchant user imports the file into eParcel in order to generate a manifest.

2.1 Import Consignment

Step Action

1.

Select Import Reference File from the Reference Data menu. The Import Reference File screen is displayed:

When you go into this screen the first option has been pre-selected. 2. Select the Import Consignment File:

The Assign all Consignments to the next Manifest box is ticked by default. If you do not wish the consignments to be assigned to the next manifest, please uncheck the Assign all Consignments to the next Manifest check box.

5 eParcel Consignment Import Guide

Version 3.8

3.

Click on

Browse

and select the import file:

4. 5.

Click on Import . A message tells you whether the import has completed successfully or if there are any errors. To view the details, click on View Log File . The View Log File screen is displayed. Error Message? If a file is not in the correct format for importing (it must be a CSV file), an error message is displayed.

6 eParcel Consignment Import Guide

Version 3.8

2.2 View Log File

After youve imported data, click on
View Log File

to view the details.

The Log displays details at the top including: Merchant name Name of the log file The date of import The imported files location and name Error details (if errors are found) Error line number Error description Possible ways to fix the error Summary details.

The error log will display errors ordered by line number and indicate why a line has failed the import process. Those lines that fail due to incorrect Suburb State and Postcode will be marked as Invalid and can be edited in the Consignments Not Despatched screen or deleted by clicking on the Consignments that failed due to other errors need to be recreated into a new csv file and imported again.
Delete Incorrect Records from Import

After the import, two other buttons are activated: Click on this to delete all the records from this last import (previous imports will not be affected). Click on this button to delete only incorrect records from this last import (previous imports will not be affected).
Delete Incorrect Records from Import

Delete All Records from Import

The option to

Delete Existing Incorrect Records

is available once you have imported one or more Consignment Import files.

Click on

Delete Existing Incorrect Records

if you choose to delete all incorrect records currently in the system. The file format is outlined in the next section. If you experience problems with the file import procedure, please check to ensure the format of the file is correct and meets the requirements outlined in the following sections. If you have further difficulties, please do not hesitate to contact your eParcel State Controller as outlined in the section of Help.
7 eParcel Consignment Import Guide Version 3.8

3 Consignment Import File Format

It is important that the format of the file is correct in order to ensure a complete error free import of consignments. Import consignment files are CSV files. The Import file specifications are outlined below and a sample consignment import file has been included. A sample file is attached to this document.

3.1 Consignment File Fields and Format

It is common for some CSV files to contain a Field Header row as the first line. In this file, such a Header line MUST NOT exist. ALL lines are considered as data. NOTE: If your data contains either commas ( , ) or quotation marks ( ), then these characters MUST be removed prior to creating the CSV file. The Consignment File consists of the following types of data lines:
Consignment Line (Type=C). This must be the first line for each consignment. Article Line (Type=A) o For Domestic consignments there must be at least 1 Article Line for each Consignment, with a maximum of 20. o For International consignments, there can be ONLY 1 Article Line per consignment. Goods Line (Type=G). Each Article Line can be followed by ONLY 1 Goods line. A Goods line is only required for Domestic Consignments if any value is populated at the Goods line. However, A Goods Line is Mandatory for International consignments.

The following rules apply to constructing the csv file:

i) Every consignment to be imported must contain at least one Consignment Line and one Article Line. ii) If the consignment to be imported has a destination within Australia, then it must contain one Consignment Line and up to twenty Article Lines (representing 20 articles per consignment to the same address). A Goods line is not required for each Article Line of Domestic Consignments and it is only required if values are populated at the Goods level. iii) If the consignment to be imported has a destination overseas (or to external territories such Christmas Island, Cocos Island, Norfolk Island), then it must contain one Consignment Line, only one Article Line and one Goods Line (for customs purposes). iv) Subsequent Article or Goods Lines above the required number, as mentioned above, will be ignored and an error message will be displayed in the error log. v) Boolean fields are not case sensitive. vi) Fields left blank must be separated by commas. vii) Carriage return or the end of file will indicate end of line, i.e. no need to insert string of commas without any optional values between if there is no other data carriage return is the end of the line. Where carriage return is used (instead of trailing commas) the line will import successfully and all columns unspecified will be read as null. viii) There is currently a restriction on the file size of 2,000 consignments. If you import more than 2,000 consignments each day, you will need to break down your files into 2,000 consignments or less. A file with more than 2,000 consignments will fail the import process and no consignments will be imported. If you import less than 2,000 consignments but more than 2,000 articles each day, it is advisable to break down your files into 2,000 articles or less. This restriction will be lifted in a future release of the eParcel system but customers progressing integration at present will need to develop their system with the current limitation in mind.

The following sections outline the fields and format. A Microsoft Excel format of these sections has also been attached to this document.
8 eParcel Consignment Import Guide Version 3.8

3.2 Consignment Line

Spreadsheet Column
A

Field Description

Type / Length

Mandatory / Optional

Comments

Consignment Line Indicator See Insert C to represent consignment line. Must M (TYPE) comments be populated or import will fail. Consignment Identifier B Varchar(20) N/A Must be left blank, this will be system generated (CNSGMT_ID) Your Australia Post Account Number C Varchar(20) O Use Default for Customer Location if blank. (POST_CHRG_TO_ACCT) Contract Charge Code Charge codes are determined as a part of the D Varchar(10) M (CHRG_CODE) contract setup. The following fields relate to the consignee. There are 3 options available: 1) Use existing consignee from the address book enter only the Consignee Code, or 2) Add new consignee to address book Complete all relevant fields and set the Add to Address Book Indicator = Y, or 3) Modify details for an existing Consignee enter Consignee Code, set the Add to Address Book Indicator = Y and include fields that need to be updated. Consignee Code Consignee reference. See section 4.2 E Varchar(20) O (MERCHANT_CNSGNEE_CODE) for further details. Consignee Name Mandatory if using option 2 above, otherwise F Varchar(35) M/O (CNSGNEE_NAME) optional. Consignee Business Name G Varchar(35) O (CNSGNEE_BUS_NAME) H I J K Consignee Address Line 1 (CNSGNEE_ADDR_LINE1) Consignee Address Line 2 (CNSGNEE_ADDR_LINE2) Consignee Address Line 3 (CNSGNEE_ADDR_LINE3) Consignee Address Line 4 (CNSGNEE_ADDR_LINE4) Consignee Suburb (CNSGNEE_SUBURB) Consignee State (CNSGNEE_STATE_CODE) Consignee Post Code (CNSGNEE_PCODE) Consignee Country (CNSGNEE_CNTRY_CODE) Consignee Phone Number (CNSGNEE_PHONE_NBR) Print Phone Number on Label? (IS_PHONE_PRNT_REQD) Consignee Fax Number (CNSGNEE_FAX_NBR) Varchar(40) Varchar(40) Varchar(40) Varchar(40) M/O O O O Mandatory if Australia and using option 2 above, otherwise optional. See http://auspost.com.au/products-andservices/download-postcode-data.html for valid combination of suburb, state and postcode. Mandatory if Australia and using option 2 above with the following valid values: QLD, NSW, VIC, SA, WA, NT, TAS and ACT, otherwise optional. Mandatory if Australia and using option 2 above, and must be 4 digits and include leading zero for Northern Territory, otherwise optional. Refer Appendix A for a list of valid codes. Mandatory for International consignments. Default to N if blank. Mandatory if using option 2 above, otherwise optional.

Varchar(50)

M/O

M N O P Q R

Varchar(10) Varchar(5) Varchar(30) Varchar(20) Char(1) Varchar(20)

M/O M/O M M/O O O

End of Consignee Address

9 eParcel Consignment Import Guide

Version 3.8

S T U V W X Y Z AA AB AC AD

Delivery Instructions (DELIVY_INSTRN)

Varchar(128)

AE AF AG AH AI AJ AK AL AM

AN AO AP AQ AR

Is a signature required? Char(1) O (IS_SIGNTR_REQD) Is this a part delivery? Char(1) O Default to N if blank. (IS_PART_DELIVY) Comments Varchar(256) O (CMNTS) Add Consignee to the address book? Char(1) O See section 4.2 for further details. (ADD_TO_ADDRESS_BOOK) Cash to Collect Amount Number(12.2) O (CTC_AMT) Reference Varchar(50) O (REF) Print Reference of Label? Char(1) O Default to N if blank. (IS_REF_PRINT_REQD) Second Reference Varchar(50) O (REF2) Print Second Reference on Label? Char(1) O Default to N if blank. (IS_REF2_PRINT_REQD) Chargeback Account Varchar(20) O (CHRGBCK_ACCT) Is this a recurring Consignment? Default to N if blank. If "Y", recurring Char(1) O (IS_RECURRG_CNSGMT) consignment will be created. Return Address (default for Location used if omitted) Return Name Varchar(35) O Use Default for Customer Location if blank. (RTN_NAME) Return Address 1 Varchar(40) O Use Default for Customer Location if blank. (RTN_ADDR_LINE1) Return Address 2 Varchar(40) O Use Default for Customer Location if blank. (RTN_ADDR_LINE2) Return Address 3 Varchar(40) O Use Default for Customer Location if blank. (RTN_ADDR_LINE3) Return Address 4 Varchar(40) O Use Default for Customer Location if blank. (RTN_ADDR_LINE4) Return Suburb Varchar(50) O Use Default for Customer Location if blank. (RTN_SUBURB) Return State Varchar(10) O Use Default for Customer Location if blank. (RTN_STATE) Return Postcode Varchar(5) O Use Default for Customer Location if blank. (RTN_PCODE) Return Country Code Varchar(30) O Use Default for Customer Location if blank. (RTN_CNTRY_CODE) Address for Redirection Redirection Company Name Varchar(35) O Use Default for Customer Location if blank. (REDIR_CO_NAME) Redirection Name Varchar(35) O Use Default for Customer Location if blank. (REDIR_NAME) Redirection Address 1 Varchar(40) O Use Default for Customer Location if blank. (REDIR_ADDR_LINE1) Redirection Address 2 Varchar(40) O Use Default for Customer Location if blank. (REDIR_ADDR_LINE2) Redirection Address 3 Varchar(40) O Use Default for Customer Location if blank. (REDIR_ADDR_LINE3)
Version 3.8

Default to If premises unattended, leave in a secure location out of weather if left blank and signature is NOT required. Do not use commas in delivery instructions as it will fail to import. Y or N. N implies signature NOT required, i.e. authority to leave.

10 eParcel Consignment Import Guide

AS AT AU AV AW

Redirection Address 4 (REDIR_ADDR_LINE4) Redirection Suburb (REDIR_SUBURB) Redirection State (REDIR_STATE) Redirection Postcode (REDIR_PCODE) Redirection Country Code (REDIR_CNTRY_CODE) Manifest Identifier (MANIFEST_ID) Consignee Email Address (CONSIGNEE_EMAIL) Email Notification (EMAIL_NOTIFICATION) Business Partner Number (BPN) Survey ID (SURVEY_ID) Delivery Subscription (DELIVERY SUBSCRIPTION) Embargo Date (EMBARGO_DATE) Specified Delivery Date (SPECIFIED_DATE) Specified Delivery Day (Delivery on) (DELIVER_DAY) Specified Delivery Day (Do not deliver on) (DO_NOT_DELIVER_DAY) Customer Collect Location (CDP_LOCATION)

Varchar(40) Varchar(50) Varchar(10) Varchar(5) Varchar(30) Other

O O O O O

Use Default for Customer Location if blank. Use Default for Customer Location if blank. Use Default for Customer Location if blank. Use Default for Customer Location if blank. Use Default for Customer Location if blank.

AX AY AZ BA BB BC BD BE BF

Varchar(20) Varchar(50) Varchar(10) Integer Varchar(50) Char(1) Date (dd/mm/yyyy) Date (dd/mm/yyyy) Varchar

N/A O M/O O O O O O O

Must be left blank.

See section 1.1 for further details. The customers Business partner number Provided by Australia Post once a survey is registered. Y or N. Default to N if blank. Y indicates that expected delivery date notification will be sent to the customers email address. The date that delivery should not occur before. The date for delivery. Multiple day of the week abbreviations (case insensitive) values one for each day, separated by a semi-colon. E.g. Mon;Tue;Wed;Thur;Fri;Sat;Sun Multiple day of the week abbreviations (case insensitive) values one for each day, separated by a semi-colon. E.g. Mon;Tue;Wed;Thur;Fri;Sat;Sun The Customer Collect delivery point identifier (DPID).

Varchar O Integer O

BG BI

11 eParcel Consignment Import Guide

Version 3.8

3.3 Article Line

Spreadsheet Column
A B C

Field
Article Line Indicator (TYPE) Article Actual Weight (ACTL_CUB_WT) Length (LEN) Width (WIDTH)

Type / Length
See comments Number(6.2) Integer

Mandatory / Optional
M M O

Comments
Insert A to represent article line. Must be populated or import will fail. Must be populated or import will fail (Kilograms). If no data is entered AND if the price schedule requires cubing (Y or P), then the consignment will be marked as invalid. (Measured in Centimetres no decimals) If no data is entered AND if the price schedule requires cubing (Y or P), then the consignment will be marked as invalid. (Measured in Centimetres no decimals) If no data is entered AND if the price schedule requires cubing (Y or P), then the consignment will be marked as invalid. (Measured in Centimetres no decimals) See section 4.1 for further details.

Integer

Height (HT) Number of Identical Articles (NUMBER_IDENTICAL_ARTS) Article Description (CNSGMT_ARTC_TYPE_DESCR) Are the Goods Dangerous? (IS_DANGEROUS_GOODS)

Integer

F G H I

Integer Varchar(40) Char(1) Char(1) Number(12.2) Number(8.2) Varchar(128) Varchar(20)

O O O O O O O O

Y or N. Default to N if blank. Refer to http://www.auspost.com.au/Pdfs/DangerousGoods Guide.pdf Y or N. Default to N if blank.

Is Insurance Required? (IS_TRANS_CVR_REQD) Insurance Amount J (TRANS_CVR_AMT) Goods Value for Customs K (CUSTOMS_DECL_VAL) Export Reason L (EXPORT_RSN) Export Clearance Number M (EXPORT_CLRNC_NBR) Undelivered International Articles Return by Sea N (IS_RTN_SFC) Return by Air O (IS_RTN_AIR) Abandon Goods P (IS_ABANDON) Redirect by Sea Q (IS_REDIRECT_SFC) Redirect by Air R (IS_REDIRECT_AIR)

Char(1) Char(1) Char(1) Char(1) Char(1)

O O O O O

Y or N. Default to N if blank. Y or N. Default to N if blank. Y or N. Default to N if blank. Y or N. Default to N if blank. Y or N. Default to N if blank.

12 eParcel Consignment Import Guide

Version 3.8

3.4 Goods Line

Spreadsheet Column
A B C D E F G H I J

Field
Good Line Indicator (TYPE) Country of Origin (ORIG_CNTRY_CODE) HS Tariff Code (HS_TARIFF) Description (DESCR) Product Type (PROD_Type) Product Classification (PROD_CLASSN) Quantity (QTY) Weight (WT) Unit Value (UNIT_VAL) Total Value (TOT_VAL)

Type / Length
See comments Varchar(30) Varchar(12) Varchar(50) Varchar(20) Varchar(30) Integer Number(8.2) Number(12.2) Number(12.2)

Mandatory / Optional
M/O O O M/O M/O O O O O M/O

Comments
Insert G to represent goods line. Mandatory if any value at the Goods line is populated.

Do not use commas in the description as it will fail the import. For International consignments, this field describes the contents and is mandatory. Product type is mandatory for ECI and EPI consignments.

Mandatory for International consignments.

Type / Length Description: Char(x) - Characters (maximum number of characters) Varchar(x) - Variable Alpha Numeric Characters (maximum number of characters) Integer - Number with NO decimal places Number(xx,x) - Number (maximum number of digits with comma representing decimal point) Date - A date in the format dd/mm/yyyy

13 eParcel Consignment Import Guide

Version 3.8

4 Additional Features to the file Structure

4.1 Number of Identical Articles
Where Number of Identical Articles (column F of Article Line) is populated, it is an indication that there are multiple identical articles in the consignment and that number of articles must be created. e.g. If Number of Identical Articles is six then the consignment will have six identical articles, each with the details as per that specific line. If the field is left blank or not provided, the number of articles is defaulted to 1.

4.2 Add To Address Book

Where Add to Address Book (column W of Consignment line) is populated, it is an indication that the address provided must be either updated or created in the list of consignees. The following rules are applied during the import process when using the Add to Address Book functionality. If the field is left blank or not provided, Add to Address Book is defaulted to N.
MERCHANT_ CONSIGNEE_CODE exists in eParcel
N/A N/A Yes No Yes No

MERCHANT_ CONSIGNEE_CODE
NULL NULL NOT NULL NOT NULL NOT NULL NOT NULL

ADD_TO_ ADDRESS _BOOK

Y N Y Y N N

Action
Use address details for consignment and new Consignee created and system generated Consignee ID is assigned Use address details for consignment. Consignee address details, currently held by the system are overwritten and used for consignment. Use address details for consignment and new Consignee created and Consignee ID provided in file assigned to consignee. Use address details for consignment. Use address details for consignment.

Note: Address details for consignment denote the following fields: CNSGNEE_ADDR_LINE1 CNSGNEE_ADDR_LINE2 CNSGNEE_ADDR_LINE3 CNSGNEE_ADDR_LINE4 CNSGNEE_BUS_NAME CNSGNEE_CNTRY_CODE CNSGNEE_FAX_NBR CNSGNEE_NAME CNSGNEE_PCODE CNSGNEE_PHONE_NBR CNSGNEE_STATE_CODE CNSGNEE_SUBURB

14 eParcel Consignment Import Guide

Version 3.8

4.3 Email Notification

Where Email Notification (column AZ of Consignment line) is populated, it is an indication that an email notification must be sent to the email address provided when the consignment is despatched. Three options are allowed for Email Notification: 1. NONE no email notification is sent when consignment is despatched, whether or not an email address is provided. 2. DESPATCH a despatch email notification is sent when consignment is despatched (see sample below).
Subject: Despatch notification: consignment ABC0000001 Dear Customer, Your parcels (3) from ABC Company have been despatched with Australia Post. This consignment can be viewed or you can choose to receive tracking emails by clicking on this link http://auspost.com.au/track/. Please allow approx 24 hours before checking the website. Regards, ABC Company **Please note that this is an automatically generated email replies will not be answered.

3. TRACKADV a track advice email notification is sent when consignment is despatched (see sample below).
Subject: Track Advice Notification: Consignment ABC1234567 Dear Customer, Your parcels (2) from ABC Company have been despatched with Australia Post. You will receive email notifications relating to the arrival of the product to the delivery address. Should you wish to: 1. 2. 3. add an email address to which these emails notifications are sent view the current status of your parcels read more about this service

please click on this link http://auspost.com.au/track/info. If you do not want to receive emails to this address please unsubscribe by clicking this link http://auspost.com.au/track/stop. Regards, ABC Company **Please note that this is an automatically generated email replies will not be answered.
15 eParcel Consignment Import Guide Version 3.8

The following rules are applied during the import process when using the Email Notification functionality. If the field is left blank, not provided or misspelt, Email Notification is defaulted to NONE.
Charge Code EMAIL_ Email Track CONSIGNEE_EMAIL NOTIFICATION valid? Advice Eligible?
NONE NONE DESPATCH N/A N/A N N/A N/A N/A N/A N/A N/A

Delivery Choice

Action
Consignment imported successfully and email notification will NOT be sent when consignment is despatched. Consignment imported and marked as invalid. Consignment imported successfully with warning message Warn Msg Invalid Charge Code in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported and marked as invalid with error message Err Msg No Email Despatch in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported and marked as invalid with error message Err Msg No Email Despatch, in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported and marked as invalid with error message Err Msg Invalid Email Despatch in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported successfully, a Despatch email notification will be sent when consignment is despatched, and delivery choice and/or customer collection information will be associated to the consignment. Consignment imported successfully with warning message Warn Msg Invalid Charge Code in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported and marked as invalid with error message Err Msg No Email Despatch in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported and marked as invalid with error message Err Msg Invalid Email Despatch in error log. Email notification will NOT be sent when consignment is despatched. Consignment imported successfully and a Track Advice email notification will be sent when consignment is despatched. Consignment imported successfully and a Track Advice email notification will be sent
Version 3.8

N/A Y N/A

DESPATCH

N/A

N/A

DESPATCH

N/A

DESPATCH

N/A

DESPATCH

TRACKADV

N/A

N/A

N/A

TRACKADV

N/A

N/A

TRACKADV

N/A

TRACKADV TRACKADV

Y Y

Y Y

Y Y

N/A Y

16 eParcel Consignment Import Guide

Charge Code EMAIL_ Email Track CONSIGNEE_EMAIL NOTIFICATION valid? Advice Eligible?

Delivery Choice

Action
when consignment is despatched and delivery choices and/or customer collection information will be associated to the consignment.

For further information Track Advice, please contact your Account Manager for the Track Advice User Guide.

4.4 Delivery Choice and Customer Collection

4.4.1 Invalid Combinations

When a consignment is submitted with an invalid combination of delivery choices, then the system will choose a valid combination and the consignment will be marked with a Warning. These consignments will show with an exclamation ! icon in the View Consignments Not Despatched screen.

Figure 1: View Consignments - Not Despatched with consignments that show 'Warning' (!) and Invalid (X) icons.

Consignments that are in a state of Warning can be despatched, but consignments that are invalid cannot be despatched. It is advisable to view each article that is showing a warning icon and confirm that the consignment details are correct before despatching. If the consignment details are correct, just save the consignment to remove the warning icon. 4.4.2 Specified Delivery Day (Deliver on) DELIVER_DAY

The additional service for specified delivery day (DELIVER_DAY) requires additional information and will accept valid days of the week for the destination postcode. Delivery windows can be associated to each of the supplied days of the week, specifying a day of the week and associated times for delivery to occur. Only valid delivery windows will be accepted and not all postcodes accept delivery within time windows. Invalid delivery day and time data submitted within a consignment will result in the information being removed from the submitted consignment.
17 eParcel Consignment Import Guide Version 3.8

Specified delivery day (delivery on) cannot be used with the following options: Specified delivery day (do not deliver on); Specified delivery date; Embargo delivery date; Customer direct pick-up; Convenience store pick-up; or Unattended parcel locker pick-up. 4.4.3 Specified Delivery Day (Do not deliver on) - DO_NOT_DELIVER_DAY

The additional service for specified delivery day (DO_NOT_DELIVER_DAY) requires additional information and will accept valid days of the week for the destination postcode. Specified delivery day (do not delivery on) cannot be used with the following options: Specified delivery day (deliver on); Specified delivery date; Delivery window; Embargo delivery date; Customer direct pick-up; Convenience store pick-up; or Unattended parcel locker pick-up. 4.4.4 Expected Delivery Date - DELIVERY SUBSCRIPTION The additional service for expected delivery date (DELIVERY SUBSCRIPTION) does not require any additional information; however, the customer must elect on the consignment to accept email notifications. Expected delivery date cannot be used with the following options: Specified delivery date; or Embargo delivery date. 4.4.5 Embargo Delivery Date - EMBARGO_DATE

The additional service for embargo delivery date (EMBARGO_DATE) requires additional information and will accept a date within fourteen days of the date the consignment is submitted. Embargo delivery date cannot be used with the following options: Specified delivery day (deliver on); Specified delivery day (do not deliver on); Specified delivery date; Expected delivery date; Customer direct pick-up; Convenience store pick-up; or Unattended parcel locker pick-up.

18 eParcel Consignment Import Guide

Version 3.8

4.4.6

Specified Delivery Date - SPECIFIED_DATE

The additional service for specified delivery date (SPECIFIED_DATE) requires additional information and will accept a valid delivery date for the destination postcode, date of lodgement, and service requested. Delivery windows can be associated to the delivery date, for delivery to occur on a specified date and within specified time periods. Only valid delivery windows will be accepted and not all postcodes accept delivery within time windows. Specified delivery date cannot be used with the following options: Specified delivery day (deliver on); Specified delivery day (do not deliver on); Expected delivery date; or Embargo delivery date. 4.4.7 Delivery Window - DELIVERY_WINDOW

The additional service for timed delivery (DELIVERY_WINDOW) requires additional information. Only valid Australia Post delivery windows will be accepted. Not all postcodes accept delivery within time windows. Table 1 details the start time and end times accepted by Australia Post, any other time windows will not be accepted and will result in the delivery choices being removed from the submitted consignment. For sending consecutive time periods, each delivery window start time and end time is required. Table 1: The valid time windows that will be accepted by Australia Post.
Time Period 7-12 12-17 Description Morning delivery between 7 AM - 12 PM Afternoon delivery between 12 PM - 5 PM

Delivery windows can vary when using specified delivery day by using the following format, with each set of time periods representing the time periods for one day. DELIVER_DAY value is Mon;Wed DELIVERY_WINDOW value is [7-12]; [12-5] Then, Monday will be assigned delivery time periods of 7:00 AM to 12PM, and Wednesday will be assigned delivery time periods of 12:00PM to 5PM. Delivery window cannot be used with the following options: Specified delivery day (do not deliver on). Consignments submitted to Australia Post with delivery windows associated to postcodes that cannot accept timed delivery will result in the information being removed from the submitted consignment. 4.4.8 Customer Direct Pick-up, Convenience Store Pick-up, and Unattended Parcel Locker Pick-up CDP_LOCATION

The additional services for unattended parcel locker pick-up, customer direct pick-up, and convenience store pick-up (CDP_LOCATION) requires additional information to be sent with the delivery address.
19 eParcel Consignment Import Guide Version 3.8

When sending a customer collect location the delivery address will be a valid address of the customer collect location and will include the delivery point identifier (DPID). Invalid customer collect locations submitted to Australia Post within a consignment will result in the submitted consignment being invalid. The valid customer collection locations available for delivery are published by Australia Post. For more information on please consult with your Australia Post controller. 4.4.9 Survey - SURVEY_ID

The additional service for timed delivery (SURVEY_ID) requires additional information and will only accept valid survey identifiers. Australia Post will supply a survey identifier upon request. For more information on using the survey functionality please consult with your Australia Post controller.

20 eParcel Consignment Import Guide

Version 3.8

Appendix A: List of Country Codes

Country AFGHANISTAN ALBANIA ALGERIA ANDORIA ANGOLA ANGUILLA ANTIGUA AND BARBUDA ARGENTINA ARMENIA ARUBA ASCENSION AND ST HELENA AUSTRALIA AUSTRIA AZERBAIJAN BAHAMAS BAHRAIN BANGLADESH BARBADOS BELARUS BELGIUM BELIZE BENIN BERMUDA BHUTAN BOLIVIA BOSNIA-HERZEGOVINA BOTSWANA BRAZIL BRITISH INDIAN OCEAN TERRITORY BRUNEI DARUSSALAM BULGARIA BURKINA FASO BURUNDI CAMBODIA CAMEROON CANADA CAPE VERDE CAYMAN ISLANDS CENTRAL AFRICAN REPUBLIC CHAD CHILE CHINA, PEOPLE'S REPUBLIC COLOMBIA COMOROS CONGO CONGO, DEMOCRATIC REPUBLIC OF COOK ISLANDS COSTA RICA CTE D'IVOIRE
21 eParcel Consignment Import Guide

Code AF AL DZ AD AO AI AG AR AM AW SH AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BA BW BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CO KM CG CD CK CR CI

Country CROATIA CUBA CYPRUS CZECH REPUBLIC DENMARK DJIBOUTI DOMINICA DOMINICAN REPUBLIC EAST TIMOR (TIMOR-LESTE) ECUADOR EGYPT EL SALVADOR EQUATORIAL GUINEA ERITREA ESTONIA ETHIOPIA FALKLAND ISLANDS FAROE ISLANDS FIJI FINLAND FRANCE FRENCH GUIANA FRENCH POLYNESIA GABON GAMBIA GEORGIA GERMANY GHANA GIBRALTAR GREECE GREENLAND GRENADA GUADELOUPE GUAM GUATEMALA GUINEA GUINEA-BISSAU GUYANA HAITI HOLY SEE (VATICAN CITY STATE) HONDURAS HONG KONG HUNGARY ICELAND INDIA INDONESIA IRAN, ISLAMIC REPUBLIC IRAQ IRELAND

Code HR CU CY CZ DK DJ DM DO TP EC EG SV GQ ER EE ET FK FO FJ FI FR GF PF GA GM GE DE GH GI GR GL GD GP GU GT GN GW GY HT VA HN HK HU IS IN ID IR IQ IE
Version 3.8

Country ISRAEL ITALY JAMAICA JAPAN JORDAN KAZAKHSTAN KENYA KIRIBATI KOREA, DEMOCRATIC PEOPLE'S REPUBLIC KOREA, REPUBLIC KUWAIT KYRGYZSTAN LAO, PEOPLE'S DEMOCRATIC REPUBLIC LATVIA LEBANON LESOTHO LIBERIA LIECHTENSTEIN LITHUANIA LUXEMBOURG MACAO MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF MADAGASCAR MALAWI MALAYSIA MALDIVES MALI LIBYAN ARAB JAMAHIRIYA MALTA MARIANA ISLANDS MARSHALL ISLANDS MARTINIQUE MAURITANIA MAURITIUS MAYOTTE MEXICO MICRONESIA, FEDERATED STATES OF MOLDOVA MONACO MONGOLIA MONTENEGRO MONTSERRAT MOROCCO MOZAMBIQUE MYANMAR NAMIBIA NAURU NEPAL NETHERLANDS

Code IL IT JM JP JO KZ KE KI KP KR KW KG LA LV LB LS LR LI LT LU MO MK MG MW MY MV ML LY MT MP MH MQ MR MU YT MX FM MD MC MN ME MS MA MZ MM NA NR NP NL

Country NETHERLANDS ANTILLES AND ARUBA NEW CALEDONIA NEW ZEALAND NICARAGUA NIGER NIGERIA NIUE ISLAND NORWAY OMAN PAKISTAN PALAU, REPUBLIC OF PANAMA, REPUBLIC OF PAPUA NEW GUINEA PARAGUAY PERU PHILIPPINES PITCAIRN ISLANDS POLAND, REPUBLIC OF PORTUGAL PUERTO RICO QATAR REUNION ROMANIA RUSSIAN FEDERATION RWANDA SAINT CHRISTOPHER (ST KITTS) AND NEVIS SAMOA, AMERICAN SAMOA, WESTERN SAN MARINO SAO TOME AND PRINCIPE SAUDI ARABIA, KINGDOM OF SENEGAL SERBIA SEYCHELLES SIERRA LEONE SINGAPORE SLOVAKIA SLOVENIA SOLOMON ISLANDS SOMALIA SOUTH AFRICA SPAIN SRI LANKA ST LUCIA ST PIERRE AND MIQUELON ST VINCENT AND THE GRENADINES SUDAN SURINAME SWAZILAND SWEDEN

Code AN NC NZ NI NE NG NU NO OM PK PW PA PG PY PE PH PN PL PT PR QA RE RO RU RW KN AS WS SM ST SA SN RS SC SL SG SK SI SB SO ZA ES LK LC PM VC SD SR SZ SE

22 eParcel Consignment Import Guide

Version 3.8

Country SWITZERLAND SYRIAN ARAB REPUBLIC TAIWAN TAJIKISTAN TANZANIA THAILAND TOGO TOKELAU TONGA TRINIDAD AND TOBAGO TRISTAN DA CUNHA TUNISIA TURKEY TURKMENISTAN TURKS AND CAICOS ISLANDS TUVALU UGANDA UKRAINE

Code CH SY TW TJ TZ TH TG TK TO TT TA TN TR TM TC TV UG UA

Country UNITED ARAB EMIRATES UNITED KINGDOM UNITED STATES UNITED STATES MINOR OUTLYING ISLANDS URUGUAY UZBEKISTAN VANUATU VENEZUELA VIETNAM VIRGIN ISLANDS, BRITISH VIRGIN ISLANDS, USA WALLIS AND FUTUNA ISLANDS YEMEN ZAMBIA ZIMBABWE

Code AE GB US UM UY UZ VU VE VN VG VI WF YE ZM ZW

23 eParcel Consignment Import Guide

Version 3.8