OKC_IMP_CONTRACT

Details

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

Primary Key

Name	Columns
OKC_IMP_CONTRACT_ADDRS_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
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			Code specifying the action for the import for e.g., INSERT, UPDATE or NULL. In the current release only INSERT is supported.
INTERNAL_ACTION_CODE	VARCHAR2	30			Used internally by the bulk import ODI program.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
FUSION_CONTRACT_ADDR_ID	NUMBER		18		For successfully imported Contract Addresses, stores the Fusion Contract Address Id. This is intended to support reimport.
MAJOR_VERSION	NUMBER		18		Contract Address 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
CHR_ID	NUMBER		18		Fusion Contract Header Id to which the address belongs.
ADDRESS_SOURCE	VARCHAR2	40			Type of address that is being stored. Currently only Fusion Party Site entity is supported as a valid address source. HZ_PARTY_SITES is the only supported value.
ADDRESS_ID	NUMBER		18		Address Id (fusion key) of the address.
HDR_EXT_SOURCE	VARCHAR2	120			External key of the contract to which the address belongs. If a line is being created either the contract???s Fusion key or External key must be passed.
HDR_EXT_KEY	VARCHAR2	120			See HDR_EXT_SOURCE.
SOURCE_OBJECT_CODE	VARCHAR2	30			Type of contract entity whose address is being captured. Currently only Contract party addresses are stored in OKC_K_ADDRESSES table, therefore the only supported value is CONTRACT_PARTY.
SOURCE_OBJECT_ID	NUMBER		18		Identifies the parent contract entity to which the address belongs. Should correspond to contract party. Either the fusion key or external key of the parent contract entity must be passed during create.
SOURCE_OBJECT_EXT_SOURCE	VARCHAR2	120			External key of the parent contract entity to which the address belongs.
SOURCE_OBJECT_EXT_KEY	VARCHAR2	120			See SOURCE_OBJECT_EXT_SOURCE.
FILE_NAME_SYSTASK_ID	NUMBER		18		Save the individual sys task id for each input csv file
INTERNAL_ADDRS_OVN	NUMBER		9		Internal OVN column

Indexes

Index	Uniqueness	Tablespace	Columns
OKC_IMP_CONTRACT_ADDRS_N1	Non Unique	Default	BATCH_ID, EXT_SOURCE, HDR_EXT_KEY
OKC_IMP_CONTRACT_ADDRS_N2	Non Unique	Default	BATCH_ID, ADDRESS_ID
OKC_IMP_CONTRACT_ADDRS_U1	Unique	FUSION_TS_TX_IDX	BATCH_ID, INTERFACE_ROW_ID