EXPEDIENT SOFTWARE

Going beyond software performance.

Customer Masterfile

The Customer Masterfile holds all information related to any company that your company deals with. The ranges of company types in which you can store information against shown below:

The screen is in Administration > Customer Masterfile.

Field Name

Description

Validation

Default

Cust Code

This is the short code that is used to search for the Entity. Generally a short code is based on a rule using the first 3 letters of the first word and the first 3 letters of the second word. E.g.: Gavin Millman & Associates would be set up with GAVMIL as the short code. You have up to 8 characters to enter a code.

The Cust Code can be left blank and the Company Name can be populated first. The Cust Code will be automatically generated based on the Company Name entered.

NOTE: Specific characters will be ignored which are listed in stxinfor IGNORWORDS.

Mandatory

Blank

Name

This is the name of the Entity.

Mandatory

Blank

External ID

This is the short code of the customer in your company’s external system (if applicable)

The same External ID can apply against multiple Client Codes if the system option CMFEXTUNIQ is turned on.

Otherwise the External ID is unique per Customer.

Optional

Blank

Parts ID

This is the related Parts ID that is linked to the parts found in the Customer Masterfile. (if applicable)

Optional

Blank

ABN

This is the Australian Business Number. If this is an overseas customer then just enter an arbitrary number. If your customer has a Client Activity Centre number, CAC, please put the 3 digit code at the end of the ABN.

Optional Validation on first 11 digits

Blank

Active

This defines whether the Customer is Active, Inactive or Prospect. If the Customer is not Active then no import or export jobs can be created for that customer.

Please Note: A Prospect Customer is used to be able to provide Quotations for potential customers.

Mandatory

Active

Contact

This is the primary contact for the entity

Optional

Blank

Phone

This is the primary phone number for the entity

Optional

Blank

Fax

This is the primary fax number for the entity

Optional

Blank

Account Manager

Identifies who services the Account.

Active Users from the User Masterfile are shown in the Zoom.

Optional

Blank

Forwarding Representative

Identifies who services the Account.

Active Users from the User Masterfile are shown in the Zoom.

Optional

Blank

Customs Representative

Identifies who services the Account.

Active Users from the User Masterfile are shown in the Zoom.

Optional

Blank

Street Address 1

This is the first line of the street address. Generally this is used for Unit, or Level information. If there is no level or unit then leave this blank. E.g.: Unit 52, Level 1

Optional

Blank

Street Address2

This is the second line of the street address. This is generally the actually address. E.g.: 1 Smith Road

Optional

Blank

City

This is the city. You can click on the zoom which will allow you to select a city, state, or zip code from the Australia Post listings. Once you have selected a city then the City, State, Postcode will populate into the main screen

Optional

Blank

State

This is the state. You can click on the zoom which will allow you to select a city, state, or zip code from the Australia Post listings. Once you have selected a state then the City, State, Postcode will populate into the main screen

Optional

Blank

Postcode

This is the postcode. You can click on the zoom which will allow you to select a city, state, or zip code from the Australia Post listings. Once you have selected a postcode then the City, State, Postcode will populate into the main screen

Optional

Blank

Country

This is the Country of the Street Address

Optional

Blank

Billing Address 1

If you leave this blank the Street Address will populate automatically.

This is the first line of the billing address. Generally this is used for Unit, or Level information. If there is no level or unit then leave this blank. E.g.: Unit 52, Level 1

Optional

Blank

Billing Address2

If you leave this blank the Street Address will populate automatically.

This is the second line of the billing address. This is generally the actually address. E.g.: 1 Smith Road

Optional

Blank

City

This is the city. You can click on the zoom which will allow you to select a city, state, or zip code from the Australia Post listings. Once you have selected a city then the City, State, Postcode will populate into the main screen

Optional

Blank

State

This is the state. You can click on the zoom which will allow you to select a city, state, or zip code from the Australia Post listings. Once you have selected a state then the City, State, Postcode will populate into the main screen

Optional

Blank

Postcode

This is the postcode. You can click on the zoom which will allow you to select a city, state, or zip code from the Australia Post listings. Once you have selected a postcode then the City, State, Postcode will populate into the main screen

Optional

Blank

Country

This is the Country of the Billing Address

