req_rgq_teis092805a1

Document Sample
req_rgq_teis092805a1 Powered By Docstoc
					                                   D R A F T IR/TEIS Working Paper

        REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
IR/TEIS Issue List for BPS Consideration
ID               DESC
IR005 (BW)       Triage request for MBP’s for ‘Reversal’ versus ‘Cancel’ of charges
IR009 (GB)       Add ‘Taxing Entity’ to bill ready.
IR012 (All)      Code value tables (IR document)                                      Formatted: French (France)
IR013 (RA)       MBP Review (RA)
IR014 (All)      [All] Reconcile data elements
                                    D R A F T IR/TEIS Working Paper

        REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)

          TECHNICAL IMPLEMENTATION: BILLING USAGE [GB]
Technical Implementation Of Business Process
Related MBP’s: RXQ.3.3.2.3, RXQ.3.3.2.4, RXQ.3.3.1.5,                 RXQ.3.3.4.9,   RXQ.3.3.4.10,
RXQ.3.3.5.4, RXQ.3.3.5.5, RXQ.3.3.6.2

The Billing Usage (BillUsage) transaction is the inter-company communication that itemizes
energy consumption or demand for a given period of time, used to determine invoice charges.
The transaction reflects usage from actual meter reads, estimated meter reads, interval meter
reads, unmetered usage, and usage used by the meter reader for billing. BillUsage is not used
to communicate historical usage.

The Billing Usage transaction supports all market billing models (Dual billing, consolidated bill-
ready and rate ready, and single retailer billing option).

The types of usage transactions supported by BillUsage in retail energy markets are:
    Monthly usage
    Interval usage
    Summarized interval usage
    Cancel usage (all of the above can be cancelled)

Each Billing Usage transaction can include any of the following categories of Usage:
    Summary (PTD*SU)                                                                                Formatted: NAESB Bullets Tight
    Non-Interval Detail (PTD*PL) – Monthly usage, including time                        of   use,   Formatted: Bullets and Numbering
      additive/subtractive, missing/abundance consumption,
    Unmetered Services Summary (PTD*BC)
    Unmetered Services Detail (PTD*BD)
    Net Interval Usage Summary (PTD*IA)                                                             Formatted: NAESB Bullets Tight
    Interval Usage Summary Across Meters (PTD*PP)
    Interval Summary (PTD*BO)
    Interval Detail (PTD*PM)

The Sender of the transaction is either the meter reading entity (MRE), the distribution company
(LDC), or a central registration agent (e.g. ERCOT). The Receiver of the usage could be a
supplier/retailer, a distribution company or a central registration agent (e.g. ERCOT).

The usage is identified by the Usage Unique ID (UUID; formerly ‘Reference Number ID’). This
UUID is assigned by the originator of the usage UET – either the MRE or the LDC. If usage is
cancelled, the Original UUID indicates the specific UUID to be cancelled.

The UUID is echoed in any invoice or payment UET’s that use this usage, establishing a thread
to tie these transactions together for involved parties.

Each original BillUsage header contains:
    Final Indicator [FinalInd]
    Sender Common Code ID [SenderID]
    Sender Name [SenderName]
    Customer Account ID [CustAcctID]
    Customer Name [CustName]
    Customer Name Overflow [CustNameOver]
    Non-Billing Party Invoice Due Date [InvoiceDueDate]
    Receiver ID [ReceiverID]
                                      D R A F T IR/TEIS Working Paper

         REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
      Receiver Name [ReceiverName]
      Receiver Account ID [ReceiverAcctID]
      Original UUID [OriginalUUID]
      Party Calculating Bill [PartyCalculatingBill]
      Party Sending Bill [PartySendingBill]
      Purpose [Purpose] = ‘Original’
      Usage Unique ID [UUID]
      Report Type Code [ReportType]
      Service Type [ServiceType]
      Transaction Date [TransDate]

Each original BillUsage can contain multiple detail records. Each detail record contains:
    Ending/Single Reading [EndSingleRead]
    Quantity [Quantity]
    Summary Level [SummaryLevel]
    Unit of Measure [UnitOfMeasure]
    Interval End Date Time [IntervalEndTime]
    Measurement Reference ID [MeasureRefID]
    Service Period End Date [ServPerEndDate]
    Service Period Start Date [ServPerStartDate]
    Therm Factor [ThermFactor]
    Transformer Loss Multiplier [TransLossMultiplier]
    Usage Detail Category [UsageDetailCategory]
    Usage Code [UsageCode]

If providing information at a meter level, each original BillUsage detail contains, if available:
      Beginning Reading [BegRead]
      Meter Multiplier [MeterMultiplier]
      Meter Consumption Type [MeterConsType]
      Meter Interval Type [MeterIntervalType]
      Meter Number [MeterID]
      Meter Role [MeterRole]
      Number of Dials / Digits [NumDialsDigits]
      Power Factor [PowerFactor]
      Pressure Correction Factor [PresCorrFactor]
      Primary Metering Indicator [PrimaryMeter]

In addition to the above detail elements, each original BillUsage interval usage transaction has a
interval detail record for each interval, as defined by Meter Consumption Type and Meter
Report Period, including:
     Interval Date
     Interval Time
     Interval Quantity
     Interval Unit of Measure

Each cancel BillUsage includes Purpose Code = ‘Cancel’, the UUID trace number to the
original transaction, and the same data found in the original BillUsage transaction.

Reissuing cancelled usage is treated as original usage.
                                         D R A F T IR/TEIS Working Paper

       REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
Sample Paper Transaction
                                                Usage Header
      Usage Date:                                                         20040413
      Usage Unique ID:                                                    04132004TR4877
      Original Usage Unique ID:
      Purpose:                                                            Original
      Final Indicator:                                                    No

      Sender Name:                                                        Distribute-It Incorporated
      Sender Common Code ID:                                              123456789

      Receiver Name:                                                      Sell-It Incorporated
      Receiver Entity Common Code ID:                                     546897321

      Total KWH Billed                                                    4,000
      Total KW Billed                                                     20
      Total KVA Billed                                                    18

                                                                   Interval
                               Service Period     Service Period                Actual/       Unit of
    Category      Meter #                                            End                                 Quantity
                                 Start Date         End Date                   Estimated     Measure
                                                                     Time
       IU        12345678        20040410            20040509        0015         Actual        KW          200

       IU        12345678        20040410            20040509        0030       Estimated       KW


                                    Service Period       Service Period        Actual/       Unit of
      Category       Meter #                                                                            Quantity
                                      Start Date           End Date           Estimated     Measure
        MU        23456789             20040410             20040509           Actual        KWH          200

        MU        23456789             20040410             20040509          Estimated      KWH
                                                                                    D R A F T IR/TEIS Working Paper

                                              REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
Data Dictionary
                                                                                                                                                                                                           Formatted: Normal



           Current BP Data Elem.
Item #                                                        Description                              Use    Condition                                    Comments and Code Value              Group
                   Name ID
         Meter Exchange Date          Date meter was exchanged                                          M                                                                                    3:MtrDetail
         Unmetered Service Type
         Customer Account ID
  5                                   Customer Account ID or SDID assigned by the Billing Party         M                                                                                    1:Header
         [CustAcctID]
         Customer Name                End Use Customer Name as defined in Billing Party’s
  6                                                                                                     M                                                                                    1:Header
         [CustName]                   systems
         Customer Name Overflow       Additional information used to further identify the
  7                                                                                                    SO                                                                                    1:Header
         [CustNameOver]               Customer, as defined in Billing Party’s systems.
  2      Final Indicator [FinalInd]   Indicates whether this is a final bill                            M                                           [Yes, No]                                1:Header
         Non-Billing Party Invoice    The last date invoices will be accepted by the Billing Party
  8                                                                                                   RBC                                           CBBR only                                1:Header
         Due Date [InvoiceDueDate]    for inclusion on the bill
                                                                                                                                                    When a transaction is cancelled, the
         Original UUID                The UUID from the original transaction, used only to cancel             [M] when Purpose=‘Reverse’ or
 22                                                                                                     C                                           Original Reference Number is used as a 1:Header
         [OriginalUUID]               the original.                                                           ‘Cancel’
                                                                                                                                                    trace number
         Party Calculating Bill       Code that identifies which party calculates the NBP
 23                                                                                                   RBC                                           [Distribution Company, DUAL, Supplier]   1:Header
         [PartyCalculatingBill]       charges
         Party Sending Bill
 24                                   Code that identifies which party sends the bill                 RBC                                           [Distribution Company, DUAL, Supplier]   1:Header
         [PartySendingBill]
 28      Purpose [Purpose]            Code that defines the reason for sending this information         M                                           [Original, Cancellation]                1:Header
         Receiver Account ID                                                                                                                        BR: sent if previously received by Non-
 20                                   Customer Account ID assigned by the NBP                         RBC                                                                                   1:Header
         [ReceiverAcctID]                                                                                                                           Billing Party
                                      NBP Entity Common Code ID (DUNS Number or DUNS+4
 18      Receiver ID [ReceiverID]                                                                       M                                                                                    1:Header
                                      Number or other mutually-agreed upon number)
         Receiver Name
 19                                   Identifies the NBP                                                M                                                                                    1:Header
         [ReceiverName]
         Report Type Code             Code that defines whether usage is being reported or a                                                        [Interval, Non-
 30                                                                                                     M                                                                                   1:Header
         [ReportType]                 meter is being changed.                                                                                       IntervalAccount,Meter,Rate,Unmetered??]
                                      Common Code ID (DUNS Number or DUNS+4 Number or
         Sender Common Code ID
  3                                   other mutually-agreed upon number) of the party that              M                                                                                    1:Header
         [SenderID]
                                      initiates the transaction.
         Sender Name
  4                                 Name of the trading partner that initiates the transaction.         M                                                                                    1:Header
         [SenderName]
 33      Service Type [ServiceType] Code that defines the type of service rendered                      M                                           [Electric, Gas]                          1:Header
         Transaction Date
 35                                 Date the transaction was generated                                  M                                                                                    1:Header
         [TransDate]
                                    Unique number created by the originator identifying this
 29      Usage Unique ID [UUID]                                                                         M                                                                                    1:Header
                                    usage transaction
  9      Ending/Single Reading      The ending reading or single reading for metering period.           C     [M] when ReportType =’METER’                                                   2:UsageDet


                                           Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                        04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                           5 of 39
                                                                                   D R A F T IR/TEIS Working Paper

                                             REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
            Current BP Data Elem.
