Models
Column | Description | Values | Required | Inventory (In case of Inventory vehicle creation with these data) | LH Configurator | ||
---|---|---|---|---|---|---|---|
1 | Model Level | Defines the model level of the record. This is calculated based on the "U_MKitPrnt". | 0: Make | ||||
2 | DMSCode | The code of the connected DMS | text | ||||
3 | MakeCode | The DMS Code from the excel spreadsheet "Makes" | text | Tab: Details Section: Model Tree Field: Make | |||
4 | FamilyCode | The DMS Code from the excel spreadsheet "Families" | text | Tab: Details Section: Model Tree Field: Family | |||
5 | ModelParentCode | text | |||||
6 | KitsParentModelCode | text | |||||
7 | Model Description | text | |||||
8 | PresentationCode | text | |||||
9 | ModelYear | text | Tab: Details Section: Vehicle Information Field: Model Year | ||||
10 | ModelYearTo | text | |||||
11 | FuelTypeCode | text | |||||
12 | Engine Code | text | |||||
13 | DriveTypeCode | text | |||||
14 | CarTypeCode | text | Tab: Details Section: Vehicle Information Field: Vehicle Type | ||||
15 | TransmissionCode | text | |||||
16 | BodystyleCode | text | |||||
17 | TaxGroupCode | text | |||||
18 | VATProductGroup | If VATProductGroup is empty, use TaxGroupCode | text | Tab: Details Section: Main Information Field: VAT Product Group | |||
19 | Country Manufacturered | text | |||||
20 | HSN | text | |||||
21 | EmissionClassCode | text | |||||
22 | EngineDisplacement | text | |||||
23 | FuelConsumptionCombined | number | |||||
24 | FuelConsumptionUrban | number | |||||
25 | FuelConsumptionExtraUrban | number | |||||
26 | NumberOfCylinders | text | |||||
27 | TireSize | text | |||||
28 | NumberOfDoorsCode | text | Tab: Details Section: Vehicle Information Field: Number of Doors | ||||
29 | EmissionStickerCode | text | |||||
30 | CO2EmissionCombined | number | |||||
31 | CO2EmissionCity | number | |||||
32 | CO2EmissionLongDistance | number | |||||
33 | SeatsNumber | text | Tab: Details Section: Vehicle Information Field: Number of Seats | ||||
34 | Axles | integer number | |||||
35 | TopSpeed | integer number | |||||
36 | Acceleration | text | |||||
37 | PowerKW | integer number | |||||
38 | PowerPS | integer number | |||||
39 | PowerHP | text | |||||
40 | Orderable | integer number | |||||
41 | Trunk Volume | integer number | |||||
42 | Towing Capacity | Deprecated | |||||
43 | Width | integer number | |||||
44 | Height | integer number | |||||
45 | Length | integer number | |||||
46 | Battery Capacity | integer number | |||||
47 | Voltage | integer number | |||||
48 | Drive Train | Deprecated | |||||
49 | Range on a single charge | integer number | |||||
50 | L1 Charge | integer number | |||||
51 | L2 Charge | integer number | |||||
52 | L3 Charge | integer number | |||||
53 | ModelPictureFileName | text | |||||
54 | LaborType | text | |||||
55 | SHOW_IN_CONF | 1: Yes 0: No | |||||
56 | SHOW_IN_B2C | 1: Yes 0: No | |||||
57 | MARKETING_DESCRIPTION | text | |||||
58 | MaxWeight | Gross Vehicle Weight (kg) | number | ||||
59 | Chassis | text | |||||
60 | EmptyWeight | Curb Weight (kg) | integer number | ||||
61 | WheelBase | number | |||||
62 | MaxTorque | integer number | |||||
63 | Payload | Payload (kg) | number | ||||
64 | TechnicallyPermissibleMaxWeight | integer number | |||||
65 | TowLoad | TowLoad (Kg) | integer number | ||||
66 | Length | integer number | |||||
67 | SortOrder | integer number |
Model Prices
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Modellevel | ||||
2 | DMSCode | text | |||
3 | PriceList | integer | |||
4 | Currency | text | |||
5 | Price | decimal |
Options
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | DMSCode | ||||
2 | Name | ||||
3 | ModelCode | ||||
4 | IsStandard | Y: Yes | |||
5 | IsPackage | Used only in AWT | 1: Yes | ||
6 | IncludedOptions | Not Used | |||
7 | CO2Adjustment | Not Used | |||
8 | OptionType | Color Option Trim | |||
9 | OptionCategory | ||||
10 | TaxGroupCode | ||||
11 | VATProductGroup | Not Used | |||
12 | ModelTreeLevel | Not stored in DB | |||
13 | NetPrice | ||||
14 | GrossPrice | ||||
15 | Weight | ||||
16 | IsAttributeLHAC | ||||
17 | RegistrationFee | ||||
18 | ParentCode | Used only in AWT | |||
19 | DisplayInConfigurator | Y: Yes | |||
20 | OptionDefault | Y: Yes | |||
21 | IsChangeable | Y: Yes |
Option Packages
Here we define the options that are included in a package.
Column | Description | Values | Required | |
---|---|---|---|---|
1 | PackageDMSCode | The DMS Code of the option that is package | text | |
2 | OptionDMSCode | The DMS Code of the option that belongs to this package | text |
Option Rules - Plausibility Checks
Column | Description | Values | Required | |
---|---|---|---|---|
1 | ModelDMSCode | The DMS Code of the model that has the relationship | text | |
2 | ModelLevel | The model tree level. Currently we support only level 2 ( model ), but we have it in case we need it in the future. | text | |
3 | OptionDMSCode | The DMS Code of the option that has the relationship | text | |
LinkedOptionDMSCode | The DMS Code of the option that is linked with other option | text | ||
RelationType | An enumeration that defines the relationship type | 1: Is Incompatible With |
Option Category
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | DMSCode | ||||
2 | Description | ||||
3 | Make | ||||
4 | Resource Code | ||||
5 | SortOrder |
Makes
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | DMSCode | The make code of the connected DMS | text | ||
2 | Name | The description of the make | text |
Families
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | DMSCode | The model family code of the connected DMS | text | ||
2 | Name | The description of the model family | text | ||
3 | MakeDMSCode | The DMS Code of the model make. This field defines the relationship between families and makes | text | ||
4 | FamilyGroupCode | The family group code from "FamilyGroups" excel spreadsheet | text |
Family Groups
It was introduced in excel version 1.23 because AWT wanted to display data in LH Configurator in a different way of the DSW model tree.
They wanted to introduced another layer of grouped model families.
Currently it does not take part in "LH Configurator" sync process, since they have their own implementation.
Column | Description | Values | Required | |
---|---|---|---|---|
1 | Code | The code of the Family Group | text | |
2 | Name | The description of the Family Group | text |
Fuel Types
Column | Description | Values | Required | Table | Field | DB Type | ||
---|---|---|---|---|---|---|---|---|
1 | Code | text | Code | NVARCHAR(50) | ||||
2 | Name | text | Name | NVARCHAR(100) | ||||
3 | BusinessValue |
Engine Types
Column | Description | Values | Required | |
---|---|---|---|---|
1 | Code | text | ||
2 | Name | text |
Drive Types
Column | Description | Values | Required | |
---|---|---|---|---|
1 | Code | text | ||
2 | Name | text |
Car Types
Column | Description | Values | Required | |
---|---|---|---|---|
1 | Code | text | ||
2 | Name | text | ||
3 | BusinessValue |
Transmission
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Code | text | |||
2 | Name | text |
Body Style
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Code | text | |||
2 | Name | text |
VAT Product Group
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Code | text | |||
2 | Description | text |
TaxGroups
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Code | text | |||
2 | Name | text | |||
3 | VATRate | ||||
4 | EffectDate | ||||
5 | Category |
Emission Class
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Code | text | |||
2 | Name | text |
Emission Sticker
Column | Description | Values | Required | ||
---|---|---|---|---|---|
1 | Code | text | |||
2 | Name | text |
Full Or Delta
Field | Description | Values | |
---|---|---|---|
1 | Entity | The entity that is going to be inserted/updated as full or delta | Models / Options |
2 | IsFullUpdate | Whether the entity is going to inserted following the full insert/update process | Y / N |
3 | MakeDMSCode | The DMS Code of the Make | text |
Entity | IsFullUpdate | MakeDMSCode |
---|---|---|
Models | Y | BMW |
Options | Y | BMW |
0 Comments