[Home] [Help] [Dependency Information]
Object Name: | OKL_STREAM_INTERFACES |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_STREAM_INTERFACES |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_SIF_U2 | NORMAL | UNIQUE | APPS_TS_NOLOGGING | TRANSACTION_NUMBER |
OKL_SIF_U1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
FASB_ACCT_TREATMENT_METHOD | VARCHAR2 | (30) | Yes | Lease classification for book |
IRS_TAX_TREATMENT_METHOD | VARCHAR2 | (30) | Yes | Tax lease or conditional sale |
SIF_MODE | VARCHAR2 | (30) | Mode of the external pricing engine. | |
DATE_DELIVERY | DATE | Yes | Earliest delivery date of all assets | |
TOTAL_FUNDING | NUMBER | (14) | Total funding amount for the loan | |
SECURITY_DEPOSIT_AMOUNT | NUMBER | (14) | Amount of sec dep | |
SIS_CODE | VARCHAR2 | (30) | Yes | Transaction status. |
KHR_ID | NUMBER | Yes | Foreign key to table OKL_K_HEADERS | |
PRICING_TEMPLATE_NAME | VARCHAR2 | (150) | Yes | Name of the Pricing Template |
DATE_PROCESSED | DATE | Yes | Processing date. | |
DATE_SEC_DEPOSIT_COLLECTED | DATE | Date of sec dep or start date of contract | ||
DATE_PAYMENTS_COMMENCEMENT | DATE | Yes | Start date for contract | |
TRANSACTION_NUMBER | NUMBER | Yes | order or sequence within "parent" | |
COUNTRY | VARCHAR2 | (150) | Yes | asset location |
IMPLICIT_INTEREST_RATE | NUMBER | (18) | Implicit interest rate. | |
ADJUST | VARCHAR2 | (80) | The object that can be adjusted for a desired yield e.g. FEES, RENT etc. | |
ADJUSTMENT_METHOD | VARCHAR2 | (80) | Adjustment Method | |
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. |
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. | |
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 | ||
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. | |
TERM | NUMBER | Term of the contract. | ||
STRUCTURE | VARCHAR2 | (200) | Payment structure at the contract level. | |
DEAL_TYPE | VARCHAR2 | (200) | Deal type of the contract. | |
LOG_FILE | VARCHAR2 | (200) | Log file name for a transaction. | |
FIRST_PAYMENT | VARCHAR2 | (200) | Not in use. | |
LAST_PAYMENT | VARCHAR2 | (200) | Not in use. | |
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. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
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 ID
, OBJECT_VERSION_NUMBER
, FASB_ACCT_TREATMENT_METHOD
, IRS_TAX_TREATMENT_METHOD
, SIF_MODE
, DATE_DELIVERY
, TOTAL_FUNDING
, SECURITY_DEPOSIT_AMOUNT
, SIS_CODE
, KHR_ID
, PRICING_TEMPLATE_NAME
, DATE_PROCESSED
, DATE_SEC_DEPOSIT_COLLECTED
, DATE_PAYMENTS_COMMENCEMENT
, TRANSACTION_NUMBER
, COUNTRY
, IMPLICIT_INTEREST_RATE
, ADJUST
, ADJUSTMENT_METHOD
, ORP_CODE
, LENDING_RATE
, RVI_YN
, RVI_RATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, JTOT_OBJECT1_CODE
, OBJECT1_ID1
, OBJECT1_ID2
, TERM
, STRUCTURE
, DEAL_TYPE
, LOG_FILE
, FIRST_PAYMENT
, LAST_PAYMENT
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PURPOSE_CODE
, SIF_ID
FROM OKL.OKL_STREAM_INTERFACES;
OKL.OKL_STREAM_INTERFACES does not reference any database object
OKL.OKL_STREAM_INTERFACES is referenced by following:
|
|
|