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


TABLE: OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T

Object Details
Object Name: OKL_CNTRCT_LINE_FIN_EXTRACT_T
Object Type: TABLE
Owner: OKL
Subobject Name:
Status: VALID


Table for Contract Line Financial Extract


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_CNTRCT_LINE_FIN_EXT_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCONTRACT_ID
ColumnCONTRACT_LINE_ID
OKL_CNTRCT_LINE_FIN_EXT_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCONTRACT_START_DATE
ColumnCONTRACT_STATUS
OKL_CNTRCT_LINE_FIN_EXT_T_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCNTRCT_CUSTOMER_PARTY_NAME
ColumnREQUEST_ID
ColumnCONTRACT_START_DATE
ColumnCNTRCT_CUST_PARTY_NUMBER
OKL_CNTRCT_LINE_FIN_EXT_T_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCONTRACT_BOOK_CLASSIFICATION
ColumnCONTRACT_START_DATE
ColumnCONTRACT_FINANCIAL_PRODUCT
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Request Identifier of the concurrent program
CONTRACT_ID NUMBER
Yes Primary ID of contract
CONTRACT_LINE_ID NUMBER
Yes Contract Line ID of the contract line
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number of the contract line
CONTRACT_OPERATING_UNIT_ID NUMBER
Yes Operating Unit ID of the contract
OPERATING_UNIT VARCHAR2 (240) Yes Operating Unit associated to the contract
OPERATING_UNIT_SHORT_CODE VARCHAR2 (150)
Operating Unit Short Code associated to the contract
CONTRACT_STATUS_TYPE_CODE VARCHAR2 (30)
Status Type Code associated to the contract
CONTRACT_STATUS_CODE VARCHAR2 (30)
Status Code of the contract
CONTRACT_STATUS VARCHAR2 (90)
Contract Status
CONTRACT_CURRENCY VARCHAR2 (15)
Contract Currency
CONTRACT_CURRENCY_CONV_TYPE VARCHAR2 (30)
Currency Conversion Type on the contract
CONTRACT_CURRENCY_CONV_RATE NUMBER

Currency Conversion Rate on the contract
CONTRACT_CURRENCY_CONV_DATE DATE

Currency Conversion Date on the contract
FUNCTIONAL_CURRENCY VARCHAR2 (15)
Functional Currency of the contract
CONTRACT_START_DATE DATE

Start Date of the contract
CONTRACT_END_DATE DATE

End Date of the contract
CONTRACT_FINANCIAL_PRODUCT_ID NUMBER

Primary ID of Financial Product associated to contract
CONTRACT_FINANCIAL_PRODUCT VARCHAR2 (150)
Financial Product associated to contract
CONTRACT_REPORTING_PRODUCT_ID NUMBER

Reporting Product ID associated to contract
CONTRACT_REPORTING_PRODUCT VARCHAR2 (150)
Reporting Product Name associated to contract
INTEREST_CALCLATION_BASIS_CODE VARCHAR2 (150)
Interest Calculation Basis Code of the contract
REVENUE_RECOGNTION_METHOD_CODE VARCHAR2 (150)
Revenue Recognition Method Code of the contract
INTEREST_CALCULATION_BASIS VARCHAR2 (4000)
Interest Calculation Basis of the contract
REVENUE_RECOGNITION_METHOD VARCHAR2 (4000)
Revenue Recognition Method of the contract
CONTRACT_INTEREST_INDEX_ID NUMBER

Interest Index ID associated to the contract
CONTRACT_INTEREST_INDEX VARCHAR2 (150)
Interest Index Name associated to the contract
CONTRACT_TERM_DURATION NUMBER (10)
Term of contract in months
CONTRACT_BOOK_CLASS_CODE VARCHAR2 (30)
Deal Type Code of the contract
CONTRACT_BOOK_CLASSIFICATION VARCHAR2 (80)
Deal Type of the contract
CONTRACT_LEGAL_ENTITY_ID NUMBER

Legal Entity ID associated to the contract
LEGAL_ENTITY VARCHAR2 (240)
Legal Entity Name associated to the contract
LEDGER_ID NUMBER (15)
Ledger ID of the Primary Ledger associated to the contract
LEDGER VARCHAR2 (30)
Ledger Name of the Primary Ledger associated to the contract
CNTRCT_CUSTOMER_PARTY_NAME VARCHAR2 (360) Yes Customer Name associated to contract
CNTRCT_CUST_PARTY_ID NUMBER (15) Yes Primary ID of the Customer associated to the contract
CNTRCT_CUST_PARTY_NUMBER VARCHAR2 (30)
Customer Name associated to contract
CNTRCT_CUST_ACOUNT_ID NUMBER (15)
Customer Account ID of the Lessee on the contract
CNTRCT_CUST_ACCT_NUMBER VARCHAR2 (30)
Customer Account Number of the Lessee
CNTRCT_CUST_PARTY_SITE_ID NUMBER (15)
Primary ID of Customer Party Site
CNTRCT_CUST_PARTY_SITE_NUM VARCHAR2 (30)
Party Site Number of customer
CNTRCT_CUST_PARTY_SITE_NAME VARCHAR2 (240)
Party Site Name of customer
CNTRCT_CUST_PARTY_SITE_LOC_ID NUMBER (15)
Party Site Location ID of customer
CNTRCT_CUST_PARTY_SITE_USE_ID NUMBER (15)
Party Site Use ID of customer
CREATED_BY NUMBER
Yes Standard who column - user who created this row
CREATION_DATE DATE
Yes Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row
PROGRAM_LOGIN_ID NUMBER

Concurrent Program who column - operating system login when a program last updated this row
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row
CONTRACT_LINE_TYPE_ID NUMBER

