Table: BILLINGFINANCIALADJUSTMENTS

BILLINGFINANCIALADJUSTMENTS

Name

BILLINGFINANCIALADJUSTMENTS

Comment

BILLINGFINANCIALADJUSTMENTS contains any manual adjustments included in the billing run.


Description

BILLINGFINANCIALADJUSTMENTS data is confidential to the relevant participant.

Source

BILLINGFINANCIALADJUSTMENTS is populated by the posting of a billing run, being several times each week. The insertion of a manual adjustment in a billing run is infrequent.

Volume

Infrequent and, if included in a billing run, low volume. An indicative maximum is 15 records inserted.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

ADJUSTMENTITEM

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


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)

 

Not Used

ADJUSTMENTITEM

VARCHAR2(64)

X

Description of the adjustment being made

AMOUNT

NUMBER(15,5)

 

The amount of the manual adjustment line item

VALUE

NUMBER(15,5)

 

Not Used

LASTCHANGED

DATE

 

Last date and time the record changed.

FINANCIALCODE

NUMBER(10,0)

 

The GL financial code of the manual adjustment line item. Used internally by AEMO systems.

BAS_CLASS

VARCHAR2(30)

 

The BAS classification of the manual adjustment line item.