[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_AM_SCHEDS_DTL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  LNS.LNS_AM_SCHEDS_DTL_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Amortization Schedule Details View
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOAN_ID | NUMBER | (15) | Yes | Identifies the Loan |
| AMORTIZATION_SCHEDULE_ID | NUMBER | (15) | Yes | Identifies the Amortization Schedule |
| PAYMENT_NUMBER | NUMBER | Payment Number | ||
| DUE_DATE | DATE | Due Date | ||
| PRINCIPAL_AMOUNT | NUMBER | Billed Principal Amount | ||
| INTEREST_AMOUNT | NUMBER | Billed Interest Amount | ||
| FEE_AMOUNT | NUMBER | Billed Fee Amount | ||
| PRIN_CASH | NUMBER | Principal Paid in Cash | ||
| PRIN_LOAN_PMT_CREDIT | NUMBER | Principal Paid as Credit Memo | ||
| PRIN_NET_CREDIT | NUMBER | Principal Paid as Netting Credit Memo | ||
| PRIN_OTHER_CREDIT | NUMBER | Other Credit Memos on Principal | ||
| PRIN_CREDIT | NUMBER | Credit Memos on Principal | ||
| PRIN_ADJ | NUMBER | Adjustements on Principal | ||
| INT_CASH | NUMBER | Interest Paid in Cash | ||
| INT_LOAN_PMT_CREDIT | NUMBER | Interest Paid as Credit Memo | ||
| INT_NET_CREDIT | NUMBER | Interest Paid as Netting Credit Memo | ||
| INT_OTHER_CREDIT | NUMBER | Other Credit Memos on Interest | ||
| INT_CREDIT | NUMBER | Credit Memos on Interest | ||
| INT_ADJ | NUMBER | Adjustements on Interest | ||
| FEE_CASH | NUMBER | Fee Paid in Cash | ||
| FEE_LOAN_PMT_CREDIT | NUMBER | Fee Paid as Credit Memo | ||
| FEE_NET_CREDIT | NUMBER | Fee Paid as Netting Credit Memo | ||
| FEE_OTHER_CREDIT | NUMBER | Other Credit Memos on Fee | ||
| FEE_CREDIT | NUMBER | Credit Memos on Fee | ||
| FEE_ADJ | NUMBER | Adjustements on Fee | ||
| TOTAL_BILLED_AMOUNT | NUMBER | Total Billed Amount | ||
| REVERSED_CODE | VARCHAR2 | (1) | Reversed Code | |
| BILL_TYPE_CODE | VARCHAR2 | (9) | Bill Type Code | |
| BILL_TYPE_DESC | VARCHAR2 | (80) | Yes | Bill Type Description |
| PRINCIPAL_REMAINING | NUMBER | Principal Remaining Amount | ||
| INTEREST_REMAINING | NUMBER | Interest Remaining Amount | ||
| FEE_REMAINING | NUMBER | Fee Remaining Amount | ||
| PHASE | VARCHAR2 | (30) | Phase |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_ID
, AMORTIZATION_SCHEDULE_ID
, PAYMENT_NUMBER
, DUE_DATE
, PRINCIPAL_AMOUNT
, INTEREST_AMOUNT
, FEE_AMOUNT
, PRIN_CASH
, PRIN_LOAN_PMT_CREDIT
, PRIN_NET_CREDIT
, PRIN_OTHER_CREDIT
, PRIN_CREDIT
, PRIN_ADJ
, INT_CASH
, INT_LOAN_PMT_CREDIT
, INT_NET_CREDIT
, INT_OTHER_CREDIT
, INT_CREDIT
, INT_ADJ
, FEE_CASH
, FEE_LOAN_PMT_CREDIT
, FEE_NET_CREDIT
, FEE_OTHER_CREDIT
, FEE_CREDIT
, FEE_ADJ
, TOTAL_BILLED_AMOUNT
, REVERSED_CODE
, BILL_TYPE_CODE
, BILL_TYPE_DESC
, PRINCIPAL_REMAINING
, INTEREST_REMAINING
, FEE_REMAINING
, PHASE
FROM APPS.LNS_AM_SCHEDS_DTL_V;
APPS
AR_PAYMENT_SCHEDULES_ALL
FND_GLOBAL
- show dependent code
LNS_AMORTIZATION_SCHEDS
LNS_LOAN_HEADERS_ALL
LNS_LOOKUPS
APPS.LNS_AM_SCHEDS_DTL_V is not referenced by any database object
|
|
|
|