Primary ID to identify contract line type
CONTRACT_LINE_TYPE_CODE VARCHAR2 (30)
Contract Line Type Code
CONTRACT_LINE_TYPE_NAME VARCHAR2 (150)
Contract Line Type Name
CONTRACT_LINE_NAME VARCHAR2 (150)
Contract Line Name
CONTRACT_LINE_STATUS_CODE VARCHAR2 (30)
Status Code of Contract Line
CONTRACT_LINE_STATUS VARCHAR2 (90)
Status of Contract Line
ASSET_DATE_DELIVERY_EXPECTED DATE

Expected Delivery Date of Asset
ASSET_DATE_FUNDING_EXPECTED DATE

Expected Funding Date of Asset
ASSET_RESIDUAL_PERCENT NUMBER (5)
Residual Percent of Asset
ASSET_RES_GUARANTOR_TYPE_CODE VARCHAR2 (30)
Residual Guarantor Type Code of Asset
ASSET_RES_GUARANTOR_TYPE VARCHAR2 (80)
Residual Guarantor Type of Asset
ASSET_RESIDUAL_AMT_GUARANTEE NUMBER (14)
Residual Amount Guarantee of Asset
ASSET_RESIDUAL_AMOUNT NUMBER (20)
Residual Amount of Asset
ASSET_UPFRONT_TAX NUMBER

Upfront Tax of Asset
ASSET_BILL_TO_SITE_USE_ID NUMBER (15)
Bill to Site Use ID of Asset
ASSET_BILL_TO_ADDRESS VARCHAR2 (40)
Bill to Address of Asset
ASSET_BILLING_PAYMENT_METHOD VARCHAR2 (30)
Billing Payment Method of Asset
ASSET_BILLING_BANK_ACCOUNT VARCHAR2 (121)
Billing Bank Account of Asset
ASSET_BILLING_BANK VARCHAR2 (360)
Billing Bank of Asset
ASSET_ST_TRANSFER_OF_TITLE VARCHAR2 (450)
Sales Tax Transfer of Title for Asset
ASSET_ST_SALE_AND_LEASE_BACK VARCHAR2 (450)
Sales Tax Sale and Lease Back for Asset
ASSET_ST_PURCHASE_OF_LEASE VARCHAR2 (450)
Sales Tax Purchase of Lease for Asset
ASSET_ST_INTENDED_USE VARCHAR2 (240)
Sales Tax Intended Use for Asset
ASSET_ST_ASSET_UPFRONT_TAX VARCHAR2 (80)
Sales Tax Upfront Tax for Asset
ASSET_ST_EQUIPMENT_AGE VARCHAR2 (450)
Sales Tax Equipment Age for Asset
ASSET_PROP_TAX_APPLICABLE VARCHAR2 (450)
Property Tax Applicable Indicator for Asset
ASSET_PROP_TAX_LESSEE_REPORT VARCHAR2 (450)
Property Tax Lessee Report for Asset
ASSET_PROP_TAX_BILL_METHOD VARCHAR2 (80)
Property Tax Billing Method for Asset
LINE_SUPPLIER_ID NUMBER

Supplier ID for contract line
LINE_SUPPLIER_NUMBER VARCHAR2 (30)
Supplier Number for contract line
LINE_SUPPLIER VARCHAR2 (360)
Supplier Name for contract line
INV_SUPPLR_SHIP_TO_SITE_USE_ID NUMBER (15)
Inventory Supplier Ship to Site Use ID
INV_SUPPLIER_SHIP_TO_SITE VARCHAR2 (80)
Inventory Supplier Ship to Site
INV_SUPPLIER_INVOICE_LINE_ID NUMBER

Inventory Supplier Invoice Line ID
INV_SUPPLIER_INVOICE_NUMBER VARCHAR2 (30)
Inventory Supplier Invoice Number
INV_SUPPLIER_INVOICE_DATE DATE

Inventory Supplier Invoice Date
INV_SUPPLIER_SHIP_TO_SITE_ID NUMBER (15)
Inventory Supplier Ship to Site ID
INV_SUPPLIER_SHIP_TO_SITE_NUM VARCHAR2 (30)
Inventory Supplier Ship to Site Number
FIXED_ASSET_LINE_ID NUMBER

Fixed Asset Line ID
FA_ASSET_KEY_ID NUMBER

Asset Key ID in Fixed Assets
FA_ASSET_KEY VARCHAR2 (320)
Asset Key in Fixed Assets
FA_MANUFACTURER_NAME VARCHAR2 (30)
Manufacturer Name in Fixed Assets
FA_ASSET_LOCATION_ID NUMBER

Asset Location ID in Fixed Assets
FA_ASSET_LOCATION_NAME VARCHAR2 (216)
Asset Location Name in Fixed Assets
FA_MODEL_NUMBER VARCHAR2 (40)
Model Number in Fixed Assets
FA_ASSET_ID NUMBER

Asset ID in Fixed Assets
FA_CORP_BOOK_TYPE_CODE VARCHAR2 (15)
Corporate Book Type Code in Fixed Assets
FA_CORPORATE_BOOK VARCHAR2 (30)
Corporate Book in Fixed Assets
FA_CORP_SAL_VALUE_BASIS_CODE VARCHAR2 (30)
Salvage Value Basis Code of Fixed Asset Corporate Book
FA_CORP_SAL_VALUE_BASIS VARCHAR2 (80)
Salvage Value Basis of Fixed Asset Corporate Book
FA_CORP_SALVAGE_VALUE NUMBER

Salvage Value of Fixed Asset Corporate Book
FA_CORP_SALVAGE_VALUE_PERCENT NUMBER

Salvage Value Percentage of Fixed Asset Corporate Book
FA_CORP_DEP_RATE NUMBER

