SOUTHERN COMPANY EDI 810
Southern Company currently supports versions 3030 and 4010 of the Electronic Data Interchange (EDI) transaction 810 with some special mapping for specific customers. Since late 1999 all new customers have implemented EDI using the 4010 version.
Attached in Appendix A is a sample of the current version 4010 with a couple of modifications in progress highlighted in red. This example shows a Wal-Mart account with Electric Service and Lighting tariffs (Multiple IT1 loops).
Modifications to the 4010 version
1. Add the total kWh to IT102 field so customers can compare the total consumption in the IT102 field with the calculated consumption reported in the MEA records.
2. Move the usage information from the PID to the SAC records and use an “N” charge indicator. Most customers reference the SAC records for usage information.
Segment Notes
(1) The attached 4010 sample does not display several segments because they are not applicable to this specific sample account. These segments are listed below:
NTE Note segment includes messages, such as disconnection notices.
N2 There is no “In Care Of Name” for this account.
(2) There are several other segments indicated in the generic 4010 version that Southern Company does not include in the 810 invoice. These are listed below:
BAL The balance due is shown in the “TDS” segment.
CUR The currency is always US dollars.
INC The installment information appears in SAC segments as applicable.
PAM The period amount (the service period and dollar amount for the period) information appears in the DTM and TDS segments.
(3) Southern Company displays the TXI segment (tax information) in the IT1 loop only.
The second attachment in Appendix B is a sample of the Wal-Mart RTP (Real-Time Pricing) map created to include incremental usage information in the SAC charge record. This map was created in Spring 2004 from discussions with Wal-Mart, but was discontinued at Wal-Mart’s request due to Wal-Mart having to manually review the information before inputting into their system. We feel that this 4010 map is a good starting point for discussion on how to pass the Incremental Energy kWh on Real Time Pricing (RTP) tariffs.
Appendix A
Southern Company Current 810 version 4010 With Modifications
ISA~00~ ~00~ ~01~06924989G ~12~5012040116 ~050910~0254~U~00401~000001333~0~P~>|
GS~IN~006924989~5012040116~20050910~0254~1333~X~004010|
ST~810~13237|
BIG~20050909~640466400420050909~~UTILITY~~~PR~00|
REF~OI~640466400420050804|
N1~BT~WAL-MART STORES INC~91~6404664004|
REF~AQ~648668|
N1~RE~GEORGIA POWER~92~01-1338|
N3~96 ANNEX|
N4~ATLANTA~GA~303960001|
PER~CR~~TE~404-506-1326|
ITD~~~~~~20050923|
DTM~135~20050901|
IT1~1~207000~~~~SV~ELECTRIC|
TXI~TX~819.52~~~~~A|
MEA~AA~MU~200~KH~60211~61246~22|
MEA~AA~MU~200~K7~0~1.79~22|
MEA~BO~~~K1~~358~31|
PID~F~~~~Commercial|
PID~F~~~~Usage Info. TOT KWH: 0000207000.0000|
PID~F~~~~Usage Info. PK KW: 0000000358.0000|
PID~F~~~~Usage Info. SEA RATCH KW 2: 0000000358.0000|
PID~F~~~~Usage Info. EXCESS PK KVAR: 0000000000.0000|
PID~F~~~~Usage Info. BILLING DEMAND: 0000000358.0000|
REF~NH~PLM~Power and Light Medium|
REF~MG~CC9807|
DTM~150~20050810|
DTM~151~20050909|
SLN~1~~A|
SAC~C~~EU~BAS001~1400~~~~~~~~~~Customer Charge|
SLN~2~~A|
SAC~C~~EU~DMD004~00~~~0.27~K5~0~~~~~Reactive Dmd|
SLN~3~~A|
SAC~C~~EU~FUE001~508827~~~0.024581~KH~207000~~~~~Fuel Charge|
SLN~4~~A|
SAC~C~~EU~DSC004~00~~~0~UN~11707~~~~~Economy Sales Credit|
SLN~5~~A|
SAC~C~~EU~ENC001~00~~~0~KH~71600~~~~~Energy Charge|
SLN~6~~A|
SAC~C~~EU~ENC001~26271~~~0.08757~KH~3000~~~~~Energy Charge|
SLN~7~~A|
SAC~C~~EU~ENC001~63867~~~0.00892~KH~71600~~~~~Energy Charge|
SLN~8~~A|
SAC~C~~EU~ENC001~56182~~~0.08026~KH~7000~~~~~Energy Charge|
SLN~9~~A|
SAC~C~~EU~ENC001~42874~~~0.00672~KH~63800~~~~~Energy Charge|
SLN~10~~A|
SAC~C~~EU~ENC001~425656~~~0.0691~KH~61600~~~~~Energy Charge|
SLN~11~~A|
SAC~C~~EU~DSC011~45660~~~~~~~~~~Rate Case Adjustment|
SLN~12~~A|
SAC~N~~EU~ENC001~~~~~~207000~TOT KWH|
SLN~13~~A|
SAC~N~~EU~ENC001~~~~~~358~PK KW|
SLN~14~~A|
SAC~N~~EU~ENC001~~~~~~358~ SEA RATCH KW 2|
SLN~15~~A|
SAC~N~~EU~ENC001~~~~~~0~ EXCESS PK KVAR|
SLN~16~~A|
SAC~N~~EU~ENC001~~~~~~358~ BILLING DEMAND|
IT1~2~468~~~~SV~ELECTRIC|
TXI~TX~4.74~~~~~A|
PID~F~~~~000003 400 HPS FLOOD 46 OH|
PID~F~~~~Usage Info. TOT KWH: 0000000468.0000|
REF~NH~OL-NGRE~Outdoor Lighting Svc - Non Govt, Regulated|
DTM~150~20050810|
DTM~151~20050909|
SLN~1~~A|
SAC~C~~EU~ENC001~1150~~~~KH~468~~~~~Fuel Charge|
SLN~2~~A|
SAC~C~~EU~DSC004~00~~~0~UN~67~~~~~Economy Sales Credit|
SLN~3~~A|
SAC~C~~EU~ODL001~5271~~~~KH~468~~~~~Lighting Charge|
SLN~4~~A|
SAC~C~~EU~DSC011~350~~~~~~~~~~Rate Case Adjustment|
N1~MQ~WAL-MART STORES INC~92~01-1338|
N3~4701 BUENA VISTA RD|
N4~COLUMBUS~GA~31907|
TDS~1259934|
CTT~2|
SE~69~13237|
GE~1~1333|
IEA~1~000001333|\\\
Appendix B
Southern Company Wal-Mart RTP 810 Sample*
*The Real-TimePricing (RTP) map includes the incremental kWh usage in the SAC record (highlighted in blue).
ISA~00~ ~00~ ~01~06924989G ~12~5012040116 ~040330~1016~U~00401~000000007~0~P~>|
GS~IN~006924989~5012040116G~20040330~1016~7~X~004010|
ST~810~0016|
BIG~20040329~000332060720040329~~UTILITY~~~PR~00|
REF~OI~000332060720040223|
N1~BT~WAL-MART STORES INC~91~0003320607|
REF~AQ~648668|
N1~RE~GEORGIA POWER~92~01-0615|
N3~96 ANNEX|
N4~ATLANTA~GA~303960001|
PER~CR~~TE~770-840-3668|
ITD~~~~~~20040412|
DTM~135~20040301|
IT1~1~~~~~SV~ELECTRIC|
TXI~TX~1574.37~~~~~A|
MEA~AA~MU~1~K7~0~1113~22|
MEA~AA~MU~1~KH~0~120408~22|
MEA~AA~MU~1~KH~0~612593~22|
MEA~~~~K1~~238~31|
PID~F~~~~Customer Baseline Load Contract Bill Demand: 0000238.00000|
PID~F~~~~Customer Baseline Load Contract Economy Demand: 0000000.00000|
PID~F~~~~Meter Info. Desc PK KW: 0000001113.0000|
PID~F~~~~Meter Info. Desc TOT BASE INTERVAL KW: 0000120408.0000|
PID~F~~~~Meter Info. Desc TOT INT KWH: 0000612593.0000|
PID~F~~~~Usage Info. TOT KWH: 0000612593.0000|
PID~F~~~~Usage Info. EXCESS PK KVAR: 0000000000.0000|
PID~F~~~~Usage Info. PK KW: 0000001113.0000|
PID~F~~~~Usage Info. TOT INC KWH: 0000492185.0000|
PID~F~~~~Usage Info. TOTAL BASE KWH: 0000120408.0000|
PID~F~~~~Usage Info. BASE DEMAND: 0000000238.0000|
PID~F~~~~Usage Info. BILLING DEMAND: 0000000238.0000|
REF~NH~RTPDPLM~RTP Day Ahead/PLM|
REF~MG~EA0857|
DTM~150~20040226|
DTM~151~20040326|
SLN~1~~A|
SAC~C~~EU~BAS001~1400~~~~~~~~~~Customer Charge|
SLN~2~~A|
SAC~C~~EU~DMD004~00~~~0.27~K5~0~~~~~Reactive Dmd|
SLN~3~~A|
SAC~C~~EU~ENC001~1647067~~~~KH~492185~~~~~Incremental Energy|
SLN~4~~A|
SAC~C~~EU~FUE001~198962~~~0.016524~KH~120408~~~~~Fuel Charge|
SLN~5~~A|
SAC~C~~EU~DSC004~00~~~0~UN~22490~~~~~Economy Sales Credit|
SLN~6~~A|
SAC~C~~EU~ENC001~00~~~0~KH~47600~~~~~Energy Charge|
SLN~7~~A|
SAC~C~~EU~ENC001~26271~~~0.08757~KH~3000~~~~~Energy Charge|
SLN~8~~A|
SAC~C~~EU~ENC001~42459~~~0.00892~KH~47600~~~~~Energy Charge|
SLN~9~~A|
SAC~C~~EU~ENC001~56182~~~0.08026~KH~7000~~~~~Energy Charge|
SLN~10~~A|
SAC~C~~EU~ENC001~16940~~~0.00672~KH~25208~~~~~Energy Charge|
SLN~11~~A|
SAC~C~~EU~ENC001~259816~~~0.0691~KH~37600~~~~~Energy Charge|
N1~MQ~WAL-MART STORES INC~92~01-0615|
N3~5428 HIGHWAY 20|
N4~CARTERSVILLE~GA~30120|
TDS~2423119|
TXI~TX~10.85~~~~~A|
SAC~C~~EU~MSC001~15500~~~~~~~~~~Administrative Charge|
CTT~1|
SE~63~0016|
GE~1~7|
IEA~1~000000007|