AR_INTEREST_LINES

Details

Schema: FUSION
Object owner: AR
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AR_INTEREST_LINES_PK	INTEREST_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INTEREST_LINE_ID	NUMBER		18	Yes	Interest line identifier. It is used as a primary key.
INTEREST_HEADER_ID	NUMBER		18	Yes	Foreign key to ra_interest_headers_all.interest_invoice_id
PAYMENT_SCHEDULE_ID	NUMBER		18	Yes	Foreign key to AR_PAYMENT_SCHEDULES_ALL.PAYMENT_SCHEDULE_ID.
OUTSTANDING_AMOUNT	NUMBER				Outstanding Amount, overdue late payment amount
DAYS_OVERDUE_LATE	NUMBER				Number of days the payment is overdue or late.
DAYS_OF_INTEREST	NUMBER				Number of days for which interest is charged.
INTEREST_CHARGED	NUMBER				Amount of interest charged against an overdue transaction.
PAYMENT_DATE	DATE				Payment date used when late charges are calculated for late payments.
FINANCE_CHARGE_CHARGED	NUMBER				The adjustments of type FINCHRG this is deducted from the overdue amount of invoice to compute the simple interest for invoices.
AMOUNT_DUE_ORIGINAL	NUMBER				The original amount due for the transaction installment which is selected for late charge calculation.
AMOUNT_DUE_REMAINING	NUMBER				The remaining due amount for the transaction installment which is selected for late charge calculation.
ORIGINAL_TRX_ID	NUMBER		18		Link between a late charge interest line and its original transaction. RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID, AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID.
LAST_CHARGE_DATE	DATE				Date on which the late charge was last calculated for the transaction installment.
DUE_DATE	DATE				Payment schedule due date/Balance ford bill date
ACTUAL_DATE_CLOSED	DATE				Actual date closed of payment schedule
INTEREST_RATE	NUMBER				Interest rate applied.
RATE_START_DATE	DATE				Rate effectivity start date
RATE_END_DATE	DATE				Rate effectivity end date
SCHEDULE_DAYS_FROM	NUMBER				From days of aging bucket line
SCHEDULE_DAYS_TO	NUMBER				To day of aging bucket line
PROCESS_MESSAGE	VARCHAR2	2000			Error message text
PROCESS_STATUS	VARCHAR2	30			Status code to indicate Success or Error
ORIGINAL_TRX_CLASS	VARCHAR2	30			Interest on INV, DM (debits), CM, Receipt (credits)
TYPE	VARCHAR2	30			Lookup type : AR_CHARGE_LINE_TYPE
DAILY_INTEREST_CHARGE	NUMBER				Daily interest charged/interest amount charged
RECEIVABLES_TRX_ID	NUMBER		18		Interest line or penalty receivables transaction identifier used only for adjustments.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_INTEREST_LINES_ALL	ar_interest_headers_all	INTEREST_HEADER_ID
AR_INTEREST_LINES_ALL	ar_payment_schedules_all	PAYMENT_SCHEDULE_ID
AR_INTEREST_LINES_ALL	ar_receivables_trx_all	RECEIVABLES_TRX_ID, ORG_ID
AR_INTEREST_LINES_ALL	ra_customer_trx_all	ORIGINAL_TRX_ID
ar_adjustments_all	ar_interest_lines_all	INTEREST_LINE_ID
ra_customer_trx_lines_all	ar_interest_lines_all	INTEREST_LINE_ID

Indexes

Index	Uniqueness	Columns
AR_INTEREST_LINES_U1	Unique	INTEREST_LINE_ID
AR_INTEREST_LINES_U2	Unique	INTEREST_HEADER_ID, INTEREST_LINE_ID