OKC_IMP_CONTRACT_RELNS
Interface table for importing Contract Relationships
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
OKC_IMP_CONTRACT_RELNS_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_RELN_ID | NUMBER | 18 | For successfully imported Contract Relationships, stores the Fusion Contract Relationship Id. This is intended to support reimport. | ||
| 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 | Id of the contract for which the relationship is defined. | ||
| HDR_EXT_SOURCE | VARCHAR2 | 120 | External key of the contract to which the relationship 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. | ||
| RELN_CODE | VARCHAR2 | 30 | Type of relationship. For OM relationships, seeded values are provided. For user defined relationships, users can add their own relationship types. For e.g., Ordered From (OM relationship), Referenced By (user relationship). | ||
| REL_CONTRACT_ID | NUMBER | 18 | Identifies the related contract in the relationship. | ||
| REL_OBJECT_EXT_SOURCE | VARCHAR2 | 120 | External key of the related contract The related contract???s fusion key or external key must be specified. | ||
| REL_OBJECT_EXT_KEY | VARCHAR2 | 120 | See REL_OBJECT_EXT_SOURCE. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Save the individual sys task id for each input csv file | ||
| INTERNAL_RELNS_OVN | NUMBER | 9 | Internal OVN column | ||
| INTERNAL_RECIPROCAL_RELN_CODE | VARCHAR2 | 30 | INTERNAL_RECIPROCAL_RELN_CODE | ||
| INTERNAL_HEADER_STATUS | VARCHAR2 | 30 | INTERNAL_HEADER_STATUS | ||
| RELN_NAME | VARCHAR2 | 80 | Relationship name | ||
| DATA_LANG | VARCHAR2 | 30 | Language for name column |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_IMP_CONTRACT_RELNS_N1 | Non Unique | FUSION_TS_TX_DATA | BATCH_ID, EXT_SOURCE, EXT_KEY |
| OKC_IMP_CONTRACT_RELNS_U1 | Unique | FUSION_TS_TX_IDX | BATCH_ID, INTERFACE_ROW_ID |