Transcription

CP EDI 214 GuidelinesVersion 4010CP EDI 214 Guidelines (Version 4010)CP EDI 214 Guidelines1January, 2019

CP EDI 214 GuidelinesVersion 4010214 Transportation Carrier Shipment Status MessageFunctional Group ID QMIntroduction:This Draft Standard for Trial Use contains the format and establishes the data contents of the TransportationCarrier Shipment Status Message Transaction Set (214) for use within the context of an Electronic DataInterchange (EDI) environment. The 214 is sent from CP to shippers, consignees or their agents providing themwith the status of shipments in terms of dates, times, locations, route, identifying numbers, and 030Not UsedNot UsedReq.Des.MNameTransaction Set HeaderLoopRepeatMax.Use1M1L11Beginning Segment for Transportation CarrierShipment Status MessageBusiness Instructions and Reference NumberO300035MANMarks and NumbersO9999040K1RemarksO10LOOP ID - 010010O050N1NameO1Not Used060N2Additional Name InformationO1O070N3Address InformationO2O080N4Geographic LocationO1Not Used090G61ContactO1Not Used100G62Date/TimeO1Not Used110L11Business Instructions and Reference NumberO10Not Used120MS3Interline InformationO12O130LXO1O140AT7Shipment Status DetailsO1O143MS1O1O146MS2Equipment, Shipment, or Real PropertyLocationEquipment or Container Owner and TypeO1O150L11Business Instructions and Reference NumberO10Not Used155MANMarks and NumbersO9999Not Used160Q7Lading Exception CodeO10Not Used170K1RemarksO10Not Used180AT5Bill of Lading Handling RequirementsO10O200AT8Shipment Weight, Packaging and Quantity DataO10LOOP ID - 020010LOOP ID - 0210999999Not Used210CD3Carton (Package) DetailO1Not Used220L11Business Instructions and Reference NumberO20LOOP ID - 0215230CP EDI 214 GuidelinesAT7n1999999Assigned NumberLOOP ID - 0205Not UsedNotes andCommentsn210Shipment Status DetailsO21January, 2020

