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


VIEW: OKL.OKL_LINES_INTERFACE#

Object Details
Object Name: OKL_LINES_INTERFACE#
Object Type: VIEW
Owner: OKL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER_OLD VARCHAR2 (30) Yes
LINE_NUMBER NUMBER
Yes
LINE_TYPE VARCHAR2 (30) Yes
ASSET_NUMBER VARCHAR2 (15)
LINK_ASSET_NUMBER VARCHAR2 (15)
ORIGINAL_COST NUMBER

TOTAL_UNITS NUMBER

AMOUNT NUMBER

STATUS VARCHAR2 (40)
DATE_APPROVED DATE

DATE_SIGNED DATE

CURRENCY_CODE VARCHAR2 (3)
INVENTORY_ORGANIZATION_NAME VARCHAR2 (240)
INVENTORY_ORGANIZATION_ID NUMBER

INVENTORY_ITEM_NAME VARCHAR2 (1000)
INVENTORY_ITEM_ID NUMBER

DESCRIPTION VARCHAR2 (1995)
MODEL VARCHAR2 (40)
MAKE VARCHAR2 (360)
YEAR_OF_MANUFACTURE NUMBER

INSTALL_SITE_NUMBER VARCHAR2 (30)
INSTALL_SITE_ID NUMBER

RESIDUAL_PERCENT NUMBER

RESIDUAL_AMOUNT NUMBER

RESIDUAL_AMOUNT_GUARANTEE NUMBER

RESIDUAL_AMOUNT_GUARANTEE_PV NUMBER

GUARANTOR_TYPE_CODE VARCHAR2 (30)
TRADE_IN_AMOUNT NUMBER

CAPITAL_REDUCTION_PERCENT NUMBER

CAPITAL_REDUCTION_AMOUNT NUMBER

INTERIM_INT_CAPITALIZED_AMT NUMBER

ASSET_CORPORATE_BOOK VARCHAR2 (15)
ASSET_CATEGORY_SEGMENT1 VARCHAR2 (30)
ASSET_CATEGORY_SEGMENT2 VARCHAR2 (30)
ASSET_CATEGORY_SEGMENT3 VARCHAR2 (30)
ASSET_CATEGORY_SEGMENT4 VARCHAR2 (30)
ASSET_CATEGORY_SEGMENT5 VARCHAR2 (30)
ASSET_CATEGORY_SEGMENT6 VARCHAR2 (30)
ASSET_CATEGORY_SEGMENT7 VARCHAR2 (30)
ASSET_CATEGORY_ID NUMBER

ASSET_LOCATION_SEGMENT1 VARCHAR2 (30)
ASSET_LOCATION_SEGMENT2 VARCHAR2 (30)
ASSET_LOCATION_SEGMENT3 VARCHAR2 (30)
ASSET_LOCATION_SEGMENT4 VARCHAR2 (30)
ASSET_LOCATION_SEGMENT5 VARCHAR2 (30)
ASSET_LOCATION_SEGMENT6 VARCHAR2 (30)
ASSET_LOCATION_SEGMENT7 VARCHAR2 (30)
ASSET_LOCATION_ID NUMBER

DEPRECIATION_METHOD_ID NUMBER

DEPRECIATION_METHOD_CODE VARCHAR2 (12)
LIFE_IN_MONTHS NUMBER

DEPRECIATION_RATE NUMBER

SALVAGE_VALUE NUMBER

SALVAGE_VALUE_PERCENT NUMBER

SALES_TAX_EXEMPT_FLAG VARCHAR2 (1)
SALES_TAX_EXEMPT_CERT_NUMBER VARCHAR2 (50)
SALES_TAX_OVERRIDE_FLAG VARCHAR2 (1)
SALES_TAX_OVERRIDE_RATE NUMBER

VAT_TAX_EXEMPT VARCHAR2 (1)
VAT_TAX_EXEMPT_CERT_NUMBER VARCHAR2 (50)
VAT_TAX_OVERRIDE_FLAG VARCHAR2 (1)
VAT_TAX_OVERRIDE_RATE NUMBER

LIEN_TYPE VARCHAR2 (30)
LIEN_FILING_NUMBER VARCHAR2 (50)
LIEN_FILING_DATE DATE

LIEN_FILING_STATUS VARCHAR2 (30)
LIENHOLDER_ID NUMBER

LIENHOLDER_NUMBER VARCHAR2 (360)
FILING_JURISDICTION VARCHAR2 (50)
FILING_SUB_JURISDICTION VARCHAR2 (50)
LIEN_EXPIRATION_DATE DATE

