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

VIEW: OKL.OKL_CNTRCT_FIN_EXTRACT_T#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
CONTRACT_ID NUMBER
Yes
CONTRACT_DOCUMENT_ID NUMBER

CONTRACT_NUMBER VARCHAR2 (120) Yes
CONTRACT_OPERATING_UNIT_ID NUMBER
Yes
CONTRACT_INVENTORY_ORG_ID NUMBER

CONTRACT_STATUS_CODE VARCHAR2 (30)
CONTRACT_CURRENCY VARCHAR2 (15)
CONTRACT_TEMPLATE_INDICATOR VARCHAR2 (3)
CONTRACT_CUST_PURCH_ORDER_NUM VARCHAR2 (150)
CONTRACT_TEMPLATE_NAME VARCHAR2 (120)
CONTRACT_APPROVED_DATE DATE

CONTRACT_CANCELED_TIMESTAMP DATE

CONTRACT_SIGNED_DATE DATE

CONTRACT_TERMINATION_DATE DATE

CONTRACT_START_DATE DATE

CONTRACT_END_DATE DATE

CUSTOMER_ACCOUNT_ID NUMBER (15)
CUST_BILL_TO_SITE_USE_ID NUMBER (15)
CUST_PAYMENT_TERM_ID NUMBER (15)
CONTRACT_ORIG_SYSTEM_SOURCE VARCHAR2 (30)
CONTRACT_SALES_REGION_ID NUMBER

VENDOR_PROGRAM_ID NUMBER

CONTRACT_FINANCIAL_PRODUCT_ID NUMBER

CONTRACT_DATE_DEAL_ACTIVATED DATE

CONTRACT_DATE_DEAL_TRANSFERD DATE

CONTRACT_TERM_DURATION NUMBER (10)
CONTRACT_HDR_DFF_CATEGORY VARCHAR2 (90)
CONTRACT_HDR_DFF1 VARCHAR2 (450)
CONTRACT_HDR_DFF2 VARCHAR2 (450)
CONTRACT_HDR_DFF3 VARCHAR2 (450)
CONTRACT_HDR_DFF4 VARCHAR2 (450)
CONTRACT_HDR_DFF5 VARCHAR2 (450)
CONTRACT_HDR_DFF6 VARCHAR2 (450)
CONTRACT_HDR_DFF7 VARCHAR2 (450)
CONTRACT_HDR_DFF8 VARCHAR2 (450)
CONTRACT_HDR_DFF9 VARCHAR2 (450)
CONTRACT_HDR_DFF10 VARCHAR2 (450)
CONTRACT_HDR_DFF11 VARCHAR2 (450)
CONTRACT_HDR_DFF12 VARCHAR2 (450)
CONTRACT_HDR_DFF13 VARCHAR2 (450)
CONTRACT_HDR_DFF14 VARCHAR2 (450)
CONTRACT_HDR_DFF15 VARCHAR2 (450)
CONTRACT_ACCRUAL_STATUS VARCHAR2 (3)
CONTRACT_GEN_ACCRUAL_OVRIDE_YN VARCHAR2 (3)
CONTRACT_CREDIT_ACT_YN VARCHAR2 (3)
CONTRACT_CONVERTED_ACCOUNT_YN VARCHAR2 (3)
CONTRACT_AFTER_TAX_YIELD NUMBER

CONTRACT_IMPL_INTEREST_RATE NUMBER

CONTRACT_LAST_INT_CALC_DATE DATE

CONTRACT_BOOK_CLASS_CODE VARCHAR2 (30)
CONTRACT_BOOK_CLASSIFICATION VARCHAR2 (80)
CONTRACT_PRE_TAX_IRR NUMBER

CONTRACT_AFTER_TAX_IRR NUMBER

CONTRACT_EXP_DELIVERY_DATE DATE

CONTRACT_ACCEPTANCE_DATE DATE

CONTRACT_PREFUND_ELIG_YN VARCHAR2 (3)
CONTRACT_REVOL_CREDIT_ELIG_YN VARCHAR2 (3)
CONTRACT_CURRENCY_CONV_TYPE VARCHAR2 (30)
CONTRACT_CURRENCY_CONV_RATE NUMBER

CONTRACT_CURRENCY_CONV_DATE DATE

