CSE_DOC_REFERENCES_INT
This interface table captures all the document references that are to be associated with the asset.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
CSE_DOC_REFERENCES_INT_PK |
INTERFACE_ROW_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ROW_ID | NUMBER | 18 | Yes | Interface Row Identifier. The primary key column of this table. | |
INTERFACE_STATUS_CODE | VARCHAR2 | 30 | The status of the interface row. The processor heavily relies on this column to persist interim status of the row upon processing data in bulk. | ||
INTERFACE_BATCH_ID | NUMBER | 18 | Interface Batch Identifier. This is the foreign key to the Interface Batch entity. | ||
INTERFACE_BATCH_CODE | VARCHAR2 | 30 | The interface batch code. The user key to the interface batch entity. | ||
INTERFACE_RECORD_NUMBER | VARCHAR2 | 18 | Interface Record Number. This is the user key to link the child interface entities together. | ||
ACTION_CODE | VARCHAR2 | 30 | Yes | The various actions that can be performed via the import functionality at the document reference level. | |
DOCUMENT_REF_ID | NUMBER | 18 | The document reference id. This is mapped to cse_tracked_object_refs.tracked_object_ref_id. | ||
SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Type of source system. Valid values exist in the lookup with lookup_type = ORA_CSE_SOURCE_SYSTEM_TYPE. | ||
SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | Depending on the source system type, it could be a product code or the TCA source system reference. FND_APPLICATION_ID.PRODUCT_CODE HZ_ORIG_SYSTEMS_VL.ORIG_SYSTEM | ||
SOURCE_SYSTEM_ID | NUMBER | 18 | The application id value is stored here if the source_system_type is "INTERNAL". If "EXTERNAL", then the Source system as it is defined in TCA source systems table. | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that uniquely identifies the document type as defined in lookup ORA_CSE_DOCUMENT_TYPE. | ||
DOCUMENT_NUMBER | VARCHAR2 | 80 | Number that identifies the document for the asset document reference. | ||
DOCUMENT_ID | NUMBER | 18 | Value that uniquely identifies the document for the asset document reference. | ||
DOCUMENT_LINE_NUMBER | VARCHAR2 | 80 | Numbers that identifies the line of the document for the asset document reference. | ||
DOCUMENT_LINE_ID | NUMBER | 18 | Value that uniquely identifies the document line for the asset document reference. | ||
DOCUMENT_SUB_LINE_NUMBER | VARCHAR2 | 80 | Numbers that identifies the sub line of the document for the asset document reference. | ||
DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Value that uniquely identifies the document sub line for the asset document reference. | ||
DOCUMENT_DATE | DATE | Date when the document was originated. If not provided, the default date is the system date. | |||
PARTITION_NUMBER | NUMBER | 18 | For parallel processing, the internal logic uses this column to stripe the bunch of document references in to a partition. | ||
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. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Yes | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_DOC_REFERENCES_INT_U01 | Unique | Default | INTERFACE_ROW_ID |