CST_I_SHIPMENT_REVENUE_MAP

This interface table captures the mapping between the shipment fullfillment lines and the billing fullfillment lines. This 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: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Yes	Identifier of the source order orchestration system.
FULLFILL_LINE_ID	NUMBER		18		Fulfillment Line identifier against which sales order shipment or RMA receipt transactions have been performed.
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	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.
BILL_ONLY_FLAG	VARCHAR2	1			Indicates that the Billing Fullfill Line has no corresponding shipment lines.
SHIPMENT_LINE_ID	NUMBER		18		Identifies the Shipment Details
DS_SOURCE_LINE_ID	NUMBER		18		An identifier which based on flow type(ASN OR INVOICE) indicates either shipment line identifier or transaction event identifier for the customer drop ship flows.
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.
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.