BILLING_DIRECTION_RECON_OTHER

Billing reconciliation result table for both provisional and final directions

Column Schema

BILLRUNNO

Billing run no

SQL Type: NUMBER(3) Polars Type: pl.UInt16

This column is mandatory, and a primary key.

Examples: 13, 15

CONTRACTYEAR

Billing contract year

SQL Type: NUMBER(4) Polars Type: pl.UInt16

This column is mandatory, and a primary key.

Example: 2026

DIRECTION_ID

Direction identifier

SQL Type: VARCHAR2(20) Polars Type: str

This column is mandatory, and a primary key.

Examples:

20260417.D0001
20260506.D0001
20260514.D0001
20260515.D0001
20260802.D0001
20260802.D0002
20260808.D0001
20260809.D0001
20260818.D0001
20260822.D0001

REGIONID

Region Identifier

For more information, see the dedicated documentation page.

The SQL type is VARCHAR2(20). This is actually a factor/enum, with values:

QLD1
VIC1
TAS1
NSW1
SA1
SNOWY1

This column is mandatory, and a primary key.

WEEKNO

Billing week no

Warning

There may be 53 weeks in a year, depending on how weeks align to the year start/end.

SQL Type: NUMBER(3) Polars Type: pl.UInt16

This column is mandatory, and a primary key.

Examples: 16, 35

COMPENSATION_AMOUNT

The final compensation amount for the direction. The same value for all regions

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Examples: 2164.606668, 0, 90818.046689

CRA

The total recovery amount for the direction. The same value for all regions

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Examples: 2164.606668, 0, 90818.046689

DIRECTION_DESC

Direction description

SQL Type: VARCHAR2(200) Polars Type: str

This column is not mandatory.

Examples:

Direction issued in SA refer to market notices 141104 & 141108
Direction issued in SA refer to market notices 144049 & 144052
Direction issued in SA refer to market notices 144079 & 144081
Direction issued in SA refer to market notices 144086 & 144089
Direction issued in SA refer to market notices 144706 & 144715
Direction issued in SA refer to market notices 144781 & 144783
Directions issued in SA refer to market notices 144815 & 144818
Directions issued in SA refer to market notices 144908 & 144910
Directions issued in SA refer to market notices 144946 & 144950

DIRECTION_END_DATE

Settlement day on which the direction ends. The same value for all regions

SQL Type: DATE Polars Type: pl.Date()

This column is not mandatory.

Example: 2026/04/17 00:00:00

Note that AEMO represents dates as datetimes with a midnight time component.

DIRECTION_END_INTERVAL

Dispatch interval in which the direction ends. The same value for all regions

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2026/04/17 16:00:00

DIRECTION_SERVICE_ID

The Direction Service ID associated with the Direction Type ID. Eg For FCAS Direction Type, Direction Service could be any contingency service.

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Example: ENERGY

DIRECTION_START_DATE

Settlement day on which the direction starts

SQL Type: DATE Polars Type: pl.Date()

This column is not mandatory.

Example: 2026/04/17 00:00:00

Note that AEMO represents dates as datetimes with a midnight time component.

DIRECTION_START_INTERVAL

Dispatch interval in which the direction starts. The same value for all regions

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2026/04/17 09:05:00

DIRECTION_TYPE_ID

The service for which the direction occurred (ENERGY, ANCILLARY, NON_ENERGY_NON_AS, etc)

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Example: ENERGY

INDEPENDENT_EXPERT_FEE

The independent expert fee amount for the direction. The same value for all regions

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Example: 0

INTEREST_AMOUNT

The interest amount calculated on the final compensation amount for the direction. The same value for all regions

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Example: 0

REGION_ACE_MWH

The Sum of ACE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Examples: -770.482325, -239395.89709155

REGION_ASOE_MWH

The Sum of ASOE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Examples: 785.96506877, 208118.42521528

REGIONAL_BENEFIT_FACTOR

The regional benefit factor allocated to this region for the direction

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1

REGIONAL_CUSTOMER_ENERGY

The total customer energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date.

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

REGIONAL_GENERATOR_ENERGY

The total generator energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date.

SQL Type: NUMBER(18,8) Polars Type: pl.Float64

This column is not mandatory.

New Data Timing

Populated by the posting of a billing run, being several times each week

Code Examples

Polars

Casting is enums, categoricals etc is not essential, but may speed up parsing. Swapping int for pl.UInt16, pl.Int32 would also speed up parsing. However some of the datatypes are inferred, so they may be wrong.

