Transcript pres_edifact_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.
DELFOR, Delivery schedules message.
Calloff, based on DELFOR
DELJIT only sequence suppliers.
DESADV, Advanced shipping note.
OTL, Odette transport label.
INVOIC, Self-billed message
ENGDAT, Engineering model exchange, Odette message.
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
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 (EDIFACT)
Date 2001-01-05
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 (EDIFACT)
Date 2001-01-05
Logistic Sequence EDI Flow
Second tier
Supplier
STOACT/DESADV
Sequence
Supplier
VCC Unit
Self Billing INVOIC
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
An EDI message
UNA:+.?
UNB+UNOA:1+SENDER LOGICAL ADDRESS:QUAL:ROUTING+RECEIVER
LOGICAL ADDRESS:QUAL:ROUTING+001219:0121+555’
UNH+0001+DESADV:D:96A:UN:A01051’
BGM+351+0000016487’
DTM+137:200101081121:203’
RFF+AAS:1268751110’
NAD+CZ+12345::92’
NAD+CN+1003::92’
LOC+11+TVV::92’
NAD+CA+BILSPED::92’
CPS+1++1’
PAC+2++L4::92’
QTY+52:24:PCE’
PCI+17+++S::92’
GIR+3+193712:ML’
GIR+3+193713:ML’
LIN+1++1234567:IN’
QTY+12:48:PCE’
RFF+ON:123918040005’
UNT+18+0001’
UNZ+1+555'
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
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 18 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+0001+DESADV:D:96A:UN:A01051’
BGM+351+0000016487’
DTM+137:200101081121:203’
RFF+AAS:1268751110’
NAD+CZ+12345::92’
NAD+CN+1003::92’
LOC+11+TVV::92’
NAD+CA+BILSPED::92’
CPS+1++1’
PAC+2++L4::92’
QTY+52:24:PCE’
PCI+17+++S::92’
GIR+3+193712:ML’
GIR+3+193713:ML’
LIN+1++1234567:IN’
QTY+12:48:PCE’
RFF+ON:123918040005’
UNT+18+0001’
UNZ+1+555'
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
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+0001+DESADV:D:96A:UN:A01051’
BGM+351+0000016487’
DTM+137:200101081121:203’
RFF+AAS:1268751110’
NAD+CZ+12345::92’
NAD+CN+1003::92’
LOC+11+TVV::92’
NAD+CA+BILSPED::92’
CPS+1++1’
PAC+2++L4::92’
QTY+52:24:PCE’
PCI+17+++S::92’
GIR+3+193712:ML’
GIR+3+193713:ML’
LIN+1++1234567:IN’
QTY+12:48:PCE’
RFF+ON:123918040005’
UNT+18+0001’
UNZ+1+555'
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
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 (EDIFACT)
Date 2001-01-05
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 route a message to a specific unit.
•
•
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 (EDIFACT)
Date 2001-01-05
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 (EDIFACT)
Date 2001-01-05
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 (EDIFACT)
Date 2001-01-05
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 (EDIFACT)
Date 2001-01-05
F
Sa
Su
BufferProduction
VCC VCC
M
Tu
W
Forecast
Th
F
Sa
Su
Delivery Instruction message DELFOR
•
•
•
Action request
•
•
3 = Change
4 = Amendment
Date
•
•
51 = Cumulative
257 = Calculation date
Quantity details
•
•
•
•
•
•
12 = Despatch
quantity
48 = Received
quantity
70 = Cumulative
73 = Outstanding
quantity
83 Back order quantity
113 = Quantity to be
delivered
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
UNH+988957+DELFOR:D:96A:UN:A09040'
BGM+241+200012140606'
DTM+137:20001214:102'
DTM+157:20001218:102'
NAD+BY+1011149::91'
NAD+SE+402::92'
UNS+D'
NAD+CN+1003::92++VOLVO TORSLANDA MONTERING'
LIN++3+3539690:IN'
LOC+11+005'
LOC+159+TVV'
DTM+257:20001214:102'
DTM+51:20000101:102'
RFF+ON:171900402005'
RFF+AIF:200011090657'
QTY+70:268250'
QTY+12:1450'
QTY+48:1450'
RFF+AAK:7011670'
DTM+171:20001212:102'
QTY+83:4350'
QTY+113:1450'
SCC+4'
DTM+2:20001219:102'
- -
•
•
•
•
•
•
•
•
Validity date
Article number
Place location qualifier
Order number
Previous delivery instruction
number
Despatch advice number
•
•
•
Despatch quantity
Received quantity
Date
Scheduling conditions
•
•
•
•
•
1 = Firm order
2 = Fabrication
3 = raw material only
4 = Forecast
9 = Amendement
Delivery date
Delivery Instruction message DELFOR (Calloff)
•
•
•
Action request
•
•
3 = Change
4 = Amendment
Date
•
•
51 = Cumulative
257 = Calculation date
Quantity details
•
•
•
•
•
•
12 = Despatch
quantity
48 = Received
quantity
70 = Cumulative
73 = Outstanding
quantity
83 Back order quantity
113 = Quantity to be
delivered
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
UNH+1014456+DELFOR:D:96A:UN:A09040'
BGM+241+200101021444'
DTM+137:20010102:102'
DTM+157:20010104:102'
DTM+36:20010401:102'
NAD+BY+1003::91'
NAD+SE+12345::92'
UNS+D'
NAD+CN+1003::92++VOLVO TORSLANDA MONTERING'
LIN++3+8622896:IN'
LOC+11+TVV'
LOC+159+TVV'
DTM+257:20010102:102'
DTM+51:20010101:102'
RFF+ON:171910087005'
RFF+AIF:200012140558'
QTY+70:0'
QTY+83:48'
QTY+113:48'
SCC+4'
DTM+2:20010226:102'
QTY+113:48'
SCC+4'
DTM+2:20010307:102'
QTY+113:96'
SCC+4'
DTM+2:20010314:102'
- -
•
•
•
•
•
•
•
•
Validity date
Expire date
Article number
Place location qualifier
Order number
Previous delivery instruction
number
Scheduling conditions
•
•
•
•
•
1 = Firm order
2 = Fabrication
3 = raw material only
4 = Forecast
9 = Amendment
Delivery date
Despatch advice message, DESADV
•
•
•
•
•
•
•
•
Place of discharge
Packaging level
•
•
1 = Inner
2 = Outer
Number of packages
Type of packages
Marking/label number
Article number
Despatch quantity
Order number
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
UNH+0001+DESADV:D:96A:UN:A01051’
BGM+351+0000016487’
DTM+137:200101081121:203’
RFF+AAS:1268751110’
NAD+CZ+12345::92’
NAD+CN+1003::92’
LOC+11+TVV::92’
NAD+CA+BILSPED::92’
CPS+1++1’
PAC+2++L4::92’
QTY+52:24:PCE’
PCI+17+++S::92’
GIR+3+193712:ML’
GIR+3+193713:ML’
LIN+1++1234567:IN’
QTY+12:48:PCE’
RFF+ON:123918040005’
LOC+159+TVV::92'
UNT+18+0001’
•
•
•
•
•
•
•
•
Transport document number
Consignor
Consignee
Carrier
Order number
Quantity
•
52 = Quantity per pack
Type of marking
•
•
•
G = Mixed handling unit
M = Homogeneous handling
unit
S = Simplified handling unit
Additional Internal Destination
EDIFACT reference for simplified handling unit. Pallet
with frames
S123
S124
In a pallet containing one article
number, there shall be one S-label
on each pallet
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
DESADV
EXAMPLE
CPS+1++1’
PAC+ Number of Packages ++Package reference number::92’
QTY+52:Quantity of articles in package:PCE'
PCI++++S::92'
GIR+3+Shipping marks:ML++0:BX’
GIR+3+Shipping marks:ML++0:BX’
LIN+1++Article Number:IN++0'
QTY+12:Quantity Delivered:PCE'
ALI+Country of origin'
RFF+ON:Order Number’
CPS+1++1’
PAC+2++212034::92’
QTY+52:128:PCE'
PCI++++S::92'
GIR+3+123:ML++0:BX’
GIR+3+124:ML++0:BX’
LIN+1++8619537:IN++0'
QTY+12:256:PCE'
ALI+BE'
RFF+ON:143914647005’
(LIN
(QTY
(RFF
(ALI
7140)
6060)
1154)
3239)
Article Number
Quantity Delivered
Reference Number
Country of origin
(PAC
(PAC
(QTY
(GIR
7065)
7224)
6060)
7402)
Package reference number
Number of Packages
Quantity of articles in package
Shipping marks
EDIFACT reference for homogenous handling unit.
Small boxes containing the same article number
S11
S12
S13
M191
S14
8 Small Boxes in total
DESADV
EXAMPLE
CPS+1++1’
PAC+Number of Packages++Package reference number::92’
QTY+52:Quantity of articles in package:PCE’
PCI++++M::92’
RFF+AAT:Master Label number’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
LIN+1++Article Number:IN++0'
QTY+12:Quantity Delivered:PCE'
ALI+Country of origin'
RFF+ON:Order Number’
--
CPS+1++1’
PAC+8++225598::92’
QTY+52:128:PCE’
PCI++++M::92’
RFF+AAT:191’
GIR+3+11:ML’
GIR+3+12:ML’
GIR+3+13:ML’
GIR+3+14:ML’
GIR+3+15:ML’
GIR+3+16:ML’
GIR+3+17:ML’
GIR+3+18:ML’
LIN+1++8619537:IN++0'
QTY+12:1024:PCE'
ALI+BE'
RFF+ON:143914647005’
--
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. (LIN
(QTY
(RFF
(ALI
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
7140)
6060)
1154)
3239)
Article Number
Quantity Delivered
Reference Number
Country of origin
(PAC
(PAC
(QTY
(GIR
7065)
7224)
6060)
7402)
Package reference number
Number of Packages
Quantity of articles in package
Shipping marks
EDIFACT reference for mixed handling unit.
Small boxes containing different article number
S111
S112
S113
G123
S114
8 Small Boxes in total
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
(LIN
(QTY
(RFF
(ALI
(PAC
(PAC
(QTY
(GIR
7140)
6060)
1154)
3239)
7065)
7224)
6060)
7402)
Article Number
Quantity Delivered
Reference Number
Country of origin
Package reference number
Number of Packages
Quantity of articles in package
Shipping marks
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05
DESADV
CPS+1++1’
PAC+Number of Packages++Package reference number::92’
QTY+52:Quantity of articles in package:PCE’
PCI++++G::92’
RFF+AAT:Master Label number’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
LIN+++Article Number:IN++0'
QTY+12:Quantity Delivered:PCE'
ALI+Country of origin'
RFF+ON:Order Number’
CPS+2++1’
PAC+Number of Packages++Package reference number::92’
QTY+52:Quantity of articles in package:PCE’
PCI++++G::92’
RFF+AAT:Master Label number’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
GIR+3+Shipping marks:ML’
LIN+++Article Number:IN++0'
QTY+12:Quantity Delivered:PCE'
ALI+Country of origin'
RFF+ON:Order Number’
--
EXAMPLE
CPS+1++1’
PAC+4++100780::92’
QTY+52:8:PCE’
PCI++++G::92’
RFF+AAT:123’
GIR+3+111:ML’
GIR+3+112:ML’
GIR+3+113:ML’
GIR+3+114:ML’
LIN+++8626343:IN++0'
QTY+12:32:PCE'
ALI+BE'
RFF+ON:161905281005’
CPS+2++1’
PAC+4++100780::92’
QTY+52:8:PCE’
PCI++++G::92’
RFF+AAT:123’
GIR+3+115:ML’
GIR+3+116:ML’
GIR+3+117:ML’
GIR+3+118:ML’
LIN+++8626344:IN++0'
QTY+12:32:PCE'
ALI+BE'
RFF+ON:161905281005’
--
Example and reference to an Odette label
DELFOR - NAD 3036 - (CN)
DELFOR - LOC 3225 (159)
DESADV - LOC 3225 (159)
DESADV - BGM 1004
DELFOR- LIN 7140 (IN)
DESADV - LIN 7140 (IN)
DESADV - QTY 6060 (52)
DELFOR - NAD 3039 (SE)
DESADV - NAD 3039 (CZ)
DESADV - PIA 7140*
DESADV - RFF 1154
GIR 7402
*=special agreements
Demands and Introduction of EDI (EDIFACT)
Date 2001-01-05