|
Name |
|
|
Comment |
The security deposit provision entry details |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
PARTICIPANTID |
|
SECURITY_DEPOSIT_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SECURITY_DEPOSIT_ID |
VARCHAR2(20) |
X |
The security deposit ID |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant ID linked to the security deposit ID |
|
TRANSACTION_DATE |
DATE |
|
The date the security deposit ID is entered and authorised by settlements |
|
MATURITY_CONTRACTYEAR |
NUMBER(4,0) |
|
The contract year of the billing week when the security deposit is maturing |
|
MATURITY_WEEKNO |
NUMBER(3,0) |
|
The week no of the billing week when the security deposit is maturing |
|
AMOUNT |
NUMBER(18,8) |
|
The security deposit amount |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The interest rate assigned to the security deposit ID. Null if INTEREST_CALC_TYPE <> FIXED |
|
INTEREST_CALC_TYPE |
VARCHAR2(20) |
|
FIXED OR DAILY |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
|
The Interest Account ID for calculating the Interest Payment. This is NULL if the INTEREST_CALC_TYPE = FIXED |
|
|
|