050 REF Reference Identification O 12 ID – N1 200 070 N1 Name O 1 130 ITD Terms of /Deferred Terms of O >1 212 BAL Balance Detail O >1 Detail: Pos. Seg. Req. Loop Notes and No. ID Name Des. Max.Use Repeat Comments ID – IT1 200000 010 IT1 Baseline Item Data (Invoice) O 1 040 TXI Tax Information O 10 ID – PID 1000 060 PID Product/Item Description O 1 120 REF Reference Identification O >1 150 DTM Date/Time Reference O 10 ID – SLN 1000 200 SLN Subline Item Detail O 1 230 SAC Service, Promotion, Allowance, or Charge Information O 25 Summary: Pos. Seg. Req. Loop Notes and No. ID Name Des. Max.Use Repeat Comments Must Use 010 TDS Total Monetary Value Summary M 1 070 CTT Transaction Totals O 1 n1 Must Use 080 SE Transaction Set Trailer M 1 Transaction Set Notes Number of line items (CTT01) is the accumulation of the number of IT1 segments. If used, hash total (CTT02) is the sum of the value of quantities invoiced (IT102) for each IT1 segment. Data Dictionary for 810 LDC Consolidated Bill Appl Field Field Name Description EDI Segment Related EDI Qualifier Data Type HEADER LEVEL BILL INFORMATION 1 Bill Date Date Bill was issued. For Bill Ready Scenarios, this will be the date the bill was created. For Rate Ready Scenarios, this will be the date the bill was issued. BIG01 9(8) 2 Bill Number Unique Number identifying this Bill BIG02 X(22) 3 Cross Reference Number The cross reference number originally transmitted in the 867 in the BPT02. BIG05 X(30) 4 Bill Action Code “FE” – Memorandum, Final Bill Customer account has finaled with the LDC. “ME” – Memorandum BIG07 X(2)
Budget Billed. Please see EDI guideline for valid codes. 88 Energy Charge Category Code indicating the type of charge (See segment for Valid Values) SAC04 SAC03="EU" X(10) 89 Charge or Allowance Amount Dollar amount (credit or for the charge. If dollar amount is negative, the leading negative sign will be sent. If the dollar amount is positive, no leading sign is sent. SAC05 -9(13)V99 Implied Decimal 90 Price Per Unit ESP/LDC price per unit associated with the charge SAC08 -9(5).9(6) Max 9 digits 91 Unit of Measure Unit of measure of above consumption See EDI for valid codes. SAC09 X(2) 92 Quantity Consumption or "unit" for the charge. Other unit may be the number of unmetered services. SAC10 9(8).9(4) 93 Print Sequencing Number Determines placement of line items on bill SAC13 9(2) 94 Charge Description Text description for line item charge that will print on the customer's bill SAC15 X(80) SUMMARY SECTION 100 Actual Current Total Total Bill Amount for non-billing party's portion of bill. This does not include arrearages. Even though this segment does not appear at the end of the transaction, it is expected to include all amounts, including those that follow. TDS01 -9(13)V99 Implied Decimal 101 Number of IT1 segments Number of IT1 segments CTT01 9(6) Segment: ST Transaction Set Header Position: 010 : Level: Heading Usage: Mandatory Max Use: 1 Purpose: To indicate the start of a transaction set and to assign a control number Syntax Notes: Semantic Notes: 1 The transaction set identifier (ST01) is used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set). Comments: PA Use: Required NJ Use: Required DE Use: Required MD Use: Required Example: ST*810*000000001 Data Element Summary
Rate SAC*C*F950*EU*GEN004*4539***.03678*KH*1234*****GENERATION CHARGE Data Element Summary Ref. Data Des. Element Name Attributes Must Use SAC01 248 Allowance or Charge Indicator M ID 1/1 Code which indicates an allowance or charge for the service specified A Allowance C Charge N No Allowance or Charge The amount in the SAC05 will be ignored when summing the invoice total. Must Use SAC02 1300 Service, Promotion, Allowance, or Charge Code X ID 4/4 D140 Bill – Actual Charges F950 Rate Ready – Actual Charges H151 Rate Ready – Budget Billed Charges Conditional 559 Agency Qualifier Code (Used for Rate Ready Only) X ID 2/2 EU Electric Utilities Conditional SAC04 1301 Energy Charges X AN 1/10 ADJ002 Adjustment BAS001 Customer Charge BUD001 Current Budget Charge DMD001 Demand Charge GEN002 Generation Charge – Measured GEN003 Generation Charge – Adjusted GEN004 Generation Charge – Billed GTC002 Generation/Transmission Charge – Measured GTC003 Generation/Transmission Charge – Adjusted GTC004 Generation/Transmission Charge – Billed GTC005 Generation/Transmission Charge – On Peak GTC006 Generation/Transmission Charge – Off Peak LPC001 Late Payment Charge TRN002 Transmission Charge – Measured TRN003 Transmission Charge – Adjusted TRN004 Transmission Charge – Billed Must Use SAC05 610 Amount O N2 1/15 Monetary amount This field stands on its own and will be signed if it is negative. The SAC01is NOT used to determine the sign in the SAC05. Conditional SAC08 118 Rate O R 1/9 Rate expressed in the standard monetary denomination for the currency specified Conditional SAC09 355 Unit or Basis for Measurement Code X ID 2/2 Code specifying the in which a value is being expressed, or manner in which a measurement has been taken 99 Watt K1 Kilowatt Demand (kW) Represents potential power load measured at predetermined intervals Kilovolt Amperes Reactive Demand (kVAR) Reactive that must be supplied for specific types of customer's equipment; billable when kilowatt demand usage meets or exceeds a defined parameter K3 Kilovolt Amperes Reactive Hour (kVARH)