[Home] [Help] [Dependency Information]
Object Name: | OKL_PAYMENTS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_NUMBER_OLD | VARCHAR2 | (30) | Yes | |
LINE_NUMBER | NUMBER | |||
ASSET_NUMBER | VARCHAR2 | (15) | ||
PAYMENT_TYPE_CODE | VARCHAR2 | (150) | ||
PAYMENT_SCHEDULE_NUMBER | NUMBER | |||
PAYMENT_FREQUENCY_CODE | VARCHAR2 | (30) | ||
ARREARS_FLAG | VARCHAR2 | (1) | ||
ADVANCE_PAYMENTS | NUMBER | |||
PAYMENT_AMOUNT | NUMBER | |||
START_DATE | DATE | |||
NUMBER_OF_PERIODS | NUMBER | |||
RATE | NUMBER | |||
COMMENTS | VARCHAR2 | (50) | ||
STUB_DAYS | NUMBER | |||
STUB_AMOUNT | NUMBER | |||
STREAM_PURPOSE_CODE | VARCHAR2 | (35) |
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#;
|
|
|