CP EDI 214 GuidelinesNot Used233MS1Not Used236Not UsedVersion 4010O1MS2Equipment, Shipment, or Real PropertyLocationEquipment or Container Owner and TypeO1240NM1Individual or Organizational NameO1Not Used250Q7Lading Exception CodeO10Not Used260AT8Shipment Weight, Packaging and Quantity DataO1Not Used265MANMarks and NumbersO9999LOOP ID - 0220999999Not Used270N1NameO1Not Used280N2Additional Name InformationO1Not Used290N3Address InformationO3Not Used300N4Geographic LocationO1Not Used310L11Business Instructions and Reference NumberO10LOOP ID - 0230Not Used320PRF999999Purchase Order ReferenceO1LOOP ID - 0231999999Not Used330N1NameO1Not Used340N2Additional Name InformationO1Not Used350N3Address InformationO2Not Used360N4Geographic LocationO1Not Used370L11Business Instructions and Reference NumberO10LOOP ID - 0233999999Not Used380CD3Carton (Package) DetailO1Not Used390L11Business Instructions and Reference NumberO20LOOP ID - 024010Not Used400AT7Shipment Status DetailsO1Not Used402MS1O1Not Used404MS2Equipment, Shipment, or Real PropertyLocationEquipment or Container Owner and TypeO1Not Used405MANMarks and NumbersO9999LOOP ID - 0250999999Not Used410SPOShipment Purchase Order DetailO1Not Used420SDQDestination QuantityO10LOOP ID - 0260 1Not Used423EFIElectronic Format IdentificationO1Not Used426BINBinary DataM1M610SETransaction Set TrailerM1CP EDI 214 Guidelines3January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Version 4010ST Transaction Set Header010Mandatory1To indicate the start of a transaction set and to assign a control numberThe transaction set identifier (ST01) is used by the translation routines of theinterchange partners to select the appropriate transaction set definition (e.g., 810selects the Invoice Transaction Set).Comments:CPAttributesMRef.Des.ST01MST02CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes143Transaction Set Identifier CodeM ID 3/3Code uniquely identifying a Transaction Set214Transportation Carrier Shipment Status Message329Transaction Set Control NumberM AN 4/9Identifying control number that must be unique within the transaction setfunctional group assigned by the originator for a transaction set4January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic 003Not UsedNot UsedB1004B1005Not UsedNot UsedB1006B1007CP EDI 214 GuidelinesVersion 4010B10 Beginning Segment for Transportation Carrier Shipment Status Message020Mandatory1To transmit identifying numbers and other basic data relating to the transaction set1 At least one of B1001 or B1006 is required.2 Only one of B1001 or B1005 may be present.3 If either B1005 or B1006 is present, then the other is required.B1001 is the carrier assigned reference number.1 B1001 is the carrier's PRO (invoice number) that identifies the shipment.2 B1003 is required when used in Transaction Set 214.Data Element SummaryDataElement NameAttributes127Reference IdentificationX AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification Qualifier145Shipment Identification NumberO AN 1/30Identification number assigned to the shipment by the shipper that uniquelyidentifies the shipment from origin to ultimate destination and is not subjectto modification; (Does not contain blanks or special characters)140Standard Carrier Alpha CodeM ID 2/4Standard Carrier Alpha CodeCPRSSCAC Code for Canadian Pacific Railway71Inquiry Request NumberO N0 1/3128Reference Identification QualifierX ID 2/3Refer to 004010 Data Element Dictionary for acceptable code values.127Reference IdentificationX AN 1/301073Yes/No Condition or Response CodeO ID 1/1Refer to 004010 Data Element Dictionary for acceptable code values.5January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Version 4010L11 Business Instructions and Reference Number030Optional300To specify instructions in this business relationship or a reference number1 At least one of L1101 or L1103 is required.2 If either L1101 or L1102 is present, then the other is required.Semantic 103CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes127Reference IdentificationX AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification Qualifier128Reference Identification QualifierX ID 2/3Code qualifying the Reference IdentificationBMBill of Lading NumberBNBooking NumberCNCarrier's Reference Number (PRO/Invoice)COCustomer Order NumberCRCustomer Reference NumberPOPurchase Order NumberSIShipper's Identifying Number for Shipment (SID)A unique number (to the shipper) assigned by the shipperto identify the shipmentSOShipper's Order (Invoice Number)WHMaster Reference (Link) NumberWYWaybill NumberZZMutually DefinedThis is not a comprehensive list and only includes some of the mostcommonly used Reference Identification Qualifiers.352DescriptionX AN 1/80A free-form description to clarify the related data elements and their content6January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Version 4010N1 Name0500100OptionalOptional1To identify a party by type of organization, name, and code1 At least one of N102 or N103 is required.2 If either N103 or N104 is present, then the other is required.Semantic Notes:Comments:CPAttributesMRef.Des.N101XN102Not UsedN103Not UsedN104Not UsedN105Not UsedN106CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes98Entity Identifier CodeM ID 2/3Code identifying an organizational entity, a physical location, property or anindividualBTBill-to-PartyCNConsigneePFParty to Receive Freight BillSFShip FromSHShipperSTShip To93NameX AN 1/60Free-form name66Identification Code QualifierX ID 1/2Code designating the system/method of code structure used for IdentificationCode (67)Refer to 004010 Data Element Dictionary for acceptable code values.67Identification CodeX AN 2/80Code identifying a party or other code706Entity Relationship CodeO ID 2/2Refer to 004010 Data Element Dictionary for acceptable code values.98Entity Identifier CodeO ID 2/3Refer to 004010 Data Element Dictionary for acceptable code values.7January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic nt:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Comments:N3 Address Information0700100Ref.Des.N401ON402ON403ON404Not UsedN405Not UsedN406CP EDI 214 GuidelinesOptionalOptional2To specify the location of the named partyData Element SummaryDataElement Name166Address InformationAddress information166Address InformationAddress informationAttributesM AN 1/55OAN 1/55N4 Geographic Location0800100OptionalOptional1To specify the geographic place of the named party1 If N406 is present, then N405 is required.12CPAttributesOVersion 4010A combination of either N401 through N404, or N405 and N406 may be adequate tospecify a location.N402 is required only if city name (N401) is in the U.S. or Canada.Data Element SummaryDataElement NameAttributes19City NameO AN 2/30Free-form text for city name156State or Province CodeO ID 2/2Code (Standard State/Province) as defined by appropriate government agency116Postal CodeO ID 3/15Code defining international postal zone code excluding punctuation andblanks (zip code for United States)26Country CodeO ID 2/3Code identifying the country309Location QualifierX ID 1/2Refer to 004010 Data Element Dictionary for acceptable code values.310Location IdentifierO AN 1/308January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Comments:CPAttributesMRef.Des.LX01CP EDI 214 GuidelinesVersion 4010LX Assigned Number1300200OptionalOptional1To reference a line number in a transaction setData Element SummaryDataElement NameAttributes554Assigned NumberM N0 1/6Number assigned for differentiation within a transaction set9January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Version 4010AT7 Shipment Status Details1400205OptionalOptional1To specify the status of a shipment, the reason for that status, the date and time of thestatus and the date and time of any appointments scheduled.1 Only one of AT701 or AT703 may be present.2 If either AT701 or AT702 is present, then the other is required.3 If either AT703 or AT704 is present, then the other is required.4 If AT706 is present, then AT705 is required.5 If AT707 is present, then AT706 is required.1 If AT701 is present, AT705 is the date the status occurred. If AT703 is present,AT705 is a date related to an appointment.If AT701 is present, AT706 is the time of the status. If AT703 is present, AT706 is thetime of the appointment.2 If AT707 is not present then AT706 represents local time of the status.Comments:CPAttributesXRef.Des.AT701CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes1650Shipment Status CodeX ID 2/2Code indicating the status of a shipmentOrigin EventsX3Arrived at Pick-up LocationAFCarrier Departed Pick-up Location with ShipmentCPCompleted Loading at Pick-up LocationRail EventsI1In-GateALLoaded to RailRLRail Departure from Origin Intermodal RampARRail Arrival at Destination Intermodal RampAVAvailable for DeliveryOAOut-GateJ1Delivered to Connecting LineLimited Rail Scanner EventsP1Departed Terminal LocationX4Arrived at Terminal LocationDelivery EventsX1Arrived at Delivery LocationX6En Route to Delivery LocationS1Trailer Spotted at Consignee's LocationD1Completed Unloading at Delivery LocationCDCarrier Departed Delivery Location10January, 2020

