EDI Transmission Guidelines - Florens

Transcription

Florens EDI Transmission Guidelines (April 2008)EDI is a standard communication protocol for system-to-system integration of Florenswith depots. In container leasing or related transportation industry, depots can set up EDIwith their customers to submit and receive container movement and MNR informationelectronically.Standard EDI MessagesFlorens accepts a standardized EDI integration process. We support CEDEX andUN/EDIFACT message standards.Message FormatsFlorens' EDI message format are widely adopted market standard (UN/EDIFACT andCEDEX) for system-to-system integration for container Gate-In, Gate-Out and MNRestimate details. Other message formats which acceptable by Florens system includecustomized flat file provided by depots.Transmission ProtocolsThe Simple Mail Transfer Protocol (SMTP) is the email communication protocol whichFlorens uses for capturing EDI messages directly from depots as email attachments.Methods of sending EDI files to Florens(1) Prepare your EDI filesThe EDI file extension must be in either one of below listed 3 types. It should begenerated by Win Bridge or depots’ in-house system. txt imp expFor CEDEX flat file format, there may be maximum FOUR attachments in oneemail, the GATEIN, GATEOUT, WESTIM and WESTIMDT. The file name formathas to be renamed as below convention.GATEIN:GATEOUT:WESTIM:WESTIMDT:DDDDDD GATEIN XXXXXXXX EXPDDDDDD GATEOUT XXXXXXXX EXPDDDDDD WESTIM XXXXXXXX EXPDDDDDD WESTIMDT XXXXXXXX EXP

Where DDDDDD is the depot code assigned by Florens, XXXXXXXX is depot’s ownreference for the file name.For examples:GATE IN: USNYC1 GATEIN XYZABC . EXPGATEOUT: USNYC1 GATEOUT XYZABC . EXPWESTIM:USNYC1 WESTIM XYZABC . EXPWESTIMDT: USNYC1 WESTIMDT XYZABC . EXPFor EDIFACT format, the file name format has to be renamed as below convention.DDDDDEDI FACT XYZABC. TXTDDDDDDEDI FACTXYZABCTXT depot code assigned by Florens (e.g. USNYC1) definition of the file type depot's own reference of the file file extensionFor example:USNYC1 EDIFACT 31DEC2005 .txt(2)Prepare an email with the subject line shows: FLORENS DIRECT EDI(3)Insert the EDI files as email attachment.(4) Send the email to Florens email address: EDIManager@florens.com aftercompleting the test. See below for testing EDI transmission with Florens.Procedures for Testing New Depots/Messages Before TestingFlorens local office will send to depot EDI Transmission Guidelines so thatthey are aware our EDI requirements.FLORENS local office should ensure that the depot’s EDI address code is in thesystem. Test Procedures:The type of the EDI file must be either in EDIFACT format or CEDEX flat fileformat.1. Depot should send an email with EDI file as attachments. to EDITest@florens.com.2. The subject line of the email must be Florens Direct EDI.

3. Rename your EDI files as mentioned previously and send to us asattachments by email.4. Florens local office will inform depot of the status of the test messages.5. Coordinate with the depot when to begin production.NOTE: Send all gate activity and status changes by the end of each working day.Estimates and revisions may be sent the following day.Please note that the EDI transmission will fail if the depots use ZZZ and ZZ forcomponent and repair codes. They will be notified via email to use correct code. THISVALIDATION IS FOR DRY VANS ONLY.Sample of email attaching with EDI files to be sent by depot to Florens system.edimanager@florens.comSubject line mustbe:FLORENSDepot is allowed tosend maximumFOUR attachments

Validation of incoming EDI files from depotsFlorens’ system will perform a wide range of validation to all incoming EDT messagessending by depots; instant update will be performed if no errors found. Otherwise, depotshave to respond to the instruction delivered by Florens’ system for appropriate actions.Sample of acknowledgement routing back depot to confirm receipt of EDI messages.Florens system willacknowledge thereceipt of depots'EDT files by sendingFlorens system willstamp the date andtime depots EDTfiles being accepted.After validationFlorens system willshow number ofEDT line detailFlorens system willlist the name of EDTfiles being accepted.

