[Home] [Help] [Dependency Information]
Object Name: | OKL_STREAM_INTERFACES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STREAM_INTERFACES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the stream interface header table. This is an interface table that holds the contract header
level details for external pricing. Reference to the contract is also stored here.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
FASB_ACCT_TREATMENT_METHOD | VARCHAR2 | (30) | Yes | Lease classification for book |
DATE_PAYMENTS_COMMENCEMENT | DATE | Yes | Start date for contract | |
COUNTRY | VARCHAR2 | (150) | Yes | asset location |
SECURITY_DEPOSIT_AMOUNT | NUMBER | (14) | Amount of sec dep | |
DATE_DELIVERY | DATE | Yes | Earliest delivery date of all assets | |
IRS_TAX_TREATMENT_METHOD | VARCHAR2 | (30) | Yes | Tax lease or conditional sale |
SIF_MODE | VARCHAR2 | (30) | Mode of the external pricing engine. | |
PRICING_TEMPLATE_NAME | VARCHAR2 | (150) | Yes | Name of the Pricing Template |
DATE_SEC_DEPOSIT_COLLECTED | DATE | Date of sec dep or start date of contract | ||
TRANSACTION_NUMBER | NUMBER | Yes | order or sequence within "parent" | |
TOTAL_FUNDING | NUMBER | (14) | Total funding amount for the loan | |
SIS_CODE | VARCHAR2 | (30) | Yes | Transaction status. |
KHR_ID | NUMBER | Yes | Foreign key to table OKL_K_HEADERS | |
ADJUST | VARCHAR2 | (80) | The object that can be adjusted for a desired yield e.g. FEES, RENT etc. | |
IMPLICIT_INTEREST_RATE | NUMBER | (18) | Implicit interest rate. | |
ADJUSTMENT_METHOD | VARCHAR2 | (80) | Adjustment Method | |
DATE_PROCESSED | DATE | Yes | Processing date. | |
ORP_CODE | VARCHAR2 | (30) | Yes | Lookup code to identify the contract process that created the transaction. Valid values are AUTH, QUOT, RSAM, RSCS, VIRP and RENW. |
REQUEST_ID | NUMBER | Concurrent Manager column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Manager column | ||
PROGRAM_ID | NUMBER | Concurrent Manager column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
TERM | NUMBER | Term of the contract. | ||
JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. | |
OBJECT1_ID1 | VARCHAR2 | (40) | Foreign key to an OKX view identified by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. | |
OBJECT1_ID2 | VARCHAR2 | (400) | Foreign key to an OKX view identified by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. | |
STRUCTURE | VARCHAR2 | (200) | Payment structure at the contract level. | |
LOG_FILE | VARCHAR2 | (200) | Log file name for a transaction. | |
DEAL_TYPE | VARCHAR2 | (200) | Deal type of the contract. | |
STREAM_INTERFACE_ATTRIBUTE01 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE02 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE03 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE04 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE05 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE06 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE07 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE08 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE09 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE10 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE11 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE12 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE13 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE14 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE15 | VARCHAR2 | (450) | Generic attribute for extensions. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
FIRST_PAYMENT | VARCHAR2 | (200) | Not in use. | |
LAST_PAYMENT | VARCHAR2 | (200) | Not in use. | |
LENDING_RATE | NUMBER | (18) | Lending rate for the loans. | |
RVI_YN | VARCHAR2 | (10) | Whether residual value insurance is present. | |
RVI_RATE | NUMBER | (18) | Residual value insurance rate. | |
PURPOSE_CODE | VARCHAR2 | (30) | Purpose of streams. Currently used for reporting. | |
SIF_ID | NUMBER | Foreign key to OKL_STREAM_INTERFACES. The streams created for MUlti-GAAP will have the value for this column. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, FASB_ACCT_TREATMENT_METHOD
, DATE_PAYMENTS_COMMENCEMENT
, COUNTRY
, SECURITY_DEPOSIT_AMOUNT
, DATE_DELIVERY
, IRS_TAX_TREATMENT_METHOD
, SIF_MODE
, PRICING_TEMPLATE_NAME
, DATE_SEC_DEPOSIT_COLLECTED
, TRANSACTION_NUMBER
, TOTAL_FUNDING
, SIS_CODE
, KHR_ID
, ADJUST
, IMPLICIT_INTEREST_RATE
, ADJUSTMENT_METHOD
, DATE_PROCESSED
, ORP_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TERM
, JTOT_OBJECT1_CODE
, OBJECT1_ID1
, OBJECT1_ID2
, STRUCTURE
, LOG_FILE
, DEAL_TYPE
, STREAM_INTERFACE_ATTRIBUTE01
, STREAM_INTERFACE_ATTRIBUTE02
, STREAM_INTERFACE_ATTRIBUTE03
, STREAM_INTERFACE_ATTRIBUTE04
, STREAM_INTERFACE_ATTRIBUTE05
, STREAM_INTERFACE_ATTRIBUTE06
, STREAM_INTERFACE_ATTRIBUTE07
, STREAM_INTERFACE_ATTRIBUTE08
, STREAM_INTERFACE_ATTRIBUTE09
, STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15
, OBJECT_VERSION_NUMBER
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FIRST_PAYMENT
, LAST_PAYMENT
, LENDING_RATE
, RVI_YN
, RVI_RATE
, PURPOSE_CODE
, SIF_ID
FROM APPS.OKL_STREAM_INTERFACES_V;
|
|
|