Transcript pres_odette_vcc

Volvo Cars EDI Demands
•
•
•
•
•
•
•
•
100% usage of EDI without a manual interference,
the business must include the following
functionality's according to Volvo´s profile of
the Odette subset of EDIFACT.
DELINS, Delivery schedules message.
Calloff, based on DELINS
SYNCRO only sequence suppliers.
AVIEXP, Advanced shipping note.
OTL, Odette transport label.
INVOIC, Self-billing message. Based on D96A
ENGDAT, Engineering model exchange with a two way capacity.
Demands and Introduction of EDI (Odette)
Date 2002-10-16
EDI
Electronic Data Interchange
•
•
•
•
Integrated application to application exchange of information
High quality of the information flow
No hands on
Standards available and developed.
Demands and Introduction of EDI (Odette)
Date 2002-10-16
Logistic EDI flow
Purchasing
SAL
MFG
Supplier
SHP
VCC-Unit
SAL = Sales Office
MFG = Manufacturing unit
SHP = Ship From Location
EDI Self Billed INVOIC
Demands and Introduction of EDI (Odette)
Date 2002-10-16
Logistic Sequence EDI Flow
Second tier
Supplier
STOACT / AVIEXP
Sequence
Supplier
VCC Unit
Self Billed INVOIC
Demands and Introduction of EDI (Odette)
Date 2002-10-16
An EDI message
UNA:+.? '
UNB+UNOA:1+SENDER LOGICAL ADDRESS:QUAL:ROUTING+
RECEIVER LOGICAL ADDRESS:QUAL:ROUTING+001219:0121+555'
UNH+1+AVIEXP:3::OD'
MID+80015449+001219:0121’
CDT+::::::5213’
SDT+::::::5213’
CSG+::::::5678+070+070’
DTR+++::::::TRP+9490016040'
ARD+9159920+70:PCE+167901234005+FR+++P03'
TCO+:123456+2+35:PCE'
NCO++S542:S543'
PVT+46++1.94'
UNT+11+1'
UNZ+1+555'
Demands and Introduction of EDI (Odette)
Date 2002-10-16
The message is built up as an envelope
and containing one or more letters
•
The envelope start with an UNB
segment and ends with an UNZ
segment telling us how many letters . In
this case one letter
•
The letter starts with an UNH segment
and ends with an UNT segment telling
us how many segments the letter
contains. In this case 11 segments
•
The UNA segments tell the application
which segment separators that shall be
used. This segment is necessary when
using the syntax identifier UNOC
UNA and UNB
UNA:+.? '
UNB+UNOA:1+SENDER LOGICAL ADDRESS:QUAL:ROUTING+
RECEIVER LOGICAL ADDRESS:QUAL:ROUTING+001219:0121+555'
UNH+1+AVIEXP:3::OD'
MID+80015449+001219:0121’
CDT+::::::5213’
SDT+::::::5213’
CSG+::::::5678+070+070’
DTR+++::::::TRP+9490016040'
ARD+9159920+70:PCE+167901234005+FR+++P03'
TCO+:123456+2+35:PCE'
NCO++S542:S543'
PVT+46++1.94'
UNT+10+1'
UNZ+1+555'
Demands and Introduction of EDI (Odette)
Date 2002-10-16
In the UNA segment you just specify
• which separates to use for UNOC
In the UNB segment you specify:
• Which key to the signs
• UNOA: As defined in ISO 646 (with the
exception of letters, lower case a to z)
• UNOB: As defined in ISO 646
• UNOC: As defined in ISO 8859-1 Latin
alphabet no. 1. You must use the UNA
segment. I.e. UNA:+.? ’
• Identification of the sender and receiver, called
logical address, qualifier and routing
• Date, time and reference to UNZ.
UNT and UNZ
UNA:+.? '
UNB+UNOA:1+SENDER LOGICAL ADDRESS:QUAL:ROUTING+
RECEIVER LOGICAL ADDRESS:QUAL:ROUTING+001219:0121+555'
UNH+1+AVIEXP:3::OD'
MID+195565+001219:0121'
CDT+::::::5213’
SDT+::::::5213’
CSG+::::::5678+070+070’
DTR+++::::::TRP+9490016040'
ARD+9159920+70:PCE+167901234005+FR+++P03'
TCO+:123456+2+35:PCE'
NCO++S542:S543'
PVT+46++1.94'
UNT+10+1'
UNZ+1+555'
Demands and Introduction of EDI (Odette)
Date 2002-10-16
In the UNT segment you specify:
• Number of segment in the message. From UNH to UNT
• The quantity delivered
• Message reference number. Shall correspond to UNH
In the UNZ segment you specify:
• Number of messages in the transmission
• The quantity delivered
• Interchange reference number. Shall correspond to UNB
Communication
OFTP Protocol
The ODETTE File Transfer Protocol (ODETTE-FTP) was defined in 1986 by
working group four of the Organisation for Data Exchange by Tele
Transmission in Europe (ODETTE) to address the electronic data
interchange (EDI) requirements of the European automotive industry.
It was designed in the spirit of the Open System Interconnection
(OSI) model utilising the Network Service provided by the CCITT X25
recommendation.
Moore information can be reach at
http://www.oftp.net/US/Default.htm
http://www.Odette.org
Demands and Introduction of EDI (Odette)
Date 2002-10-16
Physical address and Logical address
•
•
•
The Physical address is a parameter in the OFTP protocol and it is also
called SSID. This address is only used for the transmission.
The logical address is a parameter in the UNB segment in the file, used to
define the sender and the receiving part.
Volvo are using the logical addresses to rout to different units.
•
•
Example for assembly plant in Uddevalla
UNB+UNOA:1+0013000123GMBH:30:1111+094200005562320142:30:001
127+200011:1456+000100’
Example for assembly plant in Torslanda, Gothenburg
UNB+UNOA:1+0013000123GMBH:30:1111+094200005562320142:30:001
003+200011:1456+000100’
Demands and Introduction of EDI (Odette)
Date 2002-10-16
Character set
•
•
•
UNOA: As defined in ISO 646 (with the exception of letters, lower case a to z)
UNB+UNOA:1+……………………………………
UNOB: As defined in ISO 646
UNB+UNOB:1+……………………………………
UNOC: As defined in ISO 8859-1 Latin alphabet no. 1.
You must use the UNA segment. I.e. UNA:+.? ‘
UNA:+.? ‘
UNB+UNOC:1+……………………………………
Demands and Introduction of EDI (Odette)
Date 2002-10-16
Car on Line 8 days, VCC Production Plan
Call Off
Call Off
Despatch from
supplier
Transport to
VCC
Production
plan for Tu
next week
M
Tu
W
Th
Buffer Production
VCC
VCC
F
Sa
Su
Tu
M
W
Call Off
Despatch from
supplier
Production
Transport to
plan for W
VCC
next week
Tu
W
Th
Fixed plan
Demands and Introduction of EDI (Odette)
Date 2002-10-16
F
Sa
Su
Forecast
Fixed plan
M
Th
F
Sa
Su
BufferProduction
VCC VCC
M
Tu
W
Th
F
Sa
Forecast
Su
Car on Line 8 days Supplier´s view
Call Off
Call Off
Despatch from
supplier
Transport to
VCC
Production
plan for Tu
next week
M
Tu
W
Th
Buffer Production
VCC
VCC
F
Sa
Su
Tu
M
Fixed
W
Th
F
Sa
Su
Forecast
Call Off
Despatch from
supplier
Transport to
VCC
Production
plan for W
next week
M
Tu
W
Th
Fixed
Demands and Introduction of EDI (Odette)
Date 2002-10-16
F
Sa
Su
BufferProduction
VCC VCC
M
Tu
W
Forecast
Th
F
Sa
Su
Delivery Instruction message DELINS
•
Release type code
•
•
•
•
•
•
•
•
•
•
1 = Ship by
2 = Receive by
3 = In manufacturing
by
4 = Availability date at
freight distribution
centre
Article number
Order number
Previous delivery
schedule number
Reconciliation date
Accumulated deliveries
from 1/1
Previous despatch
number, date and quantity
Demands and Introduction of EDI (Odette)
Date 2002-10-16
UNB+UNOA:1+0942000055609……………..
UNH+1022821+DELINS:3::OD'
MID+200101050511+010105'
SDT+::::::12345'
BDT+::::::1003'
ARI+1+010109'
CSG+:VOLVO TORSLANDA MONTERING:::::1003+TVV+TVV'
ARD+3533836++187916226005'
PDI+200012290456'
SAD+1'
DST+010105+:80'
PDN+25117121:010103+80:80'
PDN+25116023:001219+39:39'
PDN+25114740:001211+40:40'
DEL+010109:0000+0::3:1'
DEL+010119:0900+40:::4'
DEL+010126:0900+40:::4'
DEL+010221:0900+40:::4'
DEL+010315:0900+40:::4'
DEL+010405:0900+40:::4'
DEL+010503:0900+40:::4'
DEL+010523:0900+40:::4'
DEL+010621:0900+40:::4'
DEL+010802:0900+40:::4'
DEL+010816:0900+8:::4'
- -
•
•
•
Creation date
Effective from date
Instruction update action
code
•
•
1 = Replace preceding
delivery plan
Delivery details
•
•
•
•
•
Date
time
quantity
Delivery instruction
reasoned
•
3 = Back order
Schedule status indicator
•
•
•
•
•
1 = Firm order
2 = Fabrication
3 = raw material only
4 = Forecast
9 = Amendment
Delivery Instruction message CALLOFF
•
Release type code
•
•
•
•
•
•
•
•
•
•
1 = Ship by
2 = Receive by
3 = In manufacturing
by
4 = Availability date at
freight distribution
centre
Article number
Order number
Previous delivery
schedule number
Reconciliation date
Accumulated deliveries
from 1/1
Previous despatch
number, date and quantity
Demands and Introduction of EDI (Odette)
Date 2002-10-16
UNB+UNOA:1+0942000055609……………..
UNH+1022827+DELINS:3::OD'
MID+200101050505+010105'
SDT+::::::12345'
BDT+::::::1003'
ARI+1+010109:010219'
CSG+:VOLVO TORSLANDA MONTERING:::::1003+TVV+TVV'
ARD+9470016++190910117005'
PDI+200012140558'
SAD+2'
DST+010105+:1920'
PDN+101704:010104+600:600'
PDN+101703:010103+720:720'
PDN+101702:010102+600:600'
DEL+010109:0000+1320::3:1'
DEL+010109:0600+600:::4'
DEL+010110:0600+720:::4'
DEL+010111:0600+720:::4'
DEL+010112:0600+600:::4'
DEL+010115:0600+720:::4'
DEL+010116:0600+720:::4'
DEL+010117:0600+600:::4'
DEL+010118:0600+720:::4'
DEL+010119:0600+720:::4'
DEL+010122:0600+600:::4’
- - -
•
•
•
Creation date
Effective date
•
•
Instruction update action
code
•
•
From
To
2 = Change of delivery
schedule
Delivery details
•
•
•
•
•
Date
time
quantity
Delivery instruction
reasoned
•
3 = Back order
Schedule status indicator
•
•
•
•
•
1 = Firm order
2 = Fabrication
3 = raw material only
4 = Forecast
9 = Amendment
Despatch advice, AVIEXP
•
•
•
Consignor
Seller
Consignee
•
•
•
•
Number
Final delivery point
Additional delivery
point
Packages Identification
numbers
•
•
Transport label
number
Weight and Volume,
Totals
•
•
Consignment gross
weight
Consignment Cube
Demands and Introduction of EDI (Odette)
Date 2002-10-16
UNH+1+AVIEXP:3::OD'
MID+195565+001219:0121'
CDT+::::::5213’
SDT+::::::5213’
CSG+::::::5678+070+070’
DTR+++::::::TRP+9490016040'
ARD+9159920+70:PCE+167901234005+FR'
TCO+:123456+2+35'
NCO++S542:S543'
PVT+46++1.94'
UNT+10+1'
UNZ+1+555'
•
•
•
Data on Transport
•
Code for actual carrier
Article details
•
•
•
•
Article number
Quantity delivered
order number
Country of origin
Type of packages
•
•
•
Package reference
number provided by Volvo
Transport. If not known
insert NIL
Number of packages
quantity per packages
Odette reference for simplified handling unit. Pallet with
frames.
AVIEXP
ARD+Article Number+Quantity Delivered:PCE+Order Number+Country of origin’
TCO+:Package reference number+Number of Packages+Quantity of articles in package:PCE’
NCO++Shipping marks:Shipping marks'
ARD+8619537+256:PCE+143914647005+BE’
TCO+:212034+2+128:PCE’
NCO++S123:S124'
S123
S124
In a pallet containing one article
number, there shall be one S-label
on each pallet
Demands and Introduction of EDI (Odette)
Date 2002-10-16
(ARD
(ARD
(ARD
(ARD
(TCO
(TCO
(TCO
(NCO
7304)
6270)
1022)
3239)
1906)
7224)
6853)
7102)
Article Number
Quantity Delivered
Order Number
Country of origin
Package reference number
Number of Packages
Quantity of articles in package
Shipping marks
Odette reference for homogenous handling unit.
Small boxes containing the same article number.
16 Small Boxes in total
S11
S12
S13
S14
S15
S16
S17
M191
S18
A pallet, with small boxes, containing one
article number. There shall be one S-label
on each box and a M-label on the pallet.
Demands and Introduction of EDI (Odette)
Date 2002-10-16
AVIEXP
ARD+Article Number+Quantity Delivered:PCE+Order Number+Country of origin’
TCO+:Package reference number+Number of Packages+Quantity of articles in package:PCE’
NCO+Shipping marks+Shipping marks:Shipping marks'
ARD+8619537+2048:PCE+143914647005+BE’
TCO+:225598+16+128:PCE’
NCO+M191+S11:S12:S13:S14:S15:S16:S17:1S8:S19:S20:S21:S22:S23:S24:S25:S26’
(ARD
(ARD
(ARD
(ARD
(TCO
(TCO
(TCO
(TCO
(NCO
7304)
6270)
1022)
3239)
1906)
7224)
6853)
7246)
7102)
Article Number
Quantity Delivered
Order Number
Country of origin
Package reference number
Number of Packages
Quantity of articles in package
Transport Label Number (M or G)
Shipping marks
Odette reference for mixed handling unit.
Blue boxes containing different article number.
16 Small Boxes in total
S110
S111
S112
S113
S114
S115
S116
G123
S117
A pallet, with small boxes, containing
more than one article number, there
shall be one S-label on each box and
a G-label on the pallet
Demands and Introduction of EDI (Odette)
Date 2002-10-16
AVIEXP
ARD+Article Number+Quantity Delivered:PCE+Order Number+Country of origin’
TCO+:Package reference number+Number of Packages+Quantity of articles in package:PCE’
NCO+Shipping marks+Shipping marks:Shipping marks’
ARD+8626343+64:PCE+161905281005+BE’
TCO+:100780+8+8'
NCO+G123+S110:S111:S112:S113:S114:S115:S116:S117'
ARD+8626344+64:PCE+161905281005+BE'
TCO+:100780+8+8'
NCO+G123+S118:S119:S120:S121:S122:S123:S124:S125'
(ARD
(ARD
(ARD
(ARD
(TCO
(TCO
(TCO
(TCO
(NCO
7304)
6270)
1022)
3239)
1906)
7224)
6853)
7246)
7102)
Article Number
Quantity Delivered
Order Number
Country of origin
Package reference number
Number of Packages
Quantity of articles in package
Transport Label Number (M or G)
Shipping marks
Example and reference to an Odette label.
DELINS - CSG 3036
DELINS - CSG 3923
AVIEXP - CSG 3923
AVIEXP - MID 1004
DELINS - ARD 7304
AVIEXP - ARD 7304
AVIEXP - TCO 6853
DELINS - SDT 3296
AVIEXP - CDT/SDT 3296
AVIEXP - ARD 7860*
AVIEXP - NCO 7102/7246
*=special agreements
Demands and Introduction of EDI (Odette)
Date 2002-10-16