Table: BILLINGCPSUM

BILLINGCPSUM

Name

BILLINGCPSUM

Comment

BILLINGCPSUM shows adjustments for a billing run by participant.


Description

BILLINGCPSUM data is confidential to the relevant participant.

Source

Weekly update with billing run.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

PARTICIPANTTYPE

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

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