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

TABLE: OKL.OKL_PAYMENTS_INTERFACE

Object Details
Object Name: OKL_PAYMENTS_INTERFACE
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_PAYMENTS_INTERFACE
Subobject Name:
Status: VALID


OKL_PAYMENTS_INTERFACE stores contract payment information that you create or load for import. There are multiple rows of payments for each contract you import.
The payments are assigned to contract header or line depending on values you have provided at contract number old, line number and asset number column in OKL_PAYMENTS_INTERFACE table.
Scope: public
Product: OKL
Display Name: OKL Contract Payment Open Interface
Category: BUSINESS_ENTITY OKL_CONTRACT
Lifecycle: active


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_PAYMENTS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCONTRACT_NUMBER_OLD
Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER_OLD VARCHAR2 (30) Yes Legacy Contract number. Used to link payment records with imported contract
LINE_NUMBER NUMBER

Line number
ASSET_NUMBER VARCHAR2 (15)
Asset number
PAYMENT_TYPE_CODE VARCHAR2 (150)
Stream type for payment. Validated against okl_strmtyp_source_v.name
PAYMENT_SCHEDULE_NUMBER NUMBER

Unique sequence number for payment records
PAYMENT_FREQUENCY_CODE VARCHAR2 (30)
Periodicity of payments expressed as units of Time unit of measure. Validated against OKL_TIME_UNITS_V.NAME
ARREARS_FLAG VARCHAR2 (1)
'Y' if payment due in arrears, else null or 'N' in advance for the period
ADVANCE_PAYMENTS NUMBER

Number of advance payments
PAYMENT_AMOUNT NUMBER

Payment amount
START_DATE DATE

Start date
NUMBER_OF_PERIODS NUMBER

Number of periods
RATE NUMBER

Rate
COMMENTS VARCHAR2 (50)
User entered comments
STUB_DAYS NUMBER

Stub days
STUB_AMOUNT NUMBER

Stub payment amount
STREAM_PURPOSE_CODE VARCHAR2 (35)
The purpose code of the stream (payment) type
Query Text

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


SELECT CONTRACT_NUMBER_OLD
,      LINE_NUMBER
,      ASSET_NUMBER
,      PAYMENT_TYPE_CODE
,      PAYMENT_SCHEDULE_NUMBER
,      PAYMENT_FREQUENCY_CODE
,      ARREARS_FLAG
,      ADVANCE_PAYMENTS
,      PAYMENT_AMOUNT
,      START_DATE
,      NUMBER_OF_PERIODS
,      RATE
,      COMMENTS
,      STUB_DAYS
,      STUB_AMOUNT
,      STREAM_PURPOSE_CODE
FROM OKL.OKL_PAYMENTS_INTERFACE;

Dependencies

[top of page]

OKL.OKL_PAYMENTS_INTERFACE does not reference any database object

OKL.OKL_PAYMENTS_INTERFACE is referenced by following:

SchemaOKL
ViewOKL_PAYMENTS_INTERFACE#