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

TABLE: LNS.LNS_LOAN_CANCEL_DETAILS

Object Details
Object Name: LNS_LOAN_CANCEL_DETAILS
Object Type: TABLE
Owner: LNS
Subobject Name:
Status: VALID


Table for loan cancellation details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOAN_CANCEL_DETAIL_ID NUMBER (15) Yes Identifies the Invoice for Loan Cancelation Request
LOAN_CANCELLATION_ID NUMBER (15) Yes Identifies the Loan Cancelation Request
LOAN_ID NUMBER (15) Yes Identifies the Loan
PURPOSE_CODE VARCHAR2 (30)
Invoice Purpose Code: PRIN, INT, FEE
PURPOSE_DESC VARCHAR2 (256)
Description of Invoice Purpose Code
AMOUNT_DUE NUMBER

Amount due for this invoice. Calculated and verified by the system
PERCENT_TO_PROCESS NUMBER

Billing/adjustment/credit amount that will be processed during loan cancellation
AMOUNT_TO_PROCESS NUMBER

Percent of AMOUNT_DUE that will be processed during loan cancellation
DUE_DATE DATE

Invoice due date
BILLED_FLAG VARCHAR2 (1)
Billed Invoice Flag: N, Y
ACTION VARCHAR2 (30)
Action after final billing: ADJUST, CREDIT
LOAN_LINE_ID NUMBER

Identifies the Loan Line ID. Set only for ERS loans
PAYMENT_SCHEDULE_ID NUMBER

Identifies the Payment schedule ID for already billed invoices and original ERS invoices
CUST_TRX_ID NUMBER

Identifies the trx ID for for already billed invoices and original ERS invoices
ADJUSTMENT_NUMBER VARCHAR2 (20)
Adjustment number for adjusted original invoices. Set only for ERS loans
ADJUSTMENT_ID NUMBER

Adjustment ID for adjusted original invoices. Set only for ERS loans
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER (15) Yes Created By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER (15) Yes Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
INVOICE_NUMBER VARCHAR2 (60)
Invoice Number
INSTALLMENT_NUMBER NUMBER

Installment Number
TRANSACTION_TYPE VARCHAR2 (100)
Transaction Type
GL_DATE DATE

Gl Date
TRX_DATE DATE

Trx Date
Query Text

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


SELECT LOAN_CANCEL_DETAIL_ID
,      LOAN_CANCELLATION_ID
,      LOAN_ID
,      PURPOSE_CODE
,      PURPOSE_DESC
,      AMOUNT_DUE
,      PERCENT_TO_PROCESS
,      AMOUNT_TO_PROCESS
,      DUE_DATE
,      BILLED_FLAG
,      ACTION
,      LOAN_LINE_ID
,      PAYMENT_SCHEDULE_ID
,      CUST_TRX_ID
,      ADJUSTMENT_NUMBER
,      ADJUSTMENT_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INVOICE_NUMBER
,      INSTALLMENT_NUMBER
,      TRANSACTION_TYPE
,      GL_DATE
,      TRX_DATE
FROM LNS.LNS_LOAN_CANCEL_DETAILS;

Dependencies

[top of page]

LNS.LNS_LOAN_CANCEL_DETAILS does not reference any database object

LNS.LNS_LOAN_CANCEL_DETAILS is referenced by following:

SchemaLNS
ViewLNS_LOAN_CANCEL_DETAILS#