EDI 867 - Do you have plans to support this specification?

Developer
Sep 13, 2012 at 7:18 PM

Please let me know.

Regards

Coordinator
Sep 13, 2012 at 7:53 PM

If you point me to the specification you are using I can get it added in the next few days.

Developer
Sep 13, 2012 at 10:39 PM

 

This document contains the format and structure for the 867 transaction used to communicate either current billed consumption, current metered usage, calendar month estimated consumption or an Interim Bill Notice. Each 867 transaction contains current usage for a single account for a single commodity (Electric or Gas).

 

Heading:

 

Page               Pos.        Seg.                                                                                                          Req.                                         Loop              Notes and

No.                  No.          ID               Name                                                                                   Des.          Max.Use             Repeat           Comments                       

1

010

ST

Transaction Set Header

M

1

 

 

 

 

 

 

 

 

4

020

BPT

Beginning Segment for Product Transfer and Resale

M

1

 

 

 

 

 

 

 

 

5

050

DTM

Date/Time Reference (Next Meter Read Date)

O

1

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - N1

 

 

1

 

 

 

 

 

 

 

6

080

N1

Name (ESCO/Marketer)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - N1

 

 

1

 

 

 

 

 

 

 

7

080

N1

Name (Utility)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - N1

 

 

1

 

 

 

 

 

 

 

8

080

N1

Name (Customer)

O

1

 

 

 

 

 

 

 

 

9

100

N3

Address Information (Service Address)

O

1

 

 

 

 

 

 

 

 

10

110

N4

Geographic Location (Service Address)

O

1

 

 

 

 

 

 

 

 

11

120

REF

Reference Identification (ESCO/Marketer Customer Account Number)

O

1

 

 

 

 

 

 

 

 

12

120

REF

Reference Identification (Utility Account Number)

O

1

 

 

 

 

 

 

 

 

13

120

REF

Reference Identification (Previous Utility Account Number)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Detail:

 

Page               Pos.        Seg.                                                                                                          Req.                                         Loop              Notes and

No.                  No.          ID               Name                                                                                   Des.          Max.Use             Repeat           Comments                       

 

 

 

LOOP ID - PTD

 

 

>1

 

 

 

 

 

 

 

14

010

PTD

Product Transfer and Resale Detail (Metered Consumption Summary)

M

1

 

 

 

 

 

 

 

 

15

030

REF

Reference Identification (Utility Rate Service Class)

O

1

 

 

 

 

 

 

 

 

16

030

REF

Reference Identification (Rate Sub Class)

O

1

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - QTY

 

 

>1

 

 

 

 

 

 

 

17

110

QTY

Quantity

O

1

 

 

 

 

 

 

 

 

18

140

AMT

Monetary Amount (Back Out Credit)

O

1

 

 

 

 

 

 

 

 

19

160

MEA

Measurements

O

40

 

 

 

 

 

 

 

 

22

210

DTM

Date/Time Reference (Period Start Date)

O

1

 

 

 

 

 

 

 

 

22

210

DTM

Date/Time Reference (Period End Date)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

 

 

 

LOOP ID - PTD

 

 

>1

 

 

 

 

 

 

 

24

010

PTD

Product Transfer and Resale Detail (Un-metered Consumption)

M

1

 

 

 

 

 

 

 

 

25

030

REF

Reference Identification (Utility Rate Service Class)

O

1

 

 

 

 

 

 

 

 

26

030

REF

Reference Identification (Rate Sub Class)

O

1

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - QTY

 

 

>1

 

 

 

 

 

 

 

27

110

QTY

Quantity

O

1

 

 

 

 

 

 

 

 

28

140

AMT

Monetary Amount (Back Out Credit)

O

1

 

 

 

 

 

 

 

 

29

160

MEA

Measurements

O

40

 

 

 

 

 

 

 

 

30

210

DTM

Date/Time Reference (Period Start Date)

O

1

 

 

 

 

 

 

 

 

30

210

DTM

Date/Time Reference (Period End Date)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - PTD

 

 

>1

 

 

 

 

 

 

 

31

010

PTD

Product Transfer and Resale Detail (Metered Consumption Detail)

M

1

 

 

 

 

 

 

 

 

33

030

REF

Reference Identification (Meter Number)

O

1

 

 

 

 

 

 

 

 

34

030

REF

