Honda Standard set of 3PL Interfaces version 14/11/2017

This web page describes the content of the 3PL Interfaces to be exchanged between the Honda InfoHub system and the 3PL logistics operators.

The general principles of interfacing over InfoHub are documented in separate off-line documents, which are available to all interested parties.   

If required, the latest versions of these documents can be requested at 3PLinterfacing@honda-eu.com

This mail address can also be used for all other questions regarding these interfaces.

The descriptions on this page are to be considered as additional descriptions of a more functional nature to the existing xsd-files, which can be found here.

Examples for all interfaces can be found here.

List of Interfaces

 

Action Confirmation Interface

Action Instruction Interface

Arrival Confirmation Interface

Customs Result Interface

Delivery Confirmation Interface

Delivery Instruction Interface

Delivery Package Interface

Despatch Confirmation Interface

Frame Information Interface

Frame Registration Interface

Lotformation Interface

Ready For Despatch Interface (14/11/2017)

Repair Block Interface

Stock Reconciliation Interface

Transport Initiation Interface

Transportation Order Interface

Interface descriptions

 

Action Confirmation Interface

An action confirmation interface is sent by a 3PL to honda to confirm that the action that was previously requested by Honda in an action instruction interface, has been performed.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Possible values for an action confirmation interface  are:

·         3PL-FPDO (Pre-Delivery Operations Finished)

·         3PL-FEOM (Euro-Option Mounting Finished)

·         3PL-FPDI (Pre-Delivery Inspection Finished)

3

ExecutionDate

M

 

4

ExecutionTime

M

 

5

CompoundCode

M

 

6

ActionDetailCode

M

The action detail code of the executed action should normally correspond to the action detail code of the previously requested action.

 

 

Action Instruction Interface

An action instruction interface is sent by Honda to a 3PL to request the execution of a specific action in a certain compound.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Possible values for an action instruction interface  are:

·         3PL-SPDO (Start Pre-Delivery Operations)

·         3PL-SEOM (Start Option Mounting)

·         3PL-SPDI (Start Pre-Delivery Inspection)

3

AllocationDate

M

 

4

CompoundCode

M

 

5

ActionDetailCode

M

 

6

LocalSupplierCode

O

 

 

 

Arrival Confirmation Interface

An arrival confirmation interface is normally sent by a 3PL to Honda to confirm that a certain frame has arrived at a compound.  In certain particular cases, it can also be sent by Honda to a 3PL to confirm that a frame has arrived at a certain (other) compound.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Value for an action confirmation interface is always 3PL-ARCON.

3

ArrivalDate

M

 

4

ArrivalTime

M

 

5

CompoundCode

M

 

6

ReturnToLogisticsFlag

O

 

 

 

Delivery Confirmation Interface

A delivery confirmation interface is sent from a 3PL to Honda to confirm that a car has been delivered at a compound or a dealer as requested by the delivery Instruction Interface.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Value for a delivery confirmation interface is always 3PL-DLYCON.

3

DeliveryDate

M

 

4

DeliveryTime

M

 

5

CompoundCode

O

 

6

DeliveryInstructionNumber

O

 

 

 

Delivery Instruction interface

The delivery instruction interface is the Honda system’s request to a 3PL operator to deliver a certain car to another compound or to a dealer. The delivery instruction interface will typically be sent to both the 3PL compound operator and to the 3PL transport company.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Possible values for a delivery instruction interface are

·         3PL-DINEW (New Delivery Instruction)

·         3PL-DIUPD (Update of a Delivery Instruction)

·         3PL-DICAN (Cancel of a Delivery Instruction)

·         3PL-DIBLCK (Blocking of a Delivery Instruction)

·         3PL-UNBLCK (Unblocking of a Delivery Instruction)

3

DealerCode

O

 

4

DeliveryName

M

 

5

DeliveryAddress1

M

 

6

DeliveryAddress2

O

 

7

DeliveryZipCode

M

 

8

DeliveryCity

M

 

9

DeliveryRegion

O

 

10

DeliveryISOCountryCode

M

 

11

DeliveryCountry

M

 

12

PriorityCode

M

 

12

DealerArrivalDate

M

 

14

LicenseNumber

O

 

15

DeliveryInstructionNumber

O

 

16

CompoundCode

M

For a delivery instruction interface, the compound code is the one of the compound where the car is set to depart.

17

MTOC

O

18

Origin

O

 

19

Weight

O

 

20

EuroOptionCode

O

 

21

CustomsClearance

O

 

22

CompoundCodeTo

O

Compound where the car will be delivered

23

DestinationCompoundCode

O

 

24

AcceptEarlyDeliveryFlag

O

 

25

Comment

O

26

ParkingSpot

O

27

ModelYear

O

 

28

SalesModelRangeCode

O

 

29

NumberOfDoors

O

 

30

Booklet

O

 

31

LocalOptions

O

 

32

SalesPerson

O

 

33

OrderDate

O

YYYY-MM-DD

34

BranchCode

O

Branch to which the car is sold

35

DealerCode1320

O

Where 13.20 Document has to be sent to

 

 

Delivery Package interface

The delivery package interface is sent from Honda to a 3PL operator to inform about packages that need to be mounted on the car.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

3PL-DLYPCK

3

DealerCode

M

 

4

InstallationDate

M

 

5

CountryFrameOwner

O

 

6

PackageDescription

O

 

7

PackageIdentification

M

 

8

DeliveryInstructionNumber

M

 

 

 

Despatch Confirmation Interface

The despatch confirmation interface confirms that the car has left a compound towards its destination as requested in the previously received delivery instruction interface. This interface is normally sent out of a 3PL compound to Honda, but it can also be forwarded from Honda to a particular 3PL when information of despatch out of a certain compound is also required at a local compound further down in the supply chain. 

 

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Value for a despatch confirmation interface is always 3PL-DSPCON.

3

DespatchDate

M

 

4

DespatchTime

M

 

5

CompoundCode

M

 

6

ShippingUnit

O

 

7

DeliveryInstructionNumber

O

 

8

BranchCode

O

 

9

LotNumber

O

YY99999

10

LicencePlate

O

License plate of the car

11

DriverName

O

Name of the driver

12

VesselCode

O

 

13

VesselName

O

 

14

ETA-date

O

YYYY-MM-DD

15

SendNoteNumber

O

 

 

 

Customs Result Interface

The customs result information interface contains the customs related data and is sent from 3PL to Honda.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Value for a customs result interface is always 3PL-CUSTRES.

3

PreviousDocument

M

 

4

TarrifNumber

M

 

5

DocumentReference

M

 

6

TarrifKey

M

 

7

Origin

M

 

8

NetWeight

M

 

9

GrossWeight

M

 

10

StatisticsValue

M

 

11

VATValue

M

 

12

Destination

M

 

13

DestinationAddress

M

 

14

Importer

M

 

15

ImporterAddress

M

 

16

DeclarationNumber

M

 

17

DeclarerNumber

M

 

18

ClearanceDate

M

19

ClearanceQ

M

 

20

AcceptanceDate

M

21

AcceptanceTime

M

22

MatrNumber

M

 

23

AccessCode

M

 

24

ProvisionalTax

M

 

25

ProvisionalVAT

M

 

26

PreferentialOrigin

M

 

 

 

Lotformation Interface

The lotformation interface contains the data about cars that are being prepared for transport and is sent from 3PL to Honda.

 

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

3PL-LOTADD (Lot Formation), 3PL-LOTDEL (Lot Deletion)

3

PlannedTranspCompanyCode

M

 

4

PlannedCollectionDate

M

 

5

CompoundCode

M

 

6

TransportUnit

M

 

7

LicensePlate

O

8

Origin

M

ISO country code Char 2(ISO--3166) of Transport Means

9

DriverName

O

10

LotNumber

O

5 digits with year as prefix (2) – YY99999

11

DealerArrivalDateFixed

O

YYYY-MM-DD

12

PlannedCollectionTime

O

HH:MM:SS

13

QuantityManuallyLoaded

O

14

ExternalLotNumber

O

 

 

Ready For Despatch Interface in

The ready for despatch interface contains the data about cars that are made ready for transport.

It is sent from the compound operator to Honda. Honda then triggers a delivery instruction to the transporter. 

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

3PL-RDYDSP, 3PL-RDYCAN