CP EDI 214 AT706337OAT707623CP EDI 214 GuidelinesVersion 4010Shipment DelaysSDShipment DelayedShipment Status or Appointment Reason CodeX ID 2/2Code indicating the reason a shipment status or appointment reason wastransmittedNANormal AppointmentNSNormal StatusShipment Appointment Status CodeX ID 2/2Code indicating the status of an appointment to pick-up or deliver a shipmentAAPick-up Appointment Date and/or TimeABDelivery Appointment Date and/or TimeShipment Status or Appointment Reason CodeX ID 2/2Code indicating the reason a shipment status or appointment reason wastransmittedNANormal AppointmentNSNormal StatusSee Appendix 1 below for the list of Shipment Delayreason code list and description.DateX DT 8/8Date expressed as CCYYMMDDTimeX TM 4/8Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, orHHMMSSD, or HHMMSSDD, where H hours (00-23), M minutes (00-59), S integer seconds (00-59) and DD decimal seconds; decimal seconds areexpressed as follows: D tenths (0-9) and DD hundredths (00-99)Time CodeO ID 2/2Code identifying the time. In accordance with International StandardsOrganization standard 8601, time can be specified by a or - and an indicationin hours in relation to Universal Time Coordinate (UTC) time; since is arestricted character, and - are substituted by P and M in the codes thatfollowRefer to 004010 Data Element Dictionary for acceptable code values.11January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Version 4010MS1 Equipment, Shipment, or Real Property Location1430205OptionalOptional1To specify the location of a piece of equipment, a shipment, or real property in terms ofcity and state or longitude and latitude1 If MS101 is present, then at least one of MS102 or MS103 is required.2 Only one of MS101 or MS104 may be present.3 If MS102 is present, then MS101 is required.4 If MS103 is present, then MS101 is required.Semantic 103Not UsedNot UsedNot UsedMS104MS105MS106Not UsedMS107CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes19City NameX AN 2/30Free-form text for city name156State or Province CodeX ID 2/2Code (Standard State/Province) as defined by appropriate government agency26Country CodeX ID 2/3Code identifying the country1654Longitude CodeX ID 7/71655Latitude CodeX ID 7/71280Direction Identifier CodeO ID 1/1Refer to 004010 Data Element Dictionary for acceptable code values.1280Direction Identifier CodeO ID 1/1Refer to 004010 Data Element Dictionary for acceptable code values.12January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic 203OMS204CP EDI 214 GuidelinesVersion 4010MS2 Equipment or Container Owner and Type1460205OptionalOptional1To specify the owner, the identification number assigned by that owner, and the type ofequipment1 If either MS201 or MS202 is present, then the other is required.1MS203 identifies the type for the equipment specified in MS202.Data Element SummaryDataElement NameAttributes140Standard Carrier Alpha CodeX ID 2/4Standard Carrier Alpha CodeCPRSSCAC Code for Canadian Pacific Railway207Equipment NumberX AN 1/10Sequencing or serial part of an equipment unit's identifying number (purenumeric form for equipment number is preferred)Equipment Initial and Number Combined.40Equipment Description CodeO ID 2/2Code identifying type of equipment used for shipmentCCContainer resting on a ChassisCNContainer761Equipment Number Check DigitO N0 1/113January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Version 4010L11 Business Instructions and Reference Number1500200OptionalOptional10To specify instructions in this business relationship or a reference number1 At least one of L1101 or L1103 is required.2 If either L1101 or L1102 is present, then the other is required.Semantic 103CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes127Reference IdentificationX AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification Qualifier128Reference Identification QualifierX ID 2/3Code qualifying the Reference IdentificationAOAppointment NumberBMBill of Lading NumberBNBooking NumberCOCustomer Order NumberCRCustomer Reference NumberMBMaster Bill of LadingP8Pickup Reference NumberPOPurchase Order NumberQNStop Sequence NumberSIShipper's Identifying Number for Shipment (SID)A unique number (to the shipper) assigned by the shipperto identify the shipmentSOShipper's Order (Invoice Number)WHMaster Reference (Link) NumberZZMutually DefinedThis is not a comprehensive list and only includes some of the mostcommonly used Reference Identification Qualifiers.352DescriptionX AN 1/80A free-form description to clarify the related data elements and their content14January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Version 4010AT8 Shipment Weight, Packaging and Quantity Data2000200OptionalOptional10To specify shipment details in terms of weight, and quantity of handling units1 If any of AT801 AT802 or AT803 is present, then all are required.2 If either AT806 or AT807 is present, then the other is required.1 AT804 is the quantity of handling units that are not unitized (for example a carton).When added to the quantity in AT805, it is the total quantity of handling units in theshipment.2 AT805 is the quantity of handling units that are unitized (for example on a pallet orslip sheet). When added to the quantity in AT804 it is the total quantity of handlingunits for the XAT803OAT804Not UsedNot UsedAT805AT806Not UsedAT807CP EDI 214 GuidelinesData Element SummaryDataElement NameAttributes187Weight QualifierX ID 1/2Code defining the type of weightNActual Net Weight188Weight Unit CodeX ID 1/1Code specifying the weight unitKKilogramsLPounds81WeightX R 1/10Numeric value of weight80Lading QuantityO N0 1/7Number of units (pieces) of the lading commodity80Lading QuantityO N0 1/7184Volume Unit QualifierX ID 1/1Refer to 004010 Data Element Dictionary for acceptable code values.183VolumeX R 1/815January, 2020