Optional

Blank

Email

This is the primary email of the entity

Optional

Blank

Website

This is the website of the entity

Optional

Blank

Company Type

This is the type of entity. You can select multiple types for the one entity.

Once you select each company type, the associated tab will appear (where applicable) for you to enter the related information. See below:

Optional

Blank

Own Company

This describes if this is your company. This is used for billing purposes in the Job Registration process. In the Import Registration screens in the Broker Code and Forwarder Code field, if these are set to your company then the system will allow you to prepare the related charges (Customs, Forwarding, or Both). This is also used in Jobs Reporting, splitting Customs and Forwarding Shipments

Optional

No

Branch

This relates to which branch the Own Company code relates to. This is used for pre-populating the Forwarder Code in the Import Job Registration from the Consol Screen based off the user’s Branch. It links their branch with Own Company=”Y” and the matching branch.

Conditional

No

Overseas

This refers to whether the entity is an overseas based company

Optional

No

Debtor

Sales Person

This is the sales person that was responsible for the sales account. Users can click on the zoom button search on the Users Master file. This is found in Main Menu – Administration – Company Details Menu – Users Masterfile. The information in this field will automatically populate the Sales Person for new Import and Export jobs.

Optional

Blank

Responsible Person

This is the person who is responsible for the account. Generally this person ensures that money is paid by the debtor. Users can click on the zoom button search on the Users Master file. This is found in Main Menu – Administration – Company Details Menu – Users Masterfile

Optional

Blank

Responsible Office

This is the Branch that is responsible for the Debtor.

This field is a dropdown of all Branches set in the Branch Masterfile. This is used in the Debtors ATB Reporting for debt retrieval.

Mandatory

Blank

Last Pay Date

This is the date in which the customer last paid their invoice. This is a no entry field

N/A

General Ledger

On Acct Amount

This is the amount of money in which the debtor has on account.

N/A

General Ledger

Total Owed

This is the amount of money in which the debtor owes

N/A

General Ledger

Agreed Terms

If you have agreed terms with the customer then set this to Yes

Optional

Blank

Credit Check Date

This is the date in which the last credit check date was performed

Optional

Blank

Account Control

This is used to prohibit users from invoicing this client if the Accounting Module is used in Expedient. To prohibit invoicing, enter -1 in this field, or leave blank to allow invoicing.

If this is set to -1 then the following message appears when attempting to invoice this client:

The amount in this field is the allowable amount that the customer is to owe. When users are invoicing a customer the system checks the current on account amount plus what the current invoice amount and compares this with the Account Control field.

Optional

-1

Exchange Variance

This is used when billing the customer in local currency but you have Foreign Currency charges. The exchange variance adds a percentage to the foreign cost amount and adds this to the invoice. This is used in the Charges tab within the Job Registration screen depending on the Job Type.

A value entered in the Sea Exchange Variance field will automatically populate the Air Exchange Variance field if an Air value is not already provided.

Optional

Air matches Sea value on ADD

Payment Terms: Disbursement

This is the number of days you want the customer to pay the disbursement charges. The invoice due date will be reflected by the number of days you enter in to this field 

Optional

0

Payment Terms:

Final

This is the number of days you want the customer to pay the final charges. The invoice due date will be reflected by the number of days you enter in to this field

OPlease note: This is used in conjunction with the Invoice Due Date field. If the Invoice Due Date is set to “Invoice Date” then the Final Invoice Due Date calculation is: Invoice Date + Final Days.

Alternatively if the Invoice Due Date is set to “End of Month” then the Final Invoice Due Date calculation is: End of Month of Invoice Date i.e.: 31/08/10 + Final Days.

Optional

0

Invoice Due Date

This is when you want the invoice due date to be calculated from. This is used in conjunction with the Disbursement and Final Days.

You can select from “Invoice Date” or “End of the Month”.

E.g. Invoice Date: If you raise an invoice today then the invoice due date will be calculated based off today’s date + the number of days in the Payment Terms (disbursement or final)

End Of the Month: If you raise an invoice on the 15th of August then the invoice due date will be calculated based off the last day of August 31st, + the number of days in the Payment Terms (disbursement or final)