Sample of email notifying depot for amendment of EDI email subject line.After validation byFlorens system,notification will begiven to depot for

Sample of email notifying depot for amendment of MNR line items.Florens system willverify EDT filecontent and adviseerrors if any.Estimate line itemsare required toamend and resend.

Florens EDI Required SpecificationFor helping depot in translation of which pieces of information are mandatory for Florens’ system,below (EDI) specification is a set of standard structuring information that is to be electronicallyexchanged.GATEIN / GATEOUTCEDEX FieldEDIFACT FieldPOSWIDTHDESCRIPTION38Date message sent5 REC DATE13 ADVICE1262814Date message receivedACCEPTANCE ADVICE number1476415 UNIT ID N80616 UNIT ID C861e.g.: 1 - check digit17 EQUIP TYPE873CON, CHZ or GEN20 CONDITION12410Text description e.g.: DAMAGED21 COMP ID A1344Companion Unit Prefix22 COMP ID N1386Companion Unit Number23 COMP ID C1441Companion Unit Check-Digit27 EIR DATE1828Date of EIR (YYYYMMDD)#NAME3 SENT DATEUNIT ID Ae.g.: CONU – prefixCE/DE ref#UNBS004 0017RFF BNRFF ACCRFF RELEQD CNEQFC274 1154C274 1154C271 8114e.g.: 123456 - unit number29 REFERENCE46 DPT TRM195305359Customer ReferenceDepot Code52 NOTE35170Free Text53 NOTE42170Free Text60 REVISION5401Revision number of EIR82 COMP ID A29864Companion Unit Number83 COMP ID N29906Companion Unit Number84 COMP ID C29961Companion Unit Number** TotalSegmentTag1384 – GI / 1419 - GOEQFSTECI(1 DE)8521 8521DTM ATRC033 2001UNH0068 0068UNBNAD MSNAD LEDTXTS002 '0004C082 30390078 0078UNHS010 0070

WESTIMCEDEX FieldEDIFACT Field#NAMEPOSWIDTH512REC on number of estimateESTIM DATE16UNIT ID A724e.g.: CONU – prefix17UNIT ID N766e.g.: 123456 - unit number18UNIT ID C821e.g.: 1 - check digit20EQUIP TYPE1183CON, CHZ or GEN28CONDITION19410Condition at time of redelivery40DPT TRM2759Depot Code47NOTE 132170Free Text48NOTE239170Free Text49NOTE346170Free Text50BAS CURR5313Base currency for estimates51LABOR RATE53412,2Labor rateDate of estimate52DPP CURR5463Currency for DPP58U LABOR57710,2Labor cost for USER/LESSEE59U MATERIAL58710,2Material cost for USER/LESSEE61U TAX60710,2Tax for USER/LESSEE63I LABOR62710,2Labor cost for INSURER (DPP)64I MATERIAL63710,2Material cost for INSURER (DPP)66I TAX65710,2Tax for INSURER (DPP)68O LABOR67710,2Labor cost for OWNER/LESSOR69O MATERIAL68710,2Material cost for OWNER/LESSOR71O TAX70710,2Tax for OWNER/LESSOR78S LABOR77710,2Special billing labor cost for SURVEYORS MATERIAL78710,281S TAX80710,2Special billing material cost for SURVEYORSpecial billing tax for SURVEYOR89ADVICE88714Acceptance Advice Number91AUTH NUM91514Work Authorization Number92AUTH AMT92910,2Work Authorization Amount94AUTH DATE9488Approval Date95O ESTIM DATE9568CE/DE ref#Date receivedEstimate Number(Match this field with TRNSXN in WESTIMDT)1579SegmentTagOriginal Date of EstimateUNH0062UNHS010 0070RFF ESTC033 2001EQFC271 8114EQF(1 DE)8521ECINAD LEDTXTACA STDSTC082 303900786345LBR8578ACA DPP6345CTO U5536CTO U5537CTO U5538CTO I5536CTO I5537CTO I5538CTO O5536CTO O5537CTO O5538CTO S5536CTO S5537CTO S5538RFF ACCC274 1154RFF AUTC274 1154TMA5492RFF AUTC033 2001RFF ESTC033 2001