Depreciation Rate of Fixed Asset Corporate Book
FA_CORP_DEP_LIFE_IN_MONTHS NUMBER (4)
Depreciation Life in Months of Fixed Asset Corporate Book
FA_CORP_DEP_METHOD_CODE VARCHAR2 (12)
Depreciation Method Code of Fixed Asset Corporate Book
FA_CORP_DEP_METHOD_ID NUMBER (15)
Depreciation Method ID of Fixed Asset Corporate Book
FA_CORP_DEP_METHOD_NAME VARCHAR2 (80)
Depreciation Method Name of Fixed Asset Corporate Book
FA_CORP_CATEGORY_ID NUMBER (15)
Asset Category ID in Fixed Asset
FA_CORP_CATEGORY VARCHAR2 (240)
Asset Category in Fixed Asset
FA_CORP_ORIG_COST NUMBER

Original Cost in Fixed Asset Corporate Book
FA_CORP_DEP_COST NUMBER

Depreciable Cost in Fixed Asset Corporate Book
FA_CORP_DATE_IN_SERVICE DATE

Date In Service in Fixed Asset Corporate Book
FA_TAX_BOOK_TYPE_CODE VARCHAR2 (15)
Tax Book Type Code in Fixed Assets
FA_TAX_BOOK VARCHAR2 (30)
Tax Book in Fixed Assets
FA_TAX_SAL_VALUE_BASIS_CODE VARCHAR2 (30)
Salvage Value Basis Code of Fixed Asset Tax Book
FA_TAX_SAL_VALUE_BASIS VARCHAR2 (80)
Salvage Value Basis of Fixed Asset Tax Book
FA_TAX_SALVAGE_VALUE NUMBER

Salvage Value of Fixed Asset Tax Book
FA_TAX_SALVAGE_VALUE_PERCENT NUMBER

Salvage Value Percentage of Fixed Asset Tax Book
FA_TAX_DEP_RATE NUMBER

Depreciation Rate of Fixed Asset Tax Book
FA_TAX_DEP_LIFE_IN_MONTHS NUMBER (4)
Depreciation Life in Months of Fixed Asset Tax Book
FA_TAX_DEP_METHOD_CODE VARCHAR2 (12)
Depreciation Method Code of Fixed Asset Tax Book
FA_TAX_DEP_METHOD_ID NUMBER (15)
Depreciation Method ID of Fixed Asset Tax Book
FA_TAX_DEP_METHOD_NAME VARCHAR2 (80)
Depreciation Method Name of Fixed Asset Tax Book
FA_TAX_ORIG_COST NUMBER

Original Cost in Fixed Asset Tax Book
FA_TAX_DEP_COST NUMBER

Depreciable Cost in Fixed Asset Tax Book
FA_TAX_DATE_IN_SERVICE DATE

Date In Service in Fixed Asset Tax Book
FEE_OR_SERVICE_NAME VARCHAR2 (150)
Fee or Service Name
FEE_OR_SERVICE_EFFECTIVE_FROM DATE

Effective From Date for Fee or Service Line
FEE_OR_SERVICE_EFFECTIVE_TO DATE

Effective To Date for Fee or Service Line
FEE_OR_SERVICE_TOTAL_AMOUNT NUMBER (14)
Total Amount of Fee or Service Line
FEE_OR_SERV_NUMBER_OF_PERIODS VARCHAR2 (450)
Number of Periods for Fee or Service Line
FEE_OR_SERV_AMOUNT_PER_PERIOD VARCHAR2 (450)
Amount Per Period for Fee or Service Line
FEE_OR_SERVICE_FREQUENCY_CODE VARCHAR2 (40)
Frequency Code for Fee or Service Line
FEE_OR_SERVICE_FREQUENCY VARCHAR2 (80)
Frequency of payment for Fee or Service Line
FEE_TYPE_CODE VARCHAR2 (30)
Fee Type Code
FEE_TYPE VARCHAR2 (80)
Fee Type
FEE_TRX_TAX_YN VARCHAR2 (3)
Fee Transaction Tax Indicator
FEE_INITIAL_DIRECT_COST NUMBER (14)
Fee Initial Direct Cost
FEE_ROLLOVER_QUOTE_ID NUMBER

Quote ID of Termination Quote associated to Rollover Fee
FEE_ROLLOVER_QUOTE_NUMBER NUMBER

Quote Number of Termination Quote associated to Rollover Fee
FEE_ROLLOVER_CONTRACT_NUMBER VARCHAR2 (120)
Contract Number of rollover contract associated to Rollover Fee
SERVICE_CONTRACT_NUMBER VARCHAR2 (120)
Service Contract Number linked to Lease Contract
SERVICE_PAYMENT_TYPE VARCHAR2 (40)
Service Payment Type
INSURANCE_POLICY_ID NUMBER

Insurance Policy ID
INSURANCE_QUOTE_NUMBER VARCHAR2 (20)
Insurance Quote Number
INSURANCE_POLICY_NUMBER VARCHAR2 (20)
Insurance Policy Number
INSURANCE_POLICY_TYPE_CODE VARCHAR2 (30)
Insurance Policy Type Code
INSURANCE_POLICY_TYPE VARCHAR2 (80)
Insurance Policy Type
INSURANCE_POLICY_STATUS_CODE VARCHAR2 (30)
Insurance Policy Status Code
INSURANCE_POLICY_STATUS VARCHAR2 (80)
Insurance Policy Status
INSURANCE_PROVIDER VARCHAR2 (360)
Insurance Provider
INSURANCE_POLICY_LOCATION VARCHAR2 (80)
Insurance Policy Location
INSURANCE_PAYMENT_FREQUENCY VARCHAR2 (80)
Payment Frequency of Insurance Premium
INS_POLICY_LESSOR_INSURED_YN VARCHAR2 (3)
Lessor Insured on Insurance Policy Indicator
INS_POLICY_LESSOR_PAYEE_YN VARCHAR2 (3)
Lessor Payee on Insurance Policy Indicator
INSURANCE_POLICY_EFF_FROM DATE

