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

OKC_ASYNC_UPLOAD_CONTRACT

This table stores the details of the all the contract terms documents uploaded in the background.

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

OKC_ASYNC_UPLOAD_CONTRACT_PK

ASYNC_UPLOAD_CONTRACT_ID

Columns

Name Datatype Length Precision Not-null Comments
ASYNC_UPLOAD_CONTRACT_ID NUMBER 18 Yes System generated unique identifier. Primary key column of the table.
DOCUMENT_ID NUMBER 18 Yes Business document header ID. Foreign key to various business document header tables.
DOCUMENT_VERSION NUMBER 18 Yes Business document version.
DOCUMENT_TYPE VARCHAR2 30 Yes Business document type. Foreign key to OKC_BUS_DOC_TYPES_B.
DOCUMENT_NUMBER VARCHAR2 150 Yes Business document number for which the contract terms document is uploaded.
DOC_SOURCE_CODE VARCHAR2 30 Indicates the source type of the uploaded document.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
FILE_NAME VARCHAR2 256 Yes Name of the uploaded document.
FILE_WML_NO_REDLINE BLOB Contents of the uploaded document without mark ups.
FILE_WML_REDLINE BLOB Contents of the uploaded document with mark ups.
FILE_TITLE VARCHAR2 256 Title of the uploaded document.
FILE_DECSRIPTION VARCHAR2 255 Description of the uploaded document.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
UPLOAD_STATUS VARCHAR2 40 Yes Status of the uploaded document.
UPLOAD_USER_GUID VARCHAR2 64 Yes GUID of the uploaded user.
UPLOAD_USER_NAME VARCHAR2 100 Yes Name of the uploaded user.
UPLOAD_FROM_WORD_YN VARCHAR2 1 Yes Indicates if the upload is from Word add-in.
TERMS_TEMPLATE_ID NUMBER Indicates the terms template ID.
REVIEW_YN VARCHAR2 1 Yes Indicates if the document changes will be reviewed by user.
AUTO_CLOSE_COLLABORATION_YN VARCHAR2 1 Indicates if the collaboration has to close automatically.
JOB_COMPLETION_DATE TIMESTAMP Indicates the date and time of the job completion.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes 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.

Indexes

Index Uniqueness Tablespace Columns
OKC_ASYNC_UPLOAD_CONTRACT_N1 Non Unique FUSION_TS_TX_IDX DOCUMENT_ID, DOCUMENT_TYPE, DOCUMENT_VERSION, UPLOAD_STATUS
OKC_ASYNC_UPLOAD_CONTRACT_U1 Unique FUSION_TS_TX_IDX ASYNC_UPLOAD_CONTRACT_ID