[Home] [Help] [Dependency Information]
Object Name: | LNS_LOAN_HEADERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | LNS |
FND Design Data: | LNS.LNS_LOAN_HEADERS_ALL |
Subobject Name: | |
Status: | VALID |
Loans Header Table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LNS_LOAN_HEADERS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LOAN_ID |
LNS_LOAN_HEADERS_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LOAN_NUMBER |
LNS_LOAN_HEADERS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUST_ACCOUNT_ID |
LNS_LOAN_HEADERS_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRIMARY_BORROWER_ID |
LNS_LOAN_HEADERS_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOAN_STATUS |
LNS_LOAN_HEADERS_ALL_N4 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("LOAN_DESCRIPTION") |
LNS_LOAN_HEADERS_ALL_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEGAL_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_ID | NUMBER | (15) | Yes | Loan identifier |
LOAN_NUMBER | VARCHAR2 | (60) | Yes | Unique identification number for the loan |
LOAN_DESCRIPTION | VARCHAR2 | (250) | Description of the loan | |
INITIAL_LOAN_BALANCE | NUMBER | Yes | Initial loan balance | |
LAST_PAYMENT_DATE | DATE | Last payment date | ||
LAST_PAYMENT_AMOUNT | NUMBER | Last payment amount | ||
LOAN_TERM | NUMBER | Yes | Loan term | |
LOAN_TERM_PERIOD | VARCHAR2 | (30) | Yes | Loan term period. Lookup type is PERIOD |
LOAN_CURRENCY | VARCHAR2 | (15) | Yes | Loan currency code (foreign key to FND_CURRENCIES.CURRENCY_CODE) |
LOAN_CLASS_CODE | VARCHAR2 | (30) | Loan class code. Lookup type is LOAN_CLASS | |
LOAN_TYPE | VARCHAR2 | (30) | Loan type code. Lookup Type is LOAN_TYPE | |
LOAN_SUBTYPE | VARCHAR2 | (30) | Loan subtype code. Lookup type is LOAN_SUBTYPE | |
LOAN_PURPOSE_CODE | VARCHAR2 | (30) | Loan purpose code. Lookup type is LOAN_PURPOSE | |
AMORTIZED_TERM | NUMBER | Amortized term of the loan | ||
AMORTIZED_TERM_PERIOD | VARCHAR2 | (30) | Amortized term period. Lookup type is PERIOD | |
LOAN_MATURITY_DATE | DATE | Loan maturity date | ||
LOAN_START_DATE | DATE | Yes | Loan start date | |
LOAN_APPLICATION_DATE | DATE | Yes | Loan application date | |
LOAN_CLOSING_DATE | DATE | Loan closing date | ||
LAST_BILLED_DATE | DATE | Last billed date | ||
END_DATE | DATE | End date for the loan. The loan is end-dated on deletion. | ||
PRODUCT_FLAG | VARCHAR2 | (1) | Product flag. This specifies if this row is considered a template product instead of a regular loan. | |
CUST_ACCOUNT_ID | NUMBER | (15) | Customer account identifier for the primary borrower of this loan (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID). This value is denormalized from LNS_PARTICIPANTS.CUST_ACCOUNT_ID | |
PRIMARY_BORROWER_ID | NUMBER | (15) | Party identifier for the primary borrower of this loan (foreign key to HZ_PARTIES.PARTY_ID). This value is denormalized from LNS_PARTICIPANTS.HZ_PARTY_ID | |
PRODUCT_ID | NUMBER | (15) | Product identifier for this loan if created from a template product (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID for the corresponding product row) | |
REQUESTED_AMOUNT | NUMBER | Yes | Loan requested amount | |
FUNDED_AMOUNT | NUMBER | Loan funded amount | ||
REFERENCE_AMOUNT | NUMBER | When REFERENCE_TYPE='RECEIVABLE', this amount refers to the remaining outstanding receivable amount when this loan is created from an invoice. | ||
REFERENCE_NUMBER | VARCHAR2 | (60) | When REFERENCE_TYPE='RECEIVABLE', this refers to invoice number of the outstanding receivable that is used for creating this loan. | |
REFERENCE_NAME | VARCHAR2 | (60) | Reference name | |
REFERENCE_TYPE | VARCHAR2 | (30) | Reference type. If the values is 'RECEIVABLE', it indicates whether this loan is created from an outstanding receivable. | |
REFERENCE_DESCRIPTION | VARCHAR2 | (250) | User entered Reference/Cost Report FYE | |
LOAN_APPROVAL_DATE | DATE | Loan approval date | ||
LOAN_APPROVED_BY | NUMBER | Identifier for the user who approved this loan (foreign key to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID) | ||
LOAN_STATUS | VARCHAR2 | (30) | Yes | Loan status code. Lookup type is LOAN_STATUS |
LOAN_ASSIGNED_TO | NUMBER | Identifier for the user who is assigned to this loan (foreign key to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID) | ||
REFERENCE_ID | NUMBER | (15) | When REFERENCE_TYPE='RECEIVABLE', this refers to the transaction identifier of the outstanding receivable that is used for creating this loan (foreign key to RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID). | |
CUSTOM_PAYMENTS_FLAG | VARCHAR2 | (1) | Flag to indicate if this loan has a customized amortization schedule. | |
BILLED_FLAG | VARCHAR2 | (1) | Flag to indicate if the loan has been billed | |
ORG_ID | NUMBER | (15) | Yes | Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID) |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Not currently used | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID) | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID) | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes | |
GL_DATE | DATE | GL date | ||
REFERENCE_TYPE_ID | NUMBER | (15) | The transaction type identifier that will be used for billing the loan (foreign key to RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID). | |
BILL_TO_ACCT_SITE_ID | NUMBER | (15) | Customer account billing site identifier for the primary borrower of the loan (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID). This value is denormalized from LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID | |
REC_ADJUSTMENT_NUMBER | VARCHAR2 | (20) | Adjustment Number for Loans Original Receivable | |
CONTACT_PERS_PARTY_ID | NUMBER | (15) | Identifier for Loan Contact Person Party | |
CONTACT_REL_PARTY_ID | NUMBER | (15) | Identifier for Loan Primary Contact Relationship Party | |
COLLATERAL_PERCENT | NUMBER | This column defines the required collateral loan-to-value ratio for secured loan as a percentage of the loan amount | ||
CREDIT_REVIEW_FLAG | VARCHAR2 | (1) | Indicates if credit review is needed for this loan. | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type. Required if loan currency different from functional accounting currency | |
EXCHANGE_DATE | DATE | Date of the exchange rate. Required if loan currency different from functional accounting currency | ||
EXCHANGE_RATE | NUMBER | Exchange rate. Required if loan currency different from functional accounting currency | ||
LAST_PAYMENT_NUMBER | NUMBER | This column defines the last billed payment number | ||
LAST_AMORTIZATION_ID | NUMBER | This column defines the last billed amortization schedule | ||
LEGAL_ENTITY_ID | NUMBER | (15) | This Column Stores the Legal Entity Identifier | |
OPEN_TO_TERM_FLAG | VARCHAR2 | (1) | Indicates whether or not the loan can be converted to TERM loan | |
MULTIPLE_FUNDING_FLAG | VARCHAR2 | (1) | Indicates whether or not loan disbursements can be one or many | |
LOAN_TYPE_ID | NUMBER | (15) | FK to LNS_LOAN_TYPES | |
SECONDARY_STATUS | VARCHAR2 | (30) | Secondary Loan Status | |
OPEN_TO_TERM_EVENT | VARCHAR2 | (30) | Open To Term Event | |
BALLOON_PAYMENT_TYPE | VARCHAR2 | (30) | Balloon Payment Type | |
BALLOON_PAYMENT_AMOUNT | NUMBER | Balloon Payment Amount | ||
OPEN_LOAN_START_DATE | DATE | Loan Start Date for the Open Phase | ||
OPEN_LOAN_TERM | NUMBER | Loan Term for the Open Phase | ||
OPEN_LOAN_TERM_PERIOD | VARCHAR2 | (30) | Loan Term Period for Open Phase | |
CURRENT_PHASE | VARCHAR2 | (30) | Denotes the Current Phase of the loan. Contains values OPEN or TERM to denote Open-ended phase versus regular Term phase of the loan. | |
OPEN_MATURITY_DATE | DATE | Open Maturity Date | ||
FUNDS_RESERVED_FLAG | VARCHAR2 | (1) | Funds Reserved Flag | |
FUNDS_CHECK_DATE | DATE | Last Funds Check Date | ||
SUBSIDY_RATE | NUMBER | Subsidy Rate | ||
APPLICATION_ID | NUMBER | (15) | FK to FND_APPLICATION | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Created By Module | |
PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column | |
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 | |
FORGIVENESS_FLAG | VARCHAR2 | (1) | Identifies whether the loan is enabled for forgiveness | |
FORGIVENESS_PERCENT | NUMBER | This column defines the required forgiveness loanEMIPrincipal-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI Principal | ||
DISABLE_BILLING_FLAG | VARCHAR2 | (1) | Identifies whether the billing of a loan is disabled | |
ADD_REQUESTED_AMOUNT | NUMBER | Additional Requested Amount | ||
DISABLE_INT_ACCRUAL_FLAG | VARCHAR2 | (1) | Identifies whether the accrual of a loan is disabled | |
BILL_ON_APPR_AMOUNT_FLAG | VARCHAR2 | (1) | Service Based On Approved Amounts |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_ID
, LOAN_NUMBER
, LOAN_DESCRIPTION
, INITIAL_LOAN_BALANCE
, LAST_PAYMENT_DATE
, LAST_PAYMENT_AMOUNT
, LOAN_TERM
, LOAN_TERM_PERIOD
, LOAN_CURRENCY
, LOAN_CLASS_CODE
, LOAN_TYPE
, LOAN_SUBTYPE
, LOAN_PURPOSE_CODE
, AMORTIZED_TERM
, AMORTIZED_TERM_PERIOD
, LOAN_MATURITY_DATE
, LOAN_START_DATE
, LOAN_APPLICATION_DATE
, LOAN_CLOSING_DATE
, LAST_BILLED_DATE
, END_DATE
, PRODUCT_FLAG
, CUST_ACCOUNT_ID
, PRIMARY_BORROWER_ID
, PRODUCT_ID
, REQUESTED_AMOUNT
, FUNDED_AMOUNT
, REFERENCE_AMOUNT
, REFERENCE_NUMBER
, REFERENCE_NAME
, REFERENCE_TYPE
, REFERENCE_DESCRIPTION
, LOAN_APPROVAL_DATE
, LOAN_APPROVED_BY
, LOAN_STATUS
, LOAN_ASSIGNED_TO
, REFERENCE_ID
, CUSTOM_PAYMENTS_FLAG
, BILLED_FLAG
, ORG_ID
, USSGL_TRANSACTION_CODE
, REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, PROGRAM_ID
, OBJECT_VERSION_NUMBER
, GL_DATE
, REFERENCE_TYPE_ID
, BILL_TO_ACCT_SITE_ID
, REC_ADJUSTMENT_NUMBER
, CONTACT_PERS_PARTY_ID
, CONTACT_REL_PARTY_ID
, COLLATERAL_PERCENT
, CREDIT_REVIEW_FLAG
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, EXCHANGE_RATE
, LAST_PAYMENT_NUMBER
, LAST_AMORTIZATION_ID
, LEGAL_ENTITY_ID
, OPEN_TO_TERM_FLAG
, MULTIPLE_FUNDING_FLAG
, LOAN_TYPE_ID
, SECONDARY_STATUS
, OPEN_TO_TERM_EVENT
, BALLOON_PAYMENT_TYPE
, BALLOON_PAYMENT_AMOUNT
, OPEN_LOAN_START_DATE
, OPEN_LOAN_TERM
, OPEN_LOAN_TERM_PERIOD
, CURRENT_PHASE
, OPEN_MATURITY_DATE
, FUNDS_RESERVED_FLAG
, FUNDS_CHECK_DATE
, SUBSIDY_RATE
, APPLICATION_ID
, CREATED_BY_MODULE
, PARTY_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, FORGIVENESS_FLAG
, FORGIVENESS_PERCENT
, DISABLE_BILLING_FLAG
, ADD_REQUESTED_AMOUNT
, DISABLE_INT_ACCRUAL_FLAG
, BILL_ON_APPR_AMOUNT_FLAG
FROM LNS.LNS_LOAN_HEADERS_ALL;
LNS.LNS_LOAN_HEADERS_ALL does not reference any database object
LNS.LNS_LOAN_HEADERS_ALL is referenced by following:
|
|
|