eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_SIF_FEES

Object Details

Object Name:	OKL_SIF_FEES
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_SIF_FEES
Subobject Name:
Status:	VALID

This is an interface table which holds details about fees like fee type, fee amount, payment date etc.
This is a denormalized table which holds details of fee header and payment levels. This information
is used for external pricing. References to contract lines, stream Interface headers and stream
interface lines are also stored here.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_SFE_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	ID
OKL_SFE_U2	NORMAL	UNIQUE	APPS_TS_NOLOGGING	SIF_ID SIL_ID SFE_TYPE FEE_INDEX_NUMBER LEVEL_INDEX_NUMBER
SFE_KLE_FK1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	KLE_ID
SFE_SIL_FK_I	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	SIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
SFE_TYPE	VARCHAR2	(10)	Yes	Lookup code for the fee type. Valid values are SFO, SFP, SFR, SFI and SFN.
DATE_START	DATE			First due date for a recurring fee
DATE_PAID	DATE			assume start date
IDC_ACCOUNTING_FLAG	VARCHAR2	(10)		From fee type set up
INCOME_OR_EXPENSE	VARCHAR2	(10)	Yes	Always send income
DESCRIPTION	VARCHAR2	(1995)		User entered description
FEE_INDEX_NUMBER	NUMBER		Yes	Index to determine relationship with Asset
LEVEL_INDEX_NUMBER	NUMBER	(3)		Sequence number for the payment level.
ADVANCE_OR_ARREARS	VARCHAR2	(10)	Yes	Should be one setting for the contract
LEVEL_TYPE	VARCHAR2	(30)		Payment level type.
LOCK_LEVEL_STEP	VARCHAR2	(10)		Whether modifications are allowed for the payment level for pricing.
PERIOD	VARCHAR2	(30)		Frequency of the payment.
NUMBER_OF_PERIODS	NUMBER	(6)		Number of payments for a payment level.
LEVEL_LINE_NUMBER	NUMBER	(5)		Reference to the fee index number
SIF_ID	NUMBER			Foreign key to table OKL_STREAM_INTERFACES
KLE_ID	NUMBER			Foreign key to table OKL_K_LINES
SIL_ID	NUMBER			Foreign key to table OKL_SIF_LINES
RATE	NUMBER	(18)		Rate for the payment level.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
STRUCTURE	VARCHAR2	(200)		Structure of the payment level.
DAYS_IN_PERIOD	NUMBER			Number of days in a payment period.
QUERY_LEVEL_YN	VARCHAR2	(10)		Whether to query the payment level in the results from pricing engine.
STREAM_INTERFACE_ATTRIBUTE01	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE02	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE03	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE04	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE05	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE06	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE07	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE08	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE09	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE10	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE11	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE12	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE13	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE14	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE15	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE16	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE17	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE18	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE19	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE20	VARCHAR2	(450)		Generic attribute for extensions.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CASH_EFFECT_YN	VARCHAR2	(3)		Cash effect YN flag
TAX_EFFECT_YN	VARCHAR2	(3)		Tax effect YN flag
DAYS_IN_MONTH	VARCHAR2	(30)		Day Convention for Days In a Month
DAYS_IN_YEAR	VARCHAR2	(240)		Day Convention for Days In a Year
BALANCE_TYPE_CODE	VARCHAR2	(30)		This field is used to indicate if the paydown is for Solve for Payment or Solve for Term. The field will have the values 'PAYMENT' or 'TERM'
DOWN_PAYMENT_AMOUNT	NUMBER			This column stores the down payment amount made on the asset
ORIG_CONTRACT_LINE_ID	NUMBER			Foreign key to table okc_k_lines_b
AMOUNT#1	NUMBER			Amount

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      SFE_TYPE
,      DATE_START
,      DATE_PAID
,      IDC_ACCOUNTING_FLAG
,      INCOME_OR_EXPENSE
,      DESCRIPTION
,      FEE_INDEX_NUMBER
,      LEVEL_INDEX_NUMBER
,      ADVANCE_OR_ARREARS
,      LEVEL_TYPE
,      LOCK_LEVEL_STEP
,      PERIOD
,      NUMBER_OF_PERIODS
,      LEVEL_LINE_NUMBER
,      SIF_ID
,      KLE_ID
,      SIL_ID
,      RATE
,      OBJECT_VERSION_NUMBER
,      STRUCTURE
,      DAYS_IN_PERIOD
,      QUERY_LEVEL_YN
,      STREAM_INTERFACE_ATTRIBUTE01
,      STREAM_INTERFACE_ATTRIBUTE02
,      STREAM_INTERFACE_ATTRIBUTE03
,      STREAM_INTERFACE_ATTRIBUTE04
,      STREAM_INTERFACE_ATTRIBUTE05
,      STREAM_INTERFACE_ATTRIBUTE06
,      STREAM_INTERFACE_ATTRIBUTE07
,      STREAM_INTERFACE_ATTRIBUTE08
,      STREAM_INTERFACE_ATTRIBUTE09
,      STREAM_INTERFACE_ATTRIBUTE10
,      STREAM_INTERFACE_ATTRIBUTE11
,      STREAM_INTERFACE_ATTRIBUTE12
,      STREAM_INTERFACE_ATTRIBUTE13
,      STREAM_INTERFACE_ATTRIBUTE14
,      STREAM_INTERFACE_ATTRIBUTE15
,      STREAM_INTERFACE_ATTRIBUTE16
,      STREAM_INTERFACE_ATTRIBUTE17
,      STREAM_INTERFACE_ATTRIBUTE18
,      STREAM_INTERFACE_ATTRIBUTE19
,      STREAM_INTERFACE_ATTRIBUTE20
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CASH_EFFECT_YN
,      TAX_EFFECT_YN
,      DAYS_IN_MONTH
,      DAYS_IN_YEAR
,      BALANCE_TYPE_CODE
,      DOWN_PAYMENT_AMOUNT
,      ORIG_CONTRACT_LINE_ID
,      AMOUNT#1
FROM OKL.OKL_SIF_FEES;

Dependencies

[top of page]

OKL.OKL_SIF_FEES does not reference any database object

OKL.OKL_SIF_FEES is referenced by following:

OKL: OKL_SIF_FEES#