O Please Note: If either the Disbursement or Final Terms = 0 then Expedient will ignore the End of Month Setting and set the Invoice Due Date to be the same as the Invoice Creation Date 

OPlease Note: if this field is blank then the Invoice Due Date will default to the Invoice Date

Optional

Blank

Print Invoice Attachment?

This allows users to print an invoice attachment when there are more than 9 containers and 9 orders on the shipment. If a shipment has less than 9 containers or orders then the invoice attachment will not print. If the shipment has more than 9 containers or orders and the invoice attachment is set to No then the invoice will display the first 9 containers/orders with the word more… after the last container/order

Optional

Blank

Send EDI Invoice?

This indicates whether the Debtors can receive invoices by EDI. If set to Yes the Send EDI Invoice toolbar button is available in the Debtor Invoice screen. A file can be generated containing the invoice data which can be uploaded into the Debtors system.

Optional

Blank

Print Invoice Copies

When a Debtors Invoice or Manual Debtors Invoice is printed, the value in the Print Invoice Copies field will be shown in the Copies field of the Print Menu Screen.

Optional

1

Charges Print Order

This orders the way the charges print on the invoice. Users have the choice of

Alpha Code,

General Ledger Code,

Screen Order.

Screen Order will print the invoice lines as they appear on the screen.

Optional

Blank

Import Invoice Show FXC Amount

This is used when invoicing in local currency but you wish to display the Foreign Currency and Amount against each line item. This is only displayed when the foreign amount is entered at the time of entering the charges in either the charges or invoice screen.

Optional

Blank

Export Invoice Show FXC Amount

This is used when invoicing in local currency but you wish to display the Foreign Currency and Amount against each line item. This is only displayed when the foreign amount is entered at the time of entering the charges in either the charges or invoice screen.

Optional

Blank

Print Terms On Invoice

Setting this to yes will print the Number of Days Terms on the Original and Copy Invoices based on the Invoice Type (Disbursement / Final). If terms are 0 then the invoice will print COD. See below for example:

Optional

Blank

Print Imp/Exp Customs Number

Set this flag to yes to print the Customs Entry Number for Imports, or the EDN number for Exports on invoices. If there are multiple Customs Entry Numbers for a job the first number will print on the invoice. Where the first number has been withdrawn the next available Customs Entry Number.

Mandatory

Blank

Export All-In Charges (non GST)

This indicates whether the individual charge lines are to be made inclusive in a single account code on the printed invoice. Select a charge code using the zoom button. If a GST charge is included on the invoice the charges will not be rolled up. This feature will only apply to Export invoices.

Optional Flag. Account Code Mandatory if All-In flag is Yes

No

Interstate Agent

This is a Y/N Flag. If this Debtor is acting as an agent for their customers to perform the Customs Clearance. This then allows users to add this debtors’ customers via Options/Interstate Agents Clients

Optional

Blank

Receive Statements by

Select how this debtor receives statements

Mandatory

Print

Include Debtor in Batch sent Statements?

Select if this debtor will receive a statement by email during a batch send process. If the debtor has as least one Personnel with an email address that receives the Document Distribution Group Customer Statement or All Documents the client will be included in the batch send process. This option will only appear if your site has the Batch Send functionality

Mandatory

No

Invoice Comment

This is a single line of comment which will display on the printed invoice

Optional

Blank

Client Special Note

This is a single line of comment which will not display on the printed invoice

Optional

Blank

Creditor

Payee

This is the name of the company in which you are paying. This appears on the bank statement.

Optional

Blank

Instruction

This is a free type field for any payment instructions

Optional

Blank

Account Reference

This is your company’s account reference at the Creditor. This reference will be included on all remittances to this Creditor

Optional

Blank

Creditor Terms

This is the number of days in which you have to pay the Creditor. The number of days will automatically display in the Creditors Invoice Screen based of this value

Optional

Blank

Account Number

This is not used

Optional

Blank

EFT Creditor

This displays how the Creditor is paid

Optional

Blank

Credit Card GL

This is not used

Optional

Blank

On Acct Amount

This is the amount that you have out of balance. For example an amount you have overpaid

Optional

Blank

Account Balance

This is the amount that you owe the Creditor

Optional

Blank

Last Payment Date

