See also:
The Mercedes-Benz Order Details Import form imports vehicle (retail) order data to Autoline:
GiC (GO integration CESAR): Import of vehicle order data created in the GO in CESAR system (Mercedes BEnz Wholesale Ordering, Sales men (offering) Portal).
It is also possible to import GO in CESAR update files for the Vehicle Stockbook records that already have been imported from the GO in CESAR system.
In addition, setup is required for the Option types which are delivered in the Retail order files of GiC:
Note: Please ensure that all Factory option types are listed in the Franchise Data System Parameters in order to determine which options are removed prior import to prevent duplication of the factory options on the vehicle specification after an update.
GO (Global Ordering) DMS: Import of vehicle order data created in the Central system of Daimler (Previously called: WIN GO).
MBC POS OOM (Offer and Order Management): Import of the vehicle retail order data created in the MBC POS OOM (Mercedes Benz Car Point of Sale Lead and Vehicle Offering Portal) system.
It is also possible to import MBC POS OOM update files for the Vehicle Stockbook records that already have been imported from the MBC POS OOM system.
Depending on the version of the interface between Autoline and MBC POS OOM, this import function also:
Delivers trade-in vehicles, prevents that the user has to manually create the trade-in vehicle(s).
Delivers the technical data of non-petrol vehicles, the primary and secondary engine, which can be processed in Autoline.
Imports new and used vehicles. Used vehicles data comes from PVS (Pre-owned Vehicle Stock), while the new vehicle data comes from CESAR.
The data is exchanged via XML files and encoded in UTF-8 format. The XML files are stored in Autoline according to a specific code page (character table) that is related to the user's language. To convert data to and from UTF-8 format it is necessary to know the code page used in Autoline. These code pages are defined in the ISO Language Code Mapping Parameters. The MBC POS OOM system provides ISO 2 language codes in the import file. Based on these language codes, the corresponding language slot in Autoline is filled with the descriptions of the vehicle and prices provided in the XML file.
The MBC POS system is not able to supply the cost price of the vehicle in the Retail order files.
When importing a Vehicle order file without a cost price, the cost price is calculated using the margin setup of the vehicle’s variant. Two options for the Cost calculation are applicable:
P - Percentage of list on this variant only: The Options margin % of the Franchise Model Variants record is used to calculate the cost price, when a vehicle price record is found.
Formula: Selling price * (1 - (Options margin % / 100))
N - Percentage of list price from model or franchise: The Options margin % of the Franchise Model record is used to calculate the cost price. In case the Options margin % of the Franchise Model record is zero, the Options margin % of the Franchise record is used to calculate the cost price.
Formula: Selling price * (1 - (Options margin % / 100))
In all other cases the Cost price of the vehicle is equal to the Selling price delivered in the Retail order file.
In addition, setup is required for the Option types which are delivered in the Retail order files of MBC POS OOM:
VEHT (Vehicle Transfer): Import of XML files that contain (additional) information about vehicles when a vehicle is ordered between the factory / dealers.
After the import the created vehicle record can be purchased and invoiced to the customer via Vehicle Administration.
The Order Details Import function will use the StarConnect Data Server (STCDS) for the asynchronous communication between the systems and Autoline as per setup in the Communication types or consider the Add Default Communication Types function:
| Vehicle configurator | Type | Event | Description | Direction |
|---|---|---|---|---|
| MBC POS OOM | PC_RETAIL_ORDER | UPDATE | MBC POS vehicle order data | Inbound |
| GiC | CS_ORDER | UPDATE | GO in CESAR order replication | Inbound |
| WIN GO | PC_ORDER | UPDATE | GO - Vehicle order download | Inbound |
If applicable, you can Set System Suffix to communicate correctly between the concerning system and Autoline.
Tip: You can setup the Mercedes-Benz Order Details Import function to import order details automatically in Timed operations with module MS and option MBORDIMP.
Select a spooler that is connected to a print manager server that supports email, to make sure that emails with the specification differences are sent in Timed operations.
What do you want to do?
This form is displayed when you click Vehicle Stockbooks > [company] > MB Vehicle order import.
Menu Bar and Toolbar:
| Menu bar | Toolbar | Action |
|---|---|---|
| File > Delete | |
Deletes the selected file from the inbound queue. |
| File > Exit | |
Returns you to the Vehicle Stockbooks menu. |
| Edit > Copy | |
Copies the grid details of the current tab to the clipboard. |
| View > View vehicle | — | Displays the VSB record for the selected record. Only available if the record selected has a valid vehicle stock number. |
| View > View last imported vehicle | — | Displays the last imported vehicle. |
| View > Refresh | |
Refreshes the grid and, if applicable, applies the changed filter(s). |
| View > XML file | — | Displays the XML file received for the selected record. Only available on the Inbound queue tab. |
| View > Change log | — | Displays the update report with all the details of the update. Only available on the Import log tab. |
| Tools > Compare | — | Compares the current vehicle specification with the proposed specifications. |
| Tools > Import | — | Imports the selected vehicle order details. Available for order files in the inbound queue grid which are in black text colour and has no VSB number. |
| Tools > Download | |
Downloads the latest order details from the StarConnect data server. |
| Help > Help | |
Displays this help topic in a web browser. |
| Help > About | — | Displays version and copyright information. |
Tabs:
The left side of the form displays the unprocessed order files from the StarConnect data server inbound queue.
It is possible to filter the vehicle order files on Order number, Type and Location to decrease the files displayed in the grid.
Order number: Enter the order number (commission number) to filter records. Wildcards are allowed.
Location: Enter the physical location code to filter records. Wildcards are allowed.
Type: Select the source system.
Grid:
You can sort the grid ascending/descending by Timestamp (grouped by date) or Order no.
Timestamp: Displays the data and time (grouped by date) that the files are received.
Order no.: Displays the order number (commission number) of the order.
Version: Displays the factory version number which ensures that the orders are imported in the correct sequence.
VSB no.: Displays the VSB record number.
Type: Displays the vehicle configurator applicable to this file.
Chassis number: Displays, if available, the chassis number of the VSB record.
Note: Records in black text colour without VSB stock numbers can be imported by selecting the Tools > Import.
Order Details From Import File:
The right side of the form displays information from the selected Vehicle order file, like the Order details, Vehicle details, VSB stock details and the Customer details.
Note: The GiC order replication is based on CESAR interface version 3. The version of the order files is displayed in the upper right corner of the order details. The interface is able to determine the version, based on the interface version number provided in the DataServer inbound record.
The import log shows the history of updates done by the order import program, sorted by import date and time.
Filter:
Import date: Enter the date range to filter on. The records shown is based on the from date and to date entered in these fields.
Order date: Enter the date range to filter on. The records shown is based on the from date and to date entered in these fields..
Buying location: Entered the buying location to filter on.
VSB No.: Enter the VSB stock number to filter on.
Commission no.: Enter the commission number to filter on.
Import type: Select the import type to filter on.
User ID: Enter the user ID to filter on. For imports done in timed operations select user ID "-eod-".
Show descriptions: Select to display the franchise and the variant descriptions in the Update Log grid. The variant description will be in a new separate column Description.
Linked to showroom: Select to filter on records which are linked to a showroom order.
Changes:
Chassis number: Select to filter on records which chassis number has changed.
Variant code: Select to filter on records which variant code has changed.
Price: Select to filter on records which specification has changed.
Specification: Select to filter on records which price has changed.
Build date: Select to filter on records which build date has changed.
Note: Changes to the filter will be applied by selecting the Refresh button from the toolbar or press F5.
Update Log Grid:
Import date: The date and time of the file received.
VSB no.: The vehicle stock number relating to the file received.
Type: The source system type relating to the file received.
Franchise: The franchise code of the stock vehicle. The franchise description will be displayed if Show descriptions has been selected in the Filter group.
Variant: The variant of the stock vehicle.
Description: The description of the stock vehicle. Available if Show descriptions has been selected in the Filter group.
Commission no.: Commission number of the stock vehicle.
Progress: The progress code.
Account: The account code.
Location: The physical location code of the stock vehicle.
Showroom: If the VSB record is linked to a showroom order, the showroom order number with the company number as prefix will be displayed (for example 01-1234).
Chassis no.: Indicator if the chassis number has changed for the stock vehicle.
Spec.: Indicator if the specification has changed for the stock vehicle.
Price: Indicator if the price has changed for the stock vehicle.
Build date: Build date and indicator if the build date has changed for the stock vehicle.
Order date: The date the order was placed.
User: User id of the user who imported the file. User ID for imports done during end-of-day will be shown as "-eod-".
The StarConnect Data Server (STCDS) downloads the retail order files from, for example, the MBC POS OOM system. Via the Mercedes-Benz Order Details Import function you can process these order files in the inbound queue:
To import new or used vehicles:
On the master menu, select Vehicle Stockbooks > [company] > MB Vehicle order import.
The Mercedes-Benz Order Details Import form is displayed.
Select the vehicle order file required from the Inbound queue grid.
The gridline is highlighted and the right side of the form displays the order details from the selected vehicle order file. The Import function becomes available when it is possible to import the file.
Click the Import toolbar button or click the Tools > Import menu bar command.
After the import the created vehicle record can be purchased and invoiced to the customer via Vehicle Administration.
ISO Language Code Mapping Parameters
StarConnect Data Server Parameters