OKC_CONTRACT_BATCH_ING

Details

Schema: FUSION
Object owner: OKC
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
OKC_CONTRACT_BATCH_ING_INT_PK	DOC_PROCESS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Identifier of the contract batch ingestion record.
DOCUMENT_ID	VARCHAR2	100			Identifier of the document in the ingestion batch.
DOC_PROCESS_ID	NUMBER		18	Yes	Unique document processing identifier for the ingestion record.
DOC_PROCESS_NUMBER	VARCHAR2	64		Yes	Unique document process number for the ingestion record.
FILE_NAME	VARCHAR2	100			Name of the ingested file.
AGENT_PROP_CONTRACT_TYPE_ID	NUMBER		18		Contract type identifier proposed by the ingestion agent.
AGENT_PROPOSED_CONTRACT_TYPE	VARCHAR2	100			Contract type proposed by the ingestion agent.
AGENT_CONFIDENCE	NUMBER		3		Confidence score provided by the ingestion agent.
EVIDENCE_DATA	VARCHAR2	1000			Evidence data used for the proposed contract type.
OVERRIDE_CONTRACT_TYPE_ID	NUMBER		18		Contract type identifier selected as an override.
STATUS	VARCHAR2	20			Status of the document ingestion process.
ERROR_MESSAGE	VARCHAR2	2000			Error message captured during document ingestion.
FIELDS_EXTRACTED	VARCHAR2	20			Indicates whether fields were extracted from the document.
REQUIRED_FIELDS	NUMBER				Number of required fields extracted from the document.
SUPPLIER_PARTY_ID	NUMBER		18		Supplier party identifier extracted from the document.
SUPPLIER_NAME	VARCHAR2	100			Supplier name extracted from the document.
CUSTOMER_PARTY_ID	NUMBER		18		Customer party identifier extracted from the document.
CUSTOMER_NAME	VARCHAR2	100			Customer name extracted from the document.
START_DATE	DATE				Start date extracted from the document.
CONTRACT_AMOUNT	NUMBER				Contract amount extracted from the document.
CONTRACT_NUMBER	VARCHAR2	120			Contract number extracted from the document.
PARENT_CONTRACT_NUMBER	VARCHAR2	120			Parent contract number extracted from the document.
BUY_OR_SELL	VARCHAR2	3			Buy or sell indicator extracted from the document.
CURRENCY_CODE	VARCHAR2	15			Currency code extracted from the document.
END_DATE	DATE				End date extracted from the document.
TERMS	VARCHAR2	100			Terms extracted from the document.
AUTHORING_PARTY	VARCHAR2	15			Authoring party extracted from the document.
CONTRACT_NAME	VARCHAR2	200			Contract name extracted from the document.
RELATIONSHIP_ID	VARCHAR2	20			Relationship identifier extracted from the document.
VERSION	NUMBER				Version extracted from the document.
EXTN_INGESTION	CLOB				Extended ingestion payload for the document.
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
OKC_CONTRACT_BATCH_ING_INT	okc_contract_batch_ingestion	BATCH_ID

Indexes

Index	Uniqueness	Tablespace	Columns
OKC_CONTRACT_BATCH_ING_INT_U1	Unique	Default	DOC_PROCESS_NUMBER
OKC_CONTRACT_BATCH_ING_INT_U2	Unique	Default	DOC_PROCESS_ID