CST_SHIPMENT_REVENUE_MAP_S_GT
This is a global temporary table that will act as supporting table to load ship-bill references for which COGS and RMA Recognition transactions are supposed to be created.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_SHIPMENT_REV_MAP_S_GT_PK |
EXTERNAL_SYSTEM_REFERENCE, SHIPMENT_FULFILL_LINE_ID, DELIVERY_ID, BILLING_FULFILL_LINE_ID, RMA_TRANSACTION_ID, DS_SOURCE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Value that uniquely identifies the external source system. | |
| BILL_ONLY_FLAG | VARCHAR2 | 1 | A flag that indicates if the ship-bill reference record is for bill-only fulfillment. | ||
| DOO_SPLIT_FULFILL_LINE_ID | NUMBER | 18 | Fulfillment line identifier against which sales order shipment or RMA receipt transactions have been performed. | ||
| DS_SOURCE_LINE_ID | NUMBER | 18 | Yes | For customer dropship scenario, it indicates either shipment line identifier or transaction event identifier based on the flow type (ASN or INVOICE). | |
| 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. | |
| DELIVERY_ID | VARCHAR2 | 120 | Yes | Value that uniquely identifies the delivery associated with the sales shipment transaction. | |
| BILLING_FULFILL_LINE_ID | NUMBER | 18 | Yes | Fulfillment line identifier against which the billing is done. | |
| RMA_TRANSACTION_ID | VARCHAR2 | 32 | Yes | Value that uniquely identifies the receiving transaction corresponding to the RMA receipt. | |
| 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. | ||
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | Unique identifier of the fulfillment line for the root or model item. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SHIPMENT_REV_MAP_S_GT_U1 | Unique | EXTERNAL_SYSTEM_REFERENCE, SHIPMENT_FULFILL_LINE_ID, DELIVERY_ID, BILLING_FULFILL_LINE_ID, RMA_TRANSACTION_ID, DS_SOURCE_LINE_ID |