CONTRACT_MULTI_GAAP_ELIG_YN VARCHAR2 (3)
CONTRACT_INVESTOR_ASSIGN_YN VARCHAR2 (3)
CONTRACT_SECURITIZATION_TYPE VARCHAR2 (30)
CONTRACT_SUB_AFTER_TAX_YIELD NUMBER

CONTRACT_SUB_IMPL_INT_RATE NUMBER

CONTRACT_SUB_PRE_TAX_IRR NUMBER

CONTRACT_SUB_AFTER_TAX_IRR NUMBER

CONTRACT_CRDTLINE_TRNSFR_AMT NUMBER

CONTRACT_CRDTLINE_NETRNSFR_AMT NUMBER

CONTRACT_CRDTLINE_LIMIT NUMBER

CONTRACT_CRDTLINE_FUNDING_AMT NUMBER

CONTRACT_TEMPL_TYPE_CODE VARCHAR2 (30)
CONTRACT_TRADEIN_DESCRIPTION VARCHAR2 (1995)
CONTRACT_TRADEIN_DATE DATE

CONTRACT_LEGAL_ENTITY_ID NUMBER

CONTRACT_FIRST_ACTIVITY_DATE DATE

CONTRACT_ACCUMULATED_DEP NUMBER

CONTRACT_CAPITALIZED_REDUCTION NUMBER

CONTRACT_CAPITALIZED_FEE NUMBER

CONTRACT_CAPITALIZED_INTEREST NUMBER

CONTRACT_DISCOUNT NUMBER

CONTRACT_ASSET_COST NUMBER

CONTRACT_FINANCED_FEE NUMBER

CONTRACT_NEXT_PAYMENT_AMT NUMBER

CONTRACT_TOTAL_ACCRUED_INT NUMBER

CONTRACT_TOTAL_ACTUAL_INT NUMBER

CONTRACT_SUBSIDY_AMOUNT NUMBER

CONTRACT_UNACCRUED_SUBSIDY NUMBER

CONTRACT_UNBILLED_DUE_AMOUNT NUMBER

CONTRACT_UNBILLED_RECEIVABLES NUMBER

CONTRACT_OEC NUMBER

CONTRACT_ACTUAL_PRINC_BAL NUMBER

ROLLOVER_FEE_AMOUNT NUMBER

CONTRACT_TRADEIN_AMOUNT NUMBER

TOTAL_AMOUNT_PAID_TO_DEALER NUMBER

TOTAL_DEBITS_FOR_PREFUNDING NUMBER

CONTRACT_PREFUNDED_AMOUNT NUMBER

CONTRACT_BILLED_RENTS NUMBER

CONTRACT_BILLED_RENTS_FUNC NUMBER

CONTRACT_BILLED_NON_RENTS NUMBER

CONTRACT_BILLED_NON_RENTS_FUNC NUMBER

SUPPLIER_RETENTION_FUNDING_AMT NUMBER

ASSETS_FUNDED_AMOUNT NUMBER

EXPENSE_FUNDED_AMOUNT NUMBER

CONTRACT_IDC_AMOUNT NUMBER

CONTRACT_SCHEDULED_PRINC_BAL NUMBER

CONTRACT_INTEREST_RATE NUMBER

CONTRACT_DAYS_TO_ACCRUE NUMBER

CONTRACT_DAYS_IN_YEAR NUMBER

CONTRACT_CAP_AMOUNT NUMBER

CONTRACT_FINANCED_AMOUNT NUMBER

CONTRACT_VAR_INCOME_ACCRUAL NUMBER

TOTAL_PREFUNDING_AMOUNT NUMBER

OPERATING_UNIT VARCHAR2 (240) Yes
OPERATING_UNIT_SHORT_CODE VARCHAR2 (150)
CONTRACT_STATUS_TYPE_CODE VARCHAR2 (30)
CONTRACT_STATUS VARCHAR2 (90)
CONTRACT_FEE_INCOME NUMBER

ACC_ENGINE_TEMPL_SET_ID NUMBER

CONTRACT_FIN_PROD_TEMPLATE_ID NUMBER

CONTRACT_FINANCIAL_PRODUCT VARCHAR2 (150)
CONTRACT_FIN_PROD_DESC VARCHAR2 (1995)
REPORTING_PRODUCT_ID NUMBER

CONTRACT_FIN_PROD_STATUS_CODE VARCHAR2 (30)
CONTRACT_FIN_PROD_EFF_FROM_DT DATE