This date is automatically updated with the date the last Creditor Payment was made.

This date is updated when the following Creditor posting options are run:

Post Creditor EFT Bank File

Post Creditor Payments

Read Only field.

Optional

Blank

Creditor Bank Details

Bank

This is the name of the Creditor’s bank

Optional

Blank

Branch

This is the name of the Creditor’s bank branch

Optional

Blank

BSB No

This is the BSB number for the Creditor’s bank

Optional

Blank

Account No

This is the Creditor’s bank account number

Optional

Blank

SWIFT Code

This is the international SWIFT code for the Creditor’s bank

Optional

Blank

ABA Number (AU Only)

This is the Australian Bank Association’s reference for the Creditor’s bank

Optional

Blank

Beneficiary Bank Details

Beneficiary

This is the name of the Creditor’s Beneficiary

Optional

Blank

Address Line 1

This is the first address line for the Creditor’s Beneficiary

Optional

Blank

Address Line 2

This is the second address line for the Creditor’s Beneficiary

Optional

Blank

City

This is the city for the Creditor’s Beneficiary

Optional

Blank

State

This is the state for the Creditor’s Beneficiary

Optional

Blank

Zip

This is the post code for the Creditor’s Beneficiary

Optional

Blank

Country

This is the country for the Creditor’s Beneficiary

Optional

Blank

Receive Creditor Invoice EDI?

Receive Creditor Statement EDI?

This indicates whether the Creditor will send their invoices and/or statements by EDI

Mandatory

No

 

Approved Creditor

This function outlines the Signed Agreement details between you and the Creditor.

 

 

Service

This is the Service that the Creditor Supplies. The Zoom function will list these Services.

Optional

Blank

Approval Status

This is the Agreement Status for the Creditor. The Zoom function will list the different Status’.

Optional

Blank

Valid To

This information is retrieved from the Expiry Date column in the Client Document Register, if Document Type = AS [Approved Sub-Contractor Agreement].

Read Only field.

Conditional

Active

This information is retrieved from the Active column in the Client Document Register, that is associated with the above Valid To Date, if Document Type = AS [Approved Sub-Contractor Agreement].

Conditional

EDI Creditors Invoices

This section of the Customer Masterfile will appear if the Creditor Invoice EDI module is active. Please refer to the Creditors User Manual for more details

File Format

This indicates what format the Invoice data will be received in

This field is followed by the email address the Creditor should send the email with the Invoice file to.

Mandatory

Blank

Creditor’s Identifying Reference

This is the reference contained in the Invoice EDI that identifies which Creditor sent the invoice

Mandatory

Blank

Invoice GST

This indicates whether GST is applicable to the invoice

Mandatory

Blank

Consolidate lines with the same Cost Code per Job/Consol number?

This indicates whether lines of the same cost code in the invoice will be consolidated on upload

Mandatory

No

Applied Exchange Rate

This is the date the exchange rate will be applied

Mandatory

Date of Invoice

Importer

See Setup an Importer for details on creating a new Importer

Customs Bill To

Enter the Customs Code of who will be billed in the Customs Job

Optional

Blank

Forwarding Bill To

Enter the Forwarder Code of who will be billed in the Forwarding Job

Optional

Blank

Customs Broker

Enter the Broker Code of who the Customs Broker is that handles the client

Optional

Blank

Send automatic email notification at Cargo Check In

If your site has the Air Cargo Forwarding and/or the Sea Cargo Forwarding module you will see this flag to show if the default Broker receive Cargo Availability notifications automatically on check in

N/A

From the Broker Customer Masterfile

Owner EFT

Is the Customer or Owner when paying Customs Duty by EFT

Optional

No

OEFT Limit

This field is shown if Owner EFT = YES.

If this field is populated, then the value will be printed on the Job Sheet.

Optional

Blank

Last Job

This is the date of the last job associated with this Importer

N/A

System Generated

Local EFT

Is the Customer on Local EFT when paying for Customs Duty

Optional

No

EFT Authorisation Expiry

This is the date the client has set the EFT payments to expire to AU Customs. This field appears if the site is in Australia, the Customs Module is active and the Owner EFT is set to Yes

Optional

Blank

Supplier Invoice P/O Edit Default

