RCS_QS_ORG_COPIES
Table to store the information for the copy of an inventory organization. Users specify the code, name and location for each new copied organization.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
rcs_qs_org_copies_PK |
QS_ORG_COPY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QS_ORG_COPY_ID | NUMBER | 18 | Yes | Primary key and unique indicator for the copy organization request. | |
| STATUS | VARCHAR2 | 30 | Tracks the possible error points by storing the point of the last success when making the copy of each organization. So if the copy of the organization and parameters succeeds, but the Subinventory copy fails, a re-running of the job on the same data will pick up from this point and retry the Subinventory copy again, followed by all downstream requested additional data to duplicate requests. A value of SUCCESS indicates all additional data to duplicate was successfully created. | ||
| QS_ORG_COPY_SRC_ID | NUMBER | 18 | Yes | Foreign key to parent table, to indicate which set of dependent set up data to apply | |
| NEW_ORG_CODE | VARCHAR2 | 18 | Yes | Code to use on the copied inventory organization. | |
| NEW_ORG_NAME | VARCHAR2 | 240 | Yes | Name to use for the copied inventory organization. | |
| NEW_ORG_LOC_ID | NUMBER | 18 | Yes | Warehouse location to use for the copied inventory organization. | |
| 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. | ||
| 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 |
|---|---|---|---|
| rcs_qs_org_copies_U1 | Unique | FUSION_TS_TX_IDX | QS_ORG_COPY_ID |