3

DespatchDate

M

YYYY-MM-DD

4

DespatchTime

M

HH:MM:SS

5

CompoundCode

M

 

6

ShippingUnit

O

 

7

DeliveryInstructionNumber

O

8

ParkingSpot

O

 

 

Ready For Despatch Interface out

The ready for despatch interface contains the data about cars that are ready to be picked up for transport.

It is sent from Honda to the compound operator.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

3PL-RDYDSP, 3PL-RDYCAN

3

DespatchDate

M

YYYY-MM-DD

4

DespatchTime

M

HH:MM:SS

5

CompoundCode

M

 

6

ShippingUnit

O

 

7

DeliveryInstructionNumber

O

8

ParkingSpot

O

9

BranchCode

O

Branch to which the car is sold

10

SalesModelRangeCode

O

 

11

MTOC

O

 

 

Frame Information Interface

The frame information interface contains the data for the cars that will be delivered to a certain compound and is sent from Honda to a 3PL.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Value for a frame information interface is always 3PL-FRINF.

3

EngineNumber

M

 

4

Vesselcode

O

 

5

VesselName

O

 

6

DischargeSiteCode

M

 

7

CIFPrice

M

 

8

CurrencyCodeISO4217-A3

M

 

9

MTOC

M

 

10

HESColourDescription

M

 

11

InteriorColourCode

M

 

12

InteriorColourDescription

M

 

13

Origin

M

ISO country code Char 2(ISO--3166)

14

Weight

M

in kilograms

15

ProductionDate

M

 

16

KeyNumber

M

 

17

ModelYear

M

 

18

ModelGroupCode

M

 

19

Door

M

2D/3D/4D/5D

20

ETADate

O

 

21

ShippingDate

O

 

22

TransportationIncoterms

O

Incoterms (ex : FOB, CIF)

23

FrameOwner

O

ISO country code Char 2(ISO--3166) of owning branch

24

LicensePlate

O

 

25

ReceivingOrderNumber

O

 

26

ShippingInvoiceNumber

O

 

27

ModeOfTransport

O

1-digit numeric Mode of Transport code (UNECE)

28

TransportDocumentNumber

O

 

29

TransportDocumentDate

O

 

30

PreparationCharges

O

 

31

TotalValue

O

 

32

PreferentialOrigin

O

 

33

DeclarationOfOrigin

O

 

34

HomologationNumber

O

 

35

InvoiceDate

O

 

36

FuelTypeCode

O

37

Hybrid

O

38

DisplacementExact

O

39

Variant

O

 

40

Version

O

 

41

HomologationExtension

O

 

42

MassInRunningOrder

O

 

43

AxleTrack1

O

 

44

AxleTrack2

O

 

45

CO2EmissionCombined

O

 

46

CustomsClearanceDate

O

 

47

DutyAmount

O

48

DutyCurrencyCode

O

 

49

DutyExchangeRate

O

50

SADNumber

O

 

51

SADDate

O

 

52

CustomsClearanceCountryCode

O

53

BranchCode

O

Branch to which the car is sold


Frame Registration Interface

The frame information interface contains the end-customer license plate registration for the cars that are delivered at dealer and is sent from 3PL to Honda.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Possible values : 3PL-REGCRE / 3PL-REGUPD

3

EndCustomerFirstName

O

 

4

EndCustomerSurName

O

 

5

EndCustomerStreet1

O

 

6

EndCustomerStreet2

O

 

7

EndCustomerCity

O

 

8

EndCustomerPostcode

O

 

9

EndCustomerPhone

O

 

10

LicensePlate

M

 

11

LicensePlateRegistrationDate

M

 

12

LastRegistrationDate

O

 

13

FirstRegistrationDate

O

14

TransferDate

O

15

LastEndCustomerFirstName

O

 

16

LastEndCustomerSurName

O

 

17

LastEndCustomerStreet1

O

 

18

LastEndCustomerStreet2

O

 

19

LastEndCustomerCity

O

20

LastEndCustomerPostcode

O

 

21

LastEndCustomerPhone

O

 

22

LastLicensePlate

O

 

Repair Block Interface