WESTIMDTCEDEX FieldEDIFACT ONESTIMATE number(Match this field with TRNSXN in WESTIM)Revision number7ESTIM DATE348Date of document8UNIT ID A424e.g.: CONU – prefix9UNIT ID N466e.g.: 123456 - unit number10UNIT ID C521e.g.: 1 - check digit13LINE1172Line item number14REPAIR1192Repair code15REPEATS1213Quantity - number of damages16DAMAGE1242Damage code17COMPONENT1263Component code18COMP MATL1292Component material19LOCATION1314Location code20LENGTH1358,2Length dimension21WIDTH1438,2Width dimension22HEIGHT1518,2Height dimension23DT UNITS1593Unit of measure24HOURS1626,2Hours for line item25SCALE1682Work scale (05,10,15, etc.)26MAT COST17015,2Line item material cost27DT PTY RSPONS1851Party responsible for line itemSegmentTagUNHCE/DE ref#0062UNHS010 0070RFF ESTC033 2001EQFC271 522WORC858 6168WORC858 6140WORC858 6008WORC858 6410COS5533COS8531COS5534COS3535

Florens required Condition Code & ExplanationACTIVITYGate InOriginal Estimate/All estimates onbehalf of depotLessee Survey OnlyLessor Survey OnlyFully Approved & Surveyed By Lessor& LesseeLessee Survey with AuthorizationLessor Survey with AuthorizationLessee Authorization OnlyFully ApprovedRepair (gate in message)Gate OutGate In(Cosco Resale units only)Gate OutConditionCodeCondition Column in EDIRPT“A” or “D”A available, D damaged“D”D Damaged“E”E Lessee/User Surveyed“L”L Lessor/Owner Surveyed“K”K Owner/User Surveyed and approved“G”G Lessee/User Surveyed with Authorization“H”H Lessor Surveyed with Authorization“F”F Lessee Authorization Only“J”J Approved by Lessor and Lessee“C”R Repairs Completed“A”A available“X”X To be disposed“S”S SoldAcceptable ISO and Non-ISO MNR codesFlorens prefers and supports the use of the recommended IICL EDIS codes as shownon the IICL TB002 document. However Florens system will accept the location,component, damage and repair, ISO and non-ISO codes shown on this document tomeet industry practices. Florens depots should not use codes other than the ones listedon this document since our system validates the corresponding data. Please contactFlorens office in case you would like to propose the addition of new codes to our table.(Please refer to document ISO & Non ISO MNR Codes.pdf )

ISO & Non ISO M NR Codes.xlsLocation codeShort MVMXMZNBNCNENFNGNHNKNLNNNPNRNTNVNXFloor BottomFloor LowerFloor UpperFloor LeftFloor RightFloor TopFloor WholeDoor BottomDoor LowerDoor UpperDoor LeftDoor RightDoor TopDoor EndExterior BottomExterior LowerExterior UpperExterior LeftExterior RightExterior TopExterior WholeFront End BottomFront End LowerFront End UpperFront End LeftFront End RightFront End TopFront End WholeInterior BottomInterior LowerInterior UpperInterior LeftInterior RightInterior TopInterior WholeLeft Side BottomLeft Side LowerLeft Side UpperLeft Side LeftLeft Side TopLeft Side WholeRfr CntrRfr ElecRfr FramRfr CndsRfr UnspRfr PipeUns CompRfr EvapRfr WhleRfr MiscUns BttmUns CndsUns ElecUns CndsUns BttmUns TopUns CndsUns LeftUns CndsUns CndsUns RghtUns TopUns CndsUns WhleLong NameFloor BottomFloor LowerFloor UpperFloor LeftFloor RightFloor TopFloor WholeDoor Bottom HalfDoor Lower ComponentDoor Upper ComponentDoor Left HalfDoor Right HalfDoor Top HalfEntire doorExterior BottomExterior LowerExterior UpperExterior LeftExterior RightExterior TopExterior WholeFront End BottomFront End LowerFront End UpperFront End LeftFront End RightFront End TopFront End WholeInterior BottomInterior LowerInterior UpperInterior LeftInterior RightInterior TopInterior WholeLeft Side BottomLeft Side LowerLeft Side UpperLeft Side LeftLeft Side TopLeft Side Wholelocation code

