CST_DOO_FULFILL_LINES_INT
This interface table is used to store the fulfillment line identifiers that are picked for processing by the COGS Processor. Once the data is processed, corresponding fulfillment line identifiers are removed from the table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_DOO_FULFILL_LINES_INT_PK |
DOO_FULFILL_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Yes | Unique identifier of the fulfillment line in distributed order orchestration (DOO). | |
| SOURCE | VARCHAR2 | 30 | Yes | The source from which the fulfillment line identifier is derived. Possible values are: COGS_PROC_CRL, COGS_PROC_CCFL, COGS_PROC_MAIN. | |
| ROOT_PARENT_LINE_ID | NUMBER | 18 | Unique identifier of the highest orchestration order line in the hierarchy (models). | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Unique identifier for the business unit. | ||
| INVOICE_SOURCE | VARCHAR2 | 30 | The source of the invoice or contract associated with the revenue line. Possible values are: DOO: Distributed Order Orchestration FOS: Supply Chain Financial Orchestration | ||
| 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. | ||
| 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 |
|---|---|---|---|
| CST_DOO_FULFILL_LINES_INT_N1 | Non Unique | DEFAULT | ROOT_PARENT_LINE_ID |
| CST_DOO_FULFILL_LINES_INT_N2 | Non Unique | DEFAULT | REQUEST_ID |
| CST_DOO_FULFILL_LINES_INT_U1 | Unique | DEFAULT | DOO_FULFILL_LINE_ID |