The company master data in Carrier Connect must include at least the address of your shipping point.
Entering companies manually
Proceed as follows:
- You must have the role of I_CAI_EDITMASTERFILEDATA.
- From the Office, go to Master data – Companies, then click New.
- On the Company sheet, fill in the required fields. Make sure you enter a unique company code and name.
- Defining contacts: Switch to the Employee sheet. Click New to enter information about contacts.
- Some carriers expect shipping orders to include information about a contact person, so it makes sense to complete at least the E-mail and Phone fields so that they can be automatically applied to the shipping order.
- Defining account numbers for chargeable consignments and customs debtor scenarios: Switch to the Package processing sheet. Click New to enter your recipients’ carrier-specific account numbers.
- Once you enter the account numbers, they can be set as the freight payer for chargeable consignments or as the customs debtor (payer of duties and taxes) either through host systems or directly in Carrier Connect.
- Assigning the “shipping point” role: To designate the address of your shipping point as a shipping point, switch to the Company roles sheet, click New, and select the Shipping point role.
- Click Save & close to save your changes.
- Repeat these steps if you wish to enter more companies.
- Some scenarios in which you may wish to enter more companies: If you enter shipping orders directly in Carrier Connect and want to select companies from the master data, or if you process chargeable consignments.
Importing companies using a CSV file
You can also import your companies as a CSV file in Carrier Connect. Open the company overview (Master data – Companies) and click Import. Follow the import dialog.
- Use the Help button to access further information.
CSV file format specifications:
- Use the "UTF-8" character set for the .CSV file.
- Save the Excel file as "CSV UTF-8".
- Field delimiter: Semicolon (";")
- Line separator: CRLF
- Ensure the CSV field formats match those in the table below.
Field formats for importing companies
The following describes the mandatory field formats. Please refer to the table below for details.
Field no. (column) | Functionally required field | Description | Field format | Note |
---|---|---|---|---|
1 | X | Company number | an..10 | Freely selectable: e.g., D01 |
2 | X | Name 1 | an..40 | Freely selectable |
3 | Name 2 | an..40 | Freely selectable | |
4 | Name 3 | an..40 | Freely selectable | |
5 | Name 4 | an..40 | Freely selectable | |
6 | State/region | an..40 | Freely selectable | |
7 | City | an..40 | Freely selectable | |
8 | District/borough | an..40 | Freely selectable | |
9 | Street address 1 | an..40 | Freely selectable | |
10 | Street address 2 | an..40 | Freely selectable | |
11 | Postal code | an..10 | Freely selectable | |
12 | PO box | an..20 | Freely selectable | |
13 | Postal code for PO box | an..10 | Freely selectable | |
14 | City of PO box | an..40 | Freely selectable | |
15 | X | ISO country code | an..2 | Freely selectable |
16 | Phone number of reception | an..20 | Freely selectable | |
17 | E-mail address | an..256 | Freely selectable | |
18 | Fax number | an..20 | Freely selectable | |
19 | Website | an..250 | Freely selectable | |
20 | Note | an..250 | Freely selectable | |
21 | VAT ID | an..20 | Freely selectable | |
22 | Role 1 | Possible values: see Help in import dialog | ||
23 | Role 2 | Possible values: see Help in import dialog | ||
24 | Role 3 | Possible values: see Help in import dialog |
Explanations of field formats:
- Functionally required field: An “X” indicates a functionally required field.
- Field format: “an..” indicates an alphanumeric field format. “..” means that up to X characters may be transmitted. The entry “an.. 10” therefore indicates an alphanumeric field of up to 10 characters.
Comments
Please sign in to leave a comment.