CST_SHIPMENT_REV_MAP_ERRORS
This table stores all the duplicate shipment and billing fulfillment records while transferring information from costing interface to costing persistant table. Mapping will help drive the cost of goods sold recognition based on the revenue recognition.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_SHIPMENT_REV_MAP_ERRO_PK |
SHIPMENT_REVENUE_MAP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SHIPMENT_REVENUE_MAP_ID | NUMBER | 18 | Yes | Unique Identifier for the shipment revenue duplicate record | |
| BILL_ONLY_FLAG | VARCHAR2 | 1 | Indicates that the Billing Fullfill Line has no corresponding shipment lines. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifier of the source order orchestration system. | |
| SHIPMENT_FULLFILL_LINE_ID | NUMBER | 18 | Yes | Fullfillment Line identifier against which sales shipment transactions have been performed | |
| DELIVERY_ID | VARCHAR2 | 120 | Yes | Identifies the delivery associated with sales shipment transactions. This is required when multiple billing fullfill lines point to the same shipment fullfill line (as in the case of enhanced splits) | |
| BILLING_FULLFILL_LINE_ID | NUMBER | 18 | Yes | Fullfillment line identifier against which the billing is done. This will not be populated when there is no billing for the sales shipments. | |
| RMA_TRANSACTION_ID | VARCHAR2 | 32 | Yes | It refers to the receiving transaction identifier corresponding to the RMA receipt. | |
| 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_REV_MAP_ERRORS_PK | Unique | Default | SHIPMENT_REVENUE_MAP_ID |
| CST_SHIPMENT_REV_MAP_ERRS_N1 | Non Unique | Default | SHIPMENT_FULLFILL_LINE_ID, DELIVERY_ID, RMA_TRANSACTION_ID |