[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_LINES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| FND Design Data: |  OKL.OKL_LINES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
OKL_LINES_INTERFACE stores information used to create contract line detail during Lease contract open interface import.
Note that one row in this table creates, during import process, one top line and more than one contract sub-line.
rep:scope public
Product: OKL
Display Name: OKL Contract Line Open Interface
Category: BUSINESS_ENTITY OKL_CONTRACT
Lifecycle: active
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKL_LINES_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 CONTRACT_NUMBER_OLD
LINE_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONTRACT_NUMBER_OLD | VARCHAR2 | (30) | Yes | Legacy Contract number. Used to link contract line records with imported contract. |
| LINE_NUMBER | NUMBER | Yes | Line number | |
| LINE_TYPE | VARCHAR2 | (30) | Yes | Contract line type. Valid values are 'ASSET', 'SERVICE', 'FEE', 'USAGE'. |
| ASSET_NUMBER | VARCHAR2 | (15) | Asset number | |
| LINK_ASSET_NUMBER | VARCHAR2 | (15) | For linking line to an asset line. Not in use. | |
| ORIGINAL_COST | NUMBER | Asset original unti cost. | ||
| TOTAL_UNITS | NUMBER | Number of units of the asset. | ||
| AMOUNT | NUMBER | Amount | ||
| STATUS | VARCHAR2 | (40) | Status | |
| DATE_APPROVED | DATE | Date of Approval. | ||
| DATE_SIGNED | DATE | Date singed. | ||
| CURRENCY_CODE | VARCHAR2 | (3) | Currency code | |
| INVENTORY_ORGANIZATION_NAME | VARCHAR2 | (240) | Inventory organization Name. Validated against HR_ALL_ORGANIZATION_UNITS. | |
| INVENTORY_ORGANIZATION_ID | NUMBER | Inventory organization ID. Validated against HR_ALL_ORGANIZATION_UNITS. | ||
| INVENTORY_ITEM_NAME | VARCHAR2 | (1000) | Inventory item Name. Validated against MTL_SYSTEM_ITEMS.SEGMENT1. | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item ID. Validated against MTL_SYSTEM_ITEMS.. | ||
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| MODEL | VARCHAR2 | (40) | Asset model number. | |
| MAKE | VARCHAR2 | (360) | Asset make. | |
| YEAR_OF_MANUFACTURE | NUMBER | Asset year of manufacture. | ||
| INSTALL_SITE_NUMBER | VARCHAR2 | (30) | Name of address installed at. Validated against OKX_PARTY_SITE_USES_V.PARTY_SITE_NUMBER with site use type as 'INSTALL_AT'. | |
| INSTALL_SITE_ID | NUMBER | ID of address installed at. Validated against OKX_PARTY_SITE_USES_V.ID1 with site use type as 'INSTALL_AT'. | ||
| RESIDUAL_PERCENT | NUMBER | Residual value percent of total OEC for line. | ||
| RESIDUAL_AMOUNT | NUMBER | Residual value amount. | ||
| RESIDUAL_AMOUNT_GUARANTEE | NUMBER | Amount of residual value guaranteed. | ||
| RESIDUAL_AMOUNT_GUARANTEE_PV | NUMBER | PV of residual guarantee amount. | ||
| GUARANTOR_TYPE_CODE | VARCHAR2 | (30) | Guarantor type for residual guarantee. | |
| TRADE_IN_AMOUNT | NUMBER | Trade in amount applied as capital reduction. | ||
| CAPITAL_REDUCTION_PERCENT | NUMBER | Percent of direct capital reduction. | ||
| CAPITAL_REDUCTION_AMOUNT | NUMBER | Amount of direct capital reduction. | ||
| INTERIM_INT_CAPITALIZED_AMT | NUMBER | Amount of interim interest capitalized with asset line. | ||
| ASSET_CORPORATE_BOOK | VARCHAR2 | (15) | Name of corporate book post asset line in FA | |
| ASSET_CATEGORY_SEGMENT1 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_SEGMENT2 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_SEGMENT3 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_SEGMENT4 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_SEGMENT5 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_SEGMENT6 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_SEGMENT7 | VARCHAR2 | (30) | Flexfield category segment in FA. | |
| ASSET_CATEGORY_ID | NUMBER | ID of asset category to assign asset in FA. | ||
| ASSET_LOCATION_SEGMENT1 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_SEGMENT2 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_SEGMENT3 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_SEGMENT4 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_SEGMENT5 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_SEGMENT6 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_SEGMENT7 | VARCHAR2 | (30) | Flexfield location segment in FA. | |
| ASSET_LOCATION_ID | NUMBER | ID of location to assign asset in FA. | ||
| DEPRECIATION_METHOD_ID | NUMBER | Asset depreciation method ID. | ||
| DEPRECIATION_METHOD_CODE | VARCHAR2 | (12) | Asset depreciation method code. | |
| LIFE_IN_MONTHS | NUMBER | Depreciable life in months. | ||
| DEPRECIATION_RATE | NUMBER | Depreciation rate. | ||
| SALVAGE_VALUE | NUMBER | Amount of salvage value. | ||
| SALVAGE_VALUE_PERCENT | NUMBER | Percentt of salvage value. | ||
| SALES_TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Sales tax exempt flag. Valid values are 'Y' or 'N'. | |
| SALES_TAX_EXEMPT_CERT_NUMBER | VARCHAR2 | (50) | Sales tax exempt certificate number. | |
| SALES_TAX_OVERRIDE_FLAG | VARCHAR2 | (1) | Sales tax override flag. Valid values are 'Y' or 'N'. | |
| SALES_TAX_OVERRIDE_RATE | NUMBER | Sales tax override rate. | ||
| VAT_TAX_EXEMPT | VARCHAR2 | (1) | VAT tax exempt flag. Valid values are 'Y' or 'N'. | |
| VAT_TAX_EXEMPT_CERT_NUMBER | VARCHAR2 | (50) | VAT tax exempt certificate number. | |
| VAT_TAX_OVERRIDE_FLAG | VARCHAR2 | (1) | VAT tax override flag. Valid values are 'Y' or 'N'. | |
| VAT_TAX_OVERRIDE_RATE | NUMBER | VAT tax override rate. | ||
| LIEN_TYPE | VARCHAR2 | (30) | Type of lien on asset. | |
| LIEN_FILING_NUMBER | VARCHAR2 | (50) | Lien filing number. | |
| LIEN_FILING_DATE | DATE | Lien filing date. | ||
| LIEN_FILING_STATUS | VARCHAR2 | (30) | Lien filing status. | |
| LIENHOLDER_ID | NUMBER | Lien holder ID. Validated against OKX_PARTIES_V.ID1. | ||
| LIENHOLDER_NUMBER | VARCHAR2 | (360) | Lien holder number. Validated against OKX_PARTIES_V.PARTY_NUMBER. | |
| FILING_JURISDICTION | VARCHAR2 | (50) | Primary jurisdiction where lien is filed. | |
| FILING_SUB_JURISDICTION | VARCHAR2 | (50) | Sub jurisdiction where lien is filed. | |
| LIEN_EXPIRATION_DATE | DATE | Date lien expires. | ||
| LIEN_CONTINUATION_NUMBER | VARCHAR2 | (50) | Number of lien continuation (filing extension). | |
| LIEN_CONTINUATION_DATE | DATE | Date extension is filed. | ||
| TITLE_TYPE | VARCHAR2 | (30) | Type of title for asset. | |
| TITLE_ISSUER_NUMBER | VARCHAR2 | (60) | Title issuer number. Validated against OKX_PARTIES_V.PARTY_NUMBER. | |
| TITLE_ISSUER_ID | NUMBER | Title issuer ID. Validated against OKX_PARTIES_V.ID1. | ||
| TITLE_DATE | DATE | Date on title. | ||
| TITLE_NUMBER | VARCHAR2 | (50) | Title number. | |
| REGISTRATION_NUMBER | VARCHAR2 | (150) | Asset registration number. | |
| ASSET_REGISTRATION_LOC_NAME | VARCHAR2 | (50) | Asset registration location name. | |
| TITLE_CUSTODIAN_NAME | VARCHAR2 | (30) | Title custodian name. | |
| PAYEE_SITE_NAME | VARCHAR2 | (240) | Payee site name. | |
| SERIAL_NUMBER | VARCHAR2 | (100) | Serial number. | |
| VENDOR_INVOICE_NUMBER | VARCHAR2 | (30) | Vendor invoice number. | |
| VENDOR_INVOICE_DATE | DATE | Vendor invoice date. | ||
| SHIP_TO_SITE_NUMBER | VARCHAR2 | (240) | Ship to site address. Validated against OKX_PARTY_SITE_USES_V.PARTY_SITE_NUMBER with site use type as 'SHIP_TO'. | |
| SHIP_TO_SITE_ID | NUMBER | Ship to site address ID. Validated against OKX_PARTY_SITE_USES_V.ID1 with site use type as 'SHIP_TO'. | ||
| START_DATE | DATE | Start date | ||
| END_DATE | DATE | End date | ||
| PASSTHROUGH_PERCENT | NUMBER | Passthrough amount in percent. | ||
| PASSTHROUGH_BASIS_CODE | VARCHAR2 | (30) | Passthrough basis code. | |
| FEE_CODE | VARCHAR2 | (150) | Stream type source for fee. Validated against OKL_STRMTYP_SOURCE_V.CODE. | |
| USAGE_ITEM_NAME | VARCHAR2 | (1000) | Usage item name for Usage based billing. Validated against OKX_SYSTEM_ITEMS_V.NAME with usage item flag as 'Y'. | |
| USAGE_ITEM_ID | NUMBER | Usage item ID for Usage based billing. Validated against OKX_SYSTEM_ITEMS_V.ID1 with usage item flag as 'Y'. | ||
| PRICE_LIST_NAME | VARCHAR2 | (240) | Price list name for Usage based billing. Validated against OKX_LIST_HEADERS_V.NAME with list type code as 'PRL'. | |
| PRICE_LIST_ID | NUMBER | Price list ID for Usage based billing. Validated against OKX_LIST_HEADERS_V.ID1 with list type code as 'PRL'. | ||
| COUNTER_GROUP_NAME | VARCHAR2 | (30) | Counter group name for Usage based billing. | |
| COUNTER_GROUP_ID | NUMBER | Counter group ID for Usage based billing. | ||
| USAGE_BILL_FREQUENCY_CODE | VARCHAR2 | (30) | Usage bill frequency code. | |
| MINIMUM_QTY_USAGE | NUMBER | Minimum quantity to bill for in Usage based billing for the period. | ||
| DEFAULT_QTY_USAGE | NUMBER | Default to bill for if reading not obtained for the current period. | ||
| AMCV_FLAG | VARCHAR2 | (1) | AMCV flag. Valid values are 'Y' or 'N'. If Y then bill based on average meter reading. | |
| LEVEL_FLAG | VARCHAR2 | (1) | Level flag. Valid values are 'Y' or 'N'. If 'Y' then do levelling for counters for a usage line. | |
| BASE_READING | NUMBER | Base reading. | ||
| BASE_READING_UOM_CODE | VARCHAR2 | (3) | Base reading unit of measure. Validated against OKX_TUOM_V.UOM_CODE. | |
| REAL_EST_INIT_DIRECT_COST | NUMBER | Initial direct cost for real estate asset. | ||
| REAL_EST_OCCUPANCY | NUMBER | Occupancy number for real estate asset | ||
| REAL_EST_DATE_LAST_INSP | DATE | Last inspection date for real estate asset. | ||
| REAL_EST_DATE_NEXT_INSP | DATE | Next inspection date for real estate asset. | ||
| REAL_EST_WTD_AVG_LIFE | NUMBER | Weighted average life (in years) of real estate asset. | ||
| REAL_EST_BOND_EQ_YIELD | NUMBER | Bond yield equivalent tp yield on real estate asset. | ||
| REAL_EST_REFINANCE_AMT | NUMBER | Refinanced amount for real estate asset. | ||
| REAL_EST_CREDIT_TENANT_FLAG | VARCHAR2 | (1) | Tenant providing credit indicator for real estate asset. | |
| REAL_EST_PROPERTY_CLASS_CODE | VARCHAR2 | (30) | Property class code of real estate asset. | |
| REAL_EST_COVERAGE_RATIO | NUMBER | Coverage ratio of real estate asset. | ||
| REAL_EST_NET_CASH_FLOW | NUMBER | Net cash flow on real estate asset. | ||
| REAL_EST_FUNDING_CATG_CODE | VARCHAR2 | (30) | Funding category code for real estate asset. | |
| REAL_EST_APPRAISAL_FLAG | VARCHAR2 | (1) | Appraisal indicator for real estate asset. | |
| REAL_EST_APPRAISAL_DATE | DATE | Date of appraisal for reat estate asset. | ||
| REAL_EST_APPRAISAL_VALUE | NUMBER | Value of appraisal for reat estate asset. | ||
| REAL_EST_CONCEPT_TYPE_CODE | VARCHAR2 | (30) | Concept type of real estate asset. | |
| REAL_EST_DEAL_TYPE_CODE | VARCHAR2 | (30) | Deal type of real estate asset. | |
| REAL_EST_GROSS_FOOTAGE | NUMBER | Gross footage of real estate asset. | ||
| REAL_EST_NET_FOOTAGE_RENTABLE | NUMBER | Net rentable footage of real estate asset. | ||
| REAL_EST_LETTER_ACCEPT_DATE | DATE | Date of letter acceptance for real estate asset. | ||
| REAL_EST_ACCEPT_EXPIRE_DATE | DATE | Date acceptance expires for real estate asset. | ||
| CAPITALIZED_INTEREST | NUMBER | Capitalized interest. | ||
| TAX_COST | NUMBER | Cost at Tax book. | ||
| TAX_BOOK | VARCHAR2 | (15) | Name of Tax book. | |
| LIFE_IN_MONTHS_TAX | NUMBER | Life in months in tax book. | ||
| DEPRN_METHOD_TAX | VARCHAR2 | (12) | Depreciation method in tax book. | |
| DEPRN_RATE_TAX | NUMBER | Depreciation rate in tax book. | ||
| PAYMENT_TERM | VARCHAR2 | (50) | Not in use. | |
| PAYMENT_TERM_ID | NUMBER | Not in use. | ||
| VENDOR_PAYSITE_ID | NUMBER | Not in use. | ||
| VENDOR_PAYSITE_NAME | VARCHAR2 | (15) | Not in use. | |
| VENDOR_PAYMENT_METHOD | VARCHAR2 | (30) | Not in use. | |
| FEE_EXP_NO_OF_PERIODS | NUMBER | Number of periods for fee expense. | ||
| FEE_EXP_FREQUENCY | VARCHAR2 | (80) | Frequecy for fee expense. | |
| FEE_EXP_AMOUNT_PER_PERIOD | NUMBER | Fee expense amount per period. | ||
| PROP_TAX_APPLICABLE | VARCHAR2 | (3) | Property Tax applicable flag. Valid values are 'Y' or 'N'. | |
| PROP_TAX_LEASE_REP | VARCHAR2 | (3) | Property Tax Lease Reporting Flag. Valid values are 'Y' or 'N'. | |
| FRENCH_TAX_CODE | VARCHAR2 | (30) | Localization French Tax - Tax Professionale Code. | |
| FRENCH_TAX_NAME | VARCHAR2 | (150) | Localization - French Tax Professionale name | |
| USAGE_TYPE_CODE | VARCHAR2 | (30) | Usage type code at Usage line level | |
| FIXED_USAGE_QUANTITY | NUMBER | Fixed quantity, mandatory when Usage type is Fixed per period | ||
| INITIAL_DIRECT_COST | NUMBER | Initial direct cost for Fee line. Should not be greater than Fee Line amount | ||
| IN_SERVICE_DATE | DATE | Asset date placed in service | ||
| LINK_ASSET_AMOUNT | NUMBER | Service or fee linked asset amount | ||
| FEE_TYPE | VARCHAR2 | (30) | Fee type for financed fees | |
| DEPRECIATION_COST | NUMBER | Not being used. This column is left for future use only. | ||
| USAGE_PERIOD | VARCHAR2 | (3) | Usage Periiod (Used to create Service contract payment schedule) | |
| USAGE_NO_OF_PERIOD | NUMBER | Usage Number of Periods (Used to create Service contract Payment schedule) | ||
| ASSET_KEY_ID | NUMBER | Identifier of Asset Key flexfield in FA | ||
| ASSET_KEY_SEGMENT1 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT2 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT3 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT4 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT5 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT6 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT7 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT8 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT9 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| ASSET_KEY_SEGMENT10 | VARCHAR2 | (30) | Flexfield asset key segment of FA | |
| TERMINATION_QUOTE_ID | NUMBER | Termination Quote Identifier | ||
| TERMINATION_QUOTE_NUMBER | NUMBER | Termination Quote Number | ||
| PROP_TAX_BILL_METHOD | VARCHAR2 | (35) | Billing method code for Property Tax | |
| PROP_TAX_AS_CONTRACT_YN | VARCHAR2 | (1) | Flag to indicate default property tax rule from contract header | |
| STREAM_PURPOSE_CODE | VARCHAR2 | (35) | The purpose code of the stream type | |
| EXPLICIT_NEW_LINE_FLAG | VARCHAR2 | (1) | Flag to indicate creation of new line | |
| SUBSIDY_ID | NUMBER | Asset Subsidy identifier | ||
| SUBSIDY_NAME | VARCHAR2 | (30) | Asset Subsidy Number | |
| SUBSIDY_OVERRIDE_AMOUNT | NUMBER | Amount to override default subsidy value | ||
| SUBSIDY_PARTY_ID | NUMBER | Subsidy Party identifier | ||
| SUBSIDY_PARTY_NAME | VARCHAR2 | (240) | Subsidy Party Name | |
| SUBSIDY_REFND_PAYSITE_ID | NUMBER | Subsidy party payment site identifier | ||
| SUBSIDY_REFND_PAYSITE_CODE | VARCHAR2 | (15) | Subsidy party payment site code | |
| SUBSIDY_REFND_PAYTERM_ID | NUMBER | Subsidy Payment term identifier | ||
| SUBSIDY_REFND_PAYTERM_NAME | VARCHAR2 | (50) | Subsidy Payment term name | |
| SUBSIDY_REFND_PAYMETHOD_CODE | VARCHAR2 | (30) | Subsidy Payment method code | |
| SUBSIDY_REFND_PAYGROUP_CODE | VARCHAR2 | (30) | Subsidy Pay group Code | |
| PTH_BASE_PAYOUT_BASIS | VARCHAR2 | (30) | Pass through Base term payout basis | |
| PTH_BASE_STREAM_CODE | VARCHAR2 | (150) | Pass through base term stream type code | |
| PTH_BASE_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Pass through base term stream purpose code | |
| PTH_START_DATE | DATE | Pass through Start Date | ||
| PTH_EVG_PAYOUT_BASIS | VARCHAR2 | (30) | Pass through evergreen term payout basis | |
| PTH_PAYOUT_BASIS_FORMULA | VARCHAR2 | (150) | Pass through payout basis formula | |
| PTH_EVG_STREAM_CODE | VARCHAR2 | (150) | Pass through evergreen term stream type code | |
| PTH_EVG_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Pass through evergreen term stream purpose code | |
| ST_UPDATE_LINES_FROM_CONTRACT | VARCHAR2 | (1) | Update sales tax parameters from contract flag | |
| ST_TRANSFER_OF_TITLE | VARCHAR2 | (1) | Sales tax transfer of title flag | |
| ST_SALE_AND_LEASE_BACK | VARCHAR2 | (1) | Sales Tax Sale and Lease back flag | |
| ST_PURCHASE_OF_LEASE | VARCHAR2 | (1) | Sales Tax Purchase of Lease flag | |
| ST_EQUIPMENT_USAGE | VARCHAR2 | (30) | Sales Tax usage of equipment | |
| ST_EQUIPMENT_AGE | NUMBER | Sales Tax age of equipment | ||
| FEE_PURPOSE_CODE | VARCHAR2 | (30) | Sales Tax Fee Line stream purpose code | |
| ST_ASSET_UPFRONT_TAX | VARCHAR2 | (30) | Sales tax upfront tax type code | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield category column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive column | |
| DOWN_PAYMENT_RECEIVER_CODE | VARCHAR2 | (30) | Down Payment Receiver Code | |
| CAPITALIZE_DOWN_PAYMENT_YN | VARCHAR2 | (3) | Capitalize Down Payment Yes or No | |
| DATE_FUNDING_EXPECTED | DATE | Expected Funding Date | ||
| ORIGINATION_INCOME | NUMBER | Origination Income | ||
| AMOUNT_BALANCE_LEGACY | NUMBER | Balance amount in legacy system | ||
| DT_EFFECTIVE_BALANCE_LEGACY | DATE | Effective date of balance in legacy system |
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;
OKL.OKL_LINES_INTERFACE does not reference any database object
OKL.OKL_LINES_INTERFACE is referenced by following:
OKL
OKL_LINES_INTERFACE#
|
|
|
|