|
Name |
|
|
Comment |
The DAILY interest rates used by billing when calculating the interest amount |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
EFFECTIVEDATE |
|
INTEREST_ACCT_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 |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
X |
The interest account ID used by security deposit interest calculation |
|
EFFECTIVEDATE |
DATE |
X |
The effective date of the new interest change |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The interest rate to apply from the effective date |
|
|
|