ISO & Non ISO M NR Codes.xlsLocation codeShort nameLong THTLTRTTTXUns CndsRight Side BottomRight Side LowerRight Side UpperRight Side RightRight Side TopRight Side WholeUnderstructure BottomUnderstructure LowerUnderstructure UpperUnderstructure LeftUnderstructure RightUnderstructure TopUnderstructure WholeWhole Container BottomWhole Container LowerWhole Container UpperWhole Container LeftWhole Container RightWhole Container TopWhole ContainerRoof/Top BottomRoof/Top LowerRoof/Top UpperRoof/Top LeftRoof/Top RightRoof /Top TopRoof /Top WholeRight Side BottomRight Side LowerRight Side UpperRight Side RightRight Side TopRight Side WholeUnderstructure BottomUnderstructure LowerUnderstructure UpperUnderstructure LeftUnderstructure RightUnderstructure TopUnderstructure WholeWhole Container BottomWhole Container LowerWhole Container UpperWhole Container LeftWhole Container RightWhole Container TopWhole ContainerRoof/Top BottomRoof/Top LowerRoof/Top UpperRoof/Top LeftRoof/Top RightRoof /Top TopRoof /Top Wholelocation code

ISO & Non ISO MNR Codes.xlsDamage ROSASHTSWAWMWTZZShort DescriptionBlockedBlowoutBurnedBurned OutBroken/SplitBentBowedCurbingConsequential DamageRusted & HoledCrackedCompression LineCorroded/RustedContaminatedCutCracked GougedSurface CrackGRP CrackedHoledImproper RepairLow Fluid LevelLK/LeakLO/LooseMisalignedForeign MarkingsMismatchedMS/MissingNI/Not ISONL/NailsNO/Not ReqNot in PlaceNT/Not TirOD/Insp OtOL/Oil satOR/OdorOS/Oil stnsOU/Unaccep rprPushed DownPF/Paint failurePH/Pin HolesRun FlatRH/Pin hlsRO/RottenSA/ Scratch- AbradedShort/Open CircuitTS/CasingWA/WarpedWM/Wrng MTWT/Wear & tearZZ/Not applLong DescriptionBlockedBlowoutBurnedBurned outBroken/SplitBentBowedCurbingConsequential DamageRusted & Holed GENERALCrackedCompression lineCorroded/RustedContaminatedCutCracked GougedSurface CrackGRP cracked through plywoodHoledImproper RepairLow Fluid LevelLeakLoose componentForeign MarkingsMiss / lost componentNot within ISONails in flooringNot required by ownerNot in PlaceNot to TIROut of date inspectionOil saturatedOdorOil stainsOther unacceptable repairPaint failureComponent is damaged by minute holesPin holesRottenScratched or abraded by frictionCasing, tread separatedWarpedWrong materialWear & tearNot applicabledamage code