Item #                                                       Description                              Use    Condition                                    Comments and Code Value                     Group
                   Name ID
         [EndSingleRead]
         Interval End Date Time                                                                              [M] when
                                     Timestamp for interval read                                       C                                                                                           2:UsageDet
         [IntervalEndTime]                                                                                   ReportType='INTERVAL'
                                                                                                                                                   [Beg / End actual; Beg actual / End
         Measurement Reference ID
 13                               Identifies the category to which the measurement applies.            C     [M] when ReportType =’METER’          estimated; Actual Total; As Billed; Beg         2:UsageDet
         [MeasureRefID]
                                                                                                                                                   est. / End actual; Beg est. / End est.]
 10      Quantity [Quantity]         Usage                                                             M                                                                                           2:UsageDet
         Service Period End Date
 31                                  Current Meter Reading Date                                        M                                                                                           2:UsageDet
         [ServPerEndDate]
         Service Period Start Date
 32                                  Previous Meter Reading Date                                       M                                                                                           2:UsageDet
         [ServPerStartDate]
         Summary Level               Code that defines if the data is summarized by Account,                                                       Account,    Rate,     SDID,       Un-metered,
 11                                                                                                    M                                                                                           2:UsageDet
         [SummaryLevel]              Rate, SDID, Un-metered, or Meter.                                                                             Metered
                                                                                                             [M] when ReportType= ’METER’
         Therm Factor
 34                                  Converts volumetric meter reading data to therm values            C     and ServiceType= ’GAS’ and                                                            2:UsageDet
         [ThermFactor]
                                                                                                             UnitMeasure = ‘THERM’
                                     Transformer Loss Multiplier. When a customer owns a
         Transformer Loss Multiplier                                                                         [M] when this measure is
 36                                  transformer and the transformer loss is not measured by           C                                                                                           2:UsageDet
         [TransLossMultiplier]                                                                               available
                                     the meter.
         Unit of Measure                                                                                                                           [kW, kWh, therms, ccf, mcf] Only when
 12                                  Unit of measure for quantity                                      M                                                                                 2:UsageDet
         [UnitOfMeasure]                                                                                                                           line item has a measure
                                     Code distinguishes between estimated usage and actual
 38      Usage Code [UsageCode]                                                                        M                                           [Actual, Estimated]                             2:UsageDet
                                     usage
                                                                                                                                                   [Sum./Non-Interval,          Sum./Interval,
         Usage Detail Category
 37                                  Code that defines what type of detailed usage is reported         M                                           Billed/Interval,       Billed/Non-Interval, 2:UsageDet
         [UsageDetailCategory]
                                                                                                                                                   Detailed/Interval, Unmetered ]
         Usage Detail Time Of Use    Code that defines whether this usage is on peak, off peak,
                                                                                                                                                   [On Peak, Off Peak, Intermediate Peak]          2:UsageDet
         [UsageTOU]                  or intermediate peak
         Beginning Reading
  1                                  Value specifying beginning reading for the metering period.       C     [M] when ReportType =’METER’                                                          3:Meter
         [BegRead]
                                     Represents the number of units that are reflected by one
         Meter Multiplier
 15                                  dial or digit increment. Can be multiple multipliers per          C     [M] when ReportType=’METER’                                                           3:Meter
         [MeterMultiplier]
                                     meter
 16      Meter Number [MeterID]      Serial number identifier for a specific meter                   RBC                                           Can have multiple meters.                       3:Meter
                                     Code that defines the effect of consumption on
 17      Meter Role [MeterRole]                                                                        C     [M] when Report Type =’METER’         [Subtractive; Additive; Ignore]                 3:Meter
                                     summarized total.
                                                                                                                                                   [Kilowatt demand, kilovolt Amperes
         Meter Consumption Type                                                                                                                    Reactive Demand, Kilovolt Amperes
                                     Code that defines the type of meter consumption                   M                                                                                     3:Meter
         [MeterConsType]                                                                                                                           Reactive Hour, Kilovolt Amperes, Kilowatt
                                                                                                                                                   Hour]
                                                                                                                                                   [minutes, Annual, Biannual, Bi-monthly,
         Meter Report Period         Code that defines the period being reported                       M                                                                                     3:Meter
                                                                                                                                                   daily, monthly, quarterly, Time of use]
                                     Code used to define if the meter is ‘behind the meter’ (e.g.            [M] when meter is considered
         Meter Add’l Info Code                                                                        BC                                           [Behind the meter]                              3:Meter
                                     Cogen’)                                                                 ‘behind the meter’]


                                          Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                      04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                         6 of 39
                                                                                    D R A F T IR/TEIS Working Paper

                                              REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
           Current BP Data Elem.
Item #                                                        Description                              Use    Condition                                    Comments and Code Value                  Group
                  Name ID
         Power Region                 Reliability Council                                             RBC                                                                                       1:Header
         Number of Dials / Digits                                                                                                                   X12 uses dials to left of decimal, digits to
 21                                   Identify the number of meter dials or digits on the meter         C     [M] when Report Type =’METER’                                                      3:Meter
         [NumDialsDigits]                                                                                                                           right of decimal
         Power Factor                 Relationship between Watts and Volt - Amperes necessary                 [M] when this measure is
 25                                                                                                     C                                                                                       3:Meter
         [PowerFactor]                to supply electric load                                                 available
         Pressure Correction Factor
 26                                   Corrects for varying delivery pressures                           C     [M] when ReportType= ’METER’                                                      3:Meter
         [PresCorrFactor]
         Primary Metering Indicator
 27                                   Indicates the customer has primary metering                     RBC                                           [Yes, No]                                   3:Meter
         [PrimaryMeter]




                                           Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                        04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                           7 of 39
                                                    D R A F T IR/TEIS Working Paper

            REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
Code Values Dictionary

                                                                                                                         X12 Code
Data Element                  Code Description             Code Definition                                 X12 Loc
                                                                                                                         Value
FinalInd                      Yes                        Identifies last usage to be sent by MRE/LDC       BPT07         F
FinalInd                      No                         Identifies last usage to be sent by MRE/LDC       BPT07         [blank]
SummaryLevel                  Account                    Account-level usage provided                      PTD
SummaryLevel                  Rate                       Rate-level usage provided [obsolete?]             PTD
SummaryLevel                  SDID                       SDID/ESIID-level usage provided                   PTD
SummaryLevel                  Un-metered                 Unmetered usage provided                          PTD
SummaryLevel                  Metered                    Meter-level usage provided                        PTD
UnitOfMeasure                 kW                         kiloWatt (demand)                                 MEA           K1
UnitOfMeasure                 kWh                        kiloWatt hours (consumption)                      MEA           KH
UnitOfMeasure                 Therms                     Therms                                            MEA
UnitOfMeasure                 Ccf                        100 Cubic feet                                    MEA
UnitOfMeasure                 Mcf                        1000 cubic feet                                   MEA
                                                         Beginning and Ending reading are actual                         AA
MeasureRefID                  Beg / End Actual                                                             MEA01                     Formatted Table
                                                         readings
                              Beg     Actual /       End Beginning reading is actual reading; Ending                     AE
MeasureRefID                                                                                               MEA01
                              Estimated                  reading is an estimate
MeasureRefID                  Actual Total               Total is actual reading                           ??
MeasureRefID                  As Billed                  As Billed                                         ??
                              Beg Estimated /        End Beginning reading is estimated reading;
MeasureRefID
                              Actual                     Ending reading is actual
                                                                                                           MEA01         EA
MeasureRefID                  Beg / End Estimated          Beginning and Ending reading are estimated      MEA01         EE
MeterRole                     Subtractive                  Meter measures are subtracted from totals       REF*JH        S
MeterRole                     Additive                     Meter measures are added to totals              REF*JH        A
MeterRole                     Ignore                       Meter measures are ignored from totals          REF*JH        I
??                            Subtractive                  Meter measures are subtracted from totals       PTD06         AO
??                            Additive                     Meter measures are added to totals              PTD06         AI
                                                           Distribution Company calculates non-billing
Party Calculating Bill        Distribution Co
                                                           party charges
Party Calculating Bill        Retailer                     Retailer calculates non-billing party charges
Party Calculating Bill        Dual                         Each party calculates their own charges
                                                           Distribution Company sends bill with non-
Party Sending Bill            Distribution Co
                                                           billing party charges
                                                           Retailer sends bill with non-billing party
Party Sending Bill            Retailer
                                                           charges
Party Sending Bill            Dual                         Each party sends their own bill
Primary Meter Indicator       Yes                          Indicates this is the primary meter
Primary Meter Indicator       No                           Indicates this is not the primary meter
Purpose                       Original                     Original usage                                  BPT01
Purpose                       Cancellation                 Cancellation of usage                           BPT01
Report Type Code              Interval                     Interval usage                                                C1
Report Type Code              Non-Interval                 Non-Interval usge including unmetered                         DD
Service Type                  Electric                     Electric                                                      REF*QY*EL
Service Type                  Gas                          Gas                                                           REF*QY*GA
Usage Detail Category         Summary Non-Interval         Summary Non-Interval usage
Usage Detail Category         Summary Interval             Summary Interval usage
Usage Detail Category         Billed Interval              Billed Interval usage
Usage Detail Category         Summary Unmetered            Summary Unmetered usage
Usage Detail Category         Detail Meter                 Detail Meter usage
Usage Code                    Actual                       Actual Usage
Usage Code                    Estimated                    Estimated usage


Old table
                                                                                                                     Code
     Data Element                   Code Description              Code Definition
                                                                                                                     Value
     FinalInd                       Yes                           Identifies last usage to be sent by MRE/LDC        F
     FinalInd                       No                                                                               [blank]
                         04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                            8 of 39
                                             D R A F T IR/TEIS Working Paper

         REQ/RGQ Billing and Payment Model Business Practices (RXQ.3.3)
   SummaryLevel               Account
   SummaryLevel               Rate
   SummaryLevel               SDID
   SummaryLevel               Un-metered
   SummaryLevel               Metered
   UnitOfMeasure              kW                           kiloWatt (demand)                                K1
   UnitOfMeasure              kWh
   UnitOfMeasure              Therms
   UnitOfMeasure              Ccf
   UnitOfMeasure              Mcf
                                                           Beginning and Ending reading are actual
   MeasureRefID               Beg / End Actual
                                                           readings
                                                           Beginning reading is actual reading; Ending
   MeasureRefID               Beg Actual / End Estimated
                                                           reading is an estimate
   MeasureRefID               Actual Total                 Total is actual reading
   MeasureRefID               As Billed                    As Billed
                                                           Beginning reading is estimated reading; Ending
   MeasureRefID               Beg Estimated / End Actual
                                                           reading is actual
   MeasureRefID               Beg / End Estimated          Beginning and Ending reading are estimated
   MeterRole                  Subtractive
   MeterRole                  Additive
   MeterRole                  Ignore
   Party Calculating Bill     Distribution Co
   Party Calculating Bill     Retailer
   Party Calculating Bill     Dual
   Party Sending Bill         Distribution Co
   Party Sending Bill         Retailer
   Party Sending Bill         Dual
   Primary Meter Indicator    Yes
   Primary Meter Indicator    No
   Purpose                    Original
   Purpose                    Cancellation
   Report Type Code           Account
   Report Type Code           Meter
   Report Type Code           Unmetered
   Report Type Code           Rate
   Service Type               Electric
   Service Type               Gas
   Usage Detail Category      Summary Non-Interval
   Usage Detail Category      Summary Interval
   Usage Detail Category      Billed Interval
   Usage Detail Category      Summary Unmetered
   Usage Detail Category      Detail Meter
   Usage Code                 Actual
   Usage Code                 Estimated


