RCV_STAGING_TABLE
RCV_STAGING_TABLE stores information related to receive,return to vendor, return to customer transactions for the subcontracted items and also any respective corrections thereafter. This table stores the transaction identifiers to retrieve all necessary receiving transactions information by joining with main receiving transaction tables.
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Receiving transaction unique identifier. Maps to RCV_TRANSACTIONS.TRANSACTION_ID. | |
| TEAM | VARCHAR2 | 3 | Yes | Three letter product code that created the current record. | |
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| STATUS | VARCHAR2 | 10 | Yes | Status indicator. Indicates whether row is PENDING or in ERROR. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| TRANSACTION_REQUEST_ID | NUMBER | 18 | Yes | Maps to the value of RCV_TRANSACTIONS.REQUEST_ID. | |
| TRANSACTION_GROUP_ID | NUMBER | 18 | Yes | Maps to the value of RCV_TRANSACTIONS.GROUP_ID. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCV_STAGING_TABLE_N1 | Non Unique | Default | TRANSACTION_GROUP_ID |
| RCV_STAGING_TABLE_U1 | Unique | Default | TRANSACTION_ID, TEAM |
| RCV_STAGING_TABLE_N2 | Non Unique | Default | TRANSACTION_REQUEST_ID |