210 likes | 735 Views
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
E N D
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.
EDIElectronic Data Interchange • Integrated application to application exchange of information • High quality of the information flow • No hands on • Standards available and developed.
Logistic EDI flow Purchasing Orders Agreements Supplier SAL Orders Data file MFG DELFOR / Call-off Manual SHP-routine SHP DESADV Goods / Labels VCC-Unit SAL = Sales Office MFG = Manufacturing unit SHP = Ship from location EDI Self Billed INVOIC
Logistic Sequence EDI Flow Second tier Supplier DELFOR copy STOACT/DESADV Sequence Supplier DEFOR / Calloff Shipment DELJIT / SYNCRO VCC Unit Self Billing INVOIC
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' 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' • 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' • 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
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 UddevallaUNB+UNOA:1+0013000123GMBH:30:1111+094200005562320142:30:001127+200011:1456+000100’ • Example for assembly plant in Torslanda, GothenburgUNB+UNOA:1+0013000123GMBH:30:1111+094200005562320142:30:001003+200011:1456+000100’
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 646UNB+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+……………………………………
Call Off Call Off Despatch from supplier Production plan for Tu next week Transport to VCC Production VCC Buffer VCC M Tu Tu W Th F Sa Su M W Th F Sa Su Forecast Fixed plan Call Off Despatch from supplier Production plan for W next week Transport to VCC Production VCC Buffer VCC W Tu M W Th F Sa Su M Tu Th F Sa Su Forecast Fixed plan Car on Line 8 days, VCC Production Plan
Call Off Call Off Despatch from supplier Production plan for Tu next week Transport to VCC Production VCC Buffer VCC M Tu Tu W Th F Sa Su M W Th F Sa Su Fixed Forecast Call Off Despatch from supplier Production plan for W next week Transport to VCC Production VCC Buffer VCC W Tu M W Th F Sa Su M Tu Th F Sa Su Fixed Forecast Car on Line 8 days Supplier´s view
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 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 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' - -
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 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 Delivery Instruction message DELFOR (Calloff) 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' - -
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 • 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 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’
S123 S124 EDIFACT reference for simplified handling unit. Pallet with frames DESADV 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’ EXAMPLE 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’ In a pallet containing one article number, there shall be one S-label on each pallet (LIN 7140) Article Number (PAC 7065) Package reference number(QTY 6060) Quantity Delivered (PAC 7224) Number of Packages(RFF 1154) Reference Number (QTY 6060) Quantity of articles in package (ALI 3239) Country of origin (GIR 7402) Shipping marks
S11 S12 M191 S13 S14 8 Small Boxes in total EDIFACT reference for homogenous handling unit.Small boxes containing the same article number DESADV 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’ -- EXAMPLE 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 7140) Article Number (PAC 7065) Package reference number(QTY 6060) Quantity Delivered (PAC 7224) Number of Packages(RFF 1154) Reference Number (QTY 6060) Quantity of articles in package (ALI 3239) Country of origin (GIR 7402) Shipping marks
S111 S112 G123 S113 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 EDIFACT reference for mixed handling unit. Small boxes containing different article number DESADVCPS+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+++ArticleNumber: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’-- (LIN 7140) Article Number (QTY 6060) Quantity Delivered (RFF 1154) Reference Number (ALI 3239) Country of origin (PAC 7065) Package reference number(PAC 7224) Number of Packages (QTY 6060) Quantity of articles in package (GIR 7402) Shipping marks
Example and reference to an Odette label DELFOR - LOC 3225 (159) DESADV - LOC 3225 (159) DELFOR - NAD 3036 - (CN) DESADV - BGM 1004 DELFOR- LIN 7140 (IN) DESADV - LIN 7140 (IN) DESADV - QTY 6060 (52) DESADV - PIA 7140* DELFOR - NAD 3039 (SE) DESADV - NAD 3039 (CZ) DESADV - RFF 1154 GIR 7402 *=special agreements