This sets the P/O Edit button to default On when a Supplier Invoice or Pre-Job Supplier Invoice is added or updated for this client. This should indicate to the User that the client wants Purchase Order information added to Supplier Invoice lines

Optional

No

Land Cost

Does the Customer Require a Landed Costing

Optional

No

Auto Entry Copies

This determines the number of copies auto-printed of the Nature10/20/30 documents. Select from 1 to 9.

Optional

1

Defer GST

Does the Customer wish to Defer the GST on Duty

Optional

No

ONS Factor

Default Marine Insurance Factor – Used in the Nature10/20 Screen to calculate ONS

Optional

Blank

Entry Type

Select the type of entry set for this client

Mandatory

Ask at Entry Time

DAFF Owner EFT

Is the Customer or Owner when paying DAFF by EFT

Mandatory

Matches Owner EFT flag

Autoprinting

Customs Entry

This indicates whether the Customs Entry should automatically print when received from Customs

Mandatory

Yes

EFT Payment Receipt

This indicates whether the EFT Payment Receipt should automatically print when received from Customs

Mandatory

Yes

Auto Entry Copies

This indicates the number of copies automatically printed on receiving the Entry from Customs

Optional

Blank

Automatic Emailing

Import Customs Declaration

This indicates if the Customs Declaration is automatically emailed to the client on receipt of the Entry from Customs. There must be at least one contact at the Client in the Document Distribution Group for the Customs Declaration

Optional

No

EFT Receipt (AU Only)

This indicates if the EFT Receipt is automatically emailed to the client on receipt of the Entry from Customs. There must be at least one contact at the Client in the Document Distribution Group for the EFT Receipt

Optional

No

EFT Notification

This flag determines if the Notification of Direct Debit is emailed automatically to Personnel at the Client with the Entry when Customs confirm successful Entry.

Mandatory

No

EFT Authority to Direct Debit

This flag determines if the Authority to Direct Debit is emailed automatically to Personnel at the Client with the Entry when Customs confirm successful Entry. This will be sent if the EFT Expiry Date has passed

Mandatory

No

Delivery Order (NZ Only)

This indicates if the Delivery Order is automatically emailed to the client on receipt of the Entry from Customs. There must be at least one contact at the Client in the Document Distribution Group for the Delivery Order

Optional

No

Customs EFT Bank Details

Bank

The name of the Importer’s Bank to make Customs EFT payments from

Optional

Blank

Branch

The name of the Importer’s Bank Branch to make Customs EFT payments from

Optional

Blank

BSB No.

The name of the Importer’s Bank BSB Number to make Customs EFT payments from

Optional

Blank

Account No.

The name of the Importer’s Bank Account Number to make Customs EFT payments from

Optional

Blank

Swift Code

The name of the Importer’s Bank Swift Code to make Customs EFT payments from

Optional

Blank

ABA Number (AU Only)

The name of the Importer’s Bank ABA Number to make Customs EFT payments from

Optional

Blank

Automatic Check In Notification Broker Contacts

Email Address

Add the email address for the Broker Contact who should receive the automated notification of Cargo Availability for this Importer. Click on to view the contacts stored for the default Broker.

Optional

Blank

Recipient Name

Add the Broker contact name who will receive the notifications

Optional

Blank

Destination Port

Enter the destination port the Broker contact is associated or leave blank.

Optional

Blank

Demurrage Terms

This indicates whether the Importer has special agreed demurrage terms with a shipping line that that take priority when calculating the Demurrage Start Date for imported containers. If the question is answered Yes the following Demurrage Table columns will appear

Mandatory

No

Shipping Line Code

This is the code for the Shipping Lines. Use the zoom to select a Shipping Line. The full name of the Shipping Line will be shown in the next column

Mandatory

Blank

Number of Free Days

This is the number of free days the client has agreed with the Shipping Line

Mandatory

Blank

Container Type

Select from the pull down list the types of container the Shipping Line has granted special demurrage terms for.

Mandatory

Blank

Demurrage Start Date

This the is the date the Shipping Line counts the number of free days from

Mandatory

Available Date

Exporter (NZ Only)

See Setup an Exporter for details on creating a new Exporter

Automatic Emailing

