CST_SHIPMENT_REVENUE_MAP
This is the persistent table that stores the shipment revenue mapping information.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_SHIPMENT_REVENUE_MAP_PK |
EXTERNAL_SYSTEM_REFERENCE, SHIPMENT_FULLFILL_LINE_ID, DELIVERY_ID, BILLING_FULLFILL_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. | |
| 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_FULLFILL_LINE_ID | NUMBER | 18 | Yes | Fulfillment line identifier against which sales order shipment or RMA receipt transactions have been performed. In case of split, 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_FULLFILL_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. | |
| BILL_ONLY_FLAG | VARCHAR2 | 1 | A flag that indicates if the ship-bill reference record is for bill-only fulfillment. | ||
| COGS_PROCESSED_FLAG | VARCHAR2 | 1 | Indicates if the COGS or RMA recognition transaction is created against the ship-bill reference record. | ||
| 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. | ||
| 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_SHIPMENT_REVENUE_MAP_N1 | Non Unique | FUSION_TS_TX_DATA | SHIPMENT_FULLFILL_LINE_ID, BILLING_FULLFILL_LINE_ID |
| CST_SHIPMENT_REVENUE_MAP_N2 | Non Unique | FUSION_TS_TX_DATA | BILLING_FULLFILL_LINE_ID |
| CST_SHIPMENT_REVENUE_MAP_PK | Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, SHIPMENT_FULLFILL_LINE_ID, DELIVERY_ID, BILLING_FULLFILL_LINE_ID, RMA_TRANSACTION_ID, DS_SOURCE_LINE_ID |