Effective From Date of Insurance Policy
INSURANCE_POLICY_EFF_TO DATE

Effective To Date of Insurance Policy
INSURANCE_PRODUCT_ID NUMBER

Insurance Product ID
INSURANCE_PRODUCT VARCHAR2 (256)
Insurance Product
INSURANCE_FACTOR_VALUE NUMBER (15)
Insurance Factor Value
INSURANCE_NAME_OF_INSURED VARCHAR2 (256)
Name of Insured on Insurance Policy
INSURANCE_COVERED_AMOUNT NUMBER (14)
Covered Amount on Insurance Policy
INSURANCE_CALC_PREMIUM NUMBER (14)
Calculated Premium on Insurance Policy
INSURANCE_TOT_PREMIUM NUMBER

Total Premium on Insurance Policy
INSURANCE_ACTIVATION_DATE DATE

Activation Date of Insurance Policy
INSURANCE_CANCELLATION_DATE DATE

Cancellation Date of Insurance Policy
INSURANCE_SALES_REP VARCHAR2 (240)
Sales Rep of Insurance Policy
MODEL_LINE_ID NUMBER

Model Line ID in Inventory
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
INVENTORY_ITEM_ORG_ID NUMBER

Inventory Item Org ID
INVENTORY_ITEM_NAME VARCHAR2 (40)
Inventory Item Name
INVENTORY_ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
INVENTORY_TOTAL_UNITS NUMBER

Total Units of Item in Inventory
INVENTORY_UNIT_COST NUMBER

Unit Cost of Item in Inventory
ASSET_FILING_LIEN_TYPE_CODE VARCHAR2 (450)
Filing Lien Type Code of Asset
ASSET_FILING_LIEN_TYPE VARCHAR2 (80)
Filing Lien Type of Asset
ASSET_FILING_LIEN_NUMBER VARCHAR2 (450)
Filing Lien Number of Asset
ASSET_FILING_LIEN_DATE VARCHAR2 (450)
Filing Lien Date of Asset
ASSET_FILING_LIEN_STATUS_CODE VARCHAR2 (450)
Filing Lien Status Code of Asset
ASSET_FILING_LIEN_STATUS VARCHAR2 (80)
Filing Lien Status of Asset
ASSET_FILING_LIENHOLDER VARCHAR2 (360)
Filing Lien Holder of Asset
ASSET_FILING_JURISDICTION VARCHAR2 (450)
Filing Jurisdiction of Asset
ASSET_FILING_SUB_JURISDICTION VARCHAR2 (450)
Filing Sub-Jurisdiction of Asset
ASSET_FILING_LIEN_EXP_DATE VARCHAR2 (450)
Filing Lien Expiration Date of Asset
ASSET_FILING_LIEN_CONT_NUMBER VARCHAR2 (450)
Contract Number associated to Filing Lien
ASSET_FILING_LIEN_CONT_DATE VARCHAR2 (450)
Contract Date associated to Filing Lien
ASSET_FILING_TITLE_TYPE_CODE VARCHAR2 (450)
Title Type Code of Asset
ASSET_FILING_TITLE_TYPE VARCHAR2 (80)
Title Type of Asset
ASSET_FILING_TITLE_NUMBER VARCHAR2 (450)
Title Number of Asset
ASSET_FILING_TITLE_ISSUER VARCHAR2 (360)
Title Issuer of Asset
ASSET_FILING_TITLE_DATE VARCHAR2 (450)
Title Date of Asset
ASSET_FILING_TITLE_CUSTODIAN VARCHAR2 (360)
Title Custodian of Asset
ASSET_FILING_TITLE_REGIS_NUM VARCHAR2 (450)
Title Registration Number of Asset
ASSET_FILING_TITLE_LOCATION VARCHAR2 (450)
Title Location of Asset
ASSET_FILING_TITLE_REGIS_LOC VARCHAR2 (450)
Title Registration Location of Asset
ASSET_FILING_PAYEE_SITE VARCHAR2 (450)
Filing Payee Site of Asset
ASSET_FILING_REGIS_EXP_DATE VARCHAR2 (450)
Filing Registration Expiration Date of Asset
LINE_PTH_EVG_PAYOUT_BASIS_CODE VARCHAR2 (30)
Payout Basis Code for Evergreen Passthrough
LINE_PTH_EVG_PAYOUT_BASIS VARCHAR2 (80)
Payout Basis for Evergreen Passthrough
LINE_PTH_EVG_START_DATE DATE

Payout Start Date for Evergreen Passthrough
LINE_PTH_EVG_PYOUT_FORMULA_ID NUMBER

Payout Formula ID for Evergreen Passthrough
LINE_PTH_EVG_PYOUT_FORMULA VARCHAR2 (150)
Payout Formula for Evergreen Passthrough
LINE_PTH_EVG_STREAM_TYPE_ID NUMBER

Stream Type ID for Evergreen Passthrough
LINE_PTH_EVG_STREAM_TYPE_CODE VARCHAR2 (150)
Stream Type Code for Evergreen Passthrough
LINE_PTH_EVG_STREAM_TYPE VARCHAR2 (150)
Stream Type for Evergreen Passthrough
LINE_PTH_BASE_PAY_BASIS_CODE VARCHAR2 (30)
Payout Basis Code for Base Term Passthrough
LINE_PTH_BASE_PAYOUT_BASIS VARCHAR2 (80)
Payout Basis for Base Term Passthrough
LINE_PTH_BASE_STREAM_TYPE_ID NUMBER

Stream Type ID for Base Term Passthrough
LINE_PTH_BASE_STREAM_TYPE_CODE VARCHAR2 (150)
Stream Type Code for Base Term Passthrough
LINE_PTH_BASE_STREAM_TYPE VARCHAR2 (150)
Stream Type for Base Term Passthrough
LINE_PTH_BASE_START_DATE DATE