Select whether the listed Export Customs documents are automatically forwarded to the appropriate contacts at the Exporter

Optional

No

SEP Code

Enter the Security Export Partner Code. This will be used to automatically add the SEP code to the Header Codes in an Export Entry for this Exporter

Optional

Blank

Currency

Enter the currency the Exporter has forward cover for

Optional

Blank

Forward Cover Rate

The exchange rate provided for the forward cover

Mandatory if a currency is selected

Blank

Valid From

Enter the date the forward cover is applicable from

Mandatory if a currency is selected

Blank

Valid To

Enter the date the forward cover is applicable to

Mandatory if a currency is selected

Blank

Aviation Security

To become a regulated Client for Export Air Freight, a RACA Undertaking Form is sent to the client to be completed and shipments are sited at the Shipper’s premises before the cargo can be exported. Report on these details using the Aviation Security Report

 

Forwarder Details Group

 

 

Forwarder Code

Who is the regular forwarder and associated Name.

Optional

Blank

Known Shipper with Forwarder

Does the Forwarder know the Shipper?

Optional

Blank

Written Statement From Forwarder Held on File

Does the Forwarder have a document ensuring aviation security is cleared?

Optional

Blank

 

Customer Details Group

 

 

Customer has 3 previous Shipments Security Cleared

These fields are used under the following conditions:

Held Shipments

First Shipments

Sited Shipments

Optional

Blank

Comments

Any comments added that relate to the Job No 1, 2 and 3 fields.

Optional

Blank

Regulation Type

Select how the Export was given Regulated Status from the pull down list.

Optional

Blank

Regulated Client Status

The Aviation Security process has been completed and the Shipper is Security Cleared. This flag can be automatically set to No when the Expiry Date passes.

Cron Job REGCLISTAT updates this flag from YES to NO if it has expired.

NOTE: If the Expiry Date is blank then this is classified as a Regulated Client.

Optional

Blank

 

Security Information Group

 

 

#

Line Number.

Read Only field.

 

 

Alt Code

Alt Code and Description are free text fields.

Only 1 line can have a blank Alt Code.

Conditional

Blank

Authorised Company Officer

Who is the person responsible for the Export Air Site?

Free Text field.

Optional

Blank

Visual ID of Shipper Verified by Staff

Did the Customer/Staff visit the Shipper’s premises and site the shipment before exporting?

Combo Box – YES and NO Values.

Optional

Blank

Staff Visited ID

The Username of the Staff who visited the Shipper’s premises and sited the shipments.

The Zoom attached to this field looks up the User Masterfile for Active and Inactive Users.

Optional

Blank

Date ID Verified

The Date the Site was visited and Shipment sited before exporting.

Optional

Blank

Address Line 1

Address of the Shipper.

Optional

Blank

Address Line 2

Address of the Shipper.

Optional

Blank

City

Address of the Shipper.

Optional

Blank

State

Address of the Shipper.

Optional

Blank

Postcode

Postcode of the Shipper.

Optional

Blank

Phone

Phone Number of the Shipper.

Optional

Blank

Fax

Fax Number of the Shipper.

Optional

Blank

Email

Email Address of the Shipper.

Optional

Blank

Letter Sent Date

What Date was the RACA Undertaking Form sent?

Optional

Blank

Expiry Date

What date does the Aviation Security clearance Expire? This field is automatically populated under 2 conditions:

2 years from the Letter Sent Date

5 years from the Date ID Verified

This date can be used to automatically set the Regulated Client Status to ‘No’ when the Expiry Date has passed.

Optional

Blank

Active

Is the Customer Active with Export Air Security?

Combo Box Values – Active and Inactive.

Mandatory

 

Comments

Any comments added that relate to the Shipper.

Optional

Blank

Forwarder

Master Agent

Enter the Master Agent of the Forwarder

Optional

Blank

Usual Unpack Depot

This is the name of the depot in which this forwarder usually uses

Optional

Blank

Forwarder Note

Any notes that are useful for this forwarder

Optional

Blank

Air Cargo EstID

AU Only

Optional

Blank

Preferred Agent

This describes whether this Forwarder is used for Air, Sea or both

Optional

Blank

Carrier

This tab is only visible when the customer is identified as a Carrier in the General Tab. This tab can only be edited by a Super User

