Field Name Description Validation Default Details What is the reason for mapping this agent? Select the appropriate reason for mapping the agent from the pull down menu - “Receiving Import and/or sending Export EDI Manifests from an O/S Agent” Mandatory O/S Code This is your customer code for the agent. Use the to zoom on active Overseas Agents. Mandatory Blank O/S Agent Ref This is reference code for the agent. In Manifests imported from the Agent this is the code they use to identify themselves. This code will also be used in the manifests exported to the agent to identify the recipient. Mandatory Default to O/S Agent Code Import Manifest Information Do we receive Import EDI files from them? Select Yes from the drop down list to allow the import of the agents EDI manifests Mandatory Yes File Source Select the file format the will send to you. What system does the agent use to produce the EDI manifest file? Please refer to Appendix for the details of the Expedient Format which should be passed to your Overseas Agent for their information if they do not use one of the listed formats. Once selected the email address the Overseas Agent should send the EDI Manifests to is displayed. Please advise your Overseas Agent to use this email address. If your Overseas Agent is not able to supply the EDI Manifest in the Expedient format or any other format listed please send an example of the agent’s EDI Manifest to Expedient Software for investigation using Support Tracker. Conditional on Send Export EDI is Yes Blank Export Manifest Information Do we send Export EDI Files to them? This indicates if you want to send Export Manifest EDI to the Overseas Mandatory No Sender Ref This is your reference to the Overseas Agent so they know the Export Manifest EDI came from you. The Sender Ref is usually the code the Overseas Agent uses for your office. Conditional on Send Export EDI is Yes Blank Export File Trigger This indicates the trigger for sending the Export EDI Manifest automatically. Select from the pull down menu. Conditional on Send Export EDI is Yes ETD Days This is the number of days after ETD the EDI Manifest will be sent Conditional on Export File Trigger is ETD 0 Import EDI
Contacts to receive alerts regarding the EDI Import Manifests This table lists the contacts at the Overseas Agent and internally to receive email notifications when new or updated Import Manifests have been received and if there are any errors processing the data. There must be at least one contact at the Overseas Agent and at least one internal User to receive email notifications. Active Users Contact Type Select the appropriate contact type from the pull down menu Mandatory O/S Contact Name Use the to find active personnel at the Overseas Agent. If you have selected Internal as the Contact Type the will provide a list of active Users. Mandatory Blank Email Address This is populated when a Contact Name is selected. This field cannot be updated in this screen. If the email address is incorrect please update the Personnel in the Customer Masterfile or the User Masterfile for internal Users N/A Blank Export EDI Email Addresses to receive the EDI Export Manifest File This table lists the O/S Agent contacts and any internal Users that receive the Export Manifest EDI. Active Users Contact Type Select the appropriate contact type from the pull down menu Mandatory O/S Agent Contact Name Use the to find active personnel at the Overseas Agent. If you have selected Internal as the Contact Type the will provide a list of active Users. Mandatory Blank Email Address This is populated when a Contact Name is selected. This field cannot be updated in this screen. If the email address is incorrect please update the Personnel in the Customer Masterfile or the User Masterfile for internal Users N/A Blank Contacts to receive EDI Export Manifest errors This table lists the internal Users to receive email alerts when there is a problem sending the Export Manifest EDI. O/S Agent contacts can also be listed here. Active Users/Active Personnel Contact Type Select the appropriate contact type from the pull down menu Mandatory Internal Contact Name Use the to find active Users. If you have selected O/S Agent as the Contact Type the will provide a list of active Personnel at the Overseas Agent. Mandatory Blank Email Address This is populated when a Contact Name is selected. This cannot be updated in this screen. If the email address is incorrect please update the User Masterfile for internal Users or the Personnel in the Customer Masterfile for the Overseas Agent. N/A Blank
This will ensure that when you Prepare the Charges that the Bill To will populate correctly, allowing you to Invoice the consignee Vessel Avail This is the date in which the Vessel is Available Please Note: This date will get updated from the 1Stop process if this is null. Optional Blank Vessel Storage This is the date in which the storage commences from containers on the vessels Please Note: This date will get updated from the 1Stop process if this is null. Optional Vessel Masterfile (1-Stop) DG/Refrigeration This signifies whether the shipment contains any dangerous goods, or requires refrigeration Optional Containers Tab (Sea Freight Only) Container No This is the Container Number on the Shipment. Use theto search for containers on other shipments on the same consol as the current house bill. (Forwarding Module only) Optional Blank Type This is the Type of Container, values include: (F)CL , (L)CL, (X)FCX Mandatory Blank ISO Type This is the International Standards Organisation Code for the Container type. Use the to search the ISO Type Masterfile. Mandatory Blank Seal No This is the Seal Number of the Container Number Optional Blank Dehire This is the date in which the container is de-hired Optional Blank Available This is the date in which the container becomes available for pickup Optional Vessels Masterfile (via 1-Stop) Delivered This is the date in which the container is delivered Optional Blank Delivery Type This is the method in which the FCL is to be delivered, possible values: S/L Cabin Tilt Tray Tipper S/L Rear Standard Trailer Optional Blank
Supplier This is the Supplier. You can click on to look up the related Suppliers for that Customer Code Mandatory Blank Customs Code This is the Supplier’s CCID. This is the number Customs Australia assign to this Supplier. This is mandatory for sending a Customs Entry N/A Suppliers Masterfile Currency the Currency in which you received the Supplier’s Invoice in. Mandatory Blank Exchange Rate This is the exchange rate used at the time of the Supplier’s Invoice received Mandatory (if not AUD) Blank Invoice Information No. Inv Lines This counts the number of Invoice lines, either entered in the Details Tab manually, or from the CSV/TXT File you have loaded via the Load File button. This is a no entry field and for display purposes only N/A actual number of lines Inv Amount Enter the Total Invoice Dollar Amount. This must equal the Entered Amount to balance the Supplier’s Invoice Mandatory Blank Entered Amount This totals the dollar amount entered in the Details Tab. This must equal the Inv Amount. This is a no entry field and for display purposes only. If these are not equal you will receive the below message. You can still save the Supplier’s Invoice. N/A actual amounts entered Invoice Qty the Total Invoice Qty of pieces. This must equal the Entered Qty to balance the Supplier’s Invoice Mandatory Blank Entered Qty This total the qty amount entered in the Details Tab. This must equal the Invoice Qty. This is a no entry field and for display purposes only N/A actual Qty’s entered Downloaded? This represents whether the Supplier’s Invoice was downloaded via email or using the load file button N/A Blank Details Tab
Description This is the Description of the TLF Optional Blank Valid Import This is a no entry field and is for display purposes only. This describes whether the TLF has the correct information. Expedient checks this data with that of Customs and if the information on the TLF is invalid then this will be set to No. N/A Valid Export This is a no field and is for display purposes only. This describes whether the TLF has the correct information. Expedient checks this data with that of Customs and if the information on the TLF is invalid then this will be set to No. N/A Auto This is a no entry field and is for display purposes only. This describes the last date in which the Expedient System checked with Customs whether the TLF is valid/in valid. N/A Last Used This is a no entry field and is used for display purposes only. This displays the last time the TLF was used in a shipment N/A Duty Rate This describes the Duty Rate against Preferential Rates: GEN DC DCT DCS FI LDC Optional Blank Preference Schemes This describes the Preference Scheme for the following countries: CA MY NZ PG SG TH US Optional Blank Amended This displays who was the last person to amend the TLF. This is a no entry field, and is used for display purposes only. N/A Blank Date This display the date in which the TLF was last amended. This is a no entry field, and is used for display purposes only. N/A Approved This displays who approved the TLF. Optional Blank Date This display what date the TLF was approved Optional Blank Creating Parts There are 2 ways to add parts, manually or via a download feature. If you have a File, you can upload this file via menu Download Data Files / Load Parts File.
GSTE This is the GST Exemption Code. You can click on the to lookup the GST Exemption Codes that is downloaded from Customs Optional Blank Supplier id This is the Supplier Code. You can click on the to lookup the Supplier Masterfile. Mandatory Blank ORG This is the Origin Country of the Part. You can click on the to lookup the Country Codes Masterfile. This Masterfile is found in the (Administration Menu, Country Codes Masterfile). Optional PRF This is the Product Preference Scheme Code. You can click on the to lookup the Preferences that is downloaded from Customs. Conditional on ORG Blank Rule This is the Product Preference Rule Code. . You can click on the to lookup the Preference Scheme Types that is downloaded from Customs. Conditional on PRF Supplier Part No This is the Supplier’s Part Number Optional Blank DRC This is the Product Dumping Exemption Code. Optional Blank ADJ This is the Product Adjustment Percentage. Optional Blank ICN This is the Product Import Credit Number. This identifies the Credit Optional Blank CSC Code This is the Product Security Code. Customs-allocated security number that must be quoted when the goods being entered are subject to compliance with either end-use conditions, dumping/countervailing provisional measures or temporary importations. Optional Blank Client Part This is the Client’s Part Number. This is what the customer recognises. This prints on Landed Costings Optional Blank Cust. TLF This is the Client’s TLF Optional Blank Volume Fact This is the Landed Costing Volume / Weight Factor. Optional Blank VFD This is the for Duty Optional Blank Last Used This is a no entry field and used to display what date this was last used N/A Last Job This is a no entry field and used to display what job this was last used for N/A Blank Parts Information TLF This is the TLF that you wish to associate with this part. All other fields in this section relate to the TLF. See the TLF Screen for further details on each field Mandatory Blank
Supplier This is the Supplier that is supplying the goods on the shipment that need to be cleared. You can click on the to display a list of Suppliers for that Customer. The Supplier’s Masterfile is found in Menu Administration – Supplier’s Masterfile. If this Supplier does not exist then you can add the Supplier from the Look up screen. See Below: Mandatory VALB This is the Valuation Basis. The code used to indicate the Valuation Basis from which the Customs Value is derived. Relates to the particular Valuation method utilized to determine the Customs Value of goods. You can click on to display the List of Valuation Basis. If there is a Valuation Basis that does not exist please Contact GMA Staff Mandatory TV – Transactional Related Supplier Indicator This is the Related Supplier Indicator. Tick this box if you want all of the Entry Lines to have this set to yes. Optional ORG This is the Country of Origin of the You can click on to display the list of Countries. The Country Masterfile is found in Menu, Administration – Country Code Masterfile Mandatory Load Port from Job Registration PRF This is the Preference Scheme Type. You can click on to display the list of Preference Scheme Types for the Country of Origin. If this doesn’t exist then please contact GMA Staff Mandatory General RULE This is the Product Preference Rule Code. You can click on the to lookup the Preference Scheme Types that is downloaded from Customs Mandatory Blank DTVA This is the Date of Valuation Mandatory Job Registration ITRM This is the ICS Invoice Terms. You can click on to display the list of IMD Invoice Terms. If a Term doesn’t exist then please contact GMA Staff Mandatory ITOT This the Invoice Total of the Goods Optional Blank Currency Code This is the Currency Code of the Invoice. You can click on to display the list of ICS Currency Codes. If a Currency doesn’t exist then please contact GMA Staff Optional AUD FOB This is the Value of the good Free on Board Optional Blank Currency Code This is the Currency Code of the Invoice. You can on to display the list of ICS Currency Codes. If a Currency doesn’t exist then please contact GMA Staff Optional AUD
Appendix Manifest EDI Expedient Format Manifest Information Seq Name Data Format Min Chars Max Chars Enumeration Values M/O/C Description Sample Business Comments 1 ExpedientManifestMessage 2 ManifestHeader 3 TransactionInfo 4 MessageSender xs:string 1 10 Message Sender ID DEMCON 5 MessageRecipient xs:string 1 10 Message Recipient ID SAMPTY 6 MessageID xs:integer Unique Identifier for message 105 7 DateCreated xs:dateTime 1 20 Date & time message created 2012-05-1716:05:04 8 Manifest 9 MBLNumber xs:string Master Bill of Lading "Number" MBL987654321 10 MBReferenceNumber xs:string 1 20 Consol Number 3702167 Expedient reference number 11 MasterCurrency Xs:string 1 3 Currency for Consol AUD 12 PrepaidCollect xs:string 1 1 Prepaid or Collect 13 Mode xs:string 1 1 Ocean, Air Ocean or Air Ocean 14 VesselName xs:string 1 20 Vessel Name ANL Wangaratta 15 VesselCode xs:string 1 6 Vessel Code ANLKOK Expedient Vessel Reference 16 VoyageNumber xs:string 1 10 Voyage Number AZ123S 17 AirlineCode xs:string 1 2 Airline Code QF 18 FlightNumber xs:string 1 6 C Flight Number 645D Conditional on Mode 19 LoadPort xs:string 1 5 Port or Origin or Load port USLAX 20 DischargePort xs:string 1 5 Port of Discharge AUSYD 21 DestinationPort xs:string 1 5 Port of final discharge AUMEL 22 MasterBillCutDate xs.date Date Master Bill was cut 2012-07-19 23 EstDepartDate xs:date 1 20 Estimated Date of Departure 2012-05-17 24 EstDischargeArrivalDate xs:date Estimate Date of Discharge 2012-05-21 25 EstDestinationArrivalDate xs:date 1 20 Estimated Date of Arrival 2012-05-22 26 NumberOfPieces integer 1 M Number of Packages 3 27 Weight unit xs:float M Weight in KG 2.5