Payout Start Date for Base Term Passthrough
IB_INSTALL_SITE_ID NUMBER (15)
Primary Site ID in Install Base
IB_INSTALL_SITE_NUMBER VARCHAR2 (30)
Site Number in Install Base
IB_INSTALL_SITE_USE_ID NUMBER

Site Use ID in Install Base
IB_INSTALL_SITE VARCHAR2 (80)
Install Site in Install Base
IB_SERIAL_NUMBER VARCHAR2 (30)
Serial Number in Install Base
FA_MG_BOOK_TYPE_CODE VARCHAR2 (15)
Multi-GAAP Book Type Code in Fixed Assets
FA_MG_BOOK VARCHAR2 (30)
Multi-GAAP Book in Fixed Assets
FA_MG_SAL_VALUE_BASIS_CODE VARCHAR2 (30)
Salvage Value Basis Code of FA Multi-GAAP Book
FA_MG_SAL_VALUE_BASIS VARCHAR2 (80)
Salvage Value Basis of FA Multi-GAAP Book
FA_MG_SALVAGE_VALUE NUMBER

Salvage Value of FA Multi-GAAP Book
FA_MG_SALVAGE_VALUE_PERCENT NUMBER

Salvage Value Percentage of FA Multi-GAAP Book
FA_MG_DEP_RATE NUMBER

Depreciation Rate of FA Multi-GAAP Book
FA_MG_DEP_LIFE_IN_MONTHS NUMBER (4)
Depreciation Life in Months of FA Multi-GAAP Book
FA_MG_DEP_METHOD_CODE VARCHAR2 (12)
Depreciation Method Code of FA Multi-GAAP Book
FA_MG_DEP_METHOD_ID NUMBER (15)
Depreciation Method ID of FA Multi-GAAP Book
FA_MG_DEP_METHOD_NAME VARCHAR2 (80)
Depreciation Method Name of FA Multi-GAAP Book
FA_MG_ORIG_COST NUMBER

Original Cost in FA Multi-GAAP Book
FA_MG_DEP_COST NUMBER

Depreciable Cost in FA Multi-GAAP Book
FA_MG_DATE_IN_SERVICE DATE

Date In Service in FA Multi-GAAP Book
USAGE_PRICE_LIST_ID NUMBER

Price List Id associated to Usage Line
USAGE_PRICE_LIST_NAME VARCHAR2 (240)
Price List Name associated to Usage Line
USAGE_PERIOD_CODE VARCHAR2 (450)
Usage Period Code
USAGE_PERIOD VARCHAR2 (450)
Usage Period
USAGE_NO_OF_PERIOD NUMBER

Usage Number of Periods
USAGE_MINIMUM_QTY NUMBER

Minimum Quantity associated to Usage Line
USAGE_LEVEL_FLAG VARCHAR2 (450)
Usage Level Flag
USAGE_DEFAULT_QUANTITY NUMBER

Default Quantity associated to Usage Line
USAGE_BASE_READING_UOM_CODE VARCHAR2 (40)
UOM Code for Usage Based Reading
USAGE_BASE_READING_UOM VARCHAR2 (80)
UOM for Usage Based Reading
USAGE_BASE_READING VARCHAR2 (450)
Usage Based Reading
USAGE_AVG_MONTHLY_COUNTER_FLAG VARCHAR2 (450)
Average Monthly Counter Flag for Usage Line
USAGE_TYPE_CODE VARCHAR2 (450)
Usage Type Code
USAGE_TYPE VARCHAR2 (80)
Usage Type
USAGE_FIXED_QUANTITY NUMBER

Fixed Quantity for Usage
LINE_ACCUMULATED_DEPRECIATION NUMBER

Total Accumulated Depreciation for contract line
LINE_CAPITALIZED_REDUCTION NUMBER

Total Capitalized Reduction for contract line
LINE_CAPITALIZED_INTEREST NUMBER

Total Capitalized Interest for contract line
LINE_DISCOUNT NUMBER

Total Discount for contract line
LINE_UNBILLED_DUE_AMOUNT NUMBER

Total Unbilled Amount Due for contract line
LINE_OEC NUMBER

Original Equipment Cost for asset
LINE_CAP_AMOUNT NUMBER

Total Capitalized Amount
LINE_ASSET_COST NUMBER

Total Asset Cost
LINE_RESIDUAL_AMOUNT NUMBER

Total Residual amount for asset
LINE_RENT_AMOUNT NUMBER

Total Rent amount for asset
LINE_NET_INVESTMENT NUMBER

Net Investment in contract currency
LINE_NET_INVESTMENT_FUNC NUMBER

Net Investment in functional currency
LINE_BILLED_RENTS NUMBER

Total Billed Rents for asset in contract currency
LINE_BILLED_RENTS_FUNC NUMBER

Total Billed Rents for asset in functional currency
LINE_BILLED_NON_RENTS NUMBER

Total Billed Non-rents for asset in contract currency
LINE_BILLED_NON_RENTS_FUNC NUMBER

Total Billed Non-rents for asset in functional currency
ASSETS_FUNDED_AMOUNT NUMBER

Total Asset Funded Amount
EXPENSE_FUNDED_AMOUNT NUMBER

Total Expense Funded Amount
ASSET_TERMINATION_DATE DATE

Termination Date of Asset
TOTAL_ASSET_ADDON_COST NUMBER

Total Asset Addon Cost
TOTAL_ASSET_SUBSIDY_AMOUNT NUMBER

Total Asset Subsidy Amount
TOTAL_ASSET_SUBSIDY_OVRD_AMT NUMBER

Total Asset Subsidy Override Amount
TOTAL_ASSET_CAP_SERVICE_AMOUNT NUMBER