CONTRACT_FIN_PROD_EFF_TO_DT DATE

REPORTING_PRODUCT VARCHAR2 (150)
VENDOR_PROGRAM_NAME VARCHAR2 (120)
VENDOR_NUMBER VARCHAR2 (30)
VENDOR_NAME VARCHAR2 (360)
VENDOR_TYPE_CODE VARCHAR2 (30)
VENDOR_BILL_TO_SITE_USE_ID NUMBER (15)
VENDOR_PARTY_ROLE VARCHAR2 (80)
TOTAL_UPFRONT_TAX_ON_ASSETS NUMBER

TOTAL_NUMBER_OF_ASSETS NUMBER

FUNCTIONAL_CURRENCY VARCHAR2 (15)
LEDGER_ID NUMBER (15)
LEDGER VARCHAR2 (30)
CONTRACT_EARLIEST_BILL_DATE DATE

CONTRACT_SALES_REP VARCHAR2 (360)
LEGAL_ENTITY VARCHAR2 (240)
CUSTOMER_PARTY_NUMBER VARCHAR2 (30)
CUSTOMER_PARTY_NAME VARCHAR2 (360) Yes
CUSTOMER_PARTY_TYPE VARCHAR2 (30)
CUSTOMER_SIC_CODE VARCHAR2 (30)
CUSTOMER_HQ_BRANCH_IND VARCHAR2 (30)
CUSTOMER_TAX_REFERENCE VARCHAR2 (50)
CUSTOMER_DUNS_NUMBER NUMBER

CUSTOMER_ALIAS VARCHAR2 (240)
CUSTOMER_COUNTRY VARCHAR2 (60)
CUSTOMER_ADDRESS1 VARCHAR2 (240)
CUSTOMER_ADDRESS2 VARCHAR2 (240)
CUSTOMER_ADDRESS3 VARCHAR2 (240)
CUSTOMER_ADDRESS4 VARCHAR2 (240)
CUSTOMER_CITY VARCHAR2 (60)
CUSTOMER_POSTAL_CODE VARCHAR2 (60)
CUSTOMER_STATE VARCHAR2 (60)
CUSTOMER_PROVINCE VARCHAR2 (60)
CUSTOMER_COUNTY VARCHAR2 (60)
CUSTOMER_SIC_CODE_TYPE VARCHAR2 (30)
CUSTOMER_URL VARCHAR2 (2000)
FINANCIAL_INFO_FISCAL_YEAR VARCHAR2 (5)
CUSTOMER_FISCAL_YEAREND_MONTH VARCHAR2 (30)
TOTAL_NUM_OF_EMPLOYEES NUMBER

CURR_FISC_YEAR_POTENTIAL_REV NUMBER

NEXT_FISC_YEAR_POTENTIAL_REV NUMBER