LIEN_CONTINUATION_NUMBER VARCHAR2 (50)
LIEN_CONTINUATION_DATE DATE

TITLE_TYPE VARCHAR2 (30)
TITLE_ISSUER_NUMBER VARCHAR2 (60)
TITLE_ISSUER_ID NUMBER

TITLE_DATE DATE

TITLE_NUMBER VARCHAR2 (50)
REGISTRATION_NUMBER VARCHAR2 (150)
ASSET_REGISTRATION_LOC_NAME VARCHAR2 (50)
TITLE_CUSTODIAN_NAME VARCHAR2 (30)
PAYEE_SITE_NAME VARCHAR2 (240)
SERIAL_NUMBER VARCHAR2 (100)
VENDOR_INVOICE_NUMBER VARCHAR2 (30)
VENDOR_INVOICE_DATE DATE

SHIP_TO_SITE_NUMBER VARCHAR2 (240)
SHIP_TO_SITE_ID NUMBER

START_DATE DATE

END_DATE DATE

PASSTHROUGH_PERCENT NUMBER

PASSTHROUGH_BASIS_CODE VARCHAR2 (30)
FEE_CODE VARCHAR2 (150)
USAGE_ITEM_NAME VARCHAR2 (1000)
USAGE_ITEM_ID NUMBER

PRICE_LIST_NAME VARCHAR2 (240)
PRICE_LIST_ID NUMBER

COUNTER_GROUP_NAME VARCHAR2 (30)
COUNTER_GROUP_ID NUMBER

USAGE_BILL_FREQUENCY_CODE VARCHAR2 (30)
MINIMUM_QTY_USAGE NUMBER

DEFAULT_QTY_USAGE NUMBER

AMCV_FLAG VARCHAR2 (1)
LEVEL_FLAG VARCHAR2 (1)
BASE_READING NUMBER

BASE_READING_UOM_CODE VARCHAR2 (3)
REAL_EST_INIT_DIRECT_COST NUMBER

REAL_EST_OCCUPANCY NUMBER

REAL_EST_DATE_LAST_INSP DATE

REAL_EST_DATE_NEXT_INSP DATE

REAL_EST_WTD_AVG_LIFE NUMBER

REAL_EST_BOND_EQ_YIELD NUMBER

REAL_EST_REFINANCE_AMT NUMBER

REAL_EST_CREDIT_TENANT_FLAG VARCHAR2 (1)
REAL_EST_PROPERTY_CLASS_CODE VARCHAR2 (30)
REAL_EST_COVERAGE_RATIO NUMBER

REAL_EST_NET_CASH_FLOW NUMBER

REAL_EST_FUNDING_CATG_CODE VARCHAR2 (30)
REAL_EST_APPRAISAL_FLAG VARCHAR2 (1)
REAL_EST_APPRAISAL_DATE DATE

REAL_EST_APPRAISAL_VALUE NUMBER

REAL_EST_CONCEPT_TYPE_CODE VARCHAR2 (30)
REAL_EST_DEAL_TYPE_CODE VARCHAR2 (30)
REAL_EST_GROSS_FOOTAGE NUMBER

REAL_EST_NET_FOOTAGE_RENTABLE NUMBER

REAL_EST_LETTER_ACCEPT_DATE DATE

REAL_EST_ACCEPT_EXPIRE_DATE DATE

CAPITALIZED_INTEREST NUMBER

TAX_COST NUMBER

TAX_BOOK VARCHAR2 (15)
LIFE_IN_MONTHS_TAX NUMBER

DEPRN_METHOD_TAX VARCHAR2 (12)
DEPRN_RATE_TAX NUMBER

PAYMENT_TERM VARCHAR2 (50)
PAYMENT_TERM_ID NUMBER

VENDOR_PAYSITE_ID NUMBER

VENDOR_PAYSITE_NAME VARCHAR2 (15)
VENDOR_PAYMENT_METHOD VARCHAR2 (30)
FEE_EXP_NO_OF_PERIODS NUMBER

FEE_EXP_FREQUENCY VARCHAR2 (80)
FEE_EXP_AMOUNT_PER_PERIOD NUMBER

PROP_TAX_APPLICABLE VARCHAR2 (3)
PROP_TAX_LEASE_REP VARCHAR2 (3)
FRENCH_TAX_CODE VARCHAR2 (30)
FRENCH_TAX_NAME VARCHAR2 (150)
USAGE_TYPE_CODE VARCHAR2 (30)
FIXED_USAGE_QUANTITY NUMBER