CP EDI 214 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Comments:CPAttributesMRef.Des.SE01MSE02CP EDI 214 GuidelinesVersion 4010SE Transaction Set Trailer610Mandatory1To indicate the end of the transaction set and provide the count of the transmittedsegments (including the beginning (ST) and ending (SE) segments)SE is the last segment of each transaction set.Data Element SummaryDataElement NameAttributes96Number of Included SegmentsM N0 1/10Total number of segments included in a transaction set including ST and SEsegments329Transaction Set Control NumberM AN 4/9Identifying control number that must be unique within the transaction setfunctional group assigned by the originator for a transaction set16January, 2020

CP EDI 214 GuidelinesVersion 4010Appendix 1Shipment Delay Reason Codes:Delay ReasonCodeShipment Delay ReasonA5ADAFAGAHAIUnable to LocateCustomer Requested Future DeliveryCarrier Involved in Accidentconsignee relatedDriver RelatedMechanical BreakdownAJAKALAMANAOAQATAWAXB1B8B9BCBEBFBGRail Delayed ramp congestion, annulled train, naturaldisaster weather, avalanche or floodDamaged, Rewrapped in Hub Terminalprevious stopshipper relatedHoliday - ClosedWeather or Natural DisasterRecipient unavailable - delivery delayedincorrect addresspast cut off timeInsufficient Pick Up TimeConsignee Closed/Holidayimproper unloading facility or equipmentreceiving time restrictedmissing documentsRoad Closure/Construction/Trafficcarrier keying errorotherBHBJinsufficient time to complete deliveryCustomer requested early deliveryBNBOFailed to Release Billingrailroad failed to meet scheduleBPBQLoading Issue at OriginShipment OverweightBRBSBTD1D2HBP3PETrain DerailmentRefused by Customerrefused by shippercarrier dispatch errordriver not availableHeld Pending AppointmentShipper Loaded LateShipper Loade