CUSTOMER_YEAR_ESTABLISHED NUMBER (4)
GEN_SERV_ADMIN_INDICATOR VARCHAR2 (1)
CUSTOMER_ORG_NAME_PHONETIC VARCHAR2 (320)
CUSTOMER_COMPETITOR_YN VARCHAR2 (1)
CUSTOMER_ALIAS2 VARCHAR2 (240)
CUSTOMER_ALIAS3 VARCHAR2 (240)
CUSTOMER_ALIAS4 VARCHAR2 (240)
CUSTOMER_ALIAS5 VARCHAR2 (240)
CUSTOMER_PRIM_PHONE_PURPOSE VARCHAR2 (30)
CUSTOMER_PRIM_PHONE_TYPE VARCHAR2 (30)
CUSTOMER_PRIM_PH_COUNTRY_CODE VARCHAR2 (10)
CUSTOMER_PRIM_PH_AREA_CODE VARCHAR2 (10)
CUSTOMER_PRIM_PHONE_NUMBER VARCHAR2 (40)
CUSTOMER_PRIM_PHONE_EXTN VARCHAR2 (20)
CUSTOMER_HOME_COUNTRY VARCHAR2 (2)
CUSTOMER_STATUS VARCHAR2 (80)
CUSTOMER_PARTY_ID NUMBER (15) Yes
CUSTOMER_ACCOUNT_NUMBER VARCHAR2 (30)
CUSTOMER_ACC_DFF_CATEGORY VARCHAR2 (30)
CUSTOMER_ACC_DFF1 VARCHAR2 (150)
CUSTOMER_ACC_DFF2 VARCHAR2 (150)
CUSTOMER_ACC_DFF3 VARCHAR2 (150)
CUSTOMER_ACC_DFF4 VARCHAR2 (150)
CUSTOMER_ACC_DFF5 VARCHAR2 (150)
CUSTOMER_ACC_DFF6 VARCHAR2 (150)
CUSTOMER_ACC_DFF7 VARCHAR2 (150)
CUSTOMER_ACC_DFF8 VARCHAR2 (150)
CUSTOMER_ACC_DFF9 VARCHAR2 (150)
CUSTOMER_ACC_DFF10 VARCHAR2 (150)
CUSTOMER_ACC_DFF11 VARCHAR2 (150)
CUSTOMER_ACC_DFF12 VARCHAR2 (150)
CUSTOMER_ACC_DFF13 VARCHAR2 (150)
CUSTOMER_ACC_DFF14 VARCHAR2 (150)
CUSTOMER_ACC_DFF15 VARCHAR2 (150)
CUSTOMER_ACC_DFF16 VARCHAR2 (150)
CUSTOMER_ACC_DFF17 VARCHAR2 (150)
CUSTOMER_ACC_DFF18 VARCHAR2 (150)
CUSTOMER_ACC_DFF19 VARCHAR2 (150)
CUSTOMER_ACC_DFF20 VARCHAR2 (150)
CUSTOMER_ACCOUNT_STATUS VARCHAR2 (80)
CUSTOMER_TYPE VARCHAR2 (80)
CUSTOMER_SALES_CHANNEL VARCHAR2 (30)
CUSTOMER_ACC_ESTAB_DATE DATE

CUSTOMER_ACCOUNT_NAME VARCHAR2 (240)
CUSTOMER_ACCOUNT_COMMENTS VARCHAR2 (240)
CUSTOMER_LAST_STATUS_UPD_DT DATE

CUSTOMER_PARTY_SITE_ID NUMBER (15)
CUSTOMER_PARTY_SITE_NUMBER VARCHAR2 (30)
CUSTOMER_PARTY_SITE_NAME VARCHAR2 (240)
CUSTOMER_PARTY_SITE_LOC_ID NUMBER (15)
CUSTOMER_IDENTIFYING_ADR_FLAG VARCHAR2 (1)
CUSTOMER_PARTY_SITE_STATUS VARCHAR2 (80)
CUSTOMER_PARTY_SITE_ADDRESSEE VARCHAR2 (360)
CUSTOMER_SITE_GLOB_LOC_NUM VARCHAR2 (40)
CUSTOMER_PARTY_SITE_USE_ID NUMBER (15)
CUSTOMER_PARTY_SITE_USE_TYPE VARCHAR2 (30)
CUSTOMER_PARTY_SITE_COMMENTS VARCHAR2 (240)
CUSTOMER_PARTY_SITE_USE_STATUS VARCHAR2 (80)
CONTRACT_PAST_DUE_AMT_1_30 NUMBER

CONTRACT_PAST_DUE_AMT_31_60 NUMBER

CONTRACT_PAST_DUE_AMT_61_90 NUMBER

CONTRACT_PAST_DUE_AMT_91_120 NUMBER

CONTRACT_PAST_DUE_AMT_120_PLUS NUMBER

CONTRACT_TOT_PAST_DUE_AMT NUMBER

CONTRACT_TOT_BILLED_RECEIVABLE NUMBER

CONTRACT_RESIDUAL_AMOUNT NUMBER

CONTRACT_RENT_AMOUNT NUMBER

CONTRACT_ACC_DEPRECIATION NUMBER

NET_INVESTMENT NUMBER

NET_INVESTMENT_FUNCTIONAL NUMBER

CONTRACT_AMOUNT_PREFUNDED NUMBER

CONTRACT_TOTAL_MISC_FUND NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Query Text

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#;

Dependencies

[top of page]

OKL.OKL_CNTRCT_FIN_EXTRACT_T# references the following:

SchemaOKL
TableOKL_CNTRCT_FIN_EXTRACT_T
OKL.OKL_CNTRCT_FIN_EXTRACT_T# is referenced by following:

SchemaAPPS
SynonymOKL_CNTRCT_FIN_EXTRACT_T