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.
Arrival Confirmation Interface
Delivery Confirmation Interface
Delivery Instruction Interface
Despatch Confirmation Interface
Ready For Despatch Interface (14/11/2017)
Stock Reconciliation Interface
Transport Initiation Interface
Transportation Order 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 |
M |
|
|
2 |
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 |
M |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
M |
The action detail code of the executed action should normally correspond to the action detail code of the previously requested action. |
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 |
M |
|
|
2 |
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 |
M |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
O |
|
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 |
M |
|
|
2 |
M |
Value for an action confirmation interface is always 3PL-ARCON. |
|
3 |
M |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
O |
|
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 |
M |
|
|
2 |
M |
Value for a delivery confirmation interface is always 3PL-DLYCON. |
|
3 |
M |
|
|
4 |
M |
|
|
5 |
O |
|
|
6 |
O |
|
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 |
M |
|
|
2 |
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 |
O |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
O |
|
|
7 |
M |
|
|
8 |
M |
|
|
9 |
O |
|
|
10 |
M |
|
|
11 |
M |
|
|
12 |
M |
|
|
12 |
M |
|
|
14 |
O |
|
|
15 |
O |
|
|
16 |
M |
For a delivery instruction interface, the compound code is the one of the compound where the car is set to depart. |
|
17 |
O |
||
18 |
O |
|
|
19 |
O |
|
|
20 |
O |
|
|
21 |
CustomsClearance |
O |
|
22 |
O |
Compound where the car will be delivered |
|
23 |
O |
|
|
24 |
O |
|
|
25 |
O |
||
26 |
O |
||
27 |
O |
|
|
28 |
O |
|
|
29 |
O |
|
|
30 |
O |
|
|
31 |
O |
|
|
32 |
O |
|
|
33 |
O |
YYYY-MM-DD |
|
34 |
O |
Branch to
which the car is sold |
|
35 |
O |
Where
13.20 Document has to be sent to |
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 |
M |
|
|
2 |
M |
3PL-DLYPCK |
|
3 |
M |
|
|
4 |
M |
|
|
5 |
O |
|
|
6 |
O |
|
|
7 |
M |
|
|
8 |
M |
|
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 |
M |
|
|
2 |
M |
Value for a despatch confirmation interface is always 3PL-DSPCON. |
|
3 |
M |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
O |
|
|
7 |
O |
|
|
8 |
O |
|
|
9 |
O |
YY99999 |
|
10 |
O |
License plate of the car |
|
11 |
O |
Name of the driver |
|
12 |
O |
|
|
13 |
O |
|
|
14 |
O |
YYYY-MM-DD |
|
15 |
O |
|
The customs result information interface contains the
customs related data and is sent from 3PL to Honda.
Nbr |
Name |
M/O |
Remarks |
1 |
M |
|
|
2 |
M |
Value for a customs result interface is always 3PL-CUSTRES. |
|
3 |
M |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
M |
|
|
7 |
M |
|
|
8 |
M |
|
|
9 |
M |
|
|
10 |
M |
|
|
11 |
M |
|
|
12 |
M |
|
|
13 |
M |
|
|
14 |
M |
|
|
15 |
M |
|
|
16 |
M |
|
|
17 |
M |
|
|
18 |
M |
||
19 |
M |
|
|
20 |
M |
||
21 |
M |
||
22 |
M |
|
|
23 |
M |
|
|
24 |
M |
|
|
25 |
M |
|
|
26 |
M |
|
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 |
M |
|
|
2 |
M |
3PL-LOTADD (Lot Formation), 3PL-LOTDEL (Lot Deletion) |
|
3 |
M |
|
|
4 |
M |
|
|
5 |
M |
|
|
6 |
M |
|
|
7 |
O |
||
8 |
M |
ISO
country code Char 2(ISO--3166) of Transport Means |
|
9 |
O |
||
10 |
O |
5 digits
with year as prefix (2) – YY99999 |
|
11 |
O |
YYYY-MM-DD |
|
12 |
O |
HH:MM:SS |
|
13 |
O |
||
14 |
O |
|
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 |
M |
|
|
2 |
M |
3PL-RDYDSP, 3PL-RDYCAN |
|
3 |
M |
YYYY-MM-DD |
|
4 |
M |
HH:MM:SS |
|
5 |
M |
|
|
6 |
O |
|
|
7 |
O |
||
8 |
O |
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 |
M |
|
|
2 |
M |
3PL-RDYDSP, 3PL-RDYCAN |
|
3 |
M |
YYYY-MM-DD |
|
4 |
M |
HH:MM:SS |
|
5 |
M |
|
|
6 |
O |
|
|
7 |
O |
||
8 |
O |
||
9 |
O |
Branch to which
the car is sold |
|
10 |
O |
|
|
11 |
O |
|
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 |
M |
|
|
2 |
M |
Value for a frame information interface is always 3PL-FRINF. |
|
3 |
M |
|
|
4 |
O |
|
|
5 |
O |
|
|
6 |
M |
|
|
7 |
M |
|
|
8 |
M |
|
|
9 |
M |
|
|
10 |
M |
|
|
11 |
M |
|
|
12 |
M |
|
|
13 |
M |
ISO country code Char
2(ISO--3166) |
|
14 |
M |
in kilograms |
|
15 |
M |
|
|
16 |
M |
|
|
17 |
M |
|
|
18 |
M |
|
|
19 |
M |
2D/3D/4D/5D |
|
20 |
O |
|
|
21 |
O |
|
|
22 |
O |
Incoterms (ex : FOB, CIF) |
|
23 |
O |
ISO country code Char
2(ISO--3166) of owning branch |
|
24 |
O |
|
|
25 |
O |
|
|
26 |
O |
|
|
27 |
O |
1-digit numeric Mode of
Transport code (UNECE) |
|
28 |
O |
|
|
29 |
O |
|
|
30 |
O |
|
|
31 |
O |
|
|
32 |
O |
|
|
33 |
O |
|
|
34 |
O |
|
|
35 |
O |
|
|
36 |
O |
||
37 |
O |
||
38 |
O |
||
39 |
O |
|
|
40 |
O |
|
|
41 |
O |
|
|
42 |
O |
|
|
43 |
O |
|
|
44 |
O |
|
|
45 |
O |
|
|
46 |
O |
|
|
47 |
O |
||
48 |
O |
|
|
49 |
O |
||
50 |
O |
|
|
51 |
O |
|
|
52 |
O |
||
53 |
O |
Branch to
which the car is sold |
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 |
M |
|
|
2 |
M |
Possible values : 3PL-REGCRE / 3PL-REGUPD |
|
3 |
O |
|
|
4 |
O |
|
|
5 |
O |
|
|
6 |
O |
|
|
7 |
O |
|
|
8 |
O |
|
|
9 |
O |
|
|
10 |
M |
|
|
11 |
M |
|
|
12 |
O |
|
|
13 |
O |
||
14 |
O |
||
15 |
O |
|
|
16 |
O |
|
|
17 |
O |
|
|
18 |
O |
|
|
19 |
O |
||
20 |
O |
|
|
21 |
O |
|
|
22 |
O |
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 |
M |
|
|
2 |
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 |
M |
|
|
4 |
M |
|
|
5 |
O |
|
|
6 |
O |
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 |
M |
|
|
2 |
M |
Value for a stock reconciliation interface is always 3PL-RECON. |
|
3 |
M |
|
|
4 |
O |
|
|
5 |
M |
|
|
6 |
M |
|
|
7 |
O |
Only to be filled in the stock reconciliation interface if the frame already has a delivery instruction attached to it. |
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 |
M |
|
|
2 |
M |
3PL-TRSPI |
|
3 |
M |
YYYY-MM-DD |
|
4 |
M |
HH:MM:SS |
|
5 |
O |
|
|
6 |
O |
|
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 |
M |
|
|
2 |
M |
3PL-TRPORD |
|
3 |
M |
||
4 |
M |
||
5 |
M |
|
|
6 |
M |
|
|
7 |
M |
||
8 |
M |
||
9 |
M |
|
|
10 |
O |
|
|
11 |
O |
|
|
12 |
O |
||
13 |
O |
||
14 |
O |
||
15 |
O |
||
16 |
O |
||
17 |
O |
||
18 |
O |
||
19 |
o |
Compound where the car will be delivered |
|
20 |
o |
||
21 |
o |
Branch to which the car is sold |
|
22 |
o |
Format :Date with format YYYY-MM-DD
Format :Time with format HH:MI:SS
This flag indicates wheather or not the transporter may deliver the car earlier than the agreed DAD.
Format : 1 character
Format : 25 characters
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.
The Allocation Date is the date on which a requested action should be executed.
Format : Date with format YYYY-MM-DD.
Date of arrival of a car at a compound.
Format: Date with format YYYY-MM-DD.
Time of arrival of a car at a compound.
Format: Time with format HH:MM:SS.
Valid values Y/N
·
'Y' : Deliver ASAP, regardless DAD given
·
'N' : Deliver in-line with DAD
Format : 1
characters
Format : 1 till 5 numeric digits
Format: 1 till 15 characters
Format : 3 characters
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.
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.
Format : Date with format YYYY-MM-DD
Format : 20 characters
Format :
1 till 5 numeric digits (eg. 128)
Multi purpose comment field
Format : 30 charactes
The Compound Code is a code that uniquely identifies a compound in the Honda-system.
Format: 3 characters.
The (final) destination compound.
Format : 3
characters
Compound where the repair or blocking takes place or where the car will be delivered
Format : 3 characters
ISO country code Char 2(ISO--3166) of owning branch
Format : 2 characters
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.
ISO country
code Char 2(ISO--3166)
Format : 2 characters
Format : date with format YYYY-MM-DD
Date of required arrival of a car at a dealer.
Format: Date with format YYYY-MM-DD
The Dealer Code is a code that uniquely identifies a dealer in the Honda-system.
Format: 1 till 12 characters.
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.
Format: 3 characters
Format : 3 characters
First line of the delivery address (usually of the compound or dealer) where a car has to be delivered.
Format: 1 till 35 characters.
Second line of the delivery address (usually of the compound or dealer) where a car has to be delivered.
Format: 1 till 35 characters.
City of the compound or dealer where a car has to be delivered.
Format: 1 till 35 characters.
Country of the compound or dealer where a car has to be delivered.
Format: 1 till 20 characters.
Date of delivery of a car at a compound or a dealer.
Format: Date with format YYYY-MM-DD.
Delivery Instruction Number is the unique identification of a delivery instruction in the Honda system.
Format: 11
characters.
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.
Name of the compound or dealer where a car has to be delivered.
Format: 1 till 35 characters.
Region of the compound or dealer where a car has to be delivered.
Format: 1 till 35 characters.
Time of delivery of a car at a compound or a dealer.
Format: Time with format HH:MM:SS
ZipCode of the compound or dealer where a car has to be delivered.
Format: 1 till 10 characters.
Format: 40 characters
Date of despatch of a car from a compound.
Format: Date with format YYYY-MM-DD
Time of despatch of a car from a compound.
Format: Time with format HH:MM:SS
Format : 25 characters
Format : 25 characters
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.
Defined in cubic centimetres
Format : 1 till 4 numeric digits (f.e. 9999)
Format : 35 characters
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.
Name of the
driver
Format :
1 till 20 characters
Format : 4 till 15 numeric digits (eg. 99999999999,99)
Format : 3 characters
Format : 6 till 10 numeric digits (eg 5,0001)
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
Engine Number is the unique identification number of the engine in a car.
Format: 12 characters.
The ETADate is the expected date of Arrival of the car.
Format: Date with format YYYY-MM-DD.
The EuroOption Code is a code that uniquely defines an euro-option that can be mounted on a car.
Format: 3 characters.
Date of execution of an action.
Format: Date with format YYYY-MM-DD.
Time of execution of an action.
Format: Time with format HH:MM:SS.
Format: 1 till 50 characters.
Flag indicating if customs clearance is required (Y/N)
Format: 1 character
Format: Date with format YYYY-MM-DD
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>
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.
Valid values are ‘D’/’P’
D=Diesel
P=Petrol
Format : 1 character
Format : 10 characters
Description of the HESColour of the car.
Format: 1 till 20
characters.
Format : 1 till 30 characters (eg. e11*2001/116*0255*11)
Format : 8 characters
Valid values ‘Y’/’N’
Format : 1 character
Format : 25 characters
Format : 25 characters
Format : Date with format YYYY-MM-DD
The Interior Colour Code is a code that uniquely describes the car’s interior colour.
Format: 1 till 2
characters.
The Interior Colour Description contains the car’s interior colour.
Format: 1 till 20
characters.
Format : Date with format YYYY-MM-DD
The Key Number is a number that uniquely identifies the key of the car.
Format: 1 till 14
characters.
Format : Date with format YYYY-MM-DD
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
Format : 1 till 15 characters
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.
Format : 7 character – format YY99999
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.
The License Plate contains the number of the license plate that will be put on the car.
Format: 1 till 15 characters.
Format : Date with format YYYY-MM-DD
Format : 1 till 5 numeric digits
Format : 12 characters
The Model Group Code is a code that uniquely defines the model group of the car.
Format: 1 till 20 characters.
Model Year is the year of the car model.
Format: Year with format YYYY.
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.
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>
Format : 12 characters
Format : 1 numeric position
Format : Date with format YYYY-MM-DD.
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.
Format : 1 till 30 characters
Format : 1
till 15 characters
Foramt : 5 characters
Text field containing parking information from compound operator
Format : 30 characters
The planned date on which the cars will be collected and put into a lot (Format: YYYY-MM-DD).
The code for the transport company that is planned to move the cars.
Format : 9 characters
Format : 3 till 10 numeric digits (f.e.9999999,99)
Format : 17 characters
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.
Production Date of the car.
Format: Date with format YYYY-MM-DD.
Format : 11 characters
Format : 11 characters
The number of cars that will be loaded for this lot
Format : 1 numeric position
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.
Format :
Date format YYYY-MM-DD
Format :
Time format HH:MI:SS
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.
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.
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.
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).
Format : Date format YYYY-MM-DD
Format : 1
till 30 characters
Format : 15 Characters
Format : 1 till 30 Characters
The Shipping Date is the date of shipping of the car.
Format: Date with format YYYY-MM-DD.
The Shipping Invoice Number contains the invoice number on which the car was shipped towards its destination.
Format: 12 characters.
The Shipping Unit of which the car is part of.
Format: 1 till 20 characters.
Format :
Date format YYYY-MM-DD
Format : Time format HH:MI:SS
Format : 9 characters
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.
Format : 3 characters
Format : 8 characters
Format : 3 till 12 numeric digits (f.e. 999999999,99)
The date that we receive the registration information of the car
Format : Date with format –YYYY-MM-DD
Format : 11 characters
Format : Date with format –YYYY-MM-DD
Format : 1 till 5 characters
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.
Format : 1 character
Format : 9 characters
Format : 1 character
Code of the vessel that is shipping the car.
Format: 1 till 6 characters.
Code of the vessel that is shipping the car.
Format: 1 till 36 characters.
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 -----