DOO_ORDER_CLOSED_DETAILS
Contains details that identify sales orders and fulfilment lines that are closed. A scheduled process uses this table to identify the nontransactional data that it will delete for closed sales orders and closed fulfillment lines.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
DOO_ORDER_CLOSED_DETAILS_PK |
ORDER_CLOSED_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORDER_CLOSED_DETAIL_ID | NUMBER | 18 | Yes | Value that uniquely identifies the order closed detail. ORDER_CLOSED_DETAIL_ID is the primary key specifically for the DOO_ORDER_CLOSED_DETAILS table. | |
| BATCH_ID | NUMBER | 18 | Value that uniquely identifies the batch of nontransactional entities to process. | ||
| STATUS_CODE | VARCHAR2 | 30 | Contains A, Null, or no value. A: the entity is closed and is active. Null or no value: the entity isn't active. | ||
| HEADER_ID | NUMBER | 18 | Yes | Value that uniquely identifies the closed sales order or the sales order that contains closed fulfillment groups. | |
| ENTITY_TYPE | VARCHAR2 | 30 | Yes | Contains H or G: H for the order header or G for the fulfillment group that contains fulfillment lines. | |
| ENTITY_ID | NUMBER | 18 | Yes | Value that uniquely identifies the closed sales order or the fulfillment group that contains closed fulfillment lines. If the closed entity is an order header, then ENTITY_ID identifies the sales order. If the closed entity is a fulfillment line, then ENTITY_ID identifies the fulfillment group. | |
| DATE_CLOSED | TIMESTAMP | Yes | Date when order management closed the sales order or closed the fulfillment lines that are part of a fulfillment group. | ||
| DELETED_FLAG | VARCHAR2 | 1 | Yes | Contains Y or N. Y: A scheduled process successfully deleted the nontransactional entities from the closed sales order or fulfillment group. N: Order management closed the sales order or closed fulfillment lines that are part of the fulfillment group, but the scheduled process hasn't yet deleted the nontransactional entities from that order or group. | |
| PROCESS_INSTANCE_ID | NUMBER | 18 | Value that uniquely identifies an instance of the orchestration process that processed the fulfilment line. | ||
| 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_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 |
|---|---|---|---|
| DOO_ORDER_CLOSED_DETAILS_N1 | Non Unique | Default | DATE_CLOSED, ENTITY_TYPE |
| DOO_ORDER_CLOSED_DETAILS_U1 | Unique | Default | ORDER_CLOSED_DETAIL_ID |