The repair block interface will be sent out of a 3PL towards Honda when a car needs for some reason to be blocked or repaired and is hence not available for delivery.  A second repair block interface needs to be sent once the blocking or the repair of the car has ended and the car becomes available again.  

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Possible values for a repair block interface are:

·         3PL-SREP (Repair Start)

·         3PL-FREP (Repair Finished)

·         3PL-SBLCK (Block Start)

·         3PL-FBLCK (Block Finished)

3

RepairBlockDate

M

 

4

RepairBlockTime

M

 

5

RepairBlockCode

O

 

6

CompoundCode

O

 

 

Stock Reconciliation Interface

The stock reconciliation interface sends the entire stock situation of a 3PL compound to Honda so reconciliation can be done between the compound’s stock situation and the system view in a Honda system on that compound’s stock. 

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

Value for a stock reconciliation interface is always 3PL-RECON.

3

MTOC

M

 

4

EuroOptionCode

O

 

5

StockStatusCode

M

 

6

CompoundCode

M

 

7

DealerCode

O

Only to be filled in the stock reconciliation interface if the frame already has a delivery instruction attached to it.

 

 

Transport Initiation Interface

The transport initiation interface is sent from 3PL to Honda to inform Honda about the initiation of the (vessel) transport. 

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

3PL-TRSPI

3

StartDate

M

YYYY-MM-DD

4

StartTime

M

HH:MM:SS

5

CompoundCode

O

 

6

DeliveryInstructionNumber

O

 

 

 

Transportation Order Interface

The transportation order interface is sent from Honda to 3PL and instructs the 3PL to transport the car to the local compound.

Nbr

Name

M/O

Remarks

1

Frame

M

 

2

BusinessActionCode

M

3PL-TRPORD

3

ReadyDate

M

4

ReadyTime

M

5

CompoundCode

M

 

6

ParkingAddress

M

 

7

SalesModelRange

M

8

HESColourDescription

M

9

Weight

M

 

10

DealerArrivalDate

O

 

11

DeliveryName

O

 

12

DeliveryAddress1

O

13

DeliveryAddress2

O

14

DeliveryZIPCode

O

15

DeliveryCity

O

16

DeliveryRegion

O

17

DeliveryISOCountryCode

O

18

DeliveryCountry

O

19

CompoundCodeTo

o

Compound where the car will be delivered

20

CompoundCodeFinalDestination

o

21

BranchCode

o

Branch to which the car is sold

22

AsapFlag

o

 

 

Field Descriptions

AcceptanceDate

Format :Date with format YYYY-MM-DD

 

AcceptanceTime

Format :Time with format HH:MI:SS

 

AcceptEarlyDeliveryFlag

This flag indicates wheather or not the transporter may deliver the car  earlier than the agreed DAD.

Format : 1 character

 

AccessCode

Format : 25 characters

 

ActionDetailCode

Detail code of an action: depending on the confirmed action (PDO, PDI or EOM), various detail action codes can be used. These codes describe for instance what kind of pre-delivery operations have been finished.  The action detail code of the executed action should normally correspond to the action detail code of the previously requested action.

Format: 1 till 3 characters.

 

AllocationDate

The Allocation Date is the date on which a requested action should be executed.

Format : Date with format YYYY-MM-DD.

 

ArrivalDate

Date of arrival of a car at a compound.

Format: Date with format YYYY-MM-DD.

 

ArrivalTime

Time of arrival of a car at a compound.

Format: Time with format HH:MM:SS.

 

AsapFlag

Valid values Y/N

·         'Y' : Deliver ASAP, regardless DAD given

·         'N' : Deliver in-line with DAD

Format : 1 characters

 

AxleTrack

Format : 1 till 5 numeric digits

 

Booklet

Format: 1 till 15 characters

 

BranchCode

Format : 3 characters

 

BusinessActionCode

The Business Action Code is an alphanumeric code that uniquely specifies the purpose of the interface. Where an interface in itself is used for a broad range of similar communications, the Business Action Code itself nails it down to one specific situation.

Format: 1 till 10 characters.

 

CIFPrice

The CIFPrice is the CIF Value of the car, which means the value of the car including cost, insurance and freight of the transport to the compound.

Format: decimal field, value between 0 and 99999999999.99.

 

ClearanceDate