Does the Carrier send Proof of Delivery

Expedient will process files received from the Carrier if this is set to Yes

Mandatory

No

Carrier System

Select the system the Carrier will send the PODs from

Mandatory if the Carrier sends POD

Blank

How do we receive the POD?

Select from the pull down list how Expedient receives the files

Mandatory if the Carrier sends POD

Blank

IP Address

Enter the details for FTP interface

Mandatory if the interface is FTP

Blank

Username

Enter the details for FTP interface

Mandatory if the interface is FTP

Blank

Password

Enter the details for FTP interface

Mandatory if the interface is FTP

Blank

Directory Path

Enter the details for FTP and Write to File Server interface

Mandatory if the Carrier sends POD

Blank

Reference sent

Select the type of reference the Carrier uses in the file name to identify the job in Expedient

Mandatory if the Carrier sends POD

Job Number

Contact to receive unsuccessful load alerts

Enter at least one contact at your Expedient site to receive an alert by email if the Carrier sends a file that cannot be assigned to an Expedient Import Job.

Email Example:

The attached Proof of Delivery file from CARRIERTEST1, 1234567890 could not be loaded in Expedient as the Job Number 20637970 could not be matched to an Import Job. Please confirm the Job Number with the Carrier and ask them to resend the file.

The email has the original file attached for reference.

Mandatory if the Carrier sends POD

Blank

Carrier EDI

This tab is only visible when the Carrier EDI Module is active and the customer is identified as a Carrier in the General Tab. This tab can only be edited by a Super User

Carrier Account Reference

This is the account number you have with your carrier. This helps the carrier to identify which client the transport requests have come from

Mandatory

Blank

Carrier Company Reference

This is an additional reference to the account you have with your carrier. This helps the carrier to identify which client the transport requests have come from. If this is unknown please repeat the Carrier Account Reference.

Mandatory

Blank

Carrier Branch Reference

This is an additional reference to the account you have with your carrier. This helps the carrier to identify which client the transport requests have come from. If this is unknown please repeat the Carrier Account Reference.

Mandatory

Blank

Port Code

This is the ISO Port Code you associate with the carrier, e.g. Enter AUSYD if your carrier is deals with all the imports into Sydney. The full port name will be displayed. Please note you cannot enter the Port Code more than once in this table.

Mandatory

Blank

Carrier accepts EDI Bookings?

This indicates that the Carrier will accept EDI transports requests from you.

Mandatory

Blank

Job Type

This determines if the option to Send the Booking Request to the Carrier is available in the Job Registration screen based on the Job Type.  Select from the pull down list

Mandatory

Blank

Carrier System

This indicates the IT system the Carrier uses to accept EDI transport requests. Select from the down down list. If you do not see your required carrier system please contact Expedient Software support.

Mandatory

Blank

How do we send the data?

This indicates how you send the EDI files to the Carrier. Select an option from the pull down list.

Depending on the method used different fields will appear requiring entry.

Mandatory

Blank

Carrier Email Address

Enter the Carrier email address to send EDI transport instructions to the Carrier by Email

Conditional on Send Data selection

Blank

IP Address

Enter the IP address to send EDI transport instructions by FTP to the Carrier

Conditional on Send Data selection

Blank

User Name

Enter the username to send EDI transport instructions by FTP to the Carrier

Conditional on Send Data selection

Blank

Password

Enter the password to send EDI transport instructions by FTP to the Carrier

Conditional on Send Data selection

Blank

Directory Path

Enter the Directory Path to send EDI transport instructions by FTP or by ‘Write File to Server’ to the Carrier

Conditional on Send Data selection

Blank

How to we receive the carrier’s update file?

This indicates how you receive the carrier’s updates to your transport request.

Optional

Blank

Email Address

Enter the email address to receiving EDI transport updates from the Carrier by Email. The email address will be set by Expedient Software

Conditional on Receive Data selection.

Blank

IP Address

Enter the IP address to receive EDI transport updates by FTP from the Carrier

Conditional on Receive Data selection

Blank

User Name

Enter the username to receive EDI transport instructions by FTP from the Carrier

Conditional on Receive Data selection

Blank

Password

Enter the password to receive EDI transport instructions by FTP from the Carrier

