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: LNS.LNS_SYSTEM_OPTIONS_ALL

Object Details

Object Name:	LNS_SYSTEM_OPTIONS_ALL
Object Type:	TABLE
Owner:	LNS
FND Design Data:	LNS.LNS_SYSTEM_OPTIONS_ALL
Subobject Name:
Status:	VALID

Loans System Options Table

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_SYSTEM_OPTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	SYSTEM_OPTION_ID
LNS_SYSTEM_OPTIONS_U2	NORMAL	UNIQUE	APPS_TS_SEED	ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SYSTEM_OPTION_ID	NUMBER	(15)	Yes	System option identifier
ORG_ID	NUMBER	(15)	Yes	Organization identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books
COMBINE_INT_PRIN_FLAG	VARCHAR2	(1)	Yes	Identifies if billing engine should create either one invoice or multiple invoices
PAYMENT_APPLICATION_ORDER	VARCHAR2	(30)		Default order in which invoices are created in AR
RATE_ROUNDING	NUMBER			Default rounding rate used by financial calculation engine
PAYMENT_AMOUNT_ROUNDING	NUMBER			Default payment amount rounding rules
PAYMENT_AMOUNT_ROUNDING_TYPE	VARCHAR2	(10)		Default payment amount rounding type
GL_ACCT_REVENUE_INTEREST	NUMBER			Default General Ledger account for interest revenue
GL_ACCT_REVENUE_PRINCIPAL	NUMBER			Default General Ledger account for principal revenue
GL_ACCT_REVENUE_OTHER	NUMBER			Default General Ledger account for other revenue
DAY_COUNT_METHOD	VARCHAR2	(30)		Default days calculation method used by financial calculations engine
COMPOUNDING_FREQUENCY	VARCHAR2	(30)		Default compounding frequency
LOAN_PAYMENT_FREQUENCY	VARCHAR2	(30)		Default loan payment frequency
PAYMENT_IN_ARREARS_FLAG	VARCHAR2	(1)		Indicates if payment is past due
PREPAY_PENALTY_FLAG	VARCHAR2	(1)		Indicates default prepayment penalty
PREPAY_FEE_ID	NUMBER	(15)		Default prepayment fee identifier
LATE_FEE_ID	NUMBER			Default late fee identifier
SERVICING_FEE_ID	NUMBER	(15)		Default servicing fee identifier
DELINQUENCY_THRESHOLD_NUMBER	NUMBER			Default delinquency threshold number
DELINQUENCY_THRESHOLD_AMOUNT	NUMBER			Default delinquency threshold amount
CALCULATION_METHOD	VARCHAR2	(30)		Default calculation method
ORIGINAL_TERM	NUMBER			Default term
ORIGINAL_TERM_TYPE	VARCHAR2	(30)		Default term type
LOAN_CURRENCY	VARCHAR2	(15)		Default loan currency
LOAN_CLASS_CODE	VARCHAR2	(30)		Default loan class
LOAN_TYPE	VARCHAR2	(30)		Default loan type
LOAN_SUBTYPE	VARCHAR2	(30)		Default loan subtype
BATCH_SOURCE_ID	NUMBER	(15)	Yes	Default batch source
DAYS_TOBILL_BEFORE_DUE_DATE	NUMBER			Number of days before due date that billing engine will generate bill
DAYS_TOGL_AFTER_DUE_DATE	NUMBER			Number of days added to bill due date to calculate General Ledger date
TRX_TYPE_ID	NUMBER	(15)		Default principal transaction type
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure definition
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column. Foreign key to FND_USER.USER_ID
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column. Foreign key to FND_USER.USER_ID
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column. Foreign key to FND_LOGINS.LOGIN_ID
INTEREST_TRX_TYPE_ID	NUMBER	(15)		Default interest transaction type
FEE_TRX_TYPE_ID	NUMBER	(15)		Default fee transaction type
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
BILL_STMT_TEMPLATE_CODE	VARCHAR2	(80)		Default bill statement template code
RECEIVABLES_TRX_ID	NUMBER	(15)		Receivables activity ID
ADJUST_USSGL_TRX_CODE	VARCHAR2	(30)		USSGL Transaction Code for Adjusting Original Receivables
FORGIVENESS_REC_TRX_ID	NUMBER	(15)		Transaction ID used to identity the forgiveness transactions in loans
CANCELLATION_REC_TRX_ID	NUMBER	(15)		Loan Cancellation Request Transaction Id
RA_TERM_ID	NUMBER	(15)		RA payment term id

Query Text

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


SELECT SYSTEM_OPTION_ID
,      ORG_ID
,      SET_OF_BOOKS_ID
,      COMBINE_INT_PRIN_FLAG
,      PAYMENT_APPLICATION_ORDER
,      RATE_ROUNDING
,      PAYMENT_AMOUNT_ROUNDING
,      PAYMENT_AMOUNT_ROUNDING_TYPE
,      GL_ACCT_REVENUE_INTEREST
,      GL_ACCT_REVENUE_PRINCIPAL
,      GL_ACCT_REVENUE_OTHER
,      DAY_COUNT_METHOD
,      COMPOUNDING_FREQUENCY
,      LOAN_PAYMENT_FREQUENCY
,      PAYMENT_IN_ARREARS_FLAG
,      PREPAY_PENALTY_FLAG
,      PREPAY_FEE_ID
,      LATE_FEE_ID
,      SERVICING_FEE_ID
,      DELINQUENCY_THRESHOLD_NUMBER
,      DELINQUENCY_THRESHOLD_AMOUNT
,      CALCULATION_METHOD
,      ORIGINAL_TERM
,      ORIGINAL_TERM_TYPE
,      LOAN_CURRENCY
,      LOAN_CLASS_CODE
,      LOAN_TYPE
,      LOAN_SUBTYPE
,      BATCH_SOURCE_ID
,      DAYS_TOBILL_BEFORE_DUE_DATE
,      DAYS_TOGL_AFTER_DUE_DATE
,      TRX_TYPE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INTEREST_TRX_TYPE_ID
,      FEE_TRX_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      BILL_STMT_TEMPLATE_CODE
,      RECEIVABLES_TRX_ID
,      ADJUST_USSGL_TRX_CODE
,      FORGIVENESS_REC_TRX_ID
,      CANCELLATION_REC_TRX_ID
,      RA_TERM_ID
FROM LNS.LNS_SYSTEM_OPTIONS_ALL;

Dependencies

[top of page]

LNS.LNS_SYSTEM_OPTIONS_ALL does not reference any database object

LNS.LNS_SYSTEM_OPTIONS_ALL is referenced by following:

LNS: LNS_SYSTEM_OPTIONS_ALL#