component codeISO N on ISO MN R Codes.xlsComponent t DescriptionAir Baffle Floor PlateAccumulatorAir DuctAir Exchng Valve GasketPrimary Air FilterSecondary Air FilterAmbient SensorAir Opening AssemblyAir Pressure switchFresh Air Vent CoverAnti-Rack DeviceAir Exchange Vent4" Air Exchange Vent6" Air Exchange VentFresh Air Vent - KnobAnti-Rack OmegaAnti-Rack PlateFresh Air Vent SpindleAnti-Rack SpigotAir screen assemblyDual Speed CompressorAir screen flapAir screen gasketAir screen hingeAir screen lockAir screen panelCompressor with MotorSafety Anti-Theft WireAmplifier electr. boardAnalog Board-PartlowController boxTiming&Currnt elec. brd.Contrler box doorController box door gasktController box door hingeControl box door screwsControl electronic boardController box door windwDiagonal BracingElectrical boxStud 1/4 Turn Elect.Washer - 1/4 Turn StudElectrical doorElectrical door gasketElectrical door hingeElectrical Door LatchElectrical circuit diagrmElectrical door securingElectrical component shldElectrical door windowController door hingeController door hingeFan bladeLiquid injection controllController logic boardController door hingeMother electronic boardController door hingePower&Supply in elec. brdBearingBearing - cond fan motorBearing - evap fan motorLong DescriptionReefer container GENERALStorage chamber for liquid refrigerant.Component which allows air circulation in ReefersReefer container GENERALPrimary device for Screening Air FlowSecondary Device for Screening Air FlowReefer container GENERALAir opening assemblyDevice to Detect Pressure Diff. accross EVAP CoilReefer container GENERALDevice that Reinforces Securement to Locking BarDevice that allows Air Renewal to Reduce Gas Conc.Reefer container GENERALReefer container GENERALReefer container GENERALAnti-Rack Device in form of an Omega ReinforcementAnti-Rack PlateReefer container GENERALAnti-Rack SpigotAir screen assemblyReefer Machinery GENERALAir screen flapAir screen gasketAir screen hingeAir screen lockAir screen panelcomplete Assembly with motorIICL Flat Rack ManualAmplifier electronic boardReefer Machinery GENERALController boxTiming current contrl. elec. brd.Controller box doorController box door gasketController box door hingeReefer Machinery GENERALControl electronic boardController box door windowReefer Machinery GENERALElectrical boxReefer Machinery GENERALReefer Machinery GENERALElectrical doorElectrical door gasketElectrical door hingeReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALElectrical component shieldReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALMother electronic boardReefer Machinery GENERALPower supply in range elec. brd.BearingReefer Machinery GENERALReefer Machinery GENERAL

component codeISO N on ISO MN R Codes.xlsComponent t DescriptionFeeler bulbController board partController power displayPhase reversal elect bordRecorder boxRecorder box doorController relay boardBottom rail flange - AlumRecorder box door gasketRecorder box door hingeRecorder box door windowController board partBulkhead rivetsRelay electronic boardBearing, crankshaftBearing shields cond motrBearing shields evap motrTemp. control elec. boardTime delay board 6 Minute6 Minute TimerAtmosphere contollerControlld atmsphere drierCond/Evap fixing boltsControld atmsphere heaterCndnsr fan mtr. capcitatrCmpressor motor capcitatrCntrolld atmsh. cmpressorCoil assemblyEvap. fan motr capacitatrCntrl atmshr door switchCircuit breaker, 230 V8 amp Circuit BreakerCircuit BreakerCircuit breaker heat shldCircuit brkr mount bracktCircuit breaker, 460 VCircuit BreakerCircuit BreakerCircuit BreakerCond. coil mounting brcktTop Plate Hinge AssemblyCond. door middle hingeMPA Chip KitCable clampCable cover (Swing Down)Condenser deck assemblyCondenser grillCondenser door hingeCondnsr. door panel hingeCondenser grill screwCondenser door panelCarbon dioxide scrubberSensor, carbon dioxideCondenser venturiCarbon dioxide supplyContainer exteriorTop casting filler plateCorner fittingCoil finsFins - Condenser CoilCondenser front plateFins - Evaporator CoilLong DescriptionFeeler bulbReefer Machinery GENERALReefer Machinery GENERALPhase reversal electronic boardRecorder boxRecorder box doorReefer Machinery GENERALReefer container GENERALRecorder box door gasketRecorder box door hingeRecorder box door windowReefer Machinery GENERALReefer Machinery GENERALRelay electronic boardBearing, crankshaftReefer Machinery GENERALReefer Machinery GENERALTemperature control elec. brd.Reefer Machinery GENERALReefer Machinery GENERALControlled-atmosphere controllerControlled-atmosphere drierReefer Machinery GENERALControlled-atmosphere heaterCondenser fan motor capacitorCompressor motor capacitorControlled-atmosphere compressCoil assemblyEvaporator fan motor capacitorContrl. -atmosphere door switchCircuit breaker, 230 VReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALCircuit breaker, 460 VReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALCondenser coil mounting bracketIICL Flat Rack ManualReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machinery GENERALReefer Machine

EDI is a standard communication protocol for system-to-system integration of Florens . EDI FACT definition of the file type XYZABC depot's own reference of the file TXT file extension. . 83 COMP_ID_N2 990 6 Companion Unit Number 84 COMP_ID_C2 996 1