Transcription
CP EDI 820 GuidelinesVersion 4010CP EDI 820 Guidelines (Version 4010)CP EDI 820 Guidelines1December, 2018
CP EDI 820 GuidelinesVersion 4010820 Payment Order/Remittance AdviceFunctional Group ID RAIntroduction:This Draft Standard for Trial Use contains the format and establishes the data contents of the PaymentOrder/Remittance Advice Transaction Set (820) for use within the context of an Electronic Data Interchange (EDI)environment. The document is a modified version of X12 820 rail guidelines (v4010) that is accepted by CP. Thetransaction set can be used to make a payment, send a remittance advice, or make a payment and send aremittance advice. This transaction set can be an order to a financial institution to make a payment to a payee. Itcan also be a remittance advice identifying the detail needed to perform cash application to the payee's accountsreceivable system. The remittance advice can go directly from payer to payee, through a financial institution, orthrough a third party agent.An EDI 997 Functional Acknowledgment will be sent for this transaction set. The document will not be processedfurther if rejected due to violation of X12 020BPRNot Used030OReq.Des.MNameTransaction Set HeaderMax.Use1LoopRepeatNotes andCommentsM1NTEBeginning Segment for PaymentOrder/Remittance AdviceNote/Special InstructionO e IdentificationO 1O060DTMDate/Time ReferenceO 1LOOP ID - N1 1M070N1NameO1Not Used080N2Additional Name InformationO 1O090N3Address InformationO 1O100N4Geographic LocationO1Not Used110REFReference IdentificationO 1Not Used120PERAdministrative Communications ContactO 1Not Used130RDMRemittance Delivery MethodO1Not Used140DTMDate/Time l:Req.Des.NameLOOP ID - ENTEntityOMax.Use1LOOP ID - NM1Notes andCommentsn1, c4 1Not Used020NM1Individual or Organizational NameO1Not Used030N2Additional Name InformationO 1Not Used040N3Address InformationO 1CP EDI 820 GuidelinesLoopRepeat 12c5December, 2018
CP EDI 820 GuidelinesVersion 4010Not Used050N4Geographic LocationO1Not Used060REFReference IdentificationO 1Not Used070PERAdministrative Communications ContactO 1LOOP ID - ADX 1Not Used080ADXAdjustmentO1Not Used090NTENote/Special InstructionO 1Not Used100PERAdministrative Communications ContactO 1Not Used105DTMDate/Time ReferenceO1LOOP ID - REF 1Not Used110REFReference IdentificationO1Not Used120DTMDate/Time ReferenceO 1LOOP ID - IT1Not Used130IT1 1Baseline Item Data (Invoice)O1LOOP ID - REF140REFReference IdentificationO1Not Used141DTMDate/Time ReferenceO1LOOP ID - SAC 1Not Used142SACNot Used143TXIService, Promotion, Allowance, or ChargeInformationTax InformationNot Used144SLNSubline Item DetailO1O 1O1LOOP ID - SLN 1LOOP ID - REF 1Not Used145REFReference IdentificationO1Not Used146DTMDate/Time ReferenceO 1LOOP ID - SAC147SACNot Used148TXI 1Service, Promotion, Allowance, or ChargeInformationTax InformationO1O 1LOOP ID - RMR 1M150RMRRemittance Advice Accounts Receivable OpenItem ReferenceO1O160NTENote/Special InstructionO 1Rec170REFReference IdentificationO 1Rec180DTMDate/Time ReferenceO 1LOOP ID - IT1Not Used190IT1c8 1Baseline Item Data (Invoice)O1LOOP ID - REFc9 1Not Used200REFReference IdentificationO1Not Used201DTMDate/Time ReferenceO1LOOP ID - SACCP EDI 820 Guidelinesc7 1Not UsedNot Usedc6 13December, 2018
CP EDI 820 GuidelinesVersion 4010Not Used202SACService, Promotion, Allowance, or ChargeInformationO1Not Used203TXITax InformationO 1LOOP ID - SLNNot Used204SLN 1Subline Item DetailO1LOOP ID - REF 1Not Used205REFReference IdentificationO1Not Used206DTMDate/Time ReferenceO 1LOOP ID - SACNot Used207SACNot Used208TXI 1Service, Promotion, Allowance, or ChargeInformationTax InformationO1O 1LOOP ID - ADX 1Not Used210ADXAdjustmentO1Not Used220NTENote/Special InstructionO 1Not Used230PERAdministrative Communications ContactO 1LOOP ID - REF 1Not Used240REFReference IdentificationO1Not Used250DTMDate/Time ReferenceO 1LOOP ID - IT1Not Used260IT1 1Baseline Item Data (Invoice)O1LOOP ID - REF270REFReference IdentificationO1Not Used271DTMDate/Time ReferenceO1LOOP ID - SAC 1Not Used272SACService, Promotion, Allowance, or ChargeInformationO1Not Used273TXITax InformationO 1LOOP ID - SLN274SLN 1Subline Item DetailO1LOOP ID - REF 1Not Used275REFReference IdentificationO1Not Used276DTMDate/Time ReferenceO 1LOOP ID - SAC 1Not Used277SACService, Promotion, Allowance, or ChargeInformationO1Not Used278TXITax InformationO 1LOOP ID - TXP 1Not Used280TXPTax PaymentO1Not Used285TXITax InformationO 1LOOP ID - DEDCP EDI 820 Guidelinesc11 1Not UsedNot Usedc10n2 14December, 2018
CP EDI 820 GuidelinesNot Used287DEDDeductionsVersion 4010O1LOOP ID - LX 1Not Used290LXAssigned NumberO1Not Used295REFReference IdentificationO 1Not Used300TRNTraceO 1LOOP ID - NM1305NM1Individual or Organizational NameO1Not Used310REFReference IdentificationO 1Not Used315G53Maintenance TypeO1LOOP ID - AIN 1Not Used320AINIncomeO1Not Used325QTYQuantityO 1Not Used330DTPDate or Time or PeriodO 1LOOP ID - PEN 1Not Used335PENPension InformationO1Not Used340AMTMonetary AmountO 1Not Used345DTPDate or Time or PeriodO 1LOOP ID - INV 1Not Used350INVInvestment Vehicle SelectionO1Not Used355DTPDate or Time or PeriodO 1LOOP ID - N9360N91Reference IdentificationO1LOOP ID - AMT370AMTMonetary AmountO1Not Used380REFReference IdentificationO 1LOOP ID - N1390N1NameO1Not Used400REFReference IdentificationO 1LOOP ID - EMS 1Not Used410EMSEmployment PositionO1Not Used420ATNAttendanceO 1Not Used430AINIncomeO 1Not Used440PYDPayroll DeductionO 1LOOP ID - RYLRYL 1Royalty PaymentO1LOOP ID - NM1Not Used460CP EDI 820 GuidelinesNM1c12 1Not Used450n5 1Not UsedNot Usedn4 1Not UsedNot Usedn3n6 1Individual or Organizational NameO51December, 2018
CP EDI 820 GuidelinesVersion 4010LOOP ID - LOCNot Used470LOC 1LocationO1LOOP ID - PID 1Not Used480PIDProduct/Item DescriptionO1Not Used490DTMDate/Time ReferenceO1LOOP ID - PCT 1Not Used500PCTPercent AmountsO1Not Used510QTYQuantityO1LOOP ID - AMT 1Not Used520AMTMonetary AmountO1Not Used530ADXAdjustmentO 1LOOP ID - ASM1Not Used540ASMAmount and Settlement MethodO1Not Used550ADXAdjustmentO1Seg.IDSENameTransaction Set TrailerSummary:CPAttributesMPos.No.010CP EDI 820 GuidelinesReq.Des.M6Max.Use1LoopRepeatNotes andCommentsDecember, 2018
CP EDI 820 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Version 4010ST Transaction Set Header010HeadingMandatory1To 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 820 GuidelinesData Element SummaryDataElement NameAttributes143Transaction Set Identifier CodeM ID 3/3Code uniquely identifying a Transaction Set820Payment Order/Remittance Advice329Transaction Set Control NumberM AN 4/9Identifying control number that must be unique within the transaction setfunctional group assigned by the originator for a transaction set7December, 2018
CP EDI 820 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Version 4010BPR Beginning Segment for Payment Order/Remittance Advice020HeadingMandatory1To indicate the beginning of a Payment Order/Remittance Advice Transaction Set andtotal payment amount, or to enable related transfer of funds and/or information frompayer to payee to occur1 If either BPR06 or BPR07 is present, then the other is required.2 If BPR08 is present, then BPR09 is required.3 If either BPR12 or BPR13 is present, then the other is required.4 If BPR14 is present, then BPR15 is required.1 BPR02 specifies the payment amount.2 When using this transaction set to initiate a payment, all or some of BPR06 throughBPR16 may be required, depending on the conventions of the specific financialchannel being used.BPR06 and BPR07 relate to the originating depository financial institution (ODFI).3 BPR08 is a code identifying the type of bank account or other financial asset.4 BPR09 is the account of the company originating the payment. This account may bedebited or credited depending on the type of payment order.5 BPR12 and BPR13 relate to the receiving depository financial institution (RDFI).6 BPR14 is a code identifying the type of bank account or other financial asset.7 BPR15 is the account number of the receiving company to be debited or creditedwith the payment order.8 BPR16 is the date the originating company intends for the transaction to be settled(i.e., Payment Effective R03CP EDI 820 GuidelinesData Element SummaryDataElement NameAttributes305Transaction Handling CodeM ID 1/2Code designating the action to be taken by all partiesCPayment Accompanies Remittance AdviceUsed when sending EDI 820 directly to the Banks alongwith the shipment level details.IRemittance Information OnlyUsed when sending EDI 820 directly to CP along with theshipment level details.782Monetary AmountM R 1/18Monetary amountTotal payment amount for all items.478Credit/Debit Flag CodeM ID 1/1Code indicating whether amount is a credit or debitCCreditDDebit8December, 2018
CP EDI 820 OBPR14569XBPR15508CP EDI 820 GuidelinesVersion 4010Payment Method CodeM ID 3/3Code identifying the method for the movement of payment instructionsACHAutomated Clearing House (ACH)X12X12Payment Format CodeO ID 1/10Code identifying the payment format to be usedCCPCash Concentration/Disbursement plus Addenda (CCD )(ACH)CTXCorporate Trade Exchange (CTX) (ACH)(DFI) ID Number QualifierX ID 2/2Code identifying the type of identification number of Depository FinancialInstitution (DFI)01ABA Transit Routing Number Including Check Digits (9digits)(DFI) Identification NumberX AN 3/12Depository Financial Institution (DFI) identification numberAccount Number QualifierO ID 1/3Code indicating the type of accountDADemand DepositAccount NumberX AN 1/35Account number assignedOriginating Company IdentifierO AN 10/10A unique identifier designating the company initiating the funds transferinstructions. The first character is one-digit ANSI identification codedesignation (ICD) followed by the nine-digit identification number which maybe an IRS employer identification number (EIN), data universal numberingsystem (DUNS), or a user assigned number; the ICD for an EIN is 1, DUNS is 3,user assigned number is 9Originating Company Supplemental CodeO AN 9/9A code defined between the originating company and the originatingdepository financial institution (ODFI) that uniquely identifies the companyinitiating the transfer instructions(DFI) ID Number QualifierX ID 2/2Code identifying the type of identification number of Depository FinancialInstitution (DFI)01ABA Transit Routing Number Including Check Digits (9digits)(DFI) Identification NumberX AN 3/12Depository Financial Institution (DFI) identification numberAccount Number QualifierO ID 1/3Code indicating the type of accountDADemand DepositAccount NumberX AN 1/35Account number assigned9December, 2018
CP EDI 820 GuidelinesOBPR16373Not UsedBPR171048Not UsedBPR18506Not UsedNot UsedBPR19BPR20507569Not UsedBPR21508Segment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Version 4010DateO DT 8/8Date expressed as CCYYMMDDBusiness Function CodeO ID 1/3Refer to 004010 Data Element Dictionary for acceptable code values.(DFI) ID Number QualifierX ID 2/2Refer to 004010 Data Element Dictionary for acceptable code values.(DFI) Identification NumberX AN 3/12Account Number QualifierO ID 1/3Refer to 004010 Data Element Dictionary for acceptable code values.Account NumberX AN 1/35TRN Trace035HeadingOptional1To uniquely identify a transaction to an application12TRN02 provides unique identification for the transaction.TRN03 identifies an RN02OTRN03Not UsedTRN04CP EDI 820 GuidelinesData Element SummaryDataElement NameAttributes481Trace Type CodeM ID 1/2Code identifying which transaction is being referenced1Current Transaction Trace Numbers127Reference IdentificationM AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification Qualifier509Originating Company IdentifierO AN 10/10A unique identifier designating the company initiating the funds transferinstructions. The first character is one-digit ANSI identification codedesignation (ICD) followed by the nine-digit identification number which maybe an IRS employer identification number (EIN), data universal numberingsystem (DUNS), or a user assigned number; the ICD for an EIN is 1, DUNS is 3,user assigned number is 9127Reference IdentificationO AN 1/3010December, 2018
CP EDI 820 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Comments:Version 4010CUR Currency040HeadingOptional1To specify the currency (dollars, pounds, francs, etc.) used in a transactionSee Figures Appendix for examples detailing the use of the CUR segment.Data Element SummaryCPAttributesMRef.Des.CUR01MCUR02Not UsedNot UsedCUR03CUR04Not UsedNot UsedCUR05CUR06Not UsedCUR07Not UsedNot UsedNot UsedCUR08CUR09CUR10Not UsedNot UsedNot UsedCUR11CUR12CUR13Not UsedNot UsedNot UsedCUR14CUR15CUR16Not UsedNot UsedCUR17CUR18CP EDI 820 GuidelinesDataElement NameAttributes98Entity Identifier CodeM ID 2/3Code identifying an organizational entity, a physical location, property or anindividualPRPayer100Currency CodeM ID 3/3Code (Standard ISO) for country in whose currency the charges are specifiedCADCanadian DollarsUSDU.S Dollars280Exchange RateO R 4/1098Entity Identifier CodeO ID 2/3Refer to 004010 Data Element Dictionary for acceptable code values.100Currency CodeO ID 3/3669Currency Market/Exchange CodeO ID 3/3Refer to 004010 Data Element Dictionary for acceptable code values.374Date/Time QualifierX ID 3/3Refer to 004010 Data Element Dictionary for acceptable code values.373DateO DT 8/8337TimeO TM 4/8374Date/Time QualifierX ID 3/3Refer to 004010 Data Element Dictionary for acceptable code values.373DateX DT 8/8337TimeX TM 4/8374Date/Time QualifierX ID 3/3Refer to 004010 Data Element Dictionary for acceptable code values.373DateX DT 8/8337TimeX TM 4/8374Date/Time QualifierX ID 3/3Refer to 004010 Data Element Dictionary for acceptable code values.373DateX DT 8/8337TimeX TM 4/811December, 2018
CP EDI 820 GuidelinesNot UsedCUR19374Not UsedNot age:Max Use:Purpose:Syntax Notes:Semantic F03Not UsedREF04Not UsedC04001Not UsedC04002Not UsedC04003CP EDI 820 GuidelinesVersion 4010Date/Time QualifierX ID 3/3Refer to 004010 Data Element Dictionary for acceptable code values.DateX DT 8/8TimeX TM 4/8REF Reference Identification050HeadingOptional 1To specify identifying informationAt least one of REF02 or REF03 is required.Data Element SummaryDataElement NameAttributes128Reference Identification QualifierM ID 2/3Code qualifying the Reference IdentificationCKCheck NumberTNTransaction Reference NumberThis is not a comprehensive list and only includes some of the mostcommonly used Reference Identification Qualifiers.127Reference IdentificationX AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification Qualifier352DescriptionX AN 1/80A free-form description to clarify the related data elements and their contentC040Reference IdentifierOTo identify one or more reference numbers or identification numbers asspecified by the Reference Qualifier128Reference Identification QualifierM ID 2/3Code qualifying the Reference IdentificationRefer to 004010 Data Element Dictionary for acceptable code values.127Reference IdentificationM 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 IdentificationRefer to 004010 Data Element Dictionary for acceptable code values.12December, 2018
CP EDI 820 GuidelinesNot UsedC04004127Not UsedC04005128Not UsedC04006127Segment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Version 4010Reference IdentificationX AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification QualifierReference Identification QualifierX ID 2/3Code qualifying the Reference IdentificationRefer to 004010 Data Element Dictionary for acceptable code values.Reference IdentificationX AN 1/30Reference information as defined for a particular Transaction Set or asspecified by the Reference Identification QualifierDTM Date/Time Reference060HeadingOptional 1To specify pertinent dates and times1 At least one of DTM02 DTM03 or DTM05 is required.2 If DTM04 is present, then DTM03 is required.Semantic M03ODTM04CP EDI 820 GuidelinesData Element SummaryDataElement NameAttributes374Date/Time QualifierM ID 3/3Code specifying type of date or time, or both date and time097Transaction Creation373DateX DT 8/8Date expressed as CCYYMMDD337TimeX 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)623Time 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 thatfollowCTCentral TimeETEastern TimeMTMountain TimePTPacific Time13December, 2018
CP EDI 820 GuidelinesNot UsedDTM051250Not UsedDTM061251Segment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic 2Not UsedN103Not UsedNot UsedN104N105Not UsedN106CP EDI 820 GuidelinesVersion 4010Date Time Period Format QualifierX ID 2/3Refer to 004010 Data Element Dictionary for acceptable code values.Date Time PeriodX AN 1/35N1 Name070N1OptionalHeadingOptional1To 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.Provide Legal Entity names (Railinc/DUN & BRADSTREET).Data Element SummaryDataElement NameAttributes98Entity Identifier CodeM ID 2/3Code identifying an organizational entity, a physical location, property or anindividualPEPayeeCanadian Pacific RailwayPRPayerCustomer Name93NameX AN 1/60Free-form name66Identification Code QualifierX ID 1/2Refer to 004010 Data Element Dictionary for acceptable code values.67Identification CodeX AN 2/80706Entity 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.14December, 2018
CP EDI 820 GuidelinesSegment:Position:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Comments:Version 4010N3 Address Information090N1OptionalHeadingOptional 1To specify the location of the named partyData Element ion:Loop:Level:Usage:Max Use:Purpose:Syntax Notes:Semantic Notes:Comments:DataElement Name166Address InformationAddress information166Address InformationAddress informationRef.Des.N401MN402MN403RecN404Not UsedN405Not UsedN406CP EDI 820 GuidelinesOAN 1/55N4 Geographic Location100N1OptionalHeadingOptional1To specify the geographic place of the named party1 If N406 is present, then
CP EDI 820 Guidelines Version 4010 CP EDI 820 Guidelines 6 December, 2018 LOOP ID - LOC 1 Not Used 470 LOC Location O 1 LOOP ID - PID 1 Not Used 480 PID Product/Item Description O 1 Not Used 490 DTM Date/Time Reference O 1 LOOP ID - PCT 1 Not Used 500 PCT Percent Amounts O 1 Not Used 510 QTY Quantity O 1 LOOP ID - AMT 1File Size: 557KB