Reference Identification (Utility Rate Service Class)

O

1

 

 

 

 

 

 

 

 

35

030

REF

Reference Identification (Rate Sub Class)

O

1

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - QTY

 

 

>1

 

 

 

 

 

 

 

36

110

QTY

Quantity

O

1

 

 

 

 

 

 

 

 

37

140

AMT

Monetary Amount (Back Out Credit)

O

1

 

 

 

 

 

 

 

 

38

160

MEA

Measurements

O

40

 

 

 

 

 

 

 

 

41

210

DTM

Date/Time Reference (Period Start Date)

O

1

 

 

 

 

 

 

 

 

42

210

DTM

Date/Time Reference (Period End Date)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - PTD

 

 

1

 

 

 

 

 

 

 

43

010

PTD

Product Transfer and Resale Detail (Interim Bill Notice)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - PTD

 

 

>1

 

 

 

 

 

 

 

42

010

PTD

Product Transfer and Resale Detail (Metered Usage Detail)

M

1

 

 

 

 

 

 

 

 

45

030

REF

Reference Identification (Meter Number)

O

1

 

 

 

 

 

 

 

 

46

030

REF

Reference Identification (Service Point ID)

O

1

 

 

 

 

 

 

 

 

47

030

REF

Reference Identification (Number of Dials)

O

1

 

 

 

 

 

 

 

 

48

030

REF

Reference Identification (Utility Rate Service Class)

O

1

 

 

 

 

 

 

 

 

49

030

REF

Reference Identification (Rate Sub Class)

O

1

 

 

 

 

 

 

 

 

 

 

 

LOOP ID - QTY

 

 

>1

 

 

 

 

 

 

 

50

110

QTY

Quantity

O

1

 

 

 

 

 

 

 

 

51

140

AMT

Monetary Amount (Back Out Credit)

O

1

 

 

 

 

 

 

 

 

52

160

MEA

Measurements (Usage)

O

40

 

 

 

 

 

 

 

 

54

160

MEA

Measurements (Meter Multiplier)

O

1

 

 

 

 

 

 

 

 

55

160

MEA

Measurements (Metered Base Load)

O

1

 

 

 

 

 

 

 

 

56

160

MEA

Measurements (Therm Factor)

O

1

 

 

 

 

 

 

 

 

57

160

MEA

Measurements (Degree Day Factor)

O

1

 

 

 

 

 

 

 

 

58

160

MEA

Measurements (Transformer Loss Adjustment Factor)

O

1

 

 

 

 

 

 

 

 

59

210

DTM

Date/Time Reference (Period Start Date)

O

1

 

 

 

 

 

 

 

 

60

210

DTM

Date/Time Reference (Period End Date)

O

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Summary:

 

Page               Pos.        Seg.                                                                                                          Req.                                         Loop              Notes and

No.                  No.          ID               Name                                                                                   Des.          Max.Use             Repeat           Comments                       

61

030

SE

Transaction Set Trailer

M

1

 

 

 

 

 

 

 

 

E-1

 

 

Examples

 

 

 

 

 

 

 

 

 

 


Developer
Sep 13, 2012 at 10:44 PM

Guideline

http://www.hibcc.org/ebus/editemplates/EDI%20PDF%2011-21-05/ts867AH.pdf

 

Examples

http://www.hibcc.org/ebus/editemplates/EDI%20PDF%2011-21-05/867ex1.pdf

http://www.hibcc.org/ebus/editemplates/EDI%20PDF%2011-21-05/867ex2.pdf

http://www.hibcc.org/ebus/editemplates/EDI%20PDF%2011-21-05/867ex3.pdf

 

Hope this helps.

Coordinator
Sep 14, 2012 at 2:53 AM

I had to use the specification here: 

http://www2.dla.mil/j-6/dlmso/elibrary/Transformats/ICs/4010/41f867da.pdf.

The examples you gave me wouldn't parser with the specification given.  The ITA and PID segments were missing from your inline spec here and linked spec.

I also had to fix all the examples because the PTD was in the example as PTD01.

Changeset 19867 has the implementation you are looking for.



Let me know if you encounter an example that won't parse.

Developer
Sep 14, 2012 at 2:59 AM

Thank you very much. I also write software for living (I am very good at). But, the work you have done here is amazingly beautiful and immensly useful. Thank you for sharing this beautiful work.

Regards