X12 EDI Subtab
Data Element Cross Reference to ASC X12
Sample ASC X12 Transaction
ASC X12 Mapping Guidelines
Transaction Set Tables




                   04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                      9 of 39
                                       D R A F T IR/TEIS Working Paper

                        4.2 Consolidated Billing Bill-Ready Invoice

TECHNICAL IMPLEMENTATION: CONS. BILL-READY INVOICE [BKW]
Technical Implementation Of Business Process

Related MBP’s: RXQ..1.3.3.1, RXQ.3.3.4.2 through 1.3.4.12

The Consolidated Billing Bill-Ready Invoice transaction is the communication used by the non-
billing party to transmit the billing components and amounts of charges to the billing party for
presentation on the customer’s bill. The billing party sends an invoice to the customer that
displays both the billing and non-billing parties’ charges.

The types of invoice transactions supported by Consolidated Bill-Ready Invoice in retail energy
markets include:
    Monthly Invoice Original
    Monthly Invoice Cancel
    Final Invoice

The Sender and Receiver of the transaction is either the distribution company or the
supplier/retailer.

The Invoice Number ID (InvID) identifies the invoice. This is a unique number assigned by the
originator of the transaction.

The Non-Billing Party echoes in the invoice transaction the specific Usage Unique ID (UUID)
originally transmitted with the usage information. The UUID links the usage, invoice and
payment transactions together for tracking purposes.

Each Invoice Header contains the following:
    Invoice Date
    Invoice ID
    Usage Unique ID
    Purpose
    Final Indicator (when applicable)
    Billing Party (BP) Name
    Billing Party (BP) ID
    Non-Billing Party (NBP) Name
    Non-Billing Party (NBP ID)
    Non-Billing Party Account ID (when applicable)
    Customer Name
    Customer Account ID or SDID
    BP Customer Previous Account Number or SDID
    Service Address
    Service Type
    Party Calculating Bill
    Party Sending Bill
    Non-Billing Party Rate Code
    Non-Billing Party Message to Customer
    Service Period Start Date
    Service Period End Date
    Transaction Date

               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  10 of 39
                                        D R A F T IR/TEIS Working Paper

                         4.2 Consolidated Billing Bill-Ready Invoice
      Non-Billing Party Current Total Charges.

Each Invoice can have multiple Charge Detail records.                     Each Invoice Detail contains the
following:
      Charge/Allowance Line Amount
      Charge/Allowance Line Category
      Charge/Allowance Credit/Debit Code
      Charge Allowance Line Description
      Charge Allowance Line Quantity
      Charge/Allowance Line Summary
      Charge/Allowance Line Unit of Measure.

Each Single Retailer Billing Option (SRBO) Invoice Detail contains
    Non-Billing Party Charge/Allowance Rate ID
    Non-Billing Party Charge/Allowance Rate Class
    Non-Billing Party Charge/Allowance Rate Subclass

Each Invoice can have multiple Tax Detail records. Each Tax Detail contains the following:
    Taxes
    Taxing Entity.

Each cancel transaction includes Purpose Code = Cancel, the UUID trace number from the
original Billing Usage transaction, and the same data found in the original Invoice transaction.

Reissuing an invoice is treated as an original invoice.




                04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                   11 of 39
                                     D R A F T IR/TEIS Working Paper

                      4.2 Consolidated Billing Bill-Ready Invoice
Sample Paper Transaction
                                Invoice Header
      Invoice Date:                                                20040413
      Invoice Number:                                              04132004TR4877
      Usage Cross-Reference Number:                                04132004MR8392
      Invoice Purpose:                                             Original
      Final Invoice Indicator:                                     No

      Billing Party (BP) Name:                                     Distribute-It Incorporated
      BP Entity Common Code ID:                                    123456789

      Non-Billing Party (NBP) Name:                                Sell-It Incorporated
      NBP Entity Common Code ID:                                   546897321

      BP Customer Name:                                            John Shoulders
      BP Customer Account Identifier or SDID:                      8473937UHFTR41304
      BP Customer Previous Account Number or
      SDID:

      Service Type:                                                Electric
      NBP Rate Code:                                               NBPR1

      Service Period Start Date:                                   20040313
      Service Period End Date:                                     20040412


                          Line Item Charges and Allowances
Indicator   Category     UnitQty Rate     Amt      Description
                                                   Current    Basic      Generation -
Charge     GEN002     KWh 500 $0.100 $50.00 Consumption
                                                   Current Basic Generation - Peak
Charge     DMD009     KW      20   $1.000 $20.00 Demand
Charge     LPC001              1   $20.00 $20.00 Late Payment Charge
Allowance ADJ002               1   $10.00 $10.00 Adjustment to Last Bill
Charge     BAS001              1   $0.750   $0.75 Miscellaneous: Receivables Charge
          Total of NBP Line Item Charges: $79.25




             04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                12 of 39
                                                                                        D R A F T IR/TEIS Working Paper

                                                                    4.2 Consolidated Billing Bill-Ready Invoice
Data Dictionary

          Current BP Data Elem. Name
 Item #                                                       Description                         Use     Condition                                Comments and Code Value           Group
                      ID
                                                                                                                                                                                   1:Header
   1      Final Indicator [FinalInd]        Indicates whether this is a final bill                 M                                            [Yes, No]
                                                                                                                                                                                   BIG
                                            Distribution Company's Entity Common Code
          Distribution Company ID           Identifier (DUNS Number or DUNS+4                                                                                                      1:Header
   2                                                                                               M
          [BillPtyID]                       Number or other mutually-agreed upon                                                                                                   N1*8S
                                            number)
          Distribution Company Name                                                                                                                                                1:Header
   3                                        Identifies the Distribution Company                    M
          [BillPtyName]                                                                                                                                                            N1*8S
          Distribution Company              Code that defines if the Distribution Company
                                                                                                                                                                                   1:Header     N1*8S
          Submitter/Receiver Code           is the submitter or the receiver of the invoice.
          Customer Account ID               Customer Account ID or SDID assigned by                                                                                                1:Header
   4                                                                                               M
          [CustAcctID]                      the Distribution Company                                                                                                               REF*12
          Chg/Allow Line Amount                                                                                                                                                    2:CADetail
   7                                        Dollar amount (credit or debit) for the charge.        M
          [CAAmt]                                                                                                                                                                  SAC
                                                                                                                                                [Adjustment, Budget, Late
                                                                                                                                                Payment, Miscellaneous, Payment
          Chg/Allow Line Category
   8                                        Code for the class of charge                           M                                            Plan Charge] plus other governing 2:CADetail    SAC
          [CACat]
                                                                                                                                                standards codes; see Governing
                                                                                                                                                Documents for codes
                                            Code that defines if Line Item Charge/
          Chg/Allow Line Credit/Debit                                                                                                                                              2:CADetail
   9                                        Allowance is an allowance (credit), charge             M                                            Allowance, Charge, No Charge
          Code [CADebitCode]                                                                                                                                                       SAC
                                            (debit) or no charge to the customer
                                            Text description for Line Item
          Chg/Allow Line Description                                                                                                                                               2:CADetail
  10                                        Charge/Allowance that will print on the              RBC
          [CADesc]                                                                                                                                                                 SAC
                                            customer's bill
          Chg/Allow Line Quantity                                                                                                                                                  2:CADetail
  11                                        Usage                                                  M
          [CAQty]                                                                                                                                                                  SAC
                                            Code that defines if the data is summarized
          Chg/Allow Line Summary                                                                                                                Account, Rate, SDID, Un-metered, 2:CADetail
  12                                        by Account, Rate, SDID, Un-metered, or                 M
          Level [CASummaryLevel]                                                                                                                Metered                          IT1
                                            Meter.
          Chg/Allow Line Unit of                                                                                                                [kW, kWh, therms, ccf, mcf] Only   2:CADetail
  13                                        Unit of measure for quantity                           M
          Measure [CAUnitOfMeasure]                                                                                                             when line item has a measure       SAC
                                                                                                                                                [American dollars, Canadian
          Currency                          Code that defines currency                             M                                                                               2:CADetail   CUR
                                                                                                                                                dollars, pesos]
                                            NBP Entity Common Code ID (DUNS
                                                                                                                                                                                   1:Header
  15      Supplier ID [NBPID]               Number or DUNS+4 Number or other                       M
                                                                                                                                                                                   N1*SJ
                                            mutually-agreed upon number)
          Supplier Account ID                                                                                                                                                      1:Header
  16                                        Customer Account ID assigned by the NBP              RBC
          [NBPAcctID]                                                                                                                                                              REF*11
          Supplier Submitter/Receiver       Code that defines if the Supplier is the
                                                                                                   M                                                                               1:Header     N1*SJ
          Code                              submitter or the receiver of the invoice.
          Non-Billing Party Current Total                                                                                                                                          1:Header
  19                                        Sum of all current charges                             M
          Charge [TotalChg]                                                                                                                                                        TDS
                                            Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                        04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                           13 of 39
                                                                                D R A F T IR/TEIS Working Paper

                                                            4.2 Consolidated Billing Bill-Ready Invoice
20   Non-Billing Party Name          Identifies the NBP                                   M                                                                                  1:Header
     [NBPName]                                                                                                                                                               N1*SJ
     Chg/Allow Line Rate Class                                                                                                                                               2:CADetail
21                                   NBP Rate Class                                       RBC
     [CARateClass]                                                                                                                                                           REF
     Chg/Allow Line Rate ID                                                                                                                                                  2:CADetail
