Name |
|
Comment |
BILLINGFINANCIALADJUSTMENTS contains any manual adjustments included in the billing run. |
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. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private |
Name |
ADJUSTMENTITEM |
BILLRUNNO |
CONTRACTYEAR |
PARTICIPANTID |
WEEKNO |
Name |
LASTCHANGED |
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. |
|
|
|