Format : Date with format YYYY-MM-DD

 

ClearanceQ

Format : 20 characters

 

CO2EmissionCombined

Format : 1 till 5 numeric digits (eg. 128)

 

Comment

Multi purpose comment field

Format : 30 charactes

 

CompoundCode

The Compound Code is a code that uniquely identifies a compound in the Honda-system.

Format: 3 characters.

 

CompoundCodeFinalDestination

The (final) destination compound.

Format : 3 characters

 

CompoundCodeTo

Compound where the repair or blocking takes place or where the car will be delivered

Format : 3 characters

 

CountryFrameOwner

ISO country code Char 2(ISO--3166) of owning branch

Format : 2 characters

 

CurrencyCodeISO4217-A3

3character code of the currency in which the CIF Price is mentioned. 

The currency code is according to the ISO-4217-standard, of which a full list can be found at http://www.currency-iso.org/iso_index/iso_tables/iso_tables_a1.htm . [dead link]

Format: 3 alphabetic characters.

 

CustomsClearanceCountryCode

ISO country code Char 2(ISO--3166)

 

Format : 2 characters

CustomsClearanceDate

Format : date with format YYYY-MM-DD

 

DealerArrivalDate

Date of required arrival of a car at a dealer.

Format: Date with format YYYY-MM-DD

 

DealerCode

The Dealer Code is a code that uniquely identifies a dealer in the Honda-system.

Format: 1 till 12 characters.

DealerCode1320

This code will indicate where 1320 document has to be sent to :  Dealer Code in case document has to be sent to Dealer  or Branch code (‘245’)  in case document has to be sent to Branch.

 Format: 1 till 12 characters.

 

DeclarationNumber

Format: 3 characters

 

DeclarationOfOrigin

Format: 1 character

 

DeclarerNumber

Format : 3 characters

 

DeliveryAddress1

First line of the delivery address (usually of the compound or dealer) where a car has to be delivered.

Format: 1 till 35 characters.

 

DeliveryAddress2

Second line of the delivery address (usually of the compound or dealer) where a car has to be delivered.

Format: 1 till 35 characters.

 

DeliveryCity

City of the compound or dealer where a car has to be delivered.

Format: 1 till 35 characters.

 

DeliveryCountry

Country of the compound or dealer where a car has to be delivered.

Format: 1 till 20 characters.

 

DeliveryDate

Date of delivery of a car at a compound or a dealer.

Format: Date with format YYYY-MM-DD.

 

DeliveryInstructionNumber

Delivery Instruction Number is the unique identification of a delivery instruction in the Honda system.

Format: 11 characters.

 

DeliveryISOCountryCode

Alphabetic country code of the compound or dealer where a car has to be delivered. 

Country codes are according to the ISO-3166-standard, of which a full list can be found at http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html .

Format: 2 characters.

 

DeliveryName

Name of the compound or dealer where a car has to be delivered.

Format: 1 till 35 characters.

 

DeliveryRegion

Region of the compound or dealer where a car has to be delivered.

Format: 1 till 35 characters.

 

DeliveryTime

Time of delivery of a car at a compound or a dealer.

Format: Time with format HH:MM:SS

 

DeliveryZipCode

ZipCode of the compound or dealer where a car has to be delivered.

Format: 1 till 10 characters.

 

DespatchAddress

Format: 40 characters

 

DespatchDate

Date of despatch of a car from a compound.

Format: Date with format YYYY-MM-DD

 

DespatchTime

Time of despatch of a car from a compound.

Format: Time with format HH:MM:SS

 

Destination

Format : 25 characters

 

DestinationAddress

Format : 25 characters

 

DischargeSiteCode

The Discharge Site Code is the Compound Code of the descending site or a unique harbour code when coming directly from a harbour.

Format: 3 characters.

 

DisplacementExact

Defined in cubic centimetres

Format : 1 till 4 numeric digits (f.e. 9999)

 

DocumentReference

Format : 35 characters

 

Door

Door contains the number of doors of the model. 

The allowed values are:

Door

Explanation

2D

2 doors

3D

3 doors

4D

4 doors

5D

5 doors

 

Format: 2 characters.

 

DriverName

Name of the driver