22                                   NBP Rate Code for the charges                        RBC
     [CARateID]                                                                                                                                                              REF
     Chg/Allow Line Rate Subclass                                                                                                                                            2:CADetail
23                                   NBP Rate Subclass                                    RBC
     [CASubClass]                                                                                                                                                            REF
     Non-Billing Party Message To    A text message the NBP wants to appear on                                                                                               1:Header
24                                                                                        RBC
     Customer [Msg2Cust]             the customer’s bill                                                                                                                     NTE
                                     The unique number assigned to the original
                                     document, used only to cancel the original.
     Original Invoice ID                                                                           Send when Purpose is ‘Reversal’                                           1:Header
25                                   When a transaction is cancelled, the Original         C
     [OriginalInvID]                                                                               or ‘Cancellation’                                                         BIG
                                     Reference Number is used as a trace
                                     number.
     Party Calculating Non-Billing
                                     Code that identifies which party calculates                                                         [Distribution Company, DUAL,        1:Header
26   Party Charges                                                                        RBC
                                     the NBPcharges                                                                                      Supplier]                           REF*PC
     [PartyCalculatingNBPCharges]
     Party Sending Bill              Code that identifies which party sends the bill                                                     [Distribution Company, DUAL,        1:Header
27                                                                                        RBC
     [PartySendingBill]              to the end-use customer                                                                             Supplier]                           REF*BLT
                                     Code that defines the reason for sending this                                                       Original, Cancellation, Reversal,   1:Header
33   Purpose [Purpose]                                                                     M
                                     information                                                                                         Reissue                             BIG
                                     Unique number identifying this transaction
                                                                                                                                                                             1:Header
34   Invoice ID [InvID]              and created by the originator of this                 M
                                                                                                                                                                             BIG
                                     transaction
                                     Customer's service address that may not be                                                                                              1:Header
35   Service Address [ServAddr]                                                           RBC
                                     the Customer's Mailing Address                                                                                                          N1*8R
     Service Period End Date                                                                                                                                                 1:Header
36                                   Current Meter Reading Date                            M
     [ServPerEndDate]                                                                                                                                                        DTM*151
     Service Period Start Date                                                                                                                                               1:Header
37                                   Previous Meter Reading Date                           M
     [ServPerStartDate]                                                                                                                                                      DTM*150
                                     Code that defines the type of service                                                                                                   1:Header
38   Service Type [ServiceType]                                                            M                                             [Electric, Gas]
                                     rendered                                                                                                                                IT1
                                     A taxable amount transmitted to the non-                                                                                                2:TaxDetail
39   Taxes [Taxes]                                                                        RBC
                                     taxing Party                                                                                                                            TXI
                                                                                                                                                                             2:TaxDetail
     Taxing Entity [TaxEntity]       A code that identifies the taxing entity             RBC
                                                                                                                                                                             TXI
                                                                                                                                                                             1:Header
40   Transaction Date [TransDate]    Date the transaction was generated                    M
                                                                                                                                                                             BIG
                                     The cross-reference number originally                                                                                                   1:Header
42   Usage Unique ID [UUID]                                                                M
                                     transmitted with the usage information                                                                                                  BIG




                                     Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                 04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                    14 of 39
                                                    D R A F T IR/TEIS Working Paper

                                  4.2 Consolidated Billing Bill-Ready Invoice
  Code Values Dictionary

Data Element                      Code Description       Code Definition                      Code Value
FinalInd                          Yes                    Identifies last bill to be sent      F
FinalInd                          No                     Left blank??                         [blank]
Charge/Allowance Line
                                  Charge                 Charge                               C
Credit/Debit Code
Charge/Allowance Line
                                  No                     No Allowance or Charge               N
Credit/Debit Code
Charge/AllowanceLine
                                  Allowance              Allowance                            A
Credit/Debit Code
                                  See UIG and
Charge/Allowance Line             governing                                                   See UIG and governing documents
                                                         Energy Charges
Category                          documents for                                               for codes
                                  codes
Charge/Allowance Line Unit of
                                  Watt                   Watt                                 99
Measure Code
                                  kW - Represents
                                  potential power load
Charge/Allowance Line Unit of                           kW - Represents potential power load
                                  measured           at                                      K1
Measure Code                                            measured at predetermined intervals
                                  predetermined
                                  intervals
Charge/Allowance Line Unit of
                                  Kilowatt Hour          Kilowatt Hour                        KH
Measure Code
                                  KVAR        Kilovolt
Charge/Allowance Line Unit of                          KVAR      Kilovolt Amperes     Reactive
                                  Amperes Reactive                                             K2
Measure Code                                           Demand
                                  Demand
Charge/Allowance Line Unit of     Kilovolt  Amperes
                                                       Kilovolt Amperes Reactive Hour          K3
Measure Code                      Reactive Hour
Charge/Allowance Line Unit of
                                  Kilovolt Amperes       Kilovolt Amperes                     K4
Measure Code
Charge/Allowance Line Unit of
                                  Months                 Months                               MO
Measure Code
Charge/Allowance Line Unit of
                                  Watt                   Watt                                 99
Measure Code
Charge/Allowance Line Unit of
                                  Therms                 Therms                               ?
Measure Code
Charge/Allowance Line Unit of     British     Thermal
                                                         British Thermal Units                BTU?
Measure Code                      Units
Charge/Allowance Line Unit of
                                  Hundred Cubic Feet Hundred Cubic Feet                       CCF?
Measure Code
Charge/Allowance Line Unit of     Thousand Cubic
                                                         Thousand Cubic Feet                  MCF?
Measure Code                      Feet
Party Calculating Bill            Retail Supplier                                             ESP
                                  Distribution
Party Calculating Bill                                                                        LDC
                                  Company
Party Sending Bill                Retail Supplier        Supplier bills customer              ESP
                                  Distribution
Party Sending Bill                                       Utility bills customer               LDC
                                  Company
Purpose                           Original                                                    00
Purpose                           Cancellation                                                01
Purpose                           Duplicate                                                   07
Service Type                      Electric                                                    EL
Service Type                      Gas                                                         GS?


  X12 EDI Subtab
  Data Element Cross Reference to ASC X12
  Sample ASC X12 Transaction
  ASC X12 Mapping Guidelines
  Transaction Set Tables


                         04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                            15 of 39
                                        D R A F T IR/TEIS Working Paper

                        4.3 Consolidated Billing Rate-Ready Invoice

          TECHNICAL IMPLEMENTATION: RATE READY INVOICE
                          [DR/CINERGY]
Technical Implementation Of Business Process

Related MBP’s: RXQ.3.3.5.1 through 3.3.5.6

The Rate Ready Invoice transaction is used when billing data is transmitted from the Billing
Party to the Non-Billing Party in the form of an invoice that contains individual Customer bill
components and their corresponding amounts for both parties.

The Billing Party is responsible for calculating charges and issuing bills to the retail customer on
behalf of the Non-Billing Party.

The Billing Party sends the Rate Ready invoice transaction to the Non-Billing Party as
notification that a Customer bill has been calculated and rendered.

The Sender and Receiver of the Consolidated Billing Rate Ready transaction is either a
distribution company (LDC) or a supplier / retailer.

The Rate Ready Invoice transaction includes the specific Usage Unique ID (UUID) originally
transmitted with the usage information. The UUID links the usage, invoice and payment
transactions together for tracking purposes.

The Rate Ready Invoice transaction also notifies the Non-Billing Party of data concerning the
Customer accounts that it has recently billed on behalf of the Non-Billing Party. Accordingly, the
exchange of billing data between the Billing Party and Non Billing Party under this scenario is to
have the Billing Party send the Non-Billing Party “after-the-fact information” concerning the
Customer accounts that it has recently billed on behalf of the Non-Billing Party.

Each original Consolidated Billing Rate Ready transaction header contains
    Invoice Date
    Invoice Number
    Usage Unique ID (UUID)
    Invoice Purpose
    Billing Final Indicator
    Original Invoice Number
    Invoice Due Date
    Billing Party Name
    Billing Party ID
    Non-Billing Party Name
    Non-Billing Party ID
    Billing Party Customer Name
    Billing Party Account Identifier or SDID
    Billing Party Previous Account Number or SDID
    Customer Balance Total
    Service Type
    Service Period Start Date
    Service Period End Date
    and Payment Plan Indicator.

                04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                   16 of 39
                                       D R A F T IR/TEIS Working Paper

                       4.3 Consolidated Billing Rate-Ready Invoice
Each original Consolidated Billing Rate Ready transaction detail contains one or more
    Line Item Charges and Allowances
    Service Type
    Summary Level
    Unit of Measure for Quantity
    Usage Category
    Usage Code
    and Rate Codes

Each cancel Rate Ready invoice transaction must include an Invoice Purpose Code =
‘Cancel’, the UUID from the original transaction, and the same data found in the original Rate
Ready invoice.

Rebilling of a cancelled Rate Ready invoice transaction is processed as an original Rate Ready
invoice transaction.




               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  17 of 39
                                     D R A F T IR/TEIS Working Paper

                     4.3 Consolidated Billing Rate-Ready Invoice
Sample Paper Transaction
                                           Invoice Header
      Invoice Date:                                                20040413
      Invoice Number:                                              04132004TR4877
      Original Usage Unique ID:
      Invoice Purpose:                                             Original
      Billing Final Indicator:                                     No
      Original Invoice Number:                                     X2004042312345
      Invoice Due Date:                                            20040508

      Billing Party (BP) Name:                                     Distribute-It Incorporated
      Billing Party ID:                                            123456789

      Non-Billing Party (NBP) Name:                                Sell-It Incorporated
      NBP ID:                                                      546897321

      BP Customer Name:                                            John Shoulders
      BP Customer Account Identifier or SDID:                      8473937UHFTR41304
      BP Customer Previous Account Number or
      SDID:
      Customer Balance Total                                       $100.00

      Service Type:                                                Electric

      Service Period Start Date:                                   20040313
      Service Period End Date:                                     20040412

                           Line Item Charges and Allowances
Indicator Category Unit Qty          Rate    Amt     Description
                                                     Current    Basic  Generation  -
Charge      GEN002      KWh 500 $0.100 $50.00 Consumption
                                                     Current Basic Generation - Peak
Charge      DMD009      KW     20   $1.000 $20.00 Demand
   Total of NBP Line Item Current Charges: $79.25




             04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                18 of 39
                                                                                     D R A F T IR/TEIS Working Paper

                                                                    4.3 Consolidated Billing Rate-Ready Invoice
