CST_CLOSED_FULFILL_LINES_I_GT
This is a global temporary table that stores the list of fulfillment line identifiers that have been closed in the source system (DOO).
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_CLOSED_FLINES_I_GT_PK |
DOO_FULFILL_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Yes | Distributed Order Orchestration fulfillment line identifier. | |
| PROCESSED_FLAG | VARCHAR2 | 1 | A flag that indicates if the fulfillment line identifier is processed by COGS Processor. Possible values are: N: Not yet processed. P: Processed. E: Error status indicating that ship-bill reference derived for the fulfillment line identifier is invalid. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Billing / selling business unit identifier for the closed fulfill line. | ||
| SHIP_BILL_REF_FLAG | VARCHAR2 | 1 | Indicates if the ship-bill reference is generated for the closed fulfillment line identifier. Possible values are: N: Ship-bill reference is not yet generated. Y: Ship-bill reference is generated. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_CLOSED_FLINES_I_GT_U1 | Unique | DOO_FULFILL_LINE_ID |