3. Tables updated during the import process

Models

	Column	Description	Values	Inventory (In case of Inventory vehicle creation with these data)
1	Model Level	Defines the model level of the record. This is calculated based on the "U_MKitPrnt".	0: Make 1: Family 2: Model etc
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	Values
1	Modellevel
2	DMSCode	text
3	PriceList	integer
4	Currency	text
5	Price	decimal

Options

	Column	Description	Values
1	DMSCode
2	Name
3	ModelCode
4	IsStandard		Y: Yes N: No
5	IsPackage	Used only in AWT	1: Yes 0: No
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 N: No
20	OptionDefault		Y: Yes N: No
21	IsChangeable		Y: Yes N: No

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
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 2: Requires 3: Requires and is Required By 4: Requires Any of Set 5: Auto add

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
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	Values	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	Values
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	Values
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

Space shortcuts

Page tree