Comments Submitted by J. Ray, Southern Company

NAESB RETAIL ELECTRIC AND RETAIL GAS QUADRANTSTECHNICAL ELECTRONIC IMPLEMENTATION

STANDARDS AND DATA DICTIONARIESCUSTOMER BILLING AND PAYMENT NOTIFICATION

VIAUNIFORM ELECTRONIC TRANSACTIONS COMPARISON

EDI 810 INVOICE AND EDI 820 PAYMENT ORDER/REMITTANCE ADVICE

FEBRUARY 2009

EDI 810 INVOICE

EDI Guideline Section
SoCo includes,
NAESB excludes
NAESB includes,
SoCo excludes
SEGMENT ID / POSITION # / NAME/DESCRIPTION / NOTES/COMMENTS
ISA / Interchange Control Header / Add to guidelines
GS / Functional Group Header / Add to guidelines
HEADING
BIG / 020 / Beginning Segment for Invoice / BIG04 “Utility” missing
BIG08 code “01”- Cancellation. Does customer expect a cancellation invoice?
BIG08 code “05” - Replace invoice not listed
NTE / 030 / Note/Special Instruction
Need to include CODE / SoCo sends NTE01 “OTH” and uses free-form field to pass PSC required messages such as disconnection notices and KVAH usage calculation. For example,
CALCULATION OF KVA USAGEKVA usage is calculated by dividing the KW usage by the| power factor. TO CALCULATE POWER FACTOR:KVAH = Square root of (KWH) squared + (KV|ARH) squared. Power Factor = KWH/KVAH*. *Truncated to 4 decimals.
Our records indicate that we have not received payment for the appliance repair charges previously billed on your account. Since this account is past due, please pay all previous and current charges by the due date reflected on this bill.| If you have paid within the past few days, please disregard this notice, accept our sincere thanks, and pay only current billed amounts.|
REF / 050 / Customer Account ID (REF~12~Q5) / NAESB includes, SoCo excludes (De-regulated utility information)
REF / 050 / Supplier Account Number (REF~11) / NAESB includes, SoCo excludes (De-regulated utility information)
REF / 050 / Original Invoice (REF~OI) / SoCo sends only if BIG08= “05”
REF / 050 / Party Sending Bill (REF~BLT) / NAESB includes, SoCo excludes (De-regulated utility information)
LOOP ID – N1
N1 / 070 / Customer Name (N1~BT) / N104 not listed in Data Element Summary section. SoCo can populate the store # / account ID in N104
N2 / 080 / SoCo sends “Doing Business As” information
N3 / 090 / NAESB includes, SoCo excludes
N4 / 100 / NAESB includes, SoCo excludes
REF / 110 / Reference Identification Qualifier (REF~AQ) Web Access Code and (REF~ZZ) Additional Customer identifying data / SoCo includes, NAESB excludes.
PER / 120 / Administrative Communications Contact / NAESB includes, SoCo excludes
LOOP ID N-1
N1 / 070 / Customer Name (N1~RE) / N104 not listed in Data Element Summary section. SoCo can populate the store # in N104
N2 / 080 / SoCo sends “Doing Business As” information
N3 / 090 / N3 only sent when N101 = “RE”
N4 / 100 / N4 only sent when N101 = “RE”
PER / 120 / Need to include CODE / SoCo sends two PER segments.
1) “CR” for (Customer Relations Contact)
2) “IC” for (Information/Technical Contact)
PER~CR~AL Power Business Call Center~TE~1-888-430-5787|
PER~IC~EDI Technical Contact~TE~404-506-2457|
LOOP ID N-1 / Not needed for regulated utility
N1 / 070 / Distribution Company (N1~8S) / NAESB includes, SoCo excludes
PER / 120 / NAESB includes, SoCo excludes
LOOP ID N-1 / Not needed for regulated utility
N1 / 070 / Supplier (N1~SJ) / NAESB includes, SoCo excludes
PER / 120 / NAESB includes, SoCo excludes
ITD / 155 / Same format and data / SoCo uses ITD position 130
DTM / 140 / SoCo uses code 135 - Booking / SoCo sends DTM for Revenue Month Period
BAL / 212 / Previous Bill Amount (BAL~P~YB) / NAESB includes, SoCo excludes
BAL / 212 / Outstanding Balance Prior to Current (BAL~M~J9) / NAESB includes, SoCo excludes
BAL / 212 / Payments Since Last Bill (BAL~P~TP) / NAESB includes, SoCo excludes
DETAIL
LOOP ID – IT1
IT1 / 010 / Baseline Item Data (Invoice) / SoCo does not capture DUNS # to place in IT101. SoCo excludes IT108 Product/Service ID Qualifier and IT109 Product/Service ID
TXI / 040 / Tax Information
Need to include CODES / TXI 040 is used for taxes that apply to the entire IT1 segment. If the tax applies to a specific charge it appears in the TXI position 237 below.
-Tax Type Codes SoCo includes, NAESB excludes
CA City Tax
CTCountyTax (does not appear in TXI040 but does appear in TXI 237 below)
MP Municipal Tax
TX All Taxes
UL License Tax
-Tax Type Codes NAESB includes, SoCo excludes
CS City Sales Tax
LO Local Tax (Not Sales Tax)
LS State and Local Sales Tax
-NAESB includes, SoCo excludes
TX103 Percent, TX106 Tax Exempt Code and TXI107 Relationship Code
-SoCo includes, NAESB excludes
TXI10 Taxing name used for Gulf Power only
MEA / 059 / Measurements
Need to include CODE / NAESB includes, SoCo excludes
-MEA02 Measurement Qualifiers
CO Core Loss
PRQ Product Reportable Quantity
ZA Power Factor
-MEA04 Composite Unit of Measure C00101
NAESB includes, SoCo excludes
CF Cubic Feet
K2 Kilovolt Amperes Reactive Demand
SoCo includes, NAESB excludes – These need to be added
DA Days
BY British Thermal Unit
K7 Kilowatt
K9 Kilograms per Millimeter Squared (KG/MM2)
T1 Thousand pounds gross
UN Unit
-MEA07 Measurement Significance Code
SoCo includes, NAESB excludes
22 Actual
31 Calculated
AA Summer On Peak
AB Summer Mid Peak
AC Summer Off Peak
AF Winter On Peak
AG Winter Mid Peak
AH Winter Off Peak
AO Summer
AP Winter
NAESB includes, SoCo excludes
45 Per gallon
49 Mist
PID LOOP / Product/Item Description – Free format for data that doesn’t fit elsewhere. Originally used to provide usage information now included in the SAC10 / SoCo includes, NAESB excludes
PID01 / 349 / Item Description Type / SoCo includes, NAESB excludes
PID05 / 352 / Description / SoCo includes, NAESB excludes
REF / 120 / Meter Number (REF~MG) / SoCo includes REF03 – Tariff Description
REF / 120 / Distribution Company Rate Code (REF~NH) / NAESB includes, SoCo excludes
REF / 123 / Old Meter Number (REF~46) / SoCo sends in REF 120 versus REF123 if applicable
REF / 124 / Supplier Rate Code (REF~RB) / NAESB includes, SoCo excludes
LOOP ID - SLN
SLN / 200 / Subline Item Detail / Modify Name for SLN01 Data Element 350
Alphanumeric characters assigned for differentiation within a transaction set. Sequential number assignment as a segment counter within the loop.
SAC / 230 / Need to include CODES / SAC03
NAESB includes, SoCo excludes
GU Natural Gas utilities
SAC07
What does the percent value represent in the NAESB?
SAC09
NAESB includes, SoCo excludes
CF Cubic Feet
EA Each
4A Bobbin
4B Cap
4C Centistokes
4D Curie
GA Gallon
HH Hundred Cubic feet
K2 Kilovolt Amperes Reactive Demand
SoCo includes, NAESB excludes
BY
K7
K9
T1
UN
TXI / 237 / SoCo includes in the Summary Section / NAESB includes, SoCo excludes
TXI 040 is used for taxes that apply to the entire IT1 segment. If the tax applies to a specific charge it appears in the TXI position 237.
-Tax Type Codes SoCo includes, NAESB excludes
CA City Tax
CTCountyTax (appears in TXI237 but not TXI040 above)
MP Municipal Tax
TX All Taxes
UL License Tax
-Tax Type Codes NAESB includes, SoCo excludes
CS City Sales Tax
LO Local Tax (Not Sales Tax)
LS State and Local Sales Tax
-NAESB includes, SoCo excludes
TX103 Percent, TX106 Tax Exempt Code and TXI107 Relationship Code
-SoCo includes, NAESB excludes
TXI10 Taxing name used for Gulf Power only
LOOP ID – N1
N4 / 270 / Geographic Location / NAESB includes, SoCo excludes
N404 Country Code
REF / 280 / ZZ – mutually defined (catch-all) / SoCo includes, NAESB excludes
SUMMARY
TDS / 010
TXI / 020 / SoCo includes, NAESB excludes
SAC / 040 / Non-Service Charges like Administrative Charges / SoCo includes, NAESB excludes
CTT / 070
SE / 080
GE / Functional Group Header / Add to guidelines
IEA / Interchange Control Header / Add to guidelines

EDI 820 PAYMENT ORDER/REMITTANCE ADVICE

EDI Guideline Section
SoCo includes,
NAESB excludes
NAESB includes,
SoCo excludes
SEGMENT ID / POSITION # / NAME/DESCRIPTION / NOTES/COMMENTS
ISA / Interchange Control Header / Add to guidelines
GS / Functional Group Header / Add to guidelines
HEADING
BPR / 020 / Beginning Segment for Payment Order/Remittance Advice / NAESB includes, SoCo excludes
BPR01
I Remittance Information Only (used when remittance data is sent separate from payment)
BPR03
Are debit “D” transaction allowed for reversals?
BPR04
NAESB includes, SoCo excludes
CHK check
FWT Federal Reserve Funds/Wire Transfer-Non-repetitive
BPR05
CCP does not equal CCD+
SoCo includes, NAESB excludes
BPR06 DFI ID number qualifier
BPR07 Originating bank routing ID (sender’s bank ABA)
BPR08 Account number qualifier (DA for Demand Deposit)
BPR09 Account number (sender’s bank account number)
BPR12 DFI number qualifier (destination bank)
BPR13 DFI identification number (destination bank routing ID)
BPR14 Account number qualifier (DA Demand Deposit)
BPR15 Account number (bank account number of party receiving payment)
TRN / 035 / Trace Number / Must have TRN or REF segment with unique ID
REF / 050 / Reference Identification / REF used to send bank trace number if not sent in TRN segment
N1 LOOP
N1PE
N1PR
PER / 120 / Administrative Communications Contact / SoCo includes, NAESB excludes
SoCo recommends PER segment include phone number information for payment research and tracking
DETAIL
ENT / 010 / Entity / SoCo includes, NAESB excludes
SoCo expects sequential counter for each RMR record or an ENT for each group of RMR segments
ENT02 Entity Identifier Code AG Agent/Agency
ENT03 Identification Code Qualifier (assigned by receiver)
ENT04 Identification code
NM1 / 020 / Individual or Organizational Name / SoCo includes, NAESB excludes
SoCo recommends NM1 segments for individual customer payments
N3 / 040 / Address Information / SoCo includes, NAESB excludes
SoCo recommends N3 segments for individual customer payments
N4 / 270 / Geographic Location / SoCo includes, NAESB excludes
SoCo recommends N4 segments for individual customer payments
NAESB includes, SoCo excludes
N404 Country Code
REF / 060 / Reference Identification / Detail Transaction reference number (customer includes)
NTE / 090 / Note/Special Instruction / Customer provided adjustment notes
RMR / 150 / Remittance Advice Accounts Receivable Open Item Reference / SoCo includes, NAESB excludes
RMR01
11 Account number
CR Customer reference number
IN Consignee’s invoice number
IV Seller’s invoice number
OI Original invoice number
PO Purchase order number
RMR02 Reference identification required for CTX/820 and CCD+. Supplier account number listed first in field.
RMR03 Payment Action Code
AJ Adjustment not valid code. Not processed as an adjustment by SoCo.
RMR04 Net Amount Paid required CTX/820 and CCD+.
NAESB includes, SoCo excludes
IK Invoice number
RMR07 Adjustment Reason Code (not processed by SoCo)
26 Invoice cancelled
72 Authorized return
CS Adjustment
IF Insufficient funds
RMR08 Adjustment Amount (not processed by SoCo)
REF12/Q5 / 170 / Customer account ID / NAESB includes, SoCo excludes
Deregulated markets use to provide distribution company information.
SoCo includes REF 170 to provide detail level transaction number REF01 “TN” only.
REF11 / 170 / Supplier account number / NAESB includes, SoCo excludes
Deregulated markets use to provide supplier account information.
REF01
11 Supplier account information
REFQY / 170 / Commodity service type / NAESB includes, SoCo excludes
Not required for regulated utility
DTM003 / 180 / Invoice date / NAESB includes, SoCo excludes
Not required for regulated utility
SUMMARY
GE / Functional Group Header / Add to guidelines
IEA / Interchange Control Header / Add to guidelines

1

11/8/2018

C:\Documents and Settings\wmhollad\Local Settings\Temporary Internet Files\OLKBC\NAESBRETAILELECTRICANDRETAILGASQUADRANTS (2).doc