[Home] [Help]
[Dependency Information]
Object Name: | OKL_CNTRCT_LINE_FIN_EXTRACT_T |
---|---|
Object Type: | TABLE |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Table for Contract Line Financial Extract
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_CNTRCT_LINE_FIN_EXT_T_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() |
OKL_CNTRCT_LINE_FIN_EXT_T_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() |
OKL_CNTRCT_LINE_FIN_EXT_T_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
OKL_CNTRCT_LINE_FIN_EXT_T_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
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 |
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;
OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T does not reference any database object
OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T is referenced by following:
|
|
|