|
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 |
|
|
|