INITIAL_DIRECT_COST NUMBER

IN_SERVICE_DATE DATE

LINK_ASSET_AMOUNT NUMBER

FEE_TYPE VARCHAR2 (30)
DEPRECIATION_COST NUMBER

USAGE_PERIOD VARCHAR2 (3)
USAGE_NO_OF_PERIOD NUMBER

ASSET_KEY_ID NUMBER

ASSET_KEY_SEGMENT1 VARCHAR2 (30)
ASSET_KEY_SEGMENT2 VARCHAR2 (30)
ASSET_KEY_SEGMENT3 VARCHAR2 (30)
ASSET_KEY_SEGMENT4 VARCHAR2 (30)
ASSET_KEY_SEGMENT5 VARCHAR2 (30)
ASSET_KEY_SEGMENT6 VARCHAR2 (30)
ASSET_KEY_SEGMENT7 VARCHAR2 (30)
ASSET_KEY_SEGMENT8 VARCHAR2 (30)
ASSET_KEY_SEGMENT9 VARCHAR2 (30)
ASSET_KEY_SEGMENT10 VARCHAR2 (30)
TERMINATION_QUOTE_ID NUMBER

TERMINATION_QUOTE_NUMBER NUMBER

PROP_TAX_BILL_METHOD VARCHAR2 (35)
PROP_TAX_AS_CONTRACT_YN VARCHAR2 (1)
STREAM_PURPOSE_CODE VARCHAR2 (35)
EXPLICIT_NEW_LINE_FLAG VARCHAR2 (1)
SUBSIDY_ID NUMBER

SUBSIDY_NAME VARCHAR2 (30)
SUBSIDY_OVERRIDE_AMOUNT NUMBER

SUBSIDY_PARTY_ID NUMBER

SUBSIDY_PARTY_NAME VARCHAR2 (240)
SUBSIDY_REFND_PAYSITE_ID NUMBER

SUBSIDY_REFND_PAYSITE_CODE VARCHAR2 (15)
SUBSIDY_REFND_PAYTERM_ID NUMBER

SUBSIDY_REFND_PAYTERM_NAME VARCHAR2 (50)
SUBSIDY_REFND_PAYMETHOD_CODE VARCHAR2 (30)
SUBSIDY_REFND_PAYGROUP_CODE VARCHAR2 (30)
PTH_BASE_PAYOUT_BASIS VARCHAR2 (30)
PTH_BASE_STREAM_CODE VARCHAR2 (150)
PTH_BASE_STREAM_PURPOSE_CODE VARCHAR2 (30)
PTH_START_DATE DATE

PTH_EVG_PAYOUT_BASIS VARCHAR2 (30)
PTH_PAYOUT_BASIS_FORMULA VARCHAR2 (150)
PTH_EVG_STREAM_CODE VARCHAR2 (150)
PTH_EVG_STREAM_PURPOSE_CODE VARCHAR2 (30)
ST_UPDATE_LINES_FROM_CONTRACT VARCHAR2 (1)
ST_TRANSFER_OF_TITLE VARCHAR2 (1)
ST_SALE_AND_LEASE_BACK VARCHAR2 (1)
ST_PURCHASE_OF_LEASE VARCHAR2 (1)
ST_EQUIPMENT_USAGE VARCHAR2 (30)
ST_EQUIPMENT_AGE NUMBER

FEE_PURPOSE_CODE VARCHAR2 (30)
ST_ASSET_UPFRONT_TAX VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
DOWN_PAYMENT_RECEIVER_CODE VARCHAR2 (30)
CAPITALIZE_DOWN_PAYMENT_YN VARCHAR2 (3)
DATE_FUNDING_EXPECTED DATE

ORIGINATION_INCOME NUMBER

AMOUNT_BALANCE_LEGACY NUMBER

DT_EFFECTIVE_BALANCE_LEGACY DATE

Query Text

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