Data Dictionary
            Current BP Data Elem.
  Item #                                                        Description                        Use       Condition                                        Comments and Code Value               Group
                  Name ID
                                          Cycle number (1-99) on which the bill will be                                                                                                          1:Header
    1      Billing Cycle [BillCycle]                                                               RBC
                                          rendered.
    2      Final Indicator [FinalInd]     Indicates whether this is a final bill                    M                                                   [Yes, No]                                1:Header
                                          Billing Party's Entity Common Code Identifier
    3      Billing Party ID [BillPtyID]   (DUNS Number or DUNS+4 Number or other                    M                                                                                            1:Header
                                          mutually-agreed upon number)
           Billing Party Name
    4                                     Identifies the Billing Party                              M                                                                                            1:Header
           [BillPtyName]
           Customer Account ID            Customer Account ID or SDID assigned by the
    5                                                                                               M                                                                                            1:Header
           [CustAcctID]                   Billing Party
           Customer Name                  End Use Customer Name as defined in Billing
    6                                                                                               M                                                                                            1:Header
           [CustName]                     Party’s systems
           Customer Name Overflow         Additional information used to further identify the
    7                                                                                              SO                                                                                            1:Header
           [CustNameOver]                 Customer, as defined in Billing Party’s systems.
           Customer Bill Issue Date
    8                                     Date the Customer bill was issued                         M                                                                                            1:Header
           [CustBillIssueDate]
           Chg/Allow Line Amount
    9                                     Dollar amount (credit or debit) for the charge.           M                                                                                            2:CADetail
           [CAAmt]
                                                                                                                                                        [Adjustment, Budget, Late Payment,
                                                                                                                                                        Miscellaneous, Payment Plan Charge]
           Chg/Allow Line Category
   10                                     Code for the class of charge                              M                                                   plus other governing standards codes;    2:CADetail
           [CACat]
                                                                                                                                                        see UIG and governing documents for
                                                                                                                                                        codes
           Chg/Allow Line                 Code that defines if Line Item Charge/ Allowance
   11      Credit/Debit Code              is an allowance (credit), charge (debit) or no            M                                                   Allowance, Charge, No Charge             2:CADetail
           [CADebitCode]                  charge to the customer
           Chg/Allow Line                 Text description for Line Item Charge/Allowance
   12                                                                                              RBC                                                                                           2:CADetail
           Description [CADesc]           that will print on the customer's bill
           Chg/Allow Line Quantity
   13                                     Usage                                                     M                                                                                            2:CADetail
           [CAQty]
           Chg/Allow Line Rate ID                                                                                                                       Useful in RR as confirmation of proper
   14                                     NBP rate identifier                                       M                                                                                            2:CADetail
           [CARate ID]                                                                                                                                  NBP rate.
           Chg/Allow Line Summary         Code that defines if the data is summarized by                                                                Account, Rate, SDID, Un-metered,
   15                                                                                               M                                                                                            2:CADetail
           Level [CASummaryLevel]         Account, Rate, SDID, Un-metered, or Meter.                                                                    Metered
           Chg/Allow Line Unit of
                                                                                                                                                        [kW, kWh, therms, ccf, mcf] Only when
   16      Measure                        Unit of measure for quantity                              M                                                                                         2:CADetail
                                                                                                                                                        line item has a measure
           [CAUnitOfMeasure]
           Non-Billing Party Account
   17                                     Total NBP Account Balance                                RBC                                                                                           2:Balances
           Balance [NBPAcctBal]
           Non-Billing Party Balance,
   18      as of Last Billing             Amount due on the previous bill                           M                                                                                            2:Balances
           [NBPBalAsOfLast]
           Non-Billing Party Balance,
   19                                     Also known as NBP Arrears                                 M                                                                                            2:Balances
           Prior to Current Charges
                                            Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                         04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050711.doc
                                                                                            19 of 39
                                                                                D R A F T IR/TEIS Working Paper

                                                              4.3 Consolidated Billing Rate-Ready Invoice
           Current BP Data Elem.
Item #                                                    Description                        Use       Condition                                        Comments and Code Value     Group
                  Name ID
         [NBPBalPrior]
         Non-Billing Party Account
 20                                  Customer Account ID assigned by the NBP                 RBC                                                                                  1:Header
         ID [NBPAcctID]
         Non-Billing Party Name
 21                                  Identifies the NBP                                       M                                                                                   1:Header
         [NBPName]
         Non-Billing Party Message   NBP billing message as it appeared on the bill to
 22                                                                                          RBC                                                                                  1:Header
         To Customer [Msg2Cust]      the Customer
         Total Current Charge
 23                                  Total NBP Current Charge                                 M                                                                                   1:Header
         [TotalChg]
                                     NBP Entity Common Code ID (DUNS Number or
         Non-Billing Party ID
 24                                  DUNS+4 Number or other mutually-agreed upon              M                                                                                   1:Header
         [NBPID]
                                     number)
                                     The unique number assigned to the original
         Original Invoice ID         document, used only to cancel the original.                       Send when Purpose is ‘Reversal’ or
 25                                                                                           C                                                                                   1:Header
         [OriginalInvID]             When a transaction is cancelled, the Original                     ‘Cancellation’
                                     Reference Number is used as a trace number.
         Party Calculating Bill      Code that identifies which party calculates the                                                              [Distribution Company, DUAL,
 26                                                                                          RBC                                                                                  1:Header
         [PartyCalculatingBill]      NBPcharges                                                                                                   Supplier]
         Party Sending Bill                                                                                                                       [Distribution Company, DUAL,
 27                                  Code that identifies which party sends the bill         RBC                                                                                  1:Header
         [PartySendingBill]                                                                                                                       Supplier]
         Customer Payment Due
 28                                  Customer payment due date                                M                                                                                   1:Header
         Date [CustPayDueDate]
         Payment Plan Balance As
 29      of the Last Billing                                                                                                                                                      2:Balances
         [PlanAsOfLast]
         Payment Plan Balance
                                                                                                       Send when Payment Plan Indicator is
 30      Prior to Current Charges    Payment Plan balance prior to current charges            C                                                                                   2:Balances
                                                                                                       Budget or Payment Plan
         [PlanBalPrior]
         Payment Plan Indicator
 31                                  A code that idenities a type of plan                     M                                                   [No, Budget or Payment Plan]    2:Balances
         [PlanInd]
                                     Text used to inform customer of difference
         Payment Plan Info                                                                             Send when Payment Plan Indicator is
 32                                  between amounts paid and accrued amount                  C                                                                                   2:Balances
         [PlanInfo]                                                                                    Budget or Payment Plan
                                     outstanding
                                     Code that defines the reason for sending this
 33      Purpose [Purpose]                                                                    M                                                   Original, Cancellation          1:Header
                                     information
                                     Unique number identifying this transaction and
 34      Invoice ID [InvID]                                                                   M                                                                                   1:Header
                                     created by the originator of this transaction
         Service Period End Date
 35                                  Current Meter Reading Date                               M                                                                                   1:Header
         [ServPerEndDate]
         Service Period Start Date
 36                                  Previous Meter Reading Date                              M                                                                                   1:Header
         [ServPerStartDate]
         Service Type
 37                                  Code that defines the type of service rendered           M                                                   [Electric, Gas]                 1:Header
         [ServiceType]
         Transaction Date
 38                                  Date the transaction was generated                       M                                                                                   1:Header
         [TransDate]
                                      Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                   04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050711.doc
                                                                                      20 of 39
                                                                            D R A F T IR/TEIS Working Paper

                                                         4.3 Consolidated Billing Rate-Ready Invoice
          Current BP Data Elem.
Item #                                              Description                           Use       Condition                                        Comments and Code Value      Group
                Name ID
                                  A taxable amount transmitted to the non-taxing
 39      Taxes [Taxes]                                                                    RBC                                                                                  2:CADetail
                                  Party
         Payment Plan Account                                                                       Send when Payment Plan Indicator is
 40                               Total Payment Plan Balance                               C                                                                                   1:Header
         Balance [PlanAcctBal]                                                                      Budget or Payment Plan

                                  The cross-reference number originally
 42      Usage Unique ID [UUID]                                                           RBC                                                                                  1:Header
                                  transmitted with the usage information




                                   Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050711.doc
                                                                                  21 of 39
                                                    D R A F T IR/TEIS Working Paper

                                 4.3 Consolidated Billing Rate-Ready Invoice

  Code Values Dictionary
Data Element                      Code Description       Code Definition                               Code Value
FinalInd                          Yes                    Identifies last bill to be sent               F
FinalInd                          No                     Left blank??                                  [blank]
Charge/Allowance Line
                                  Charge                 Charge                                        C
Credit/Debit Code
Charge/Allowance Line
                                  No                     No Allowance or Charge                        N
Credit/Debit Code
Charge/AllowanceLine
                                  Allowance              Allowance                                     A
Credit/Debit Code
                                  See UIG and
Charge/Allowance Line             governing                                                            See UIG and governing documents
                                                         Energy Charges
Category                          documents for                                                        for codes
                                  codes
Charge/Allowance Line Unit of
                                  Watt                   Watt                                          99
Measure Code
Charge/Allowance Line Unit of                            kW - Represents potential power load
                                  kW                                                          K1
Measure Code                                             measured at predetermined intervals
Charge/Allowance Line Unit of
                                  Kilowatt Hour          Kilowatt Hour                                 KH
Measure Code
Charge/Allowance Line Unit of                            KVAR   Kilovolt          Amperes   Reactive
                                  KVAR                                                                 K2
Measure Code                                             Demand
Charge/Allowance Line Unit of     Kilovolt  Amperes
                                                    Kilovolt Amperes Reactive Hour                     K3
Measure Code                      Reactive Hour
Charge/Allowance Line Unit of
                                  Kilovolt Amperes       Kilovolt Amperes                              K4
Measure Code
Charge/Allowance Line Unit of
                                  Months                 Months                                        MO
Measure Code
Charge/Allowance Line Unit of
                                  Watt                   Watt                                          99
Measure Code
Charge/Allowance Line Unit of
                                  Therms                 Therms                                        ?
Measure Code
Charge/Allowance Line Unit of     British     Thermal
                                                         British Thermal Units                         BTU?
Measure Code                      Units
Charge/Allowance Line Unit of
                                  Hundred Cubic Feet Hundred Cubic Feet                                CCF?
Measure Code
Charge/Allowance Line Unit of     Thousand Cubic
                                                         Thousand Cubic Feet                           MCF?
Measure Code                      Feet
Party Calculating Bill            Retail Supplier                                                      ESP
                                  Distribution
Party Calculating Bill                                                                                 LDC
                                  Company