Total Asset Capitalized Service Amount
TOTAL_ASSET_CAP_FEE_AMOUNT NUMBER

Total Asset Capitalized Fee Amount
TOTAL_ASSET_FINANCED_FEE_AMT NUMBER

Total Asset Financed Fee Amount
TOTAL_ASSET_ROLLOVER_FEE_AMT NUMBER

Total Asset Rollover Fee Amount
TOTAL_ASSET_TRADEIN_AMOUNT NUMBER

Total Asset Tradein Amount
TOTAL_ACTIVE_LINE_FINANCED_AMT NUMBER

Total Active Line Financed Amount
CONTRACT_LINE_DFF_CATEGORY VARCHAR2 (90)
DFF Category associated to contract line
CONTRACT_LINE_DFF1 VARCHAR2 (450)
DFF 1 associated to contract line
CONTRACT_LINE_DFF2 VARCHAR2 (450)
DFF 2 associated to contract line
CONTRACT_LINE_DFF3 VARCHAR2 (450)
DFF 3 associated to contract line
CONTRACT_LINE_DFF4 VARCHAR2 (450)
DFF 4 associated to contract line
CONTRACT_LINE_DFF5 VARCHAR2 (450)
DFF 5 associated to contract line
CONTRACT_LINE_DFF6 VARCHAR2 (450)
DFF 6 associated to contract line
CONTRACT_LINE_DFF7 VARCHAR2 (450)
DFF 7 associated to contract line
CONTRACT_LINE_DFF8 VARCHAR2 (450)
DFF 8 associated to contract line
CONTRACT_LINE_DFF9 VARCHAR2 (450)
DFF 9 associated to contract line
CONTRACT_LINE_DFF10 VARCHAR2 (450)
DFF 10 associated to contract line
CONTRACT_LINE_DFF11 VARCHAR2 (450)
DFF 11 associated to contract line
CONTRACT_LINE_DFF12 VARCHAR2 (450)
DFF 12 associated to contract line
CONTRACT_LINE_DFF13 VARCHAR2 (450)
DFF 13 associated to contract line
CONTRACT_LINE_DFF14 VARCHAR2 (450)
DFF 14 associated to contract line
CONTRACT_LINE_DFF15 VARCHAR2 (450)
DFF 15 associated to contract line
Query Text

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


