310 likes | 656 Views
Electronic Business. Electronic Data Interchange (EDI) & Electronic Business Transactions (EBT) Standards. EBT? EDI?. EBT is the description of what is needed to conduct a business transaction & when it is done.
E N D
Electronic Business Electronic Data Interchange (EDI) & Electronic Business Transactions (EBT) Standards EBT and EDI Overview
EBT? EDI? • EBT is the description of what is needed to conduct a business transaction & when it is done. • EDI is the vehicle that allows the transfer of the EBT data between dissimilar computer systems. EBT and EDI Overview
How EDI Works Sender’s Translator Mapping Sender’s CISData Mapped Data VAN “Trading Partners” Receiver’s Translator Mapping Receiver’s CISData Mapped Data EBT and EDI Overview
Maine’s Model EBT and EDI Overview
EDI Standards • Format specifications: the characteristics & order of data for each transaction • ANSI X12 Version 4010 • UIG - D guidelines for deregulation EBT Standards • MPUC Chapters 322 & 323 • Maine EBT: Appendices A, B & C • www.cmpco.com/cep/ebtedi/ EBT and EDI Overview
EDI GUIDELINES Appendix C • Known as Data Dictionaries in other states • Links Customer System Fields to EDI Fields • Includes all data required for each business process • Typically used by programmers/EDI developers EBT and EDI Overview
EDI GUIDELINES(example of Appendix C) EBT and EDI Overview
Appendix C 824-1 RESPONSE FOR NON 814 TRANSACTIONS ADMINISTRATIVE LIST OF FIELDS • From Supplier to Distribution Company EBT EDI IMPLEMENTATION GUIDELINES HEADING DESC USESIZETYPE SEGMT/POS LOOP QUALIFIER REFER TO • Unique Tracking Number M/U 30 A/N BGN/020 BGN02 • Supplier Identifier M/U 13 A/N N1/030 N1 9 N104 (Dun’s plus 4) • Supplier account number M/U 20 A/N REF/070 N1 11 REF02 LEGEND M/U = Must Use OP = Optional A/N = Alphanumeric DATE = CCYYMMDD EBT and EDI Overview
EDI GUIDELINESMAINE Appendix B • Glossary of Terms used in Maine documents EBT and EDI Overview
EDI TransactionSets • Appendix C - Implementation Guides • Technical Specifications for EDI Structure • Maine will Implement Version 4010 • Used by EDI developers • There are some minor differences between the Maine utilities. EBT and EDI Overview
Appendix C 824 Application Advice Ver/Rel 004010 Introduction: Functional Group ID=AG The transaction set …is designed to allow the CEP to report errors back to the T&D. Transaction Best Practices: One 824 is to be used for each error to a non-814 transaction set. Transaction Layout: Heading Pos. Seg. Name Req. Max. Loop Notes No. ID Des. Use Repeat Must Use 010 ST Transaction Set Header M 1 Must Use 020 BGN Beginning Segment M 1 LOOP ID – N1 1 Must Use 030 N1 Supplier Co Name O Must Use 070 REF Supplier Acct Number O 12 EBT and EDI Overview
EDI/EBT Standards Committees • Utility Industry Group (UIG-D) 1998 • ME-EBT Working Group EBT and EDI Overview
Maine’s Business Rules • Must have designated business & technical contacts • One Enrollment per Account • First In Rule, 2 Days Prior to Next Read • Enrollments Only On Cycle • Drops may be Processed Off Cycle • CEP Retains Customer - “Seamless” Move • EDI Response by Next Business Day EBT and EDI Overview
Daily & monthly aggregated load estimates will be e-mailed to the bulk power administrator & CEPs. Settlement Transactions E-mailed, not EDI EBT and EDI Overview
ID 810 - 3 Description Aggregated Billing Information SOP Transactions Transaction Set EBT and EDI Overview
ID 810 814 820 824 867 997 Description Invoice Usage/billing Account Administration Payment/Adjustment Errors for non-814’s Historical Usage Functional Acknowledgement CEP Transactions Transaction Sets EBT and EDI Overview
Maine EDI Transaction Sets 810 Billing & Usage Best Practices • Use of the IT1 loop is used to accumulate all consumption and charge detail for a single meter or service. Each meter or service will be detailed in a separate IT1 loop • The MEA segment is used to convey consumption reading for one metering period. • The amount shown in SAC05 may be positive or negative. If negative, the minus sign will be transmitted to the supplier. EBT and EDI Overview
Maine EDI Transaction Sets 810 Monthly Billing and Usage • 810-1 Separate Billing • CEP and T&D do their own billing • 810-2 Consolidated Billing • T&D does billing for CEP and T&D • 810-3 Standard Offer Provider Billing • T&D does billing for SOP and T&D EBT and EDI Overview
Maine EDI Transaction Sets 814 Account Administration • 814 - 1 Enrollment (CEP TO T&D) • 814 - 2 Change CEP Company Data (CEP TO T&D) • 814 - 3 Change T&D Company Data (T&D TO CEP) • 814 - 4 Successful Enrollment (T&D TO CEP) • 814 - 5 Customer Move (T&D TO CEP) • 814 - 6 Error (Both Ways) EBT and EDI Overview
Maine EDI Transaction Sets 814 Account Administration (cont) • 814 - 7 Customer Drops CEP (T&D to CEP) • 814 - 8 CEP Drops Customer (CEP to T&D) • 814 - 9 Confirm Drop Date (T&D to CEP) • 814 - 10 Request History Usage (CEP to T&D) • 814 – 11 Positive Change Confirmation (Both ways) • 814 – 12 Cancel Pending Drop (CEP to T&D) • 814 – 13 Confirm Pending Drop (T&D to CEP) EBT and EDI Overview
Maine EDI Transaction Sets 820 Payments/Payment Corrections The 820 is a Remittance Advice • T&D Consolidated Billing Option Only • Contains Customer Payment Information • Write-off of Prior Supplier Receivables after 60 Days EBT and EDI Overview
Maine EDI Transaction Sets 824 -1 Error Response CEP sends this to T&D for any non-814 error • Similar to the 814-6 Error Transaction • Data would have passed the CEP’s translation mapping but for some reason would not pass data validation in CEP Customer Application EBT and EDI Overview
Maine EDI Transaction Sets 867 - 1 Historical Usage • Typical 867 will contain only 12 months of history • CEP has option for additional 24 months • Note: The 814-10 in Maine does not carry indicator to request more than 12 months. Default is 12 months via EDI EBT and EDI Overview
Maine EDI Transaction Sets 997-1 Functional Acknowledgement • Automatically sent via translator • Need to configure edi software appropriately • Must be received within 1 business day of receiving transaction • Must be reviewed daily for any discrepancies EBT and EDI Overview
Supplier Testing Why: To demonstrate EDI capability Required to enroll customers When: Prior to sending enrollments to the T&D How: Test Plan Objectives are in EBT: Appendix D (each T&D’s test plan on its Web site) EBT and EDI Overview
Scheduling • EBT transactions must be transmitted daily by the time specified in the Service Agreement • Transactions must be acknowledged by the end of the next business day • Billing/Usage data must be forwarded to CEP by the next business day EBT and EDI Overview
Designate technical contact person Assess options for EDI capability- vendors/ software/hardware Become familiar with ME EBT document - Appendix A & C Technical Contact registers with T&D and prepares for testing schedule Start now! Steps to Take Now EBT and EDI Overview
Thank you Maine Public Utilities Commission Bangor Hydro Electric Company Central Maine Power Company Maine Public Service Company EBT and EDI Overview
Thank you EBT and EDI Overview