[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CNTRCT_FIN_EXTRACT_T |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| Subobject Name: | |
| Status: | VALID |
Table to run contract Financial Report
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKL_CNTRCT_FIN_EXTRACT_T_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REQUEST_ID
CONTRACT_ID
|
| OKL_CNTRCT_FIN_EXTRACT_T_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
CONTRACT_START_DATE
CONTRACT_STATUS
|
| OKL_CNTRCT_FIN_EXTRACT_T_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_PARTY_NAME
REQUEST_ID
CONTRACT_START_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | Yes | Request Identifier | |
| CONTRACT_ID | NUMBER | Yes | Contract Identifier | |
| CONTRACT_DOCUMENT_ID | NUMBER | Contract Document Identifier | ||
| CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
| CONTRACT_OPERATING_UNIT_ID | NUMBER | Yes | Operating unit identifier for the contract | |
| CONTRACT_INVENTORY_ORG_ID | NUMBER | Inventory org identifier for the contract | ||
| CONTRACT_STATUS_CODE | VARCHAR2 | (30) | Contract Status Code of the contract | |
| CONTRACT_CURRENCY | VARCHAR2 | (15) | Contract Currency | |
| CONTRACT_TEMPLATE_INDICATOR | VARCHAR2 | (3) | Indicates whether contract is stored as a Contract Template | |
| CONTRACT_CUST_PURCH_ORDER_NUM | VARCHAR2 | (150) | Customer Purchase Order Number for the contract | |
| CONTRACT_TEMPLATE_NAME | VARCHAR2 | (120) | Contract Template Name used to create the contract | |
| CONTRACT_APPROVED_DATE | DATE | Date the contract was approved | ||
| CONTRACT_CANCELED_TIMESTAMP | DATE | Date and time the contract was cancelled | ||
| CONTRACT_SIGNED_DATE | DATE | Date the contract was signed | ||
| CONTRACT_TERMINATION_DATE | DATE | Date the contract was terminated | ||
| CONTRACT_START_DATE | DATE | Start Date of the contract | ||
| CONTRACT_END_DATE | DATE | End Date of the contract | ||
| CUSTOMER_ACCOUNT_ID | NUMBER | (15) | Customer Account ID of the Lessee on the contract | |
| CUST_BILL_TO_SITE_USE_ID | NUMBER | (15) | Customer Bill-To Site Use ID of the Lessee on the contract | |
| CUST_PAYMENT_TERM_ID | NUMBER | (15) | Identifies the Customer Payment Terms | |
| CONTRACT_ORIG_SYSTEM_SOURCE | VARCHAR2 | (30) | Identifies the source of the contract | |
| CONTRACT_SALES_REGION_ID | NUMBER | Sales Region ID associated to contract | ||
| VENDOR_PROGRAM_ID | NUMBER | Primary ID of Vendor Program Agreement associated to contract | ||
| CONTRACT_FINANCIAL_PRODUCT_ID | NUMBER | Financial Product identifier associated to contract | ||
| CONTRACT_DATE_DEAL_ACTIVATED | DATE | Date the contract was activated | ||
| CONTRACT_DATE_DEAL_TRANSFERD | DATE | Date the contract was transferred | ||
| CONTRACT_TERM_DURATION | NUMBER | (10) | Term of contract | |
| CONTRACT_HDR_DFF_CATEGORY | VARCHAR2 | (90) | DFF Category associated to contract | |
| CONTRACT_HDR_DFF1 | VARCHAR2 | (450) | DFF 1 associated to contract | |
| CONTRACT_HDR_DFF2 | VARCHAR2 | (450) | DFF 2 associated to contract | |
| CONTRACT_HDR_DFF3 | VARCHAR2 | (450) | DFF 3 associated to contract | |
| CONTRACT_HDR_DFF4 | VARCHAR2 | (450) | DFF 4 associated to contract | |
| CONTRACT_HDR_DFF5 | VARCHAR2 | (450) | DFF5 associated to contract | |
| CONTRACT_HDR_DFF6 | VARCHAR2 | (450) | DFF 6 associated to contract | |
| CONTRACT_HDR_DFF7 | VARCHAR2 | (450) | DFF 7 associated to contract | |
| CONTRACT_HDR_DFF8 | VARCHAR2 | (450) | DFF 8 associated to contract | |
| CONTRACT_HDR_DFF9 | VARCHAR2 | (450) | DFF 9 associated to contract | |
| CONTRACT_HDR_DFF10 | VARCHAR2 | (450) | DFF 10 associated to contract | |
| CONTRACT_HDR_DFF11 | VARCHAR2 | (450) | DFF 11 associated to contract | |
| CONTRACT_HDR_DFF12 | VARCHAR2 | (450) | DFF 12 associated to contract | |
| CONTRACT_HDR_DFF13 | VARCHAR2 | (450) | DFF 13 associated to contract | |
| CONTRACT_HDR_DFF14 | VARCHAR2 | (450) | DFF 14 associated to contract | |
| CONTRACT_HDR_DFF15 | VARCHAR2 | (450) | DFF 15 associated to contract | |
| CONTRACT_ACCRUAL_STATUS | VARCHAR2 | (3) | Indicates whether the Accrual program has processed the accrual amount on contract | |
| CONTRACT_GEN_ACCRUAL_OVRIDE_YN | VARCHAR2 | (3) | Indicates whether the Accrual program should not process the accrual on contract | |
| CONTRACT_CREDIT_ACT_YN | VARCHAR2 | (3) | Indicates whether contract is associated to a Consumer Credit Act Deal | |
| CONTRACT_CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | Indicates whether the contract has been converted from another account | |
| CONTRACT_AFTER_TAX_YIELD | NUMBER | After Tax Yield of the contract | ||
| CONTRACT_IMPL_INTEREST_RATE | NUMBER | Implicit Interest Rate of the contract | ||
| CONTRACT_LAST_INT_CALC_DATE | DATE | Date the interest was last calculated for pre-funding and variable rate contracts | ||
| CONTRACT_BOOK_CLASS_CODE | VARCHAR2 | (30) | Contract Book Class Code | |
| CONTRACT_BOOK_CLASSIFICATION | VARCHAR2 | (80) | Deal type of the contract | |
| CONTRACT_PRE_TAX_IRR | NUMBER | Pre Tax Internal Rate of Return of the contract | ||
| CONTRACT_AFTER_TAX_IRR | NUMBER | After Tax Internal Rate of Return of the contract | ||
| CONTRACT_EXP_DELIVERY_DATE | DATE | Financial Asset Expected Delivery Date | ||
| CONTRACT_ACCEPTANCE_DATE | DATE | Contract Acceptance Date | ||
| CONTRACT_PREFUND_ELIG_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for Pre-funding | |
| CONTRACT_REVOL_CREDIT_ELIG_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for Revolving Credit Line | |
| 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 | ||
| CONTRACT_MULTI_GAAP_ELIG_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for Multi-GAAP Accounting | |
| CONTRACT_INVESTOR_ASSIGN_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible to be assigned to an Investor Agreement | |
| CONTRACT_SECURITIZATION_TYPE | VARCHAR2 | (30) | Type of securitization of the contract | |
| CONTRACT_SUB_AFTER_TAX_YIELD | NUMBER | Subsidized After Tax Yield of the contract | ||
| CONTRACT_SUB_IMPL_INT_RATE | NUMBER | Subsidized Implicit Interest Rate of the contract | ||
| CONTRACT_SUB_PRE_TAX_IRR | NUMBER | Subsidized Pre Tax Internal Rate of Return of the contract | ||
| CONTRACT_SUB_AFTER_TAX_IRR | NUMBER | Subsidized After Tax Internal Rate of Return of the contract | ||
| CONTRACT_CRDTLINE_TRNSFR_AMT | NUMBER | Total Creditline Transfer Amount of the contract | ||
| CONTRACT_CRDTLINE_NETRNSFR_AMT | NUMBER | Total Creditline Net Transfer Amount of the contract | ||
| CONTRACT_CRDTLINE_LIMIT | NUMBER | Total Creditline Limit for the contract | ||
| CONTRACT_CRDTLINE_FUNDING_AMT | NUMBER | Total Creditline Funding Amount of the contract | ||
| CONTRACT_TEMPL_TYPE_CODE | VARCHAR2 | (30) | Template Type Code used to create the contract | |
| CONTRACT_TRADEIN_DESCRIPTION | VARCHAR2 | (1995) | Description of the Trade-in Amount | |
| CONTRACT_TRADEIN_DATE | DATE | Trade-in Date of the contract | ||
| CONTRACT_LEGAL_ENTITY_ID | NUMBER | Legal Entity ID associated to the contract | ||
| CONTRACT_FIRST_ACTIVITY_DATE | DATE | Date of first activity on the contract | ||
| CONTRACT_ACCUMULATED_DEP | NUMBER | Total Contract Accumulated Depreciation | ||
| CONTRACT_CAPITALIZED_REDUCTION | NUMBER | Total Capitalized Reduction Amount | ||
| CONTRACT_CAPITALIZED_FEE | NUMBER | Total Contract Capitalized Fee Amount | ||
| CONTRACT_CAPITALIZED_INTEREST | NUMBER | Total Capitalized Interest Amount | ||
| CONTRACT_DISCOUNT | NUMBER | Total Contract Discount Amount | ||
| CONTRACT_ASSET_COST | NUMBER | Total Contract Asset Cost | ||
| CONTRACT_FINANCED_FEE | NUMBER | Total Contract Financed Fee Amount | ||
| CONTRACT_NEXT_PAYMENT_AMT | NUMBER | Contract Next Payment Amount | ||
| CONTRACT_TOTAL_ACCRUED_INT | NUMBER | Total Accrued Interest Amount | ||
| CONTRACT_TOTAL_ACTUAL_INT | NUMBER | Total Actual Interest Amount | ||
| CONTRACT_SUBSIDY_AMOUNT | NUMBER | Total Contract Subsidy Amount | ||
| CONTRACT_UNACCRUED_SUBSIDY | NUMBER | Total Contract Unaccrued Subsidy Amount | ||
| CONTRACT_UNBILLED_DUE_AMOUNT | NUMBER | Total Contract Due Unbilled Amount | ||
| CONTRACT_UNBILLED_RECEIVABLES | NUMBER | Total Contract Unbilled Receivables Amount | ||
| CONTRACT_OEC | NUMBER | Total Contract OEC Amount | ||
| CONTRACT_ACTUAL_PRINC_BAL | NUMBER | Total Contract Principal Balance | ||
| ROLLOVER_FEE_AMOUNT | NUMBER | Total Rollover Fee Amount | ||
| CONTRACT_TRADEIN_AMOUNT | NUMBER | Total Trade-in Amount | ||
| TOTAL_AMOUNT_PAID_TO_DEALER | NUMBER | Total Amount Paid to Dealer | ||
| TOTAL_DEBITS_FOR_PREFUNDING | NUMBER | Total debits for pre-funding | ||
| CONTRACT_PREFUNDED_AMOUNT | NUMBER | Contract Prefunded Amount | ||
| CONTRACT_BILLED_RENTS | NUMBER | Total Contract Billed Rents in contract currency | ||
| CONTRACT_BILLED_RENTS_FUNC | NUMBER | Total Contract Billed Rents in functional currency | ||
| CONTRACT_BILLED_NON_RENTS | NUMBER | Total Contract Billed Non-Rents in contract currency | ||
| CONTRACT_BILLED_NON_RENTS_FUNC | NUMBER | Total Contract Billed Non-Rents in functional currency | ||
| SUPPLIER_RETENTION_FUNDING_AMT | NUMBER | Total Supplier Retention Funding Amount | ||
| ASSETS_FUNDED_AMOUNT | NUMBER | Total Asset Funding Amount | ||
| EXPENSE_FUNDED_AMOUNT | NUMBER | Total Expense Funding Amount | ||
| CONTRACT_IDC_AMOUNT | NUMBER | Total Contract IDC Amount | ||
| CONTRACT_SCHEDULED_PRINC_BAL | NUMBER | Total Contract Scheduled Principal Balance | ||
| CONTRACT_INTEREST_RATE | NUMBER | Interest Rate associated with the contract | ||
| CONTRACT_DAYS_TO_ACCRUE | NUMBER | Total Days to Accrue | ||
| CONTRACT_DAYS_IN_YEAR | NUMBER | Total Days in a Year | ||
| CONTRACT_CAP_AMOUNT | NUMBER | Total Capitalized Amount | ||
| CONTRACT_FINANCED_AMOUNT | NUMBER | Total Contract Amount Financed | ||
| CONTRACT_VAR_INCOME_ACCRUAL | NUMBER | Total Contract Variable Income Accrual | ||
| TOTAL_PREFUNDING_AMOUNT | NUMBER | Total prefunding amount | ||
| 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) | Contract Status Type | |
| CONTRACT_STATUS | VARCHAR2 | (90) | Contract Status | |
| CONTRACT_FEE_INCOME | NUMBER | Total Fee Income | ||
| ACC_ENGINE_TEMPL_SET_ID | NUMBER | Accounting Engine Template Set ID associated to contract | ||
| CONTRACT_FIN_PROD_TEMPLATE_ID | NUMBER | Financial Product Template ID associated to contract | ||
| CONTRACT_FINANCIAL_PRODUCT | VARCHAR2 | (150) | Financial Product associated to contract | |
| CONTRACT_FIN_PROD_DESC | VARCHAR2 | (1995) | Financial Product Description associated to contract | |
| REPORTING_PRODUCT_ID | NUMBER | Reporting Product ID associated to contract | ||
| CONTRACT_FIN_PROD_STATUS_CODE | VARCHAR2 | (30) | Financial Product Status Code associated to contract | |
| CONTRACT_FIN_PROD_EFF_FROM_DT | DATE | Financial Product Effective From Date | ||
| CONTRACT_FIN_PROD_EFF_TO_DT | DATE | Financial Product Effective To Date | ||
| REPORTING_PRODUCT | VARCHAR2 | (150) | Reporting Product associated to contract | |
| VENDOR_PROGRAM_NAME | VARCHAR2 | (120) | Name of Vendor Program Agreement associated to contract | |
| VENDOR_NUMBER | VARCHAR2 | (30) | Vendor Number of Vendor Program Agreement | |
| VENDOR_NAME | VARCHAR2 | (360) | Vendor Name of Vendor Program Agreement | |
| VENDOR_TYPE_CODE | VARCHAR2 | (30) | Lease Vendor Party Type Code | |
| VENDOR_BILL_TO_SITE_USE_ID | NUMBER | (15) | Lease Vendor Bill to Site Use Identifier | |
| VENDOR_PARTY_ROLE | VARCHAR2 | (80) | Lease Vendor Party Role | |
| TOTAL_UPFRONT_TAX_ON_ASSETS | NUMBER | Total Upfront Tax for Assets | ||
| TOTAL_NUMBER_OF_ASSETS | NUMBER | Total Number of Assets on the contract | ||
| FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Functional Currency of 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 | |
| CONTRACT_EARLIEST_BILL_DATE | DATE | Earliest billing date for the contract | ||
| CONTRACT_SALES_REP | VARCHAR2 | (360) | Sales Representative of contract | |
| LEGAL_ENTITY | VARCHAR2 | (240) | Legal Entity Name associated to the contract | |
| CUSTOMER_PARTY_NUMBER | VARCHAR2 | (30) | Customer Number associated to contract | |
| CUSTOMER_PARTY_NAME | VARCHAR2 | (360) | Yes | Customer Name associated to contract |
| CUSTOMER_PARTY_TYPE | VARCHAR2 | (30) | Customer Type associated to contract | |
| CUSTOMER_SIC_CODE | VARCHAR2 | (30) | Customer SIC Code from Receivables | |
| CUSTOMER_HQ_BRANCH_IND | VARCHAR2 | (30) | Identifies whether address is a headquarter or a branch | |
| CUSTOMER_TAX_REFERENCE | VARCHAR2 | (50) | Tax Reference of the Customer associated to contract | |
| CUSTOMER_DUNS_NUMBER | NUMBER | DUNS Number of the Customer associated to contract | ||
| CUSTOMER_ALIAS | VARCHAR2 | (240) | Alias of Customer | |
| CUSTOMER_COUNTRY | VARCHAR2 | (60) | Country in customer address associated to contract | |
| CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | Address Line 1 of customer associated to contract | |
| CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | Address Line 2 of customer associated to contract | |
| CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | Address Line 3 of customer associated to contract | |
| CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | Address Line 4 of customer associated to contract | |
| CUSTOMER_CITY | VARCHAR2 | (60) | City in customer address associated to contract | |
| CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | Postal Code in customer address associated to contract | |
| CUSTOMER_STATE | VARCHAR2 | (60) | State in customer address associated to contract | |
| CUSTOMER_PROVINCE | VARCHAR2 | (60) | Province in customer address associated to contract | |
| CUSTOMER_COUNTY | VARCHAR2 | (60) | County in customer address associated to contract | |
| CUSTOMER_SIC_CODE_TYPE | VARCHAR2 | (30) | SIC or Industry Classification of Customer associated to contract | |
| CUSTOMER_URL | VARCHAR2 | (2000) | URL of customer associated to contract | |
| FINANCIAL_INFO_FISCAL_YEAR | VARCHAR2 | (5) | Fiscal Year of Financial Information for Analysis | |
| CUSTOMER_FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | Fiscal Year-End Month of Customer | |
| TOTAL_NUM_OF_EMPLOYEES | NUMBER | Total Number of Employees in the Customer Organization | ||
| CURR_FISC_YEAR_POTENTIAL_REV | NUMBER | Potential Revenue of Current Fiscal Year | ||
| NEXT_FISC_YEAR_POTENTIAL_REV | NUMBER | Potential Revenue of Next Fiscal Year | ||
| CUSTOMER_YEAR_ESTABLISHED | NUMBER | (4) | Year the Customer was established | |
| GEN_SERV_ADMIN_INDICATOR | VARCHAR2 | (1) | Indicates whether Customer is General Services Administration | |
| CUSTOMER_ORG_NAME_PHONETIC | VARCHAR2 | (320) | Organization Name Phonetic (used for Japanese customers) | |
| CUSTOMER_COMPETITOR_YN | VARCHAR2 | (1) | Indicates whether customer is a competitor | |
| CUSTOMER_ALIAS2 | VARCHAR2 | (240) | Alias 2 of Customer | |
| CUSTOMER_ALIAS3 | VARCHAR2 | (240) | Alias 3 of Customer | |
| CUSTOMER_ALIAS4 | VARCHAR2 | (240) | Alias 4 of Customer | |
| CUSTOMER_ALIAS5 | VARCHAR2 | (240) | Alias 5 of Customer | |
| CUSTOMER_PRIM_PHONE_PURPOSE | VARCHAR2 | (30) | Primary Phone Purpose of customer | |
| CUSTOMER_PRIM_PHONE_TYPE | VARCHAR2 | (30) | Primary Phone Line Type of customer | |
| CUSTOMER_PRIM_PH_COUNTRY_CODE | VARCHAR2 | (10) | Primary Phone Country Code of customer | |
| CUSTOMER_PRIM_PH_AREA_CODE | VARCHAR2 | (10) | Primary Phone Area Code of customer | |
| CUSTOMER_PRIM_PHONE_NUMBER | VARCHAR2 | (40) | Primary Phone Number of customer | |
| CUSTOMER_PRIM_PHONE_EXTN | VARCHAR2 | (20) | Primary Phone Extension of customer | |
| CUSTOMER_HOME_COUNTRY | VARCHAR2 | (2) | Home Country of customer | |
| CUSTOMER_STATUS | VARCHAR2 | (80) | Customer Status | |
| CUSTOMER_PARTY_ID | NUMBER | (15) | Yes | Customer party identifier |
| CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | (30) | Customer Account number of the Lessee on the contract | |
| CUSTOMER_ACC_DFF_CATEGORY | VARCHAR2 | (30) | Customer Account Descriptive Flex Field Category | |
| CUSTOMER_ACC_DFF1 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 1 | |
| CUSTOMER_ACC_DFF2 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 2 | |
| CUSTOMER_ACC_DFF3 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 3 | |
| CUSTOMER_ACC_DFF4 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 4 | |
| CUSTOMER_ACC_DFF5 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 5 | |
| CUSTOMER_ACC_DFF6 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 6 | |
| CUSTOMER_ACC_DFF7 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 7 | |
| CUSTOMER_ACC_DFF8 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 8 | |
| CUSTOMER_ACC_DFF9 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 9 | |
| CUSTOMER_ACC_DFF10 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 10 | |
| CUSTOMER_ACC_DFF11 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 11 | |
| CUSTOMER_ACC_DFF12 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 12 | |
| CUSTOMER_ACC_DFF13 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 13 | |
| CUSTOMER_ACC_DFF14 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 14 | |
| CUSTOMER_ACC_DFF15 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 15 | |
| CUSTOMER_ACC_DFF16 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 16 | |
| CUSTOMER_ACC_DFF17 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 17 | |
| CUSTOMER_ACC_DFF18 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 18 | |
| CUSTOMER_ACC_DFF19 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 19 | |
| CUSTOMER_ACC_DFF20 | VARCHAR2 | (150) | Customer Account Descriptive Flex Field 20 | |
| CUSTOMER_ACCOUNT_STATUS | VARCHAR2 | (80) | Customer Account Status | |
| CUSTOMER_TYPE | VARCHAR2 | (80) | Customer Type | |
| CUSTOMER_SALES_CHANNEL | VARCHAR2 | (30) | Sales Channel | |
| CUSTOMER_ACC_ESTAB_DATE | DATE | Date customer account was established | ||
| CUSTOMER_ACCOUNT_NAME | VARCHAR2 | (240) | Customer Account Name | |
| CUSTOMER_ACCOUNT_COMMENTS | VARCHAR2 | (240) | Comments for customer accounts | |
| CUSTOMER_LAST_STATUS_UPD_DT | DATE | Date customer status was last updated | ||
| CUSTOMER_PARTY_SITE_ID | NUMBER | (15) | Customer Party Site ID of the contract | |
| CUSTOMER_PARTY_SITE_NUMBER | VARCHAR2 | (30) | Customer Party Site Number of the contract | |
| CUSTOMER_PARTY_SITE_NAME | VARCHAR2 | (240) | Party Site Name of customer | |
| CUSTOMER_PARTY_SITE_LOC_ID | NUMBER | (15) | Part Site Location ID of customer | |
| CUSTOMER_IDENTIFYING_ADR_FLAG | VARCHAR2 | (1) | Customer Address Identifier | |
| CUSTOMER_PARTY_SITE_STATUS | VARCHAR2 | (80) | Party Site Status of customer | |
| CUSTOMER_PARTY_SITE_ADDRESSEE | VARCHAR2 | (360) | Party Site Addressee of customer | |
| CUSTOMER_SITE_GLOB_LOC_NUM | VARCHAR2 | (40) | Global Location Number of customer | |
| CUSTOMER_PARTY_SITE_USE_ID | NUMBER | (15) | Party Site Use Identifier of customer | |
| CUSTOMER_PARTY_SITE_USE_TYPE | VARCHAR2 | (30) | Party Site Use Type of customer | |
| CUSTOMER_PARTY_SITE_COMMENTS | VARCHAR2 | (240) | Party Site Use Comments for customer | |
| CUSTOMER_PARTY_SITE_USE_STATUS | VARCHAR2 | (80) | Party Site Use Status of customer | |
| CONTRACT_PAST_DUE_AMT_1_30 | NUMBER | 1-30 Days Past Due | ||
| CONTRACT_PAST_DUE_AMT_31_60 | NUMBER | 31-60 days Past Due | ||
| CONTRACT_PAST_DUE_AMT_61_90 | NUMBER | 61-90 days Past Due | ||
| CONTRACT_PAST_DUE_AMT_91_120 | NUMBER | 91-120 days Past Due | ||
| CONTRACT_PAST_DUE_AMT_120_PLUS | NUMBER | 121+ days Past Due | ||
| CONTRACT_TOT_PAST_DUE_AMT | NUMBER | Total Past Due Amount | ||
| CONTRACT_TOT_BILLED_RECEIVABLE | NUMBER | Total Contract Billed Receivables | ||
| CONTRACT_RESIDUAL_AMOUNT | NUMBER | Residual amount for the contract | ||
| CONTRACT_RENT_AMOUNT | NUMBER | Total rent amount for the contract | ||
| CONTRACT_ACC_DEPRECIATION | NUMBER | Total Contract Accumulated Depreciation | ||
| NET_INVESTMENT | NUMBER | Net Investment Value in contract currency | ||
| NET_INVESTMENT_FUNCTIONAL | NUMBER | Net Investment Value in functional currency | ||
| CONTRACT_AMOUNT_PREFUNDED | NUMBER | Contract Prefunded Amount | ||
| CONTRACT_TOTAL_MISC_FUND | NUMBER | Total Manual Disbursement Amount | ||
| CREATED_BY | NUMBER | Yes | Standard who column | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Manager column | ||
| PROGRAM_ID | NUMBER | Concurrent Manager column | ||
| PROGRAM_LOGIN_ID | NUMBER | Concurrent Manager column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, CONTRACT_ID
, CONTRACT_DOCUMENT_ID
, CONTRACT_NUMBER
, CONTRACT_OPERATING_UNIT_ID
, CONTRACT_INVENTORY_ORG_ID
, CONTRACT_STATUS_CODE
, CONTRACT_CURRENCY
, CONTRACT_TEMPLATE_INDICATOR
, CONTRACT_CUST_PURCH_ORDER_NUM
, CONTRACT_TEMPLATE_NAME
, CONTRACT_APPROVED_DATE
, CONTRACT_CANCELED_TIMESTAMP
, CONTRACT_SIGNED_DATE
, CONTRACT_TERMINATION_DATE
, CONTRACT_START_DATE
, CONTRACT_END_DATE
, CUSTOMER_ACCOUNT_ID
, CUST_BILL_TO_SITE_USE_ID
, CUST_PAYMENT_TERM_ID
, CONTRACT_ORIG_SYSTEM_SOURCE
, CONTRACT_SALES_REGION_ID
, VENDOR_PROGRAM_ID
, CONTRACT_FINANCIAL_PRODUCT_ID
, CONTRACT_DATE_DEAL_ACTIVATED
, CONTRACT_DATE_DEAL_TRANSFERD
, CONTRACT_TERM_DURATION
, CONTRACT_HDR_DFF_CATEGORY
, CONTRACT_HDR_DFF1
, CONTRACT_HDR_DFF2
, CONTRACT_HDR_DFF3
, CONTRACT_HDR_DFF4
, CONTRACT_HDR_DFF5
, CONTRACT_HDR_DFF6
, CONTRACT_HDR_DFF7
, CONTRACT_HDR_DFF8
, CONTRACT_HDR_DFF9
, CONTRACT_HDR_DFF10
, CONTRACT_HDR_DFF11
, CONTRACT_HDR_DFF12
, CONTRACT_HDR_DFF13
, CONTRACT_HDR_DFF14
, CONTRACT_HDR_DFF15
, CONTRACT_ACCRUAL_STATUS
, CONTRACT_GEN_ACCRUAL_OVRIDE_YN
, CONTRACT_CREDIT_ACT_YN
, CONTRACT_CONVERTED_ACCOUNT_YN
, CONTRACT_AFTER_TAX_YIELD
, CONTRACT_IMPL_INTEREST_RATE
, CONTRACT_LAST_INT_CALC_DATE
, CONTRACT_BOOK_CLASS_CODE
, CONTRACT_BOOK_CLASSIFICATION
, CONTRACT_PRE_TAX_IRR
, CONTRACT_AFTER_TAX_IRR
, CONTRACT_EXP_DELIVERY_DATE
, CONTRACT_ACCEPTANCE_DATE
, CONTRACT_PREFUND_ELIG_YN
, CONTRACT_REVOL_CREDIT_ELIG_YN
, CONTRACT_CURRENCY_CONV_TYPE
, CONTRACT_CURRENCY_CONV_RATE
, CONTRACT_CURRENCY_CONV_DATE
, CONTRACT_MULTI_GAAP_ELIG_YN
, CONTRACT_INVESTOR_ASSIGN_YN
, CONTRACT_SECURITIZATION_TYPE
, CONTRACT_SUB_AFTER_TAX_YIELD
, CONTRACT_SUB_IMPL_INT_RATE
, CONTRACT_SUB_PRE_TAX_IRR
, CONTRACT_SUB_AFTER_TAX_IRR
, CONTRACT_CRDTLINE_TRNSFR_AMT
, CONTRACT_CRDTLINE_NETRNSFR_AMT
, CONTRACT_CRDTLINE_LIMIT
, CONTRACT_CRDTLINE_FUNDING_AMT
, CONTRACT_TEMPL_TYPE_CODE
, CONTRACT_TRADEIN_DESCRIPTION
, CONTRACT_TRADEIN_DATE
, CONTRACT_LEGAL_ENTITY_ID
, CONTRACT_FIRST_ACTIVITY_DATE
, CONTRACT_ACCUMULATED_DEP
, CONTRACT_CAPITALIZED_REDUCTION
, CONTRACT_CAPITALIZED_FEE
, CONTRACT_CAPITALIZED_INTEREST
, CONTRACT_DISCOUNT
, CONTRACT_ASSET_COST
, CONTRACT_FINANCED_FEE
, CONTRACT_NEXT_PAYMENT_AMT
, CONTRACT_TOTAL_ACCRUED_INT
, CONTRACT_TOTAL_ACTUAL_INT
, CONTRACT_SUBSIDY_AMOUNT
, CONTRACT_UNACCRUED_SUBSIDY
, CONTRACT_UNBILLED_DUE_AMOUNT
, CONTRACT_UNBILLED_RECEIVABLES
, CONTRACT_OEC
, CONTRACT_ACTUAL_PRINC_BAL
, ROLLOVER_FEE_AMOUNT
, CONTRACT_TRADEIN_AMOUNT
, TOTAL_AMOUNT_PAID_TO_DEALER
, TOTAL_DEBITS_FOR_PREFUNDING
, CONTRACT_PREFUNDED_AMOUNT
, CONTRACT_BILLED_RENTS
, CONTRACT_BILLED_RENTS_FUNC
, CONTRACT_BILLED_NON_RENTS
, CONTRACT_BILLED_NON_RENTS_FUNC
, SUPPLIER_RETENTION_FUNDING_AMT
, ASSETS_FUNDED_AMOUNT
, EXPENSE_FUNDED_AMOUNT
, CONTRACT_IDC_AMOUNT
, CONTRACT_SCHEDULED_PRINC_BAL
, CONTRACT_INTEREST_RATE
, CONTRACT_DAYS_TO_ACCRUE
, CONTRACT_DAYS_IN_YEAR
, CONTRACT_CAP_AMOUNT
, CONTRACT_FINANCED_AMOUNT
, CONTRACT_VAR_INCOME_ACCRUAL
, TOTAL_PREFUNDING_AMOUNT
, OPERATING_UNIT
, OPERATING_UNIT_SHORT_CODE
, CONTRACT_STATUS_TYPE_CODE
, CONTRACT_STATUS
, CONTRACT_FEE_INCOME
, ACC_ENGINE_TEMPL_SET_ID
, CONTRACT_FIN_PROD_TEMPLATE_ID
, CONTRACT_FINANCIAL_PRODUCT
, CONTRACT_FIN_PROD_DESC
, REPORTING_PRODUCT_ID
, CONTRACT_FIN_PROD_STATUS_CODE
, CONTRACT_FIN_PROD_EFF_FROM_DT
, CONTRACT_FIN_PROD_EFF_TO_DT
, REPORTING_PRODUCT
, VENDOR_PROGRAM_NAME
, VENDOR_NUMBER
, VENDOR_NAME
, VENDOR_TYPE_CODE
, VENDOR_BILL_TO_SITE_USE_ID
, VENDOR_PARTY_ROLE
, TOTAL_UPFRONT_TAX_ON_ASSETS
, TOTAL_NUMBER_OF_ASSETS
, FUNCTIONAL_CURRENCY
, LEDGER_ID
, LEDGER
, CONTRACT_EARLIEST_BILL_DATE
, CONTRACT_SALES_REP
, LEGAL_ENTITY
, CUSTOMER_PARTY_NUMBER
, CUSTOMER_PARTY_NAME
, CUSTOMER_PARTY_TYPE
, CUSTOMER_SIC_CODE
, CUSTOMER_HQ_BRANCH_IND
, CUSTOMER_TAX_REFERENCE
, CUSTOMER_DUNS_NUMBER
, CUSTOMER_ALIAS
, CUSTOMER_COUNTRY
, CUSTOMER_ADDRESS1
, CUSTOMER_ADDRESS2
, CUSTOMER_ADDRESS3
, CUSTOMER_ADDRESS4
, CUSTOMER_CITY
, CUSTOMER_POSTAL_CODE
, CUSTOMER_STATE
, CUSTOMER_PROVINCE
, CUSTOMER_COUNTY
, CUSTOMER_SIC_CODE_TYPE
, CUSTOMER_URL
, FINANCIAL_INFO_FISCAL_YEAR
, CUSTOMER_FISCAL_YEAREND_MONTH
, TOTAL_NUM_OF_EMPLOYEES
, CURR_FISC_YEAR_POTENTIAL_REV
, NEXT_FISC_YEAR_POTENTIAL_REV
, CUSTOMER_YEAR_ESTABLISHED
, GEN_SERV_ADMIN_INDICATOR
, CUSTOMER_ORG_NAME_PHONETIC
, CUSTOMER_COMPETITOR_YN
, CUSTOMER_ALIAS2
, CUSTOMER_ALIAS3
, CUSTOMER_ALIAS4
, CUSTOMER_ALIAS5
, CUSTOMER_PRIM_PHONE_PURPOSE
, CUSTOMER_PRIM_PHONE_TYPE
, CUSTOMER_PRIM_PH_COUNTRY_CODE
, CUSTOMER_PRIM_PH_AREA_CODE
, CUSTOMER_PRIM_PHONE_NUMBER
, CUSTOMER_PRIM_PHONE_EXTN
, CUSTOMER_HOME_COUNTRY
, CUSTOMER_STATUS
, CUSTOMER_PARTY_ID
, CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_ACC_DFF_CATEGORY
, CUSTOMER_ACC_DFF1
, CUSTOMER_ACC_DFF2
, CUSTOMER_ACC_DFF3
, CUSTOMER_ACC_DFF4
, CUSTOMER_ACC_DFF5
, CUSTOMER_ACC_DFF6
, CUSTOMER_ACC_DFF7
, CUSTOMER_ACC_DFF8
, CUSTOMER_ACC_DFF9
, CUSTOMER_ACC_DFF10
, CUSTOMER_ACC_DFF11
, CUSTOMER_ACC_DFF12
, CUSTOMER_ACC_DFF13
, CUSTOMER_ACC_DFF14
, CUSTOMER_ACC_DFF15
, CUSTOMER_ACC_DFF16
, CUSTOMER_ACC_DFF17
, CUSTOMER_ACC_DFF18
, CUSTOMER_ACC_DFF19
, CUSTOMER_ACC_DFF20
, CUSTOMER_ACCOUNT_STATUS
, CUSTOMER_TYPE
, CUSTOMER_SALES_CHANNEL
, CUSTOMER_ACC_ESTAB_DATE
, CUSTOMER_ACCOUNT_NAME
, CUSTOMER_ACCOUNT_COMMENTS
, CUSTOMER_LAST_STATUS_UPD_DT
, CUSTOMER_PARTY_SITE_ID
, CUSTOMER_PARTY_SITE_NUMBER
, CUSTOMER_PARTY_SITE_NAME
, CUSTOMER_PARTY_SITE_LOC_ID
, CUSTOMER_IDENTIFYING_ADR_FLAG
, CUSTOMER_PARTY_SITE_STATUS
, CUSTOMER_PARTY_SITE_ADDRESSEE
, CUSTOMER_SITE_GLOB_LOC_NUM
, CUSTOMER_PARTY_SITE_USE_ID
, CUSTOMER_PARTY_SITE_USE_TYPE
, CUSTOMER_PARTY_SITE_COMMENTS
, CUSTOMER_PARTY_SITE_USE_STATUS
, CONTRACT_PAST_DUE_AMT_1_30
, CONTRACT_PAST_DUE_AMT_31_60
, CONTRACT_PAST_DUE_AMT_61_90
, CONTRACT_PAST_DUE_AMT_91_120
, CONTRACT_PAST_DUE_AMT_120_PLUS
, CONTRACT_TOT_PAST_DUE_AMT
, CONTRACT_TOT_BILLED_RECEIVABLE
, CONTRACT_RESIDUAL_AMOUNT
, CONTRACT_RENT_AMOUNT
, CONTRACT_ACC_DEPRECIATION
, NET_INVESTMENT
, NET_INVESTMENT_FUNCTIONAL
, CONTRACT_AMOUNT_PREFUNDED
, CONTRACT_TOTAL_MISC_FUND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_UPDATE_DATE
FROM OKL.OKL_CNTRCT_FIN_EXTRACT_T;
OKL.OKL_CNTRCT_FIN_EXTRACT_T does not reference any database object
OKL.OKL_CNTRCT_FIN_EXTRACT_T is referenced by following:
APPS
OKL_CNTRCT_FIN_EXTRACT_T
|
|
|
|