Format : 1 till 20 characters

 

DutyAmount

Format : 4 till 15 numeric digits (eg. 99999999999,99)

 

DutyCurrencyCode

Format : 3 characters

 

DutyExchangeRate

Format : 6 till 10 numeric digits (eg 5,0001)

 

EndCustomer

Credentials of the person to whom the car was sold

Format :

EndCustomerFirstName : 1 till 20 characters

EndCustomerSurName : 1 till 20 characters

EndCustomerStreet1 : 1 till 25 characters

EndCustomerStreet2 : 1 till 25 characters

EndCustomerCity : 1 till 25 characters

EndCustomerPostcode : 1 till 7 characters

EndCustomerPhone : 1 till 16 characters

 

EngineNumber

Engine Number is the unique identification number of the engine in a car.

Format: 12 characters.

 

ETADate

The ETADate is the expected date of Arrival of the car.

Format: Date with format YYYY-MM-DD.

 

EuroOptionCode

The EuroOption Code is a code that uniquely defines an euro-option that can be mounted on a car.

Format: 3 characters.

 

ExecutionDate

Date of execution of an action.

Format: Date with format YYYY-MM-DD.

 

ExecutionTime

Time of execution of an action.

Format: Time with format HH:MM:SS.

 

ExternalLotNumber

Format: 1 till 50 characters.

 

CustomsClearance

Flag indicating if customs clearance is required (Y/N)

 

Format: 1 character

 

FirstRegistrationDate

 

Format: Date with format YYYY-MM-DD

 

Frame

The frame number is the vehicle identification number (VIN) of a car.

A frame number consists of 2 parts, a frame prefix of 11 characters and a frame sequence of 6 characters. 

In an xsd, a populated Frame-field will look something like this:

<Frame>

  <FramePrefix>SHHFK1740CU</FramePrefix>  

  <FrameSequence>013707</FrameSequence>  

</Frame>

 

FrameOwner

Frame Owner is a 2digit alphabetic country code of the country of the owning branch or sales organisation of the car.  

Country codes are according to the ISO-3166-standard, of which a full list can be found at http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html .

Format: 2 characters.

 

FuelTypeCode

Valid values are ‘D’/’P’

D=Diesel

P=Petrol

Format : 1 character

 

GrossWeight

Format : 10 characters

 

HESColourDescription

Description of the HESColour of the car.

Format: 1 till 20 characters.

 

HomologationExtension

Format : 1 till 30 characters (eg.  e11*2001/116*0255*11)

 

HomologationNumber

Format : 8 characters

 

Hybrid

Valid values ‘Y’/’N’

Format : 1 character

 

Importer

Format : 25 characters

 

ImporterAddress

Format : 25 characters

 

InstallationDate

Format : Date with format YYYY-MM-DD

 

InteriorColourCode

The Interior Colour Code is a code that uniquely describes the car’s interior colour.

Format: 1 till 2 characters.

 

InteriorColourDescription

The Interior Colour Description contains the car’s interior colour.

Format: 1 till 20 characters.

 

InvoiceDate

Format : Date with format YYYY-MM-DD

KeyNumber

The Key Number is a number that uniquely identifies the key of the car.

Format: 1 till 14 characters.

 

LastRegistrationDate

Format : Date with format YYYY-MM-DD

 

LatestEndCustomer

Credentials of the person to whom the car was last sold to

 

Format :

EndCustomerFirstName : 1 till 20 characters

EndCustomerSurName : 1 till 20 characters

EndCustomerStreet1 : 1 till 25 characters

EndCustomerStreet2 : 1 till 25 characters

EndCustomerCity : 1 till 25 characters

EndCustomerPostcode : 1 till 7 characters

EndCustomerPhone : 1 till 16 characters

 

LocalOptions

Format : 1 till 15 characters

 

LocalSupplierCode

A unique code that identifies the local supplier that needs to provide the required parts for certain option mounting instructions. This field is only used in particular cases: in most cases, it can simply be omitted.    

Format: 1 till 6 characters.

 

LotNumber

Format : 7 character – format YY99999

 

LicenseNumber

The LicenseNumber of a car to be used as a Taxi. This license number is only used in a very small number of countries.

Format: 1 till 30 characters.

 