SELECT CONTRACT_NUMBER_OLD
,      LINE_NUMBER
,      LINE_TYPE
,      ASSET_NUMBER
,      LINK_ASSET_NUMBER
,      ORIGINAL_COST
,      TOTAL_UNITS
,      AMOUNT
,      STATUS
,      DATE_APPROVED
,      DATE_SIGNED
,      CURRENCY_CODE
,      INVENTORY_ORGANIZATION_NAME
,      INVENTORY_ORGANIZATION_ID
,      INVENTORY_ITEM_NAME
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      MODEL
,      MAKE
,      YEAR_OF_MANUFACTURE
,      INSTALL_SITE_NUMBER
,      INSTALL_SITE_ID
,      RESIDUAL_PERCENT
,      RESIDUAL_AMOUNT
,      RESIDUAL_AMOUNT_GUARANTEE
,      RESIDUAL_AMOUNT_GUARANTEE_PV
,      GUARANTOR_TYPE_CODE
,      TRADE_IN_AMOUNT
,      CAPITAL_REDUCTION_PERCENT
,      CAPITAL_REDUCTION_AMOUNT
,      INTERIM_INT_CAPITALIZED_AMT
,      ASSET_CORPORATE_BOOK
,      ASSET_CATEGORY_SEGMENT1
,      ASSET_CATEGORY_SEGMENT2
,      ASSET_CATEGORY_SEGMENT3
,      ASSET_CATEGORY_SEGMENT4
,      ASSET_CATEGORY_SEGMENT5
,      ASSET_CATEGORY_SEGMENT6
,      ASSET_CATEGORY_SEGMENT7
,      ASSET_CATEGORY_ID
,      ASSET_LOCATION_SEGMENT1
,      ASSET_LOCATION_SEGMENT2
,      ASSET_LOCATION_SEGMENT3
,      ASSET_LOCATION_SEGMENT4
,      ASSET_LOCATION_SEGMENT5
,      ASSET_LOCATION_SEGMENT6
,      ASSET_LOCATION_SEGMENT7
,      ASSET_LOCATION_ID
,      DEPRECIATION_METHOD_ID
,      DEPRECIATION_METHOD_CODE
,      LIFE_IN_MONTHS
,      DEPRECIATION_RATE
,      SALVAGE_VALUE
,      SALVAGE_VALUE_PERCENT
,      SALES_TAX_EXEMPT_FLAG
,      SALES_TAX_EXEMPT_CERT_NUMBER
,      SALES_TAX_OVERRIDE_FLAG
,      SALES_TAX_OVERRIDE_RATE
,      VAT_TAX_EXEMPT
,      VAT_TAX_EXEMPT_CERT_NUMBER
,      VAT_TAX_OVERRIDE_FLAG
,      VAT_TAX_OVERRIDE_RATE
,      LIEN_TYPE
,      LIEN_FILING_NUMBER
,      LIEN_FILING_DATE
,      LIEN_FILING_STATUS
,      LIENHOLDER_ID
,      LIENHOLDER_NUMBER
,      FILING_JURISDICTION
,      FILING_SUB_JURISDICTION
,      LIEN_EXPIRATION_DATE
,      LIEN_CONTINUATION_NUMBER
,      LIEN_CONTINUATION_DATE
,      TITLE_TYPE
,      TITLE_ISSUER_NUMBER
,      TITLE_ISSUER_ID
,      TITLE_DATE
,      TITLE_NUMBER
,      REGISTRATION_NUMBER
,      ASSET_REGISTRATION_LOC_NAME
,      TITLE_CUSTODIAN_NAME
,      PAYEE_SITE_NAME
,      SERIAL_NUMBER
,      VENDOR_INVOICE_NUMBER
,      VENDOR_INVOICE_DATE
,      SHIP_TO_SITE_NUMBER
,      SHIP_TO_SITE_ID
,      START_DATE
,      END_DATE
,      PASSTHROUGH_PERCENT
,      PASSTHROUGH_BASIS_CODE
,      FEE_CODE
,      USAGE_ITEM_NAME
,      USAGE_ITEM_ID
,      PRICE_LIST_NAME
,      PRICE_LIST_ID
,      COUNTER_GROUP_NAME
,      COUNTER_GROUP_ID
,      USAGE_BILL_FREQUENCY_CODE
,      MINIMUM_QTY_USAGE
,      DEFAULT_QTY_USAGE
,      AMCV_FLAG
,      LEVEL_FLAG
,      BASE_READING
,      BASE_READING_UOM_CODE
,      REAL_EST_INIT_DIRECT_COST
,      REAL_EST_OCCUPANCY
,      REAL_EST_DATE_LAST_INSP
,      REAL_EST_DATE_NEXT_INSP
,      REAL_EST_WTD_AVG_LIFE
,      REAL_EST_BOND_EQ_YIELD
,      REAL_EST_REFINANCE_AMT
,      REAL_EST_CREDIT_TENANT_FLAG
,      REAL_EST_PROPERTY_CLASS_CODE
,      REAL_EST_COVERAGE_RATIO
,      REAL_EST_NET_CASH_FLOW
,      REAL_EST_FUNDING_CATG_CODE
,      REAL_EST_APPRAISAL_FLAG
,      REAL_EST_APPRAISAL_DATE
,      REAL_EST_APPRAISAL_VALUE
,      REAL_EST_CONCEPT_TYPE_CODE
,      REAL_EST_DEAL_TYPE_CODE
,      REAL_EST_GROSS_FOOTAGE
,      REAL_EST_NET_FOOTAGE_RENTABLE
,      REAL_EST_LETTER_ACCEPT_DATE
,      REAL_EST_ACCEPT_EXPIRE_DATE
,      CAPITALIZED_INTEREST
,      TAX_COST
,      TAX_BOOK
,      LIFE_IN_MONTHS_TAX
,      DEPRN_METHOD_TAX
,      DEPRN_RATE_TAX
,      PAYMENT_TERM
,      PAYMENT_TERM_ID
,      VENDOR_PAYSITE_ID
,      VENDOR_PAYSITE_NAME
,      VENDOR_PAYMENT_METHOD
,      FEE_EXP_NO_OF_PERIODS
,      FEE_EXP_FREQUENCY
,      FEE_EXP_AMOUNT_PER_PERIOD
,      PROP_TAX_APPLICABLE
,      PROP_TAX_LEASE_REP
,      FRENCH_TAX_CODE
,      FRENCH_TAX_NAME
,      USAGE_TYPE_CODE
,      FIXED_USAGE_QUANTITY
,      INITIAL_DIRECT_COST
,      IN_SERVICE_DATE
,      LINK_ASSET_AMOUNT
,      FEE_TYPE
,      DEPRECIATION_COST
,      USAGE_PERIOD
,      USAGE_NO_OF_PERIOD
,      ASSET_KEY_ID
,      ASSET_KEY_SEGMENT1
,      ASSET_KEY_SEGMENT2
,      ASSET_KEY_SEGMENT3
,      ASSET_KEY_SEGMENT4
,      ASSET_KEY_SEGMENT5
,      ASSET_KEY_SEGMENT6
,      ASSET_KEY_SEGMENT7
,      ASSET_KEY_SEGMENT8
,      ASSET_KEY_SEGMENT9
,      ASSET_KEY_SEGMENT10
,      TERMINATION_QUOTE_ID
,      TERMINATION_QUOTE_NUMBER
,      PROP_TAX_BILL_METHOD
,      PROP_TAX_AS_CONTRACT_YN
,      STREAM_PURPOSE_CODE
,      EXPLICIT_NEW_LINE_FLAG
,      SUBSIDY_ID
,      SUBSIDY_NAME
,      SUBSIDY_OVERRIDE_AMOUNT
,      SUBSIDY_PARTY_ID
,      SUBSIDY_PARTY_NAME
,      SUBSIDY_REFND_PAYSITE_ID
,      SUBSIDY_REFND_PAYSITE_CODE
,      SUBSIDY_REFND_PAYTERM_ID
,      SUBSIDY_REFND_PAYTERM_NAME
,      SUBSIDY_REFND_PAYMETHOD_CODE
,      SUBSIDY_REFND_PAYGROUP_CODE
,      PTH_BASE_PAYOUT_BASIS
,      PTH_BASE_STREAM_CODE
,      PTH_BASE_STREAM_PURPOSE_CODE
,      PTH_START_DATE
,      PTH_EVG_PAYOUT_BASIS
,      PTH_PAYOUT_BASIS_FORMULA
,      PTH_EVG_STREAM_CODE
,      PTH_EVG_STREAM_PURPOSE_CODE
,      ST_UPDATE_LINES_FROM_CONTRACT
,      ST_TRANSFER_OF_TITLE
,      ST_SALE_AND_LEASE_BACK
,      ST_PURCHASE_OF_LEASE
,      ST_EQUIPMENT_USAGE
,      ST_EQUIPMENT_AGE
,      FEE_PURPOSE_CODE
,      ST_ASSET_UPFRONT_TAX
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOWN_PAYMENT_RECEIVER_CODE
,      CAPITALIZE_DOWN_PAYMENT_YN
,      DATE_FUNDING_EXPECTED
,      ORIGINATION_INCOME
,      AMOUNT_BALANCE_LEGACY
,      DT_EFFECTIVE_BALANCE_LEGACY
FROM OKL.OKL_LINES_INTERFACE#;

Dependencies

[top of page]

OKL.OKL_LINES_INTERFACE# references the following:

SchemaOKL
TableOKL_LINES_INTERFACE
OKL.OKL_LINES_INTERFACE# is referenced by following:

SchemaAPPS
SynonymOKL_LINES_INTERFACE