Table: BILLING_SECDEPOSIT_APPLICATION

BILLING_SECDEPOSIT_APPLICATION

Name

BILLING_SECDEPOSIT_APPLICATION

Comment

The security deposit application details


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

The billing contract year where (security deposit application) SDA is applied

WEEKNO

NUMBER(3,0)

X

The billing week no. where the SDA is applied

BILLRUNNO

NUMBER(3,0)

X

The billing run no. where the SDA is applied

PARTICIPANTID

VARCHAR2(20)

X

The Participant ID lodging the SDA

APPLICATION_AMOUNT

NUMBER(18,8)

 

The SDA application amount