LicensePlate

The License Plate contains the number of the license plate that will be put on the car.

Format: 1 till 15 characters.

 

LicensePlateRegistrationDate

Format : Date with format YYYY-MM-DD

 

MassInRunningOrder

Format : 1 till 5 numeric digits

 

MatrNumber

Format : 12 characters

 

ModelGroupCode

The Model Group Code is a code that uniquely defines the model group of the car.

Format: 1 till 20 characters.

 

ModelYear

Model Year is the year of the car model.

Format: Year with format YYYY.

 

ModeOfTransport

The Mode of Transport is a 1digit code that describes the method of transport used for the carriage of goods, according to the classification made by the United Nations Economic Commission for Europe.

The allowed values are:

Mode of Transport

Explanation

0

In principle, this code should not be used since the digit “0” may be employed to indicate absence of entry, etc. If this is not the case, the code can be used when indication of a mode of transport would be irrelevant, e.g. statistical reporting should not take place (for samples, gifts, personal effect, etc.).

1

Maritime transport Provision is made for separate reporting of inland water transport under code 8, assuming that appropriate definitions and rules of application will be given, particularly when transport covers sea as well as inland waterways.

2

Rail transport

3

Road transport

4

Air transport

5

Mail (Active mode of transport unknown) – This code is provided for practical reasons, despite the fact that mail is not a genuine mode of transport. In many countries, the value of merchandise exported and imported by mail is considerable, but the exporter or importer concerned would be unable to state by which mode postal items had passed the national border.

6

Multimodal transport (Active mode of transport unknown) – This code is provided for practical reasons, despite the fact that multimodal transport is not a genuine mode of transport. It can be used when goods are carried by at least two different modes from a place at which the goods are taken in charge by a transport operator to a place designated for delivery, on the basis of one transport contract. (Operations of pick-up and delivery of goods carried out in the performance of a unimodal transport, as defined in such a contract, shall not be considered as multimodal transport.)

7

Fixed transport This code applies to installations for continuous transport such as pipelines, installations ropeways and electric power lines.

8

Inland water transport This code is used only in such cases where the application of waterborne transport is reported separately within the framework of a one-digit code.

9

Mode unknown This code can be used when the mode is not known or when information on it is not available at the time of issuing the document concerned.

 

Format: 1 digit.

 

MTOC

The MTOC is the specification of the model, type, option and colour of the car.

This is a complex datatype that is constructed in the following way:

MTOC

Value & Format of the field

MTO

ModelCode

CertifiedModelCode

SalesModel

1 character

Body

1 character

Engine

1 character

DoorTransmission

1 character

Grade

1 integer digit (between 0 and 9)

ModelYearCode

1 character (of limited dataset)

MainEquipment

1 till 5 characters

Type

2 till 4 characters

Option

1 till 3 characters

HESColourCode

1 till 8 characters

 

In an xsd, a populated MTOC-field will look something like this:

<MTOC>

  <MTO>

    <ModelCode>

      <CertifiedModelCode>

        <SalesModel>F</SalesModel>

        <Body>K</Body>

        <Engine>2</Engine>

      </CertifiedModelCode>

      <DoorTransmission>7</DoorTransmission>

      <Grade>6</Grade>

      <ModelYearCode>C</ModelYearCode>

      <MainEquipment>E <MainEquipment>

    </ModelCode>

    <Type>KG </Type>

    <Option>8E </Option>

  </MTO>

  <HESColourCode>G-535P </HESColourCode>

</MTOC>

 

NetWeight

Format : 12 characters

 

NumberOfDoors

Format : 1 numeric position

 

OrderDate

Format : Date with format YYYY-MM-DD.

 

Origin

Origin is a 2digit alphabetic country code of the country of origin of a car. 

Country codes are according to the ISO-3166-standard, of which a full list can be found at http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html .

Format: 2 characters.

 

PackageDescription

Format : 1 till 30 characters

 

PackageIdentification

Format : 1 till 15 characters

 

ParkingAddress

Foramt : 5 characters

 

ParkingSpot

Text field containing parking information from compound operator

Format : 30 characters

 

PlannedCollectionDate

The planned date on which the cars will be collected and put into a lot (Format: YYYY-MM-DD).

 

