BILLING_RUN

Results from a published Billing Run. The settlement data and billing run data are updated daily between 6am and 8am for AEMO's prudential processes. In a normal week, AEMO publishes one PRELIM, one FINAL and two REVISION runs in addition to the daily runs.Each billing run is uniquely identified by contract year, week no and bill run no.

Tables

This package contains the following tables:

Name	Description
BILLING_APC_COMPENSATION	Billing result table for APC compensation payments.
BILLING_APC_RECOVERY	Billing result table for recovery of APC compensation payments
BILLING_CASHSEC_INTEREST_PAY	Indicates the amount of cash security interest payment the participant receives
BILLING_CO2E_PUBLICATION	Carbon Dioxide Intensity Index publication table
BILLING_CO2E_PUBLICATION_TRK	Carbon Dioxide Intensity Index publication tracking table
BILLING_DAILY_ENERGY_SUMMARY	Billing result table containing daily summary data for customer and generator energy amounts
BILLING_DIR_FINAL_AMOUNT	The Billing Final Directions Payment Amount for Directed/Affected/Eligible participants
BILLING_DIR_FINAL_RECOVERY	The Billing Final Directions Recovery Amount for the participants
BILLING_DIR_PROV_AMOUNT	The Billing Provisional Directions Payment Amount for Directed/Affected/Eligible participants
BILLING_DIR_PROV_RECOVERY	The Billing Provisional Directions Recovery Amount for the participants
BILLING_DIR_RECOVERY_DETAIL	The Billing Directions Recovery Details for the participants
BILLING_DIRECTION_RECON_OTHER	Billing reconciliation result table for both provisional and final directions
BILLING_EFTSHORTFALL_AMOUNT	The billing shortfall run amounts
BILLING_EFTSHORTFALL_DETAIL	The Billing Shortfall Run Amount details
BILLING_ENERGY_GENSET_DETAIL	The Billing Energy Genset report contains the Genset Energy detail summary for the Billing Week data
BILLING_ENERGY_TRAN_SAPS	The SAP Billing Transaction Details for the Participants
BILLING_ENERGY_TRANSACTIONS	The Billing Energy Transactions is the summary of the Settlement Energy Transactions that has the ACE and ASOE MWh and Dollar values that is used for the Statement
BILLING_FCAS_REG_AMT	This report show the summary of the Billing run FCAS Regulation Amounts incl default amounts.
BILLING_FCAS_REG_RESIDAMT	This report show the summary of the Billing run FCAS Regulation Residual Amounts incl default amounts
BILLING_FPP	This report show the summary of the Billing run FPP Amounts for the week
BILLING_GST_DETAIL	BILLING_GST_DETAIL shows the BAS class, GST_Exclusive and GST amount (if any) attributable to a participant for each transaction type.
BILLING_GST_SUMMARY	BILLING_GST_SUMMARY shows the GST_Exclusive and GST amount (if any) attributable to a participant for each BAS class.
BILLING_IRSR_NSP_ALLOCATION	The report is used to show the participants the negative residue amount to TNSP based on regional share
BILLING_NMAS_MANUAL_PAYMENT	This report contains the NMAS Manual Weekly Payments that are uploaded by the Settlement Business Team. Amounts in this table are not calculated by the Settlement System.
BILLING_NMAS_MANUAL_RECOVERY	This report shows the summary of the Billing NMAS Recovery Amounts. This table will have recovery data for manual payments for System Security Services.
BILLING_NMAS_TST_PAYMENTS	BILLING_NMAS_TEST_PAYMENTS publish the NSCAS/SRAS Testing Payments data for a posted billing week. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
BILLING_NMAS_TST_RECOVERY	BILLING_NMAS_TEST_RECOVERY sets out the recovery of NMAS testing payments This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
BILLING_NMAS_TST_RECVRY_RBF	BILLING_NMAS_TEST_RECVRY_RBF sets out the NSCAS/SRAS Testing Payment recovery data for the posted billing week.
BILLING_NMAS_TST_RECVRY_TRK	BILLING_NMAS_TEST_RECVRY_TRK tracks the energy data used to allocate the test payment recovery over the recovery period. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
BILLING_SECDEP_INTEREST_PAY	The interest amount for security deposit calculated by billing, based on whether it is a fixed/floating rate
BILLING_SECDEP_INTEREST_RATE	The DAILY interest rates used by billing when calculating the interest amount
BILLING_SECDEPOSIT_APPLICATION	The security deposit application details
BILLING_SUBST_DEMAND	Demand Values Substituted in Billing Calculation
BILLING_SUBST_RUN_VERSION	Details of settlement runs used as input in the substitute demand calculation
BILLING_WDR	Billing WDR Transaction Weekly Summary
BILLING_WDR_DETAIL	Billing WDR transaction detail summary
BILLINGAPCCOMPENSATION	BILLINGAPCCOMPENSATION shows Administered Price Cap (APC) compensation amounts for the billing period. Data is for each participant by region.
BILLINGAPCRECOVERY	BILLINGAPCRECOVERY shows the Administered Price Cap (APC) Recovery for the billing period. Data is for each participant by region.
BILLINGASPAYMENTS	BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant’s connection points.
BILLINGASRECOVERY	BILLINGASRECOVERY shows participant charges for Ancillary Services for the billing period. This view shows the billing amounts for Ancillary Service Recovery.
BILLINGDAYTRK	BILLINGDAYTRK is key for matching settlement versions with billing runs. BILLINGDAYTRK displays the billrunnos per billing week, and the settlement version numbers per settlement day comprising the billrunno.
BILLINGFEES	BILLINGFEES presents pool fees applied to the statement, per billing run.
BILLINGFINANCIALADJUSTMENTS	BILLINGFINANCIALADJUSTMENTS contains any manual adjustments included in the billing run.
BILLINGINTERRESIDUES	BILLINGINTERRESIDUES shows interregion residues payable to NSP.
BILLINGINTRARESIDUES	BILLINGINTRARESIDUES shows intra-region settlement residue details for each Transmission Network Service Provider participant by region.
BILLINGIRAUCSURPLUS	BILLINGIRAUCSURPLUS supports the Settlements Residue Auction, by showing the weekly billing Interconnector Residue (IR) payments as calculated for each bill run for Network Service Providers (NSPs) from the amount not auctioned.
BILLINGIRAUCSURPLUSSUM	BILLINGIRAUCSURPLUSSUM contains Auction fees and Settlements Residue Auction distribution that may arise from unpurchased auction units that accrue to Transmission Network Service Providers.
BILLINGIRFM	BILLINGIRFM shows billing amounts associated with Industrial Relations Forced Majeure events for each participant.
BILLINGIRNSPSURPLUS	BILLINGIRNSPSURPLUS supports the Settlements Residue Auction (SRA), by showing the weekly billing Interconnector Residue (IR) payments as calculated for each bill run for Transmission Network Service Providers (TNSP) from the amount paid by participants (i.e. derogated amounts).
BILLINGIRNSPSURPLUSSUM	BILLINGIRNSPSURPLUSSUM contains derogated payments made to TNSPs arising from the Settlements Residue Auction process.
BILLINGIRPARTSURPLUS	BILLINGIRPARTSURPLUS supports the Settlements Residue Auction, by showing the weekly billing SRA distribution to Auction participants by Contract Identifier.
BILLINGIRPARTSURPLUSSUM	BILLINGIRPARTSURPLUSSUM supports the Settlements Residue Auction, by showing the weekly billing SRA distribution and associated fees to Auction participants.
BILLINGPRIORADJUSTMENTS	BILLINGPRIORADJUSTMENTS sets out prior period adjustments and associated interest inserted in subsequent Final Statements arising from Revision Statement postings.
BILLINGREALLOC	BILLINGREALLOC shows reallocation contract values in each billing run, where participants have used reallocations.
BILLINGREALLOC_DETAIL	Billing Reallocation Data aggregated by REALLOCATIONID for each billing run over the billing week.
BILLINGREGIONEXPORTS	BILLINGREGIONEXPORTS sets out the region summary table of overall energy exported to and from each region for each billing run.
BILLINGREGIONFIGURES	BILLINGREGIONFIGURES sets out additional summary region details including ancillary service amounts for each billing run.
BILLINGREGIONIMPORTS	BILLINGREGIONIMPORTS sets out the region summary table of overall energy imported to and from each region for each billing run.
BILLINGRUNTRK	BILLINGRUNTRK identifies the Statement type (i.e. Status of PRELIM, FINAL, REVISE) and date of the BillRunNo posted, per WeekNo. This provides a further extension of tracking data from the BILLINGDAYTRK table.
BILLRESERVETRADERPAYMENT	Details of the RERT Usage and Availability Payments made to the participant.
BILLRESERVETRADERRECOVERY	Provides details of the RERT Recovery Amount for the Market Customers.
BILLWHITEHOLE	BILLWHITEHOLE shows white hole payments based on participant vs region demand.

Diagram

Links

Package Documentation

Copy as Markdown