[Home] [Help] [Dependency Information]
Object Name: | LNS_INT_TRX_ACTIVITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Interest Transaction Activities View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_ID | NUMBER | (15) | Identifies the Loan | |
LOAN_AMORTIZATION_ID | NUMBER | Identifies the Amortization Schedule | ||
PAYMENT_NUMBER | NUMBER | Payment Number | ||
DUE_DATE | DATE | Due Date | ||
PRINCIPAL_DUE | NUMBER | Billed Principal Amount | ||
INTEREST_DUE | NUMBER | Billed Interest Amount | ||
FEE_DUE | NUMBER | Billed Fee Amount | ||
PARENT_AMORTIZATION_ID | NUMBER | Parent Amortization | ||
BILLED_CUSTOMER_TRX_ID | NUMBER | Billed Transaction | ||
BILLED_PAYMENT_SCHEDULE_ID | NUMBER | Billed Payment Schedule | ||
BILLED_TRX_NUMBER | VARCHAR2 | (20) | Billed Transaction Number | |
ACTIVITY_CODE | VARCHAR2 | (20) | Activity Code | |
ACTIVITY_AMOUNT | NUMBER | Activity Amount | ||
ACTIVITY_NUMBER | VARCHAR2 | (30) | Activity Number | |
ACTIVITY_DATE | DATE | Activity Date | ||
ACTUAL_BALANCE | NUMBER | Actual Balance | ||
THEORETICAL_BALANCE | NUMBER | Projected Balance | ||
DAYS_LATE | NUMBER | Days Late | ||
ORG_ID | NUMBER | (15) | Identifies the Org | |
DISPLAY_ORDER | NUMBER | Display Order | ||
INTEREST_RATE | NUMBER | Current Interest Rate |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_ID
, LOAN_AMORTIZATION_ID
, PAYMENT_NUMBER
, DUE_DATE
, PRINCIPAL_DUE
, INTEREST_DUE
, FEE_DUE
, PARENT_AMORTIZATION_ID
, BILLED_CUSTOMER_TRX_ID
, BILLED_PAYMENT_SCHEDULE_ID
, BILLED_TRX_NUMBER
, ACTIVITY_CODE
, ACTIVITY_AMOUNT
, ACTIVITY_NUMBER
, ACTIVITY_DATE
, ACTUAL_BALANCE
, THEORETICAL_BALANCE
, DAYS_LATE
, ORG_ID
, DISPLAY_ORDER
, INTEREST_RATE
FROM APPS.LNS_INT_TRX_ACTIVITIES_V;
|
|
|