PlannedTranspCompanyCode

The code for the transport company that is planned to move the cars.

 

PreferentialOrigin

Format : 9 characters

 

PreparationCharges

Format : 3 till 10 numeric digits (f.e.9999999,99)

 

PreviousDocument

Format : 17 characters

 

PriorityCode

A 1digit numeric code that determines the priority of a certain action: between a value from 1 (lowest priority) till 9 (highest priority).  The default priority is 4.

Format: 1 numeric position.

 

ProductionDate

Production Date of the car.

Format: Date with format YYYY-MM-DD.

 

ProvisionalTax

Format : 11 characters

 

Provisional Vat

Format : 11 characters

 

QuantityManuallyLoaded

The number of cars that will be loaded for this lot

Format : 1 numeric position

 

ReceivingOrderNumber

The Receiving Order Number contains the dealer order number of a car in case a car has already been ordered while not yet on its local compound.   

Format: 8 characters.

 

ReadyDate

Format : Date format YYYY-MM-DD

 

ReadyTime

Format : Time format HH:MI:SS

 

RepairBlockCode

The Repair Block Code is a code that in more detail explains the reason for the blocking or the repair of the car.

Format: 2 characters.

 

RepairBlockDate

The Repair Block Date contains the date on which the repair or the block have either started or finished, depending on the content of the Business Action Code in the interface.

Format: Date with format YYYY-MM-DD.

 

RepairBlockTime

The Repair Block Time contains the time on which the repair or the block have either started or finished, depending on the content of the Business Action Code in the interface.

Format: Time with format HH:MM:SS.

 

ReturnToLogisticsFlag

The ReturnToLogisticsFlag indicates whether a car is a “returned” car.  If so the Flag is set to Y(es), otherwise it should take the default value of N(o).  

Format: 1 character.           

Possible values: Y(es) or N(o).

 

SADDate

Format : Date format YYYY-MM-DD

 

SADNumber

Format : 1 till 30 characters

 

SalesModelRangeCode

Format : 15 Characters

 

SalesPerson

Format : 1 till 30 Characters

 

ShippingDate

The Shipping Date is the date of shipping of the car.

Format: Date with format YYYY-MM-DD.

 

ShippingInvoiceNumber

The Shipping Invoice Number contains the invoice number on which the car was shipped towards its destination.

Format: 12 characters.

 

ShippingUnit

The Shipping Unit of which the car is part of.

Format: 1 till 20 characters.

 

StartDate

Format : Date format YYYY-MM-DD

 

StartTime

Format : Time format HH:MI:SS

 

StatisticsValue

Format : 9 characters

 

StockStatusCode

The stock status code is the code that describes the status of the car on stock.

For the moment, value 60 means on stock, but different stock statuses will be added in the near future.

Format: 2 characters.

 

TarrifKey

Format : 3 characters

 

TarrifNumber

Format : 8 characters

 

TotalValue

Format : 3 till 12 numeric digits (f.e. 999999999,99)

 

TransferDate

The date that we receive the registration information of the car

Format : Date with format –YYYY-MM-DD

 

TransportDocumentNumber

Format : 11 characters

 

TransportDocumentDate

Format : Date with format –YYYY-MM-DD

 

TransportUnit

Format : 1 till 5 characters

 

TransportationIncoterms

The Transportation Incoterms contains the International Commercial Terms, which are a series of pre-defined commercial terms published by the International Chamber of Commerce (ICC) that are widely used in international commercial transactions or procurement processes. A series of three-letter trade terms related to common contractual sales practices, the Incoterms rules are intended primarily to clearly communicate the tasks, costs, and risks associated with the transportation and delivery of goods.

Format: 3 characters.

 

Variant

Format : 1 character

 

VATValue

Format : 9 characters

 

Version

Format : 1 character

 

Vesselcode

Code of the vessel that is shipping the car.

Format: 1 till 6 characters.

 

VesselName

Code of the vessel that is shipping the car.

Format: 1 till 36 characters.

 

Weight

Weight is the net weight of the car in kilograms. Value can be between 0 and 99999 kg.

Format: 5 digits.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-----  End of Webpage ----- Version 0.1 dd 14.08.2013 -----