Table: BILLADJUSTMENTS

BILLADJUSTMENTS

Name

BILLADJUSTMENTS

Comment

 


Description

BILLADJUSTMENTS is confidential, and is available only to the relevant participant.

Source

Ad hoc


Primary Key Columns

Name

ADJBILLRUNNO

ADJCONTRACTYEAR

ADJWEEKNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

AEMO Contract Year number starting in week containing 1st January

WEEKNO

NUMBER(3,0)

X

 

BILLRUNNO

NUMBER(3,0)

 

The sequential number of a billing run

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

PARTICIPANTTYPE

VARCHAR2(10)

 

Participant type Generator/Customer

ADJCONTRACTYEAR

NUMBER(4,0)

X

The contract year of the new revised billing run for this adjustment

ADJWEEKNO

NUMBER(3,0)

X

Week number of the new revised billing run for this adjustment

ADJBILLRUNNO

NUMBER(3,0)

X

Billing run number of the new revised billing run for this adjustment

PREVAMOUNT

NUMBER(16,6)

 

Prior account

ADJAMOUNT

NUMBER(16,6)

 

The total bill figure for the new revised billing run

LASTCHANGED

DATE

 

 

LRS

NUMBER(15,5)

 

 

PRS

NUMBER(15,5)

 

 

OFS

NUMBER(15,5)

 

 

IRN

NUMBER(15,5)

 

Interest rate applying to the new amount

IRP

NUMBER(15,5)

 

Interest rate applying to the principal amount

INTERESTAMOUNT

NUMBER(15,5)

 

The total interest payable for this adjustment