Table: BILLING_GST_DETAIL

BILLING_GST_DETAIL

Name

BILLING_GST_DETAIL

Comment

BILLING_GST_DETAIL shows the BAS class, GST_Exclusive and GST amount (if any) attributable to a participant for each transaction type.


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BAS_CLASS

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

TRANSACTION_TYPE

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

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