Name |
|
Comment |
|
BILLADJUSTMENTS is confidential, and is available only to the relevant participant. Source Ad hoc |
Name |
ADJBILLRUNNO |
ADJCONTRACTYEAR |
ADJWEEKNO |
CONTRACTYEAR |
PARTICIPANTID |
WEEKNO |
Name |
LASTCHANGED |
Name |
PARTICIPANTID |
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 |
|
|
|