CST_SHIPMENT_REVENUE_MAP_I_GT
This is a global temporary table that will be used to store new ship-bill references derived from the Order Management API and then move it to the persistent table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Value that uniquely identifies the external source system. | |
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Fulfillment line identifier against which sales order shipment or RMA receipt transactions have been performed. | ||
| SHIPMENT_FULFILL_LINE_ID | NUMBER | 18 | Yes | Fulfillment line identifier against which sales order shipment or RMA receipt transactions have been performed. In case of split, it is the reference to the unique identifier of the source fulfillment line. | |
| BILLING_FULFILL_LINE_ID | NUMBER | 18 | Yes | Fulfillment line identifier against which the billing is done. | |
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | Unique identifier of the root or model item in case of complex flows involving KIT, PTO or ATO. | ||
| DELIVERY_ID | VARCHAR2 | 120 | Yes | Value that uniquely identifies the delivery associated with the sales shipment transaction. | |
| RMA_TRANSACTION_ID | VARCHAR2 | 32 | Yes | Value that uniquely identifies the receiving transaction corresponding to the RMA receipt. | |
| SHIPMENT_LINE_ID | NUMBER | 18 | Value that uniquely identifies the transaction for the customer dropship flow. | ||
| DS_SOURCE_LINE_ID | NUMBER | 18 | For customer dropship scenario, it indicates either shipment line identifier or transaction event identifier based on the flow type (ASN or INVOICE). | ||
| BILL_ONLY_FLAG | VARCHAR2 | 1 | A flag that indicates if the ship-bill reference record is for bill-only fulfillment. | ||
| STATUS | VARCHAR2 | 30 | Indicates the status of the ship-bill reference record. Possible values are: NULL: Valid. E: Error. | ||
| MESSAGE_CODE | VARCHAR2 | 30 | Indicates the error message code returned by shipment revenue mapping API. | ||
| MESSAGE_TEXT | VARCHAR2 | 960 | Indicates the error message text returned by shipment revenue mapping API. | ||
| OPEN_REMNANT_MODEL_FLAG | VARCHAR2 | 1 | Indicates whether the shipment revenue mapping API returned an error because the fulfillment line was associated with a remnant model that is not closed yet. | ||
| INVENTORY_INTERFACED_FLAG | VARCHAR2 | 1 | A flag that indicates if the fulfillment is for the direct sales order issue. Possible values are: N: Not a direct sales order issue fulfillment. Y: Direct sales order issue fulfillment. |