|
Name |
|
|
Comment |
The interest amount for security deposit calculated by billing, based on whether it is a fixed/floating rate |
|
BILLING_SECDEP_INTEREST_PAY data is confidential, and is available only to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
SECURITY_DEPOSIT_ID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The billing contract year the SDA application is processed and interest calculated |
|
WEEKNO |
NUMBER(3,0) |
X |
The billing week no. the SDA application is processed and interest calculated |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The billing run no. the SDA application is processed and interest calculated |
|
SECURITY_DEPOSIT_ID |
VARCHAR2(20) |
X |
The security deposit ID for which billing has calculated the Interest amount |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The participant ID of the security deposit for whom the interest is paid |
|
INTEREST_AMOUNT |
NUMBER(18,8) |
|
The security deposit interest amount calculated by billing |
|
INTEREST_CALC_TYPE |
VARCHAR2(20) |
|
FIXED or DAILY |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
|
The interest account ID used by billing for calculating the interest. |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The STATIC Interest Rate used by Billing for calculating the interest. This is NULL if INTEREST_CALC_TYPE <> FIXED |
|
|
|