eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKL.OKL_TERMS_INTERFACE

Object Details

Object Name:	OKL_TERMS_INTERFACE
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TERMS_INTERFACE
Subobject Name:
Status:	VALID

OKL_TERMS_INTERFACE stores line level terms rules. This information is used to create rules at contract line level during Lease contract open interface import.
Scope: public
Product: OKL
Display Name: OKL Contract Terms Open Interface
Category: BUSINESS_ENTITY OKL_CONTRACT
Lifecycle: active

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TERMS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_NUMBER_OLD

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_NUMBER_OLD	VARCHAR2	(30)	Yes	Legacy contract number. Used to link terms rules records with imported contract.
LINE_NUMBER	NUMBER			Line number
BILL_TO_ADDRESS_ID	NUMBER			Customer billing address ID. Validated against OKX_CUST_SITE_USES_V.ID1.
BILL_TO_ADDRESS	VARCHAR2	(240)		Customer Billing address. Validated against OKX_CUST_SITE_USES_V.NAME.
BANK_ACCOUNT_ID	NUMBER			Customer bank account ID. Validated against OKX_RCPT_METHOD_ACCOUNTS_V.ID1.
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)		Customer bank account number. Validated against OKX_RCPT_METHOD_ACCOUNTS_V.BANK_ACCOUNT_NUM.
REASON_FOR_INVOICE_REVIEW	VARCHAR2	(50)		Reason for invoice review.
INVOICE_REVIEW_UNTIL_DATE	DATE			Invoice review until date.
INVOICE_FORMAT_ID	NUMBER			Invoice format ID. Validated against OKL_INVOICE_FORMATS_V.ID.
INVOICE_FORMAT_CODE	VARCHAR2	(150)		Invoice format Code. Validated against OKL_INVOICE_FORMATS_V.NAME.
REVIEW_INVOICE_FLAG	VARCHAR2	(1)		Invoice review flag. Valid values are 'Y' or 'N'.
PAYMENT_METHOD_ID	NUMBER			Payment method ID. Validated against OKX_RECEIPT_METHODS_V.ID1.
PAYMENT_METHOD	VARCHAR2	(30)		Payment method. Validated against OKX_RECEIPT_METHODS_V.NAME.
PRESCRIBED_ASSET_FLAG	VARCHAR2	(1)		Prescribed asset flag for line.
SCREEN_SECTION_NAME	VARCHAR2	(70)		For future use only.
SCREEN_FIELD_LABEL	VARCHAR2	(70)		For future use only.
SCREEN_FIELD_VALUE	VARCHAR2	(450)		For future use only.
CASH_APPL_RULE_NAME	VARCHAR2	(150)		Cash Application Rule Name for the asset.

Query Text

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


SELECT CONTRACT_NUMBER_OLD
,      LINE_NUMBER
,      BILL_TO_ADDRESS_ID
,      BILL_TO_ADDRESS
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NUMBER
,      REASON_FOR_INVOICE_REVIEW
,      INVOICE_REVIEW_UNTIL_DATE
,      INVOICE_FORMAT_ID
,      INVOICE_FORMAT_CODE
,      REVIEW_INVOICE_FLAG
,      PAYMENT_METHOD_ID
,      PAYMENT_METHOD
,      PRESCRIBED_ASSET_FLAG
,      SCREEN_SECTION_NAME
,      SCREEN_FIELD_LABEL
,      SCREEN_FIELD_VALUE
,      CASH_APPL_RULE_NAME
FROM OKL.OKL_TERMS_INTERFACE;

Dependencies

[top of page]

OKL.OKL_TERMS_INTERFACE does not reference any database object

OKL.OKL_TERMS_INTERFACE is referenced by following:

OKL: OKL_TERMS_INTERFACE#