1. Tables and Views for Sales and Fusion Service
  2. OKC_COVERED_ASSETS_INT

OKC_COVERED_ASSETS_INT

Interface table for okc_covered_assets

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

OKC_COVERED_ASSETS_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_ID NUMBER 18 Yes Import Batch Id, every batch of data being imported should be assigned a batch id.
INTERFACE_ROW_ID NUMBER 18 Yes Unique identifier for a record within a batch, source system should populate this.
IMPORT_STATUS_CODE VARCHAR2 30 Status of row in the interface table, source system should leave this as null.
FILE_RECORD_NUM NUMBER 18 Used by import utility to relate the record in interface table to the file row.
ACTION_CODE VARCHAR2 30 ACTION_CODE
INTERNAL_ACTION_CODE VARCHAR2 30 Used internally by the bulk import ODI program.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
FUSION_COVERED_ASSET_ID NUMBER 18 FUSION_COVERED_ASSET_ID
MAJOR_VERSION NUMBER 18 Identifies the contract major version.
EXT_SOURCE VARCHAR2 120 User or External key, to enable updates or deletes via bulk import or web services, if fusion primary key is not known.
EXT_KEY VARCHAR2 120 See ext_source
DNZ_CHR_ID NUMBER 18 Contract ID. Denormalized for performance.
CLE_ID NUMBER 18 CLE_ID
LINE_EXT_SOURCE VARCHAR2 120 Parent line external source
LINE_EXT_KEY VARCHAR2 120 Parent line external key
LINE_NUMBER VARCHAR2 150 LINE_NUMBER
ITEM_ID NUMBER 18 ITEM_ID
ITEM_NAME VARCHAR2 1995 ITEM_NAME
EXTERNAL_SEARCH_KEY1 VARCHAR2 150 EXTERNAL_SEARCH_KEY1
EXTERNAL_SEARCH_KEY2 VARCHAR2 150 EXTERNAL_SEARCH_KEY2
EXTERNAL_REFERENCE1 VARCHAR2 150 EXTERNAL_REFERENCE1
EXTERNAL_REFERENCE2 VARCHAR2 150 EXTERNAL_REFERENCE2
EXTERNAL_REFERENCE3 VARCHAR2 150 EXTERNAL_REFERENCE3
EXTERNAL_REFERENCE4 VARCHAR2 150 EXTERNAL_REFERENCE4
EXTERNAL_REFERENCE5 VARCHAR2 150 EXTERNAL_REFERENCE5
QUANTITY NUMBER QUANTITY
UOM VARCHAR2 80 UOM
UOM_CODE VARCHAR2 15 UOM_CODE
AMOUNT NUMBER AMOUNT
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
FILE_NAME_SYSTASK_ID NUMBER 18 Save the individual sys task id for each input csv file
INTERNAL_COVERED_ASSETS_OVN NUMBER 9 Used internally by the bulk import ODI program.
ASSET_ID NUMBER 18 ASSET_ID Active
ASSET_NAME VARCHAR2 1995 ASSET_NAME Active
STS_CODE VARCHAR2 30 STS_CODE Active
STATUS VARCHAR2 80 STATUS Active
PRICE_UOM_CODE VARCHAR2 30 PRICE_UOM_CODE Active
PRICE_UOM VARCHAR2 80 PRICE_UOM Active
END_DATE DATE END_DATE Active
START_DATE DATE START_DATE Active
INVOICE_TEXT VARCHAR2 2000 INVOICE_TEXT Active
CLOSED_DATE DATE DATE_TERMINATED
CLOSE_REASON_CODE VARCHAR2 30 CLOSE_REASON_CODE
CLOSE_REASON_SET_ID NUMBER 18 CLOSE_REASON_SET_ID
CLOSE_REASON_SET_CODE VARCHAR2 30 CLOSE_REASON_SET_CODE
TERMINATED_AMOUNT NUMBER TERMINATED_AMOUNT
HOLD_REASON_CODE VARCHAR2 30 Hold reason lookup code
HOLD_REASON_SET_ID NUMBER 18 Hold reason set ID
HOLD_REASON_SET_CODE VARCHAR2 30 Set Code for Hold reason
HOLD_UNTIL_DATE DATE Hold until date
CANCEL_REASON_CODE VARCHAR2 30 Cancel reason code
CANCEL_REASON_SET_ID NUMBER 18 Cancel reason set ID
CANCEL_REASON_SET_CODE VARCHAR2 30 Cancel reason set code
CANCELLED_DATE DATE Cancelled date
CANCELLED_AMOUNT NUMBER Cancelled amount
DATA_LANG VARCHAR2 4 DATA_LANG
RETURN_CREDIT_METHOD VARCHAR2 80 RETURN_CREDIT_METHOD
RETURN_CREDIT_METHOD_CODE VARCHAR2 30 Return credit method code
INVOICED_AMOUNT NUMBER Invoiced amount
CREDITED_AMOUNT NUMBER Credited amount
LINE_SUB_TOTAL NUMBER LINE_SUB_TOTAL
ONETIME_AMOUNT NUMBER ONETIME_AMOUNT
RECURRING_AMOUNT NUMBER RECURRING_AMOUNT
SUPPRESSED_CREDIT_AMOUNT NUMBER Suppressed Credit Amount
TAX_AMOUNT NUMBER Tax amount
DATE_RENEWED DATE Date the Asset was renewed
RENEWED_FROM_EXT_SOURCE VARCHAR2 120 Renewal source Asset ext_source
RENEWED_FROM_EXT_KEY VARCHAR2 120 Renewal source Asset ext_key
RENEWED_FROM_ASSET_ID NUMBER 18 Renewal source Asset ID
RENEWED_FROM_MAJOR_VERSION NUMBER 18 Renewal source Asset major version
INTERNAL_HEADER_STATUS VARCHAR2 30 The final status of the contract header.

Indexes

Index Uniqueness Tablespace Columns
OKC_COVERED_ASSETS_INT_N1 Non Unique FUSION_TS_INTERFACE BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE
OKC_COVERED_ASSETS_INT_N2 Non Unique FUSION_TS_INTERFACE BATCH_ID, EXT_SOURCE, EXT_KEY
OKC_COVERED_ASSETS_INT_N3 Non Unique Default BATCH_ID, DNZ_CHR_ID, MAJOR_VERSION
OKC_COVERED_ASSETS_INT_N4 Non Unique Default BATCH_ID, CLE_ID, MAJOR_VERSION
OKC_COVERED_ASSETS_INT_U1 Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID