Table: BILLING_SECDEP_INTEREST_RATE

BILLING_SECDEP_INTEREST_RATE

Name

BILLING_SECDEP_INTEREST_RATE

Comment

The DAILY interest rates used by billing when calculating the interest amount


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

EFFECTIVEDATE

INTEREST_ACCT_ID

WEEKNO


Content

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