Party Sending Bill                Retail Supplier        Supplier bills customer                       ESP
                                  Distribution
Party Sending Bill                                       Utility bills customer                        LDC
                                  Company
Purpose                           Original                                                             00
Purpose                           Cancellation                                                         01
Purpose                           Duplicate                                                            07
Service Type                      Electric                                                             EL
Service Type                      Gas                                                                  GS?


  X12 EDI Subtab
  Data Element Cross Reference to ASC X12
  Sample ASC X12 Transaction
  ASC X12 Mapping Guidelines
  Transaction Set Tables




                         04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                            22 of 39
                                       D R A F T IR/TEIS Working Paper

                                             4.5 Payments

   TECHNICAL IMPLEMENTATION: PAYMENT REMITTANCE [BKW]
Technical Implementation Of Business Process

Related MBP’s: RXQ.3.3.3.7

The Payment Remittance transaction is the communication between companies that itemizes
payments made from the Billing Party to the Non-Billing Party.

The Payment Remittance transaction is designed to be sent directly from the Billing Party to
the Non-Billing Party. By mutual agreement Payment Remittance and actual Payments may
be combined under a single transaction (e.g. CTX payments). These standards do not
address this scenario. Different banks have different requirements that must be addressed.

The payment is identified by the Reference Number ID.

The payment header includes:
    Billing Party ID [BillPtyID]
    Billing Party Name [BillPtyName]
    Funds Transfer Date [FundsTransferDate]
    Monetary Amount [MonAmt]
    Non-Billing Party ID [NBPID]
    Non-Billing Party Name [NBPName]
    Payment Format Code [PayFormat]
    Payment Method Code [PayMethod]
    Purpose [Purpose]
    Payment Reference ID [PayRefID]
    Transaction Date [TransDate]
    Transaction Handling Code [TransHandling]

The remittance detail includes:
    Adjustment Reason Code [AdjustReason]
    Credit/Debit Indicator [CreditDebitInd]
    Customer Account ID [CustAcctID]
    Customer Payment Posting Date [CustPayPostDate]
    Discount Amount [DiscAmt]
    Money Collected [MoneyCollected]
    Non-Billing Party Account ID [NBPAcctID]
    Payment/Adjustment Type [PayAdjustType]




               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  23 of 39
                                         D R A F T IR/TEIS Working Paper

                                               4.5 Payments
Sample Paper Transaction

                                            Remittance Header
          Remittance Date:                                             20040413
          Number:                                                      04132004TR4877
          Remittance / Payment                Cross-Reference          04132004MR8392
          Number:
          Trace Type:                                                  Remittance Only
          Payment Method Type                                          ACH
          Settlement Date:                                             20040413

          Billing Party (BP) Name:                                     Distribute-It Incorporated
          BP Entity Common Code ID:                                    123456789

          Non-Billing Party (NBP) Name:                                Sell-It Incorporated
          NBP Entity Common Code ID:                                   546897321

          Total Monetary Amount Transferred                            $100.00

 Payment                                      Usage         Orig                         Cred/
              BP Cust Acct      Date                                  Disc   Payment                Adj   Adj
  Action                                    Reference     Invoice                        Debit
               ID or SDID      Posted                                 Amt      Amt                  Amt   Reason
  Code                                       Number       Amount                         Code
Payment       123456789012    20040410    200403251234     $100.00   $5.00     $95.00      C

Payment       12345678123     20040411    200403255678     $100.00                         C

Adjustment                                200403265678                                     D




                 04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                    24 of 39
                                                                                          D R A F T IR/TEIS Working Paper

                                                                                                 4.5 Payments
Data Dictionary
Item
               Current BP Data Elem. Name ID                                            Description                                 Use    Condition                  Comments and Code Value         Group
  #
                                                                                                                                               Send when        [Adjustment, Invoice Cancelled,
 1     Adjustment Reason Code [AdjustReason]                 Code that specifies the reason for the accounting adjustment            C     Payment/Adjustment Insufficient Funds, Authorized       2:PayDetail
                                                                                                                                           Type is “Adjustment” Return]
                                                             Billing Party's Entity Common Code Identifier (DUNS Number or
       Billing Party ID [BillPtyID]                                                                                                  M                                                             1:Header
                                                             DUNS+4 Number or other mutually-agreed upon number)
 2     Billing Party Name [BillPtyName]                      Identifies the Billing Party                                            M                                                             1:Header
 3     Credit/Debit Indicator [CreditDebitInd]               Code that indicates whether the amount is positive or negative          M                                                             2:PayDetail
 4     Customer Account ID [CustAcctID]                      Customer Account ID or SDID assigned by the Billing Party               M                                                             2:PayDetail
       Customer Payment Posting Date
 5                                                           The date the customer's payment was posted                              M                                                             2:PayDetail
       [CustPayPostDate]
                                                             The amount of discount the Billing Party is entitled to when
 6     Discount Amount [DiscAmt]                                                                                                     M                                                             2:PayDetail
                                                             assuming receivables
                                                             The date the Billing Party intends for the transaction to be
 7     Funds Transfer Date [FundsTransferDate]                                                                                       M                                                             1:Header
                                                             settled
                                                             The positive dollar amount being sent to the NBP. This amount
 8     Monetary Amount [MonAmt]                                                                                                      M                                                             1:Header
                                                             should sum to the individual amounts in detail.
 9     Money Collected [MoneyCollected]                      Payments / Credits applied (+/-)                                        M                                                             2:PayDetail
                                                             NBP Entity Common Code ID (DUNS Number or DUNS+4
10     Non-Billing Party ID [NBPID]                                                                                                  M                                                             1:Header
                                                             Number or other mutually-agreed upon number)
11     Non-Billing Party Account ID [NBPAcctID]              Customer Account number or SDID assigned by the NBP                    RBC                                                            2:PayDetail
12     Non-Billing Party Name [NBPName]                      Identifies the NBP                                                      M                                                             1:Header
                                                                                                                                                                   [Adjustment, Payment on
13     Payment/Adjustment Type [PayAdjustType]               A code to indicate the type of payment or adjustment                    M                                                             2:PayDetail
                                                                                                                                                                   Account]
14     Payment Format Code [PayFormat]                       Code that defines the payment format to be used                         M                             CTX; CCD+                       1:Header
15     Payment Method Code [PayMethod]                       Code that defines the method for transmitting the payment               M                             ACH or Check                    1:Header
       Usage Unique ID [UsageID]                             ID that links this transaction to a usage report and an invoice.        M                                                             2:PayDetail
                                                             Unique number identifying this transaction and created by the
17     Payment Reference ID [PayRefID]                                                                                               M                                                             1:Header
                                                             originator of this transaction
18     Service Type [ServiceType]                            Code that defines the type of service rendered                          M                             [Electric, Gas]                 1:Header
19     Transaction Date [TransDate]                          Date the transaction was generated                                      M                                                             1:Header
                                                                                                                                                                   [Remittance only, Remittance and
20     Transaction Handling Code [TransHandling]             A code to identify which type of transaction is being used              M                                                              1:Header
                                                                                                                                                                   payment together]
                                                             An ID that links this remittance transaction to the bank payment                                                                       1:Header
       Bank Trace Number [BankTraceNumber]                                                                                           M
                                                             transaction                                                                                                                            TRN




                                                 Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                             04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                                25 of 39
                                           D R A F T IR/TEIS Working Paper

                                                  4.5 Payments
Code Values Dictionary

                              Code
Data Element                                      Code Definition                                Code Value
                              Description
Payment/Adjustment Code       Adjustment
                              Payment on
Payment/Adjustment Code
                              Account
Payment Format                CTX
Payment Format                CCD+
Payment Method                ACH
Payment Method                Check
Adjustment Reason Code        Adjustment
Adjustment Reason Code        Invoice Cancelled
                              Authorized
Adjustment Reason Code
                              Return
Adjustment Reason Code        Insufficient Fund
Service Type                  Electric
Service Type                  Gas
Transaction Handling Code     Remittance Only                                                    I
                              Remittance and
Transaction Handling Code                                                                        C
                              Payment
Transaction Handling Code     Prenotification     Prenotification of future transfers            P
Transaction Handling Code     Payment Only        Make Payment Only                              D
                              Handling Party      Handling parties option to split payment and
Transaction Handling Code                                                                        X
                              Option              remittance
                              Split Payment
Transaction Handling Code                         Split payment and Remittance                   U
                              and Remittance


X12 EDI Subtab
Data Element Cross Reference to ASC X12
Sample ASC X12 Transaction
ASC X12 Mapping Guidelines
Transaction Set Tables




                   04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                      26 of 39
                                        D R A F T IR/TEIS Working Paper

                                 4.6 Billing Services Termination

       TECHNICAL IMPLEMENTATION: TERMINATION OF BILLING
                        SERVICES [WB]
Technical Implementation Of Business Process

Related MBP’s: RXQ.3.3.9.7

The Termination of Billing Services (TBS) transaction is used when the party providing billing
services terminates those billing services for an account. The TBS transmits outstanding Non-
Billing Party charges from the Billing Party to the Non-Billing Party.

The Sender is the Billing Party; the Receiver is the Non-Billing Party.

Each TBS transaction header contains
    Billing Party ID [BillPtyID]
    Billing Party Name [BillPtyName]
    Customer Account ID [CustAcctID]
    Non-Billing Party ID [NBPID]
    Non-Billing Party Name [NBPName]
    Non-Billing Party Account ID [NBPAcctID]
    Purpose [Purpose]
    Termination of Bill Services Unique ID [TOBSID]
    Service Type [ServiceType]
    Transaction Date [TransDate].

Each TBS transaction detail contains
    Write-off Amount
    Write-off Date.




                04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                   27 of 39
                                     D R A F T IR/TEIS Working Paper

                              4.6 Billing Services Termination
Sample Paper Transaction

      Termination of Billing Services Header
      Transaction Date:                                            20040413
      TOBS ID:                                                     04132004TR4877
      Trans Purpose:                                               TOBS

      Billing Party (BP) Name:                                     Distribute-It Incorporated
      BP Entity Common Code ID:                                    123456789

      Non-Billing Party (NBP) Name:                                Sell-It Incorporated
      NBP Entity Common Code ID:                                   546897321

      Customer Acct ID:                                            12345767890
      NBP Customer Acct ID:                                        12345656788
      Service Type:                                                Electric
      Balance Returned:                                            $100.00




             04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                28 of 39
                                                                                     D R A F T IR/TEIS Working Paper

                                                                              4.6 Billing Services Termination
Data Dictionary

