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: TableLNS.LNS_SYSTEM_OPTIONS_ALL
Subobject Name:
Status: VALID


Loans System Options Table


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
LNS_SYSTEM_OPTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSYSTEM_OPTION_ID
LNS_SYSTEM_OPTIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnORG_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
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
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:

SchemaAPPS
SynonymLNS_SYSTEM_OPTIONS
SynonymLNS_SYSTEM_OPTIONS_ALL