SELECT REQUEST_ID
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      CONTRACT_NUMBER
,      CONTRACT_OPERATING_UNIT_ID
,      OPERATING_UNIT
,      OPERATING_UNIT_SHORT_CODE
,      CONTRACT_STATUS_TYPE_CODE
,      CONTRACT_STATUS_CODE
,      CONTRACT_STATUS
,      CONTRACT_CURRENCY
,      CONTRACT_CURRENCY_CONV_TYPE
,      CONTRACT_CURRENCY_CONV_RATE
,      CONTRACT_CURRENCY_CONV_DATE
,      FUNCTIONAL_CURRENCY
,      CONTRACT_START_DATE
,      CONTRACT_END_DATE
,      CONTRACT_FINANCIAL_PRODUCT_ID
,      CONTRACT_FINANCIAL_PRODUCT
,      CONTRACT_REPORTING_PRODUCT_ID
,      CONTRACT_REPORTING_PRODUCT
,      INTEREST_CALCLATION_BASIS_CODE
,      REVENUE_RECOGNTION_METHOD_CODE
,      INTEREST_CALCULATION_BASIS
,      REVENUE_RECOGNITION_METHOD
,      CONTRACT_INTEREST_INDEX_ID
,      CONTRACT_INTEREST_INDEX
,      CONTRACT_TERM_DURATION
,      CONTRACT_BOOK_CLASS_CODE
,      CONTRACT_BOOK_CLASSIFICATION
,      CONTRACT_LEGAL_ENTITY_ID
,      LEGAL_ENTITY
,      LEDGER_ID
,      LEDGER
,      CNTRCT_CUSTOMER_PARTY_NAME
,      CNTRCT_CUST_PARTY_ID
,      CNTRCT_CUST_PARTY_NUMBER
,      CNTRCT_CUST_ACOUNT_ID
,      CNTRCT_CUST_ACCT_NUMBER
,      CNTRCT_CUST_PARTY_SITE_ID
,      CNTRCT_CUST_PARTY_SITE_NUM
,      CNTRCT_CUST_PARTY_SITE_NAME
,      CNTRCT_CUST_PARTY_SITE_LOC_ID
,      CNTRCT_CUST_PARTY_SITE_USE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_UPDATE_DATE
,      CONTRACT_LINE_TYPE_ID
,      CONTRACT_LINE_TYPE_CODE
,      CONTRACT_LINE_TYPE_NAME
,      CONTRACT_LINE_NAME
,      CONTRACT_LINE_STATUS_CODE
,      CONTRACT_LINE_STATUS
,      ASSET_DATE_DELIVERY_EXPECTED
,      ASSET_DATE_FUNDING_EXPECTED
,      ASSET_RESIDUAL_PERCENT
,      ASSET_RES_GUARANTOR_TYPE_CODE
,      ASSET_RES_GUARANTOR_TYPE
,      ASSET_RESIDUAL_AMT_GUARANTEE
,      ASSET_RESIDUAL_AMOUNT
,      ASSET_UPFRONT_TAX
,      ASSET_BILL_TO_SITE_USE_ID
,      ASSET_BILL_TO_ADDRESS
,      ASSET_BILLING_PAYMENT_METHOD
,      ASSET_BILLING_BANK_ACCOUNT
,      ASSET_BILLING_BANK
,      ASSET_ST_TRANSFER_OF_TITLE
,      ASSET_ST_SALE_AND_LEASE_BACK
,      ASSET_ST_PURCHASE_OF_LEASE
,      ASSET_ST_INTENDED_USE
,      ASSET_ST_ASSET_UPFRONT_TAX
,      ASSET_ST_EQUIPMENT_AGE
,      ASSET_PROP_TAX_APPLICABLE
,      ASSET_PROP_TAX_LESSEE_REPORT
,      ASSET_PROP_TAX_BILL_METHOD
,      LINE_SUPPLIER_ID
,      LINE_SUPPLIER_NUMBER
,      LINE_SUPPLIER
,      INV_SUPPLR_SHIP_TO_SITE_USE_ID
,      INV_SUPPLIER_SHIP_TO_SITE
,      INV_SUPPLIER_INVOICE_LINE_ID
,      INV_SUPPLIER_INVOICE_NUMBER
,      INV_SUPPLIER_INVOICE_DATE
,      INV_SUPPLIER_SHIP_TO_SITE_ID
,      INV_SUPPLIER_SHIP_TO_SITE_NUM
,      FIXED_ASSET_LINE_ID
,      FA_ASSET_KEY_ID
,      FA_ASSET_KEY
,      FA_MANUFACTURER_NAME
,      FA_ASSET_LOCATION_ID
,      FA_ASSET_LOCATION_NAME
,      FA_MODEL_NUMBER
,      FA_ASSET_ID
,      FA_CORP_BOOK_TYPE_CODE
,      FA_CORPORATE_BOOK
,      FA_CORP_SAL_VALUE_BASIS_CODE
,      FA_CORP_SAL_VALUE_BASIS
,      FA_CORP_SALVAGE_VALUE
,      FA_CORP_SALVAGE_VALUE_PERCENT
,      FA_CORP_DEP_RATE
,      FA_CORP_DEP_LIFE_IN_MONTHS
,      FA_CORP_DEP_METHOD_CODE
,      FA_CORP_DEP_METHOD_ID
,      FA_CORP_DEP_METHOD_NAME
,      FA_CORP_CATEGORY_ID
,      FA_CORP_CATEGORY
,      FA_CORP_ORIG_COST
,      FA_CORP_DEP_COST
,      FA_CORP_DATE_IN_SERVICE
,      FA_TAX_BOOK_TYPE_CODE
,      FA_TAX_BOOK
,      FA_TAX_SAL_VALUE_BASIS_CODE
,      FA_TAX_SAL_VALUE_BASIS
,      FA_TAX_SALVAGE_VALUE
,      FA_TAX_SALVAGE_VALUE_PERCENT
,      FA_TAX_DEP_RATE
,      FA_TAX_DEP_LIFE_IN_MONTHS
,      FA_TAX_DEP_METHOD_CODE
,      FA_TAX_DEP_METHOD_ID
,      FA_TAX_DEP_METHOD_NAME
,      FA_TAX_ORIG_COST
,      FA_TAX_DEP_COST
,      FA_TAX_DATE_IN_SERVICE
,      FEE_OR_SERVICE_NAME
,      FEE_OR_SERVICE_EFFECTIVE_FROM
,      FEE_OR_SERVICE_EFFECTIVE_TO
,      FEE_OR_SERVICE_TOTAL_AMOUNT
,      FEE_OR_SERV_NUMBER_OF_PERIODS
,      FEE_OR_SERV_AMOUNT_PER_PERIOD
,      FEE_OR_SERVICE_FREQUENCY_CODE
,      FEE_OR_SERVICE_FREQUENCY
,      FEE_TYPE_CODE
,      FEE_TYPE
,      FEE_TRX_TAX_YN
,      FEE_INITIAL_DIRECT_COST
,      FEE_ROLLOVER_QUOTE_ID
,      FEE_ROLLOVER_QUOTE_NUMBER
,      FEE_ROLLOVER_CONTRACT_NUMBER
,      SERVICE_CONTRACT_NUMBER
,      SERVICE_PAYMENT_TYPE
,      INSURANCE_POLICY_ID
,      INSURANCE_QUOTE_NUMBER
,      INSURANCE_POLICY_NUMBER
,      INSURANCE_POLICY_TYPE_CODE
,      INSURANCE_POLICY_TYPE
,      INSURANCE_POLICY_STATUS_CODE
,      INSURANCE_POLICY_STATUS
,      INSURANCE_PROVIDER
,      INSURANCE_POLICY_LOCATION
,      INSURANCE_PAYMENT_FREQUENCY
,      INS_POLICY_LESSOR_INSURED_YN
,      INS_POLICY_LESSOR_PAYEE_YN
,      INSURANCE_POLICY_EFF_FROM
,      INSURANCE_POLICY_EFF_TO
,      INSURANCE_PRODUCT_ID
,      INSURANCE_PRODUCT
,      INSURANCE_FACTOR_VALUE
,      INSURANCE_NAME_OF_INSURED
,      INSURANCE_COVERED_AMOUNT
,      INSURANCE_CALC_PREMIUM
,      INSURANCE_TOT_PREMIUM
,      INSURANCE_ACTIVATION_DATE
,      INSURANCE_CANCELLATION_DATE
,      INSURANCE_SALES_REP
,      MODEL_LINE_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_ORG_ID
,      INVENTORY_ITEM_NAME
,      INVENTORY_ITEM_DESCRIPTION
,      INVENTORY_TOTAL_UNITS
,      INVENTORY_UNIT_COST
,      ASSET_FILING_LIEN_TYPE_CODE
,      ASSET_FILING_LIEN_TYPE
,      ASSET_FILING_LIEN_NUMBER
,      ASSET_FILING_LIEN_DATE
,      ASSET_FILING_LIEN_STATUS_CODE
,      ASSET_FILING_LIEN_STATUS
,      ASSET_FILING_LIENHOLDER
,      ASSET_FILING_JURISDICTION
,      ASSET_FILING_SUB_JURISDICTION
,      ASSET_FILING_LIEN_EXP_DATE
,      ASSET_FILING_LIEN_CONT_NUMBER
,      ASSET_FILING_LIEN_CONT_DATE
,      ASSET_FILING_TITLE_TYPE_CODE
,      ASSET_FILING_TITLE_TYPE
,      ASSET_FILING_TITLE_NUMBER
,      ASSET_FILING_TITLE_ISSUER
,      ASSET_FILING_TITLE_DATE
,      ASSET_FILING_TITLE_CUSTODIAN
,      ASSET_FILING_TITLE_REGIS_NUM
,      ASSET_FILING_TITLE_LOCATION
,      ASSET_FILING_TITLE_REGIS_LOC
,      ASSET_FILING_PAYEE_SITE
,      ASSET_FILING_REGIS_EXP_DATE
,      LINE_PTH_EVG_PAYOUT_BASIS_CODE
,      LINE_PTH_EVG_PAYOUT_BASIS
,      LINE_PTH_EVG_START_DATE
,      LINE_PTH_EVG_PYOUT_FORMULA_ID
,      LINE_PTH_EVG_PYOUT_FORMULA
,      LINE_PTH_EVG_STREAM_TYPE_ID
,      LINE_PTH_EVG_STREAM_TYPE_CODE
,      LINE_PTH_EVG_STREAM_TYPE
,      LINE_PTH_BASE_PAY_BASIS_CODE
,      LINE_PTH_BASE_PAYOUT_BASIS
,      LINE_PTH_BASE_STREAM_TYPE_ID
,      LINE_PTH_BASE_STREAM_TYPE_CODE
,      LINE_PTH_BASE_STREAM_TYPE
,      LINE_PTH_BASE_START_DATE
,      IB_INSTALL_SITE_ID
,      IB_INSTALL_SITE_NUMBER
,      IB_INSTALL_SITE_USE_ID
,      IB_INSTALL_SITE
,      IB_SERIAL_NUMBER
,      FA_MG_BOOK_TYPE_CODE
,      FA_MG_BOOK
,      FA_MG_SAL_VALUE_BASIS_CODE
,      FA_MG_SAL_VALUE_BASIS
,      FA_MG_SALVAGE_VALUE
,      FA_MG_SALVAGE_VALUE_PERCENT
,      FA_MG_DEP_RATE
,      FA_MG_DEP_LIFE_IN_MONTHS
,      FA_MG_DEP_METHOD_CODE
,      FA_MG_DEP_METHOD_ID
,      FA_MG_DEP_METHOD_NAME
,      FA_MG_ORIG_COST
,      FA_MG_DEP_COST
,      FA_MG_DATE_IN_SERVICE
,      USAGE_PRICE_LIST_ID
,      USAGE_PRICE_LIST_NAME
,      USAGE_PERIOD_CODE
,      USAGE_PERIOD
,      USAGE_NO_OF_PERIOD
,      USAGE_MINIMUM_QTY
,      USAGE_LEVEL_FLAG
,      USAGE_DEFAULT_QUANTITY
,      USAGE_BASE_READING_UOM_CODE
,      USAGE_BASE_READING_UOM
,      USAGE_BASE_READING
,      USAGE_AVG_MONTHLY_COUNTER_FLAG
,      USAGE_TYPE_CODE
,      USAGE_TYPE
,      USAGE_FIXED_QUANTITY
,      LINE_ACCUMULATED_DEPRECIATION
,      LINE_CAPITALIZED_REDUCTION
,      LINE_CAPITALIZED_INTEREST
,      LINE_DISCOUNT
,      LINE_UNBILLED_DUE_AMOUNT
,      LINE_OEC
,      LINE_CAP_AMOUNT
,      LINE_ASSET_COST
,      LINE_RESIDUAL_AMOUNT
,      LINE_RENT_AMOUNT
,      LINE_NET_INVESTMENT
,      LINE_NET_INVESTMENT_FUNC
,      LINE_BILLED_RENTS
,      LINE_BILLED_RENTS_FUNC
,      LINE_BILLED_NON_RENTS
,      LINE_BILLED_NON_RENTS_FUNC
,      ASSETS_FUNDED_AMOUNT
,      EXPENSE_FUNDED_AMOUNT
,      ASSET_TERMINATION_DATE
,      TOTAL_ASSET_ADDON_COST
,      TOTAL_ASSET_SUBSIDY_AMOUNT
,      TOTAL_ASSET_SUBSIDY_OVRD_AMT
,      TOTAL_ASSET_CAP_SERVICE_AMOUNT
,      TOTAL_ASSET_CAP_FEE_AMOUNT
,      TOTAL_ASSET_FINANCED_FEE_AMT
,      TOTAL_ASSET_ROLLOVER_FEE_AMT
,      TOTAL_ASSET_TRADEIN_AMOUNT
,      TOTAL_ACTIVE_LINE_FINANCED_AMT
,      CONTRACT_LINE_DFF_CATEGORY
,      CONTRACT_LINE_DFF1
,      CONTRACT_LINE_DFF2
,      CONTRACT_LINE_DFF3
,      CONTRACT_LINE_DFF4
,      CONTRACT_LINE_DFF5
,      CONTRACT_LINE_DFF6
,      CONTRACT_LINE_DFF7
,      CONTRACT_LINE_DFF8
,      CONTRACT_LINE_DFF9
,      CONTRACT_LINE_DFF10
,      CONTRACT_LINE_DFF11
,      CONTRACT_LINE_DFF12
,      CONTRACT_LINE_DFF13
,      CONTRACT_LINE_DFF14
,      CONTRACT_LINE_DFF15
FROM OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T;

Dependencies

[top of page]

OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T does not reference any database object

OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T is referenced by following:

SchemaAPPS
SynonymOKL_CNTRCT_LINE_FIN_EXTRACT_T