Conditional on Receive Data selection

Blank

Directory Path

Enter the Directory Path to receive EDI transport instructions by FTP or by ‘Write File to Server’ from the Carrier

Conditional on Receive Data selection

Blank

Broker

Send automatic email notification at Cargo Check In

Select whether this Broker should receive automatic notifications when Air Cargo or LCL Cargo is checked in.

Mandatory

No

Email Address

Add the email address for the Broker Contact who should receive the automated notification of Cargo Availability for this Importer. Click on to view the contacts stored for the default Broker. There must be at least one contact if the Broker receives automatic notices

Optional

Blank

Recipient Name

Add the Broker contact name who will receive the notifications

Optional

Blank

Destination Port

Enter the destination port the Broker contact is associated or leave blank.

Optional

Blank

Depot

See Setup a Depot for details on adding a new Depot

Operating Hours

These are the open hours for the Depot. This will be printed on delivery dockets, LCL Cargo Availability notice, Delivery Orders and Arrival Notices

Optional

Blank

Depot Website

This is the website address for depot enquiries. This will be printed on delivery dockets, LCL Cargo Availability notice, Delivery Orders and Arrival Notices

Optional

On ADD default to General Tab website

Establishment ID (AU Only)

Select the AU Customs Establishment ID that corresponds to the Depot

Optional

Blank

Transitional Facility (NZ Only)

This is the 6 digit code identifying the Automatic Transitional Facility. This code will auto-populate the AFT question in the Customs Entry screen and the eBACCA application.

Optional

Blank

Terminal

See Setup a Terminal for information on creating a new Terminal

Operating Hours

These are the open hours for the Terminal. This will be printed on import and export delivery dockets, Delivery Orders and Arrival Notices

Optional

Blank

Terminal Website

This is the website address for terminal enquiries. This will be printed on import and export delivery dockets, notice, Delivery Orders and Arrival Notices

Optional

On ADD default to General Tab website

Establishment ID (AU Only)

Select the AU Customs Establishment ID that corresponds to the Terminal

Optional

Blank

1-Stop Terminal Code

AU and 1-Stop sites Only. Select the 1-Stop Terminal name that corresponds to the Terminal. When vessel schedule updates are received from 1-Stop the Terminal information will be updated in the import and export consols and jobs.

Optional

Blank

Bonded Warehouse

Operating Hours

These are the open hours for the Bonded Warehouse. This will be printed on import and export delivery dockets, Delivery Orders and Arrival Notices

Optional

Blank

Warehouse Website

This is the website address for Bonded Warehouse enquiries. This will be printed on import and export delivery dockets, notice, Delivery Orders and Arrival Notices

Optional

On ADD default to General Tab website

Establishment ID (AU Only)

Select the AU Customs Establishment ID that corresponds to the Terminal

Optional

Blank

Shipping Line

Cust Code

This is the customer the details are displayed for

N/A

System Generated

Name

This is the full name for the Customer

N/A

System Generated

SCAC Code

This is the four letter Standard Carrier Alpha Code which is mapped to the Customer. This can be used to recognise the Shipping Line when Jobs are imported from external sources

Optional

Blank

Principal Agent ID (AU Only)

This is the code used in Sea Cargo Reporting to identify the Shipping Company or Co-Loader.

Optional

Blank

PRA Shipping Line Code (AU Only)

This is the code that is submitted in the PRA.

If this field is populated, then this code will be auto-populated when the PRA is created.

Optional

Blank

 

Demurrage Group

 

 

Shipping Line Code

This is the client code for the Shipping Line

N/A

From the Customer Masterfile. No Update

Shipping Line Name

This is the full name for the Shipping Line

N/A

System Generated. No update

Number of Free Days

This is the number of days the Shipping Company allows the client to keep the import container before detention charges are applied

Mandatory

Blank

Container Type

Select from the pull down menu which type on containers the number of free days is applied to.

Mandatory

Blank

Demurrage Start Date

Select from the pull down menu the date the Shipping Line uses to start the count of free days from

Mandatory

Available Date

Configuration

Configuring Pop up Notes

Updated: May 13, 2016 — 6:40 am
EXPEDIENT SOFTWARE GUIDE © 2015