This code deduplicates for you. Deduplication is normally only required across multiple months.

This code assumes that all columns are present, which may not be true for older files.

import polars as pl
import polars.selectors as cs

# e.g. "2029/03/15 00:05:00"
dt_s_fmt = "%Y/%m/%d %H:%M:%S"

# Dates are represented as datetimes at midnight

d_fmt = "%Y/%m/%d 00:00:00"

csv_paths = ["SOMEFILE.CSV", "OTHERFILE.CSV"]

lf = (
    pl.concat(
        [
            pl.scan_csv(
                csv_path,  # must be unzipped beforehand
                skip_rows=1,  # skip the header
                infer_schema=False,  # much faster
            )
            .filter(cs.by_index(0) == "D")  # drop the footer
            .select(~cs.by_index(range(4)))  # drop metadata columns
            for csv_path in csv_paths
        ],
        how="diagonal_relaxed",
    )
    .with_columns(
        pl.col("DIRECTION_END_INTERVAL", "DIRECTION_START_INTERVAL").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
        pl.col("DIRECTION_END_DATE", "DIRECTION_START_DATE").str.strptime(
            pl.Date, d_fmt
        ),
    )
    .cast(
        {
            "BILLRUNNO": int,  # or pl.UInt16
            "CONTRACTYEAR": int,  # or pl.UInt16
            "DIRECTION_ID": str,
            "REGIONID": pl.Enum(["QLD1", "VIC1", "TAS1", "NSW1", "SA1", "SNOWY1"]),
            "WEEKNO": int,  # or pl.UInt16
            "COMPENSATION_AMOUNT": pl.Float64,
            "CRA": pl.Float64,
            "DIRECTION_DESC": str,
            "DIRECTION_END_DATE": pl.Date(),
            "DIRECTION_SERVICE_ID": str,
            "DIRECTION_START_DATE": pl.Date(),
            "DIRECTION_TYPE_ID": str,
            "INDEPENDENT_EXPERT_FEE": pl.Float64,
            "INTEREST_AMOUNT": pl.Float64,
            "REGION_ACE_MWH": pl.Float64,
            "REGION_ASOE_MWH": pl.Float64,
            "REGIONAL_BENEFIT_FACTOR": pl.Float64,
            "REGIONAL_CUSTOMER_ENERGY": pl.Float64,
            "REGIONAL_GENERATOR_ENERGY": pl.Float64,
        }
    )
    # Deduplicate
    # We want one row per ['BILLRUNNO', 'CONTRACTYEAR', 'DIRECTION_ID', 'REGIONID', 'WEEKNO']
    # Tie-breaker: greatest value of ['CONTRACTYEAR', 'WEEKNO', 'BILLRUNNO', 'DIRECTION_ID', 'REGIONID']
    .sort(
        ["CONTRACTYEAR", "WEEKNO", "BILLRUNNO", "DIRECTION_ID", "REGIONID"],
        descending=False,
    )
    .unique(
        subset=["BILLRUNNO", "CONTRACTYEAR", "DIRECTION_ID", "REGIONID", "WEEKNO"],
        keep="last",
    )
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_BILLING_DIRECTION_RECON_OTHER_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

CONTRACTYEAR	WEEKNO	BILLRUNNO	DIRECTION_ID	REGIONID	DIRECTION_DESC	DIRECTION_TYPE_ID	DIRECTION_START_DATE	DIRECTION_END_DATE	DIRECTION_START_INTERVAL	DIRECTION_END_INTERVAL	COMPENSATION_AMOUNT	INTEREST_AMOUNT	INDEPENDENT_EXPERT_FEE	CRA	REGIONAL_CUSTOMER_ENERGY	REGIONAL_GENERATOR_ENERGY	REGIONAL_BENEFIT_FACTOR	REGION_ACE_MWH	REGION_ASOE_MWH	DIRECTION_SERVICE_ID
2026	16	14	20260417.D0001	NSW1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-58624.50130721	65884.75776616	ENERGY
2026	16	14	20260417.D0001	QLD1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-47847.160841	53019.46413258	ENERGY
2026	16	14	20260417.D0001	SA1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			1	-9787.67175115	8823.763265	ENERGY
2026	16	14	20260417.D0001	TAS1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-8272.91496702	7674.49709667	ENERGY
2026	16	14	20260417.D0001	VIC1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-37784.08588001	44641.61586182	ENERGY
2026	32	13	20260802.D0001	NSW1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-92265.82750878	79735.49118911	ENERGY
2026	32	13	20260802.D0001	QLD1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-65613.06058722	83620.10707105	ENERGY
2026	32	13	20260802.D0001	SA1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			1	-17482.62957367	19731.15923832	ENERGY
2026	32	13	20260802.D0001	TAS1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-13610.17061811	13909.17954504	ENERGY
2026	32	13	20260802.D0001	VIC1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-63825.21702907	74606.46538989	ENERGY
2026	32	13	20260802.D0002	NSW1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 11:45:00	2026/08/02 15:30:00	45076.280472	0	0	45076.280472			0	-30066.71805624	33380.9559343	ENERGY
...

C	SETP.WORLD	DVD_BILLING_DIRECTION_RECON_OTHER	AEMO	PUBLIC	2026/10/09	15:24:45	001791523485596	MONTHLY_ARCHIVE	001791523485596
I	BILLING	BILLING_DIRECTION_RECON_OTHER	2	CONTRACTYEAR	WEEKNO	BILLRUNNO	DIRECTION_ID	REGIONID	DIRECTION_DESC	DIRECTION_TYPE_ID	DIRECTION_START_DATE	DIRECTION_END_DATE	DIRECTION_START_INTERVAL	DIRECTION_END_INTERVAL	COMPENSATION_AMOUNT	INTEREST_AMOUNT	INDEPENDENT_EXPERT_FEE	CRA	REGIONAL_CUSTOMER_ENERGY	REGIONAL_GENERATOR_ENERGY	REGIONAL_BENEFIT_FACTOR	REGION_ACE_MWH	REGION_ASOE_MWH	DIRECTION_SERVICE_ID
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	16	14	20260417.D0001	NSW1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-58624.50130721	65884.75776616	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	16	14	20260417.D0001	QLD1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-47847.160841	53019.46413258	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	16	14	20260417.D0001	SA1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			1	-9787.67175115	8823.763265	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	16	14	20260417.D0001	TAS1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-8272.91496702	7674.49709667	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	16	14	20260417.D0001	VIC1	Direction issued in SA refer to market notices 141104 & 141108	ENERGY	2026/04/17 00:00:00	2026/04/17 00:00:00	2026/04/17 09:05:00	2026/04/17 16:00:00	52694.585279	0	0	52694.585279			0	-37784.08588001	44641.61586182	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	32	13	20260802.D0001	NSW1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-92265.82750878	79735.49118911	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	32	13	20260802.D0001	QLD1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-65613.06058722	83620.10707105	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	32	13	20260802.D0001	SA1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			1	-17482.62957367	19731.15923832	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	32	13	20260802.D0001	TAS1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-13610.17061811	13909.17954504	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	32	13	20260802.D0001	VIC1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 00:05:00	2026/08/02 11:50:00	0	0	0	0			0	-63825.21702907	74606.46538989	ENERGY
D	BILLING	BILLING_DIRECTION_RECON_OTHER	2	2026	32	13	20260802.D0002	NSW1	Direction issued in SA refer to market notices 144706 & 144715	ENERGY	2026/08/02 00:00:00	2026/08/02 00:00:00	2026/08/02 11:45:00	2026/08/02 15:30:00	45076.280472	0	0	45076.280472			0	-30066.71805624	33380.9559343	ENERGY
...
C	END OF REPORT	68

CONTRACTYEAR,WEEKNO,BILLRUNNO,DIRECTION_ID,REGIONID,DIRECTION_DESC,DIRECTION_TYPE_ID,DIRECTION_START_DATE,DIRECTION_END_DATE,DIRECTION_START_INTERVAL,DIRECTION_END_INTERVAL,COMPENSATION_AMOUNT,INTEREST_AMOUNT,INDEPENDENT_EXPERT_FEE,CRA,REGIONAL_CUSTOMER_ENERGY,REGIONAL_GENERATOR_ENERGY,REGIONAL_BENEFIT_FACTOR,REGION_ACE_MWH,REGION_ASOE_MWH,DIRECTION_SERVICE_ID
2026,16,14,20260417.D0001,NSW1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-58624.50130721,65884.75776616,ENERGY
2026,16,14,20260417.D0001,QLD1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-47847.160841,53019.46413258,ENERGY
2026,16,14,20260417.D0001,SA1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,1,-9787.67175115,8823.763265,ENERGY
2026,16,14,20260417.D0001,TAS1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-8272.91496702,7674.49709667,ENERGY
2026,16,14,20260417.D0001,VIC1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-37784.08588001,44641.61586182,ENERGY
2026,32,13,20260802.D0001,NSW1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-92265.82750878,79735.49118911,ENERGY
2026,32,13,20260802.D0001,QLD1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-65613.06058722,83620.10707105,ENERGY
2026,32,13,20260802.D0001,SA1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,1,-17482.62957367,19731.15923832,ENERGY
2026,32,13,20260802.D0001,TAS1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-13610.17061811,13909.17954504,ENERGY
2026,32,13,20260802.D0001,VIC1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-63825.21702907,74606.46538989,ENERGY
2026,32,13,20260802.D0002,NSW1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 11:45:00","2026/08/02 15:30:00",45076.280472,0,0,45076.280472,,,0,-30066.71805624,33380.9559343,ENERGY
...

Raw Text with Metadata

C,SETP.WORLD,DVD_BILLING_DIRECTION_RECON_OTHER,AEMO,PUBLIC,2026/10/09,15:24:45,001791523485596,MONTHLY_ARCHIVE,001791523485596
I,BILLING,BILLING_DIRECTION_RECON_OTHER,2,CONTRACTYEAR,WEEKNO,BILLRUNNO,DIRECTION_ID,REGIONID,DIRECTION_DESC,DIRECTION_TYPE_ID,DIRECTION_START_DATE,DIRECTION_END_DATE,DIRECTION_START_INTERVAL,DIRECTION_END_INTERVAL,COMPENSATION_AMOUNT,INTEREST_AMOUNT,INDEPENDENT_EXPERT_FEE,CRA,REGIONAL_CUSTOMER_ENERGY,REGIONAL_GENERATOR_ENERGY,REGIONAL_BENEFIT_FACTOR,REGION_ACE_MWH,REGION_ASOE_MWH,DIRECTION_SERVICE_ID
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,16,14,20260417.D0001,NSW1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-58624.50130721,65884.75776616,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,16,14,20260417.D0001,QLD1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-47847.160841,53019.46413258,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,16,14,20260417.D0001,SA1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,1,-9787.67175115,8823.763265,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,16,14,20260417.D0001,TAS1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-8272.91496702,7674.49709667,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,16,14,20260417.D0001,VIC1,"Direction issued in SA refer to market notices 141104 & 141108",ENERGY,"2026/04/17 00:00:00","2026/04/17 00:00:00","2026/04/17 09:05:00","2026/04/17 16:00:00",52694.585279,0,0,52694.585279,,,0,-37784.08588001,44641.61586182,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,32,13,20260802.D0001,NSW1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-92265.82750878,79735.49118911,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,32,13,20260802.D0001,QLD1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-65613.06058722,83620.10707105,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,32,13,20260802.D0001,SA1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,1,-17482.62957367,19731.15923832,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,32,13,20260802.D0001,TAS1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-13610.17061811,13909.17954504,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,32,13,20260802.D0001,VIC1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 00:05:00","2026/08/02 11:50:00",0,0,0,0,,,0,-63825.21702907,74606.46538989,ENERGY
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,2026,32,13,20260802.D0002,NSW1,"Direction issued in SA refer to market notices 144706 & 144715",ENERGY,"2026/08/02 00:00:00","2026/08/02 00:00:00","2026/08/02 11:45:00","2026/08/02 15:30:00",45076.280472,0,0,45076.280472,,,0,-30066.71805624,33380.9559343,ENERGY
...
C,"END OF REPORT",68

Availability

Visibility: Public

This table is in the public monthly MMSDM archive.

I have collated the list of all those files into one place, in this CSV metadata file. (Columns year, month, url, compressed_size in bytes).

The earliest available data is month 8 of 2024. The most recent available data is month 9 of 2026.

Every month in between has a file. (No gaps.)

Data Size

Each year of data is approximately 33 KB when zipped, 332 KB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

BILLRUNNO
CONTRACTYEAR
DIRECTION_ID
REGIONID
WEEKNO

The transaction type is "insert", which means that you will usually not see duplicate data. If you do, you can deduplicate based on the primary keys, without sorting first. Rows from different files with the same primary keys should have the same values.

PDR Loader configuration is:

Report Name	Report Subtype	Version
BILLING	BILLING_DIRECTION_RECON_OTHER	2

This means that the CSV files start with metadata columns:

I,BILLING,BILLING_DIRECTION_RECON_OTHER,2,...
D,BILLING,BILLING_DIRECTION_RECON_OTHER,2,...

Links

This page as JSON (schema documented here, but may change)

Download a JSON Schema specification for this table.

Official AEMO schema documentation

Other Information

Package: BILLING_RUN