Item #   Current BP Data Elem. Name ID         Description                                                  Use     Condition                           Comments and Code Value                Group
                                               Billing Party's Entity Common Code Identifier (DUNS
                                                                                                                                                                                               1:Header
2        Billing Party ID [BillPtyID]          Number or DUNS+4 Number or other mutually-agreed              M
                                                                                                                                                                                               N1
                                               upon number)
                                                                                                                                                                                               1:Header
3        Billing Party Name [BillPtyName]      Identifies the Billing Party                                  M                                          See governing documents
                                                                                                                                                                                               N1
                                             Customer Account ID or SDID assigned by the Billing                                                                                               1:Header
4        Customer Account ID [CustAcctID]                                                                    M
                                             Party                                                                                                                                             REF*12
                                             NBP Entity Common Code ID (DUNS Number or
                                                                                                                                                                                               1:Header
5        Non-Billing Party ID [NBPID]        DUNS+4 Number or other mutually-agreed upon                     M
                                                                                                                                                                                               N1
                                             number)
6        Non-Billing Party Name [NBPName] Identifies the NBP                                                 M                                                                                  1:Header
         Non-Billing Party Account ID                                                                                                                   BR: sent if previously received by Non-
7                                            Customer Account ID assigned by the NBP                       RBC                                                                                  1:Header
         [NBPAcctID]                                                                                                                                    Billing Party
                                             Code that defines the reason for sending this
8        Purpose [Purpose]                                                                                   M                                          [Write-off, Reinstate]                 1:Header
                                             information
         Termination of Bill Services Unique Unique number identifying this transaction and
9                                                                                                            M                                                                                 1:Header
         ID [TOBSID]                         created by the originator of this transaction
10       Service Type [ServiceType]          Code that defines the type of service rendered                  M                                          [Electric, Gas]                        1:Header
11       Transaction Date [TransDate]        Date the transaction was generated                              M                                                                                 1:Header
12       Balance Returned [BalRet]           Balance amount returned                                         M                                                                                 2:Detail
13       Write-off Date                      Date charges are written off Billing Party books                M                                                                                 2:Detail
         Admin Comm Contact                  Administrator Communication Contact Name                        O
         Admin Comm Phone                    Administrator Communication Contact Phone                       O                                                                                 1:Header
         Admin Comm Fax                      Administrator Communication Contact Fax                         O
         Admin Comm E-mail                   Administrator Communication Contact email                       O
                                                                                                                                                                                               2:Detail
         Customer Name                         Customer Name                                                 M
                                                                                                                                                                                               NM1
                                                                                                                    [M] if the Billing Party has a                                             2:Detail
         Customer Phone 1                      Customer First Phone Number                                  BC
                                                                                                                    phone number                                                               PER
                                                                                                                    [M] if the Billing Party has a                                             2:Detail
         Customer Phone 2                      Customer Second Phone Number                                 BC
                                                                                                                    second phone number                                                        PER
                                                                                                                                                                                               2:Detail
         Customer Info                         Customer Additional Information                               O




                                            Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                                        04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                           29 of 39
                                         D R A F T IR/TEIS Working Paper

                                4.6 Billing Services Termination
Code Values Dictionary

                          Code
Data Element                                  Code Definition                         Code Value
                          Description
                                              Used to notify the non-billing party
Purpose                   OriginalWrite-off   that the billing party will no longer   22
                                              pursue collections for this customer
Purpose                   Cancellation
Service Type              Electric
Service Type              Gas


X12 EDI Subtab
Data Element Cross Reference to ASC X12
Sample ASC X12 Transaction
ASC X12 Mapping Guidelines
Transaction Set Tables




               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  30 of 39
                                       D R A F T IR/TEIS Working Paper

                                     4.7 Payment Notification

       TECHNICAL IMPLEMENTATION: PAYMENT NOTIFICATION
                      (COLLECTIONS) [GB]
Technical Implementation Of Business Process

Related MBP’s: RXQ.3.3.8.1 through 3.3.9.5, 3.3.7.1, 3.3.7.2, 3.3.8.3,

The Payment Notification/Collections transaction is used in the ‘Assumption of Receivables’
scenario to enable Non-Billing Parties to identify accounts that are delinquent. It is the
communication of all payments and adjustments made to customer accounts by the Billing
Party. A single Payment Notification transaction is sent each day.

The transaction is sent by the Billing Party. The transaction is received by the Non-Billing
Party.

The transaction is identified by the Collection Unique ID.

Each original Payment Notice header contains
    Transaction Purpose
    Collection Unique ID
    Transaction Date
    Total Monetary Amount
    Billing Party ID and name
    Non-Billing Party ID and name.

The Payment Notice detail repeats for each payment being reported. Multiple payments for a
single customer are allowed. Each original Payment Notice detail contains
     Customer name and ID
     Supplier ID
     Service Type
     Assigned line number
     Transaction reference number for the amount
     Payment/Adjustment Indicator.




               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  31 of 39
                                       D R A F T IR/TEIS Working Paper

                                     4.7 Payment Notification
Sample Paper Transaction

                                   Payment Notification Header
       Transaction Date:                                   20040413
       Collection Unique ID:                               04132004TR4877
       Trans Purpose:                                      Original

       Billing Party (BP) Name:                                      Distribute-It Incorporated
       BP Entity Common Code ID:                                     123456789

       Non-Billing Party (NBP) Name:                                 Sell-It Incorporated
       NBP Entity Common Code ID:                                    546897321
       Total Monetary Amount                                         $190.00

       Detail
       Customer Acct ID:                                             12345767890
       NBP Customer Acct ID:                                         12345656788
       Customer Name                                                 John Doe
       Service Type:                                                 Electric
       Transaction Reference Number                                  Dkoejdhkk20040511
       Payment / Adjustment Flag:                                    Payment
       Payment Level Allocated Amount::                              $100.00

       Customer Acct ID:                                             12345767890
       NBP Customer Acct ID:                                         12345656788
       Customer Name                                                 John Doe
       Service Type:                                                 Electric
       Transaction Reference Number                                  Dkoejdhkk20040514
       Payment / Adjustment Flag:                                    Payment
       Payment Level Allocated Amount::                              $90.00

Note: this example shows a notification for a single customer, so the Total Monetary Amount is
$190.00. In the event other customers are to be reported, the Total Monetary Amount would
include those monies associated with the other customers.




               04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  32 of 39
                                                                                   D R A F T IR/TEIS Working Paper

                                                                                4.7 Payment Notification
Data Dictionary

        Current BP Data Elem. Name
 Item                                       Description                                                        Use       Conditions                       Comments                           Group
        ID
        Transaction Purpose
  1x                                        Purpose of Transaction                                              M                                         [Original, Cancel]                 0:ColHdr
        [TransPurpose]
        Collection Unique ID                Unique Number assigned by the originator of this
   2                                                                                                            M                                                                            0:ColHdr
        [CollectionID]                      transaction. This should be unique over time.
        Transaction Date                    Date this transaction was created by the sender's
   3                                                                                                            M                                                                            0:ColHdr
        [CollectionDate]                    application system.
        Total Monetary Amount               Total Monetary Amount allocated to the non-billing party;
   4                                                                                                            M                                                                            0:ColHdr
        Allocated [TotalAmt]                Sum of all detail amounts in this transaction.
        Billing Party Name
   5                                        Billing Party's Name                                                M                                                                            1:Biller
        [BillPtyName]
                                            BP Entity Common Code ID (DUNS Number or DUNS+4
   6    Billing Party ID [BillPtyID]                                                                            M                                                                            1:Biller
                                            Number or other mutually-agreed upon number)
        Non-Billing Party Name
   7                                        Non-Billing Party's Name                                            M                                                                            1:NonBiller
        [NBPName]
                                            NBP Entity Common Code ID (DUNS Number or DUNS+4
   8    Non-Billing Party ID [NBPID]                                                                            M                                                                            1:NonBiller
                                            Number or other mutually-agreed upon number)
        Billing Party Acct ID
   9                                        Billing Party Customer Account Number                               M                                                                            1:CustInfo
        [BillPtyAcctID]
                                            Total Monetary Amount allocated for this customer account
        Non-Billing Party Amount
                                            by the billing party on behalf of the non-billing party or
  10    Allocated for Account                                                                                   M                                                                            1:CustInfo
                                            adjustment amount allocated by the billing party on behalf of
        [NBPAmtAlloc]
                                            the non-billing party.
        Non-Billing Party Account ID
  11                                        NBP Customer Account Number                                         RBC      Send if previously sent                                             1:CustInfo
        [NBPAcctID]
        Billing Party Old Account ID                                                                                     Send if BPAcctID changed
  12                                        Previous Billing Party Account Number                              BC                                                                            1:CustInfo
        [BillPtyOldAcctID]                                                                                               in last 45 days
        Transaction Detail ID
  13                                        Unique Number identifying this customer account record.             M                                                                            1:ColDtl
        [TransDtlID]
                                                                                                                         Send when
        Type of Adjustment                                                                                                                                [Adjustment, Insufficient Funds,
  14                                        Adjustment reason code                                              C        Payment/Adjustment code                                             1:ColDtl
        [AdjustType]                                                                                                                                      Returned Items]
                                                                                                                         indicates Adjustment
                                            Date the payment or adjustment was posted in the billing
  15    Posting Date [PostDate]                                                                                 M                                                                            1:ColDtl
                                            party’s system. Format: CCYYMMDD
                                            Individual allocated amount or amounts. If more than one
        Payment Level Allocated
  16                                        customer payment was posted to this customer account,               M                                                                            1:ColDtl
        Amount [PayLevelAmt]
                                            this will be repeated for each customer payment.
        Billing Party Customer Name
  17                                        Customer name as it appears on the customer bill.                   M                                                                            1:CustInfo
        [BillPtyCustName]
                                            Indicates whether the Payment Level Allocated Amount is a
  18    Payment/Adjustment Indicator                                                                           M                                          [Payment or Adjustment]
                                            payment or an adjustment
  19    Service Type                        Indicates the type of energy                                       M                                          [Gas or Electric]
                                                                                                                                                                                                           Formatted: Font: 11 pt, Do not check spelling
                                                                                                                                                                                                           or grammar
                                                                                                                                                                                                           Formatted: Font: 11 pt, Do not check spelling
                                                                                                                                                                                                           or grammar
                                          Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                       04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                                 33 of 39
                                            D R A F T IR/TEIS Working Paper

                                          4.7 Payment Notification
Code Values Dictionary

                               Code
Data Element                                      Code Definition             Code Value
                               Description
Purpose                        Original
Purpose                        Cancellation
Payment/Adjustment Indicator   Payment
Payment/Adjustment Indicator   Adjustment
Service Type                   Electric
Service Type                   Gas
Type of Adjustment             Adjustment
Type of Adjustment             Insufficient Funds
Type of Adjustment             Returned Items


X12 EDI Subtab
Data Element Cross Reference to ASC X12
Sample ASC X12 Transaction
ASC X12 Mapping Guidelines
Transaction Set Tables




                                                                                           Formatted: Font: 11 pt, Do not check spelling
                                                                                           or grammar
                                                                                           Formatted: Font: 11 pt, Do not check spelling
                                                                                           or grammar
    04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                        34 of 39
                                      D R A F T IR/TEIS Working Paper

                                      4.8 Application Advice

      TECHNICAL IMPLEMENTATION: APPLICATION ADVICE [GD]
Technical Implementation Of Business Process

Related MBP’s: See Table Below

The Application Advice transaction is the communication between companies that advises
trading partners of success or failure in certain business processes. The use of the Application
Advice UET enables trading partners to automate processes for common exceptions, and for
common notifications. The following retail energy business processes use the Application
Advice:

Application Advice Use                                                               MBP References
Invalid Usage – This negative acknowledgement, sent by the party receiving           2.1.1.me1 (draft)
usage, notifies the sender that usage was bad.
                                                                                          2.4.1.3
Invalid Invoice – This negative acknowledgement, sent by the party receiving an           2.4.1.6
invoice, notifies the party that generated the invoice that it was bad.              2.5.1.me2 (draft)
                                                                                     2.6.1.me3 (draft)
Invoice Missed Bill Window – This negative acknowledgement, sent by the Billing
Party, notifies the Non-Billing Party that the invoice was received after the bill   2.4.1.7 (revised)
window had expired.


The UET consists of the following logical groups of data:
    Envelope
    Billing Party
    Non-Billing Party
    Customer
    Advice Details, including rejection information where applicable.

Envelope information contains the App Advice Action, the App Advice Date, and the App
Advice ID.

Billing Party group contains Billing Party ID, Billing Party Name, Billing Party Technical
Contact.

Customer group contains Billing Party Account ID, Billing Party Old Account ID, 1:CustInfo,
Customer Name, Non-Billing Party Account ID.

Non-Billing Party group contains Non-Billing Party ID, Non-Billing Party Name, Non-Billing
Party Technical Contact.

Application Advice Detail group contains Bill Due Date, Cross Reference ID, Date Bill
Rendered, Outstanding Balance, Rejection Level, Rejection Reason, Rejection Text.



                                                                                                         Formatted: Font: 11 pt, Do not check spelling
                                                                                                         or grammar
                                                                                                         Formatted: Font: 11 pt, Do not check spelling
                                                                                                         or grammar
   04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                 35 of 39
                               D R A F T IR/TEIS Working Paper

                              4.8 Application Advice
Sample Paper Transaction

                              Application Advice Header
      Transaction Date:                              20040413
      App Advice ID:                                 04132004TR4877
      Action Required:                               Do Not Resend
      Trans Purpose:

      Billing Party (BP) Name:                               Distribute-It Incorporated
      BP Entity Common Code ID:                              123456789
      BP Technical Contact:                                  John Distribute
      BP Technical Contact Phone:                            713.111.1111

      Non-Billing Party (NBP) Name:                          Sell-It Incorporated
      NBP Entity Common Code ID:                             546897321

      Customer Name:                                         Joe Customer
      Customer Acct ID:                                      12345767890
      NBP Customer Acct ID:                                  12345656788
      Service Type:                                          Electric

      Rejection Level:                                       Entire Transaction Rejected
      Transaction Set Rejected:                              810
      Rejection Code:                                        MBW
      Rejection Description:                                 Missed Bill Window




                                                                                           Formatted: Font: 11 pt, Do not check spelling
                                                                                           or grammar
                                                                                           Formatted: Font: 11 pt, Do not check spelling
                                                                                           or grammar
  04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                          36 of 39
                                                                                       D R A F T IR/TEIS Working Paper

                                                                                      4.8 Application Advice
Data Dictionary
 Trans            Data Elem. Name [ID]                                      Description                             Use       Condition                    Comments and Code Value               Group
                                                    Indicates whether the receiver of the AA is expected to
  1      App Advice Action [AppAdvAction]                                                                            M                               [Resend, Do Not Resend, Accept]            0:AAHdr
                                                    resend the transaction or not.
                                                    Date that the data was processed by the sender's
  2      App Advice Date [AppAdvDate]                                                                                M                                                                          0:AAHdr
                                                    application system.
                                                    A unique transaction identification number assigned by
  3      App Advice ID [AppAdvID]                   the originator of this transaction. This number must be          M                                                                          0:AAHdr
                                                    unique over time.
  4      Billing Party ID [BillPtyID]               Billing Party's DUNS Number or DUNS+4 Number                     M                                                                        1:BillPtyName
  5      Billing Party Name [BillPtyName]           Billing Party's Name                                             M                                                                        1:BillPtyName
         Billing Party Technical Contact            Billing Party Contact information (Telephone, Email,                      [M] if BP sends
  6                                                                                                                 RBC                                                                       1:BillPtyName
         [BillPtyContact]                           Fax) to resolve this particular issue.                                    transaction
         ??add BP Tech contact phone, fax,
         etc.
                                                    Billing Party Customer Account Number or SDID,
  7      Billing Party Account ID [BillPtyAcctID]                                                                    M                                                                         1:CustInfo
                                                    assigned by the Billing Party
         Billing Party Old Account ID
  8                                                 Previous Billing Party Customer Account Number                  RBC                                                                        1:CustInfo
         [BillPtyOldAcctID]
  9      Customer Name [CustName]                   Customer Name as it appears on the Customer's Bill               M                                                                         1:CustInfo
         Non-Billing Party Account ID
  10                                                Non-Billing Party Customer Account Number                       RBC                                                                        1:CustInfo
         [NBPAcctID]
  11     Non-Billing Party ID [NBPID]               Non-Billing Party's DUNS Number or DUNS+4 Number                 M                                                                        1:NBPName
  12     Non-Billing Party Name [NBPName]           Non-Billing Party's Name                                         M                                                                        1:NBPName
         Non-Billing Party Technical Contact        Non-Billing Party Contact information (Telephone,                         [M] if NBP sends
  13                                                                                                                RBC                                                                       1:NBPName
         [NBPContact]                               Email, Fax) to resolve this particular issue.                             transaction
         Non-Billing Party Technical Contact
                                                    Non-Billing Party telephone
         Phone [NBPContactPhone]
         Non-Billing Party Technical Contact
                                                    Non-Billing Party Fax
         Fax [NBPContactFax]
         Non-Billing Party Technical Contact
                                                    Non-Billing Party E-mail
         Email [NBPContactEmail]
                                                    Date customer payment is due (for Acceptance of a Bill
  14     Bill Due Date [BillDueDate]                                                                                RBC                                                                          2:AADtl
                                                    Ready Invoice)
                                                    Cross Reference Number from the Invoice or Payment
  15     Cross Reference ID [OrigCrossRefID]                                                                         M                                                                           2:AADtl
                                                    transaction.
                                                    Date bill was rendered to the customer (for Acceptance
  16     Date Bill Rendered [BillRendDate]                                                                          RBC                                                                          2:AADtl
                                                    of a Bill Ready Invoice)
                                                    Total outstanding balance that printed on bill for non-
  17     Outstanding Balance [OutstandingBal]                                                                       RBC                                                                          2:AADtl
                                                    billing party (for Acceptance of a Bill Ready Invoice)
                                                                                                                                                                                                              Formatted: Font: 11 pt, Do not check spelling
                                                                                                                                                     [Entire Transaction Rejected, Part of                    or grammar
                                                    Code indicating rejection level (e.g. entire, partial,
  18     Rejection Level [RejLev]                                                                                    M                               Transaction Rejected, Entire                2:AADtl
                                                    accepted).                                                                                                                                                Formatted: Font: 11 pt, Do not check spelling
                                                                                                                                                     Transaction Accepted, Item is Rejected
                                                                                                                                                                                                              or grammar
                                             Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                        04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                                     37 of 39
                                                                               D R A F T IR/TEIS Working Paper

                                                                             4.8 Application Advice
                                                                                                                      [M] if RejLev
19   Rejection Reason [RejReason]           Code indicating rejection reason                                  C                                                          2:AADtl
                                                                                                                      indicates reject
                                                                                                                      [M] if RejLev
20   Rejection Text [RejText]               Text explaining rejection reason                                  C                                                          2:AADtl
                                                                                                                      indicates reject
21   Transaction Set [TransSet]             Transaction Set that is being responded to                       M                               [Usage, Invoice, Payment]   2:AADtl




                                                                                                                                                                                   Formatted: Font: 11 pt, Do not check spelling
                                                                                                                                                                                   or grammar
                                                                                                                                                                                   Formatted: Font: 11 pt, Do not check spelling
                                                                                                                                                                                   or grammar
                                     Use Legend: M = Mandatory; C = Conditional; SO=Sender’s Option; BC=Business Conditional; RBC=Retail Business Conditional
                                  04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                                                            38 of 39
                                    D R A F T IR/TEIS Working Paper

                                   4.8 Application Advice
Code Values Dictionary
Data Element           Code Description      Code Definition                Code Value

App Advice Action                            [no definition necessary]      82
                       Resend
App Advice Action      Do Not Resend         [no definition necessary]      EV
App Advice Action      Accept                [no definition necessary]      CF
                       Entire Transaction
Rejection Level                              [no definition necessary]      TR
                       Rejected
                       Part of Transaction
Rejection Level                              [no definition necessary]      TP
                       Rejected
                       Entire Transaction
Rejection Level                              [no definition necessary]      TA
                       Accepted
Rejection Level        Item is Rejected      [no definition necessary]      IR
Rejection Reason       Other                 Other [Response to 810, 248]   848A13
Transaction Set                              Usage Invoice Payment


X12 EDI Subtab
Data Element Cross Reference to ASC X12
Sample ASC X12 Transaction
ASC X12 Mapping Guidelines
Transaction Set Tables




                                                                                         Formatted: Font: 11 pt, Do not check spelling
                                                                                         or grammar
                                                                                         Formatted: Font: 11 pt, Do not check spelling
                                                                                         or grammar
    04929355-1513-4952-9fa2-157784ef7203.docrxq2-ir-20050712.docrxq2-ir-20050710.doc
                                                  39 of 39

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:11/3/2012
language:English
pages:39