BILLING_SECDEP_INTEREST_PAY

The interest amount for security deposit calculated by billing, based on whether it is a fixed / floating rate.

Package

BILLING_RUN

Private

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	The billing contract year the SDA application is processed and interest calculated
WEEKNO	numeric(3, 0)	tinyint	The billing week no. the SDA application is processed and interest calculated
BILLRUNNO	numeric(3, 0)	smallint	The billing run no. the SDA application is processed and interest calculated
SECURITY_DEPOSIT_ID	varchar(20)	varchar(20)	The security deposit ID for which billing has calculated the Interest amount
PARTICIPANTID	varchar(20)	varchar(20)	The participant ID of the security deposit for whom the interest is paid
INTEREST_AMOUNT	numeric(18, 8)	numeric(18, 8)	The security deposit interest amount calculated by billing
INTEREST_CALC_TYPE	varchar(20)	varchar(20)	FIXED or DAILY
INTEREST_ACCT_ID	varchar(20)	varchar(20)	The interest account ID used by billing for calculating the interest. NULL if INTEREST_CALC_TYPE = FIXED
INTEREST_RATE	numeric(18, 8)	numeric(18, 8)	The STATIC Interest Rate used by Billing for calculating the interest. This is NULL if INTEREST_CALC_TYPE <> FIXED

Index name	Index type	Index columns (in order)
BILLING_SECDEP_INTEREST_PAY_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, SECURITY_DEPOSIT_ID, PARTICIPANTID

Index name	Index type	Index columns (in order)
PK_BILLING_SECDEP_INTEREST_PAY	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, SECURITY_DEPOSIT_ID, PARTICIPANTID

Index name	Index type	Index columns (in order)
BILLING_SECDEP_INTEREST_PAY_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, SECURITY_DEPOSIT_ID, PARTICIPANTID