|
Name |
|
|
Comment |
BILLINGCPSUM shows adjustments for a billing run by participant. |
|
BILLINGCPSUM data is confidential to the relevant participant. Source Weekly update with billing run. |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PARTICIPANTTYPE |
|
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 |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PARTICIPANTTYPE |
VARCHAR2(10) |
X |
Participant type Generator/Customer |
|
PREVIOUSAMOUNT |
NUMBER(16,6) |
|
Previous amount billed |
|
ADJUSTEDAMOUNT |
NUMBER(16,6) |
|
Adjusted amount billed |
|
ADJUSTMENTWEEKNO |
NUMBER(3,0) |
|
Week no of adjustment |
|
ADJUSTMENTRUNNO |
NUMBER(3,0) |
|
Run no of adjustment |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|