|
Name |
|
|
Comment |
BILLING_GST_DETAIL shows the BAS class, GST_Exclusive and GST amount (if any) attributable to a participant for each transaction type. |
|
BILLING_GST_DETAIL data is confidential to NSP participants. Source Populated by the posting of a billing run. Volume Approximately 20 records are inserted per billrunno, or about 220 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BAS_CLASS |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
TRANSACTION_TYPE |
|
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 |
|
BAS_CLASS |
VARCHAR2(30) |
X |
The BAS classification that the transaction type belongs to. |
|
TRANSACTION_TYPE |
VARCHAR2(30) |
X |
The transaction type (e.g. CUSTOMER_ENERGY_PURCHASES) |
|
GST_EXCLUSIVE_AMOUNT |
NUMBER(15,5) |
|
The GST exclusive amount paid by/to the participant to/by AEMO for this transaction type. |
|
GST_AMOUNT |
NUMBER(15,5) |
|
The GST amount for this transaction type. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|