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: TableOKL.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_TERMS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTRACT_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:

SchemaAPPS
SynonymOKL_TERMS_INTERFACE