Table: BILLING_EFTSHORTFALL_DETAIL

BILLING_EFTSHORTFALL_DETAIL

Name

BILLING_EFTSHORTFALL_DETAIL

Comment

The Billing Shortfall Run Amount details


Description

BILLING_EFTSHORTFALL_DETAIL data is confidential, and is available only to the relevant participant.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

TRANSACTION_TYPE

WEEKNO


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

The shortfall affected billing contract year

WEEKNO

NUMBER(3,0)

X

The shortfall affected billing week no

BILLRUNNO

NUMBER(3,0)

X

The shortfall affected billing week run no

PARTICIPANTID

VARCHAR2(20)

X

The participant affected by the shortfall calculation

TRANSACTION_TYPE

VARCHAR2(40)

X

The transaction type details associated with the shortfall calculation

AMOUNT

NUMBER(18,8)

 

The amount for each transaction type