MSC_ATP_ORDER_PROMISING

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_ATP_ORDER_PROMISING_PK	UNIQUE_ORDER_NUMBER

Columns

Name	Datatype	Length	Precision	Not-null	Comments
UNIQUE_ORDER_NUMBER	VARCHAR2	32		Yes	Header level attribute that indicates the unique order identifier for the request.
CALLING_MODULE	VARCHAR2	32			A string that indicates the identifier of the module from which the order promising service request originated.
CALLING_INSTANCE	VARCHAR2	32			A string that indicates the unique identifier of the source system from which the order promising service request originated.
RELEASE_NUMBER	VARCHAR2	32			The release number of the Oracle Fusion Distributed Order Orchestration application that is invoking Oracle Fusion Global Order Promising services.
PROMISE_DATE	DATE				A date and time when the promise is generated by DOO-OP.
PROMISING_SYSTEM	VARCHAR2	32			A string identifier for the order promising system that performed the availability check.
PROMISING_INSTANCE	VARCHAR2	32			Unique identifier for the source system in which order promising is performed.
SALES_ORDER_NUMBER	VARCHAR2	64			A string unique identifier for the sales order for which the fulfillment line is created.
NUMBER_OF_ALT_OPTIONS	NUMBER				A number that indicates the total number of availability options generated for the fulfillment line service request.
REQUESTED_CREATION_DATE	DATE				Date and time when the check availability request was created for the fulfillment line.
SET_IDENTIFIER	VARCHAR2	32			A string unique identifier for the fulfillment line set.
ROOT_PARENT_FULFILL_ID	VARCHAR2	64			Response attribute that indicates the unique fulfillment line identifier for the root parent CTO model. Applicable only for configured to order items.
SET_TYPE	VARCHAR2	32			A string that indicates the type of fulfillment line set sent for promising. The valid values are ship, arrival, pickup and consolidation. Only ship sets are currently supported.
MODEL_TYPE	VARCHAR2	32			Contains one of the following ATO, PTO-SMC, PTO-NSMC. A string that indicates they type of configure to order communicated in the service request.
OPERATION_NAME	VARCHAR2	255			A string that indicates the type of request that needs to be performed for the fulfillment line.
EXPECTED_GROUP_SHIP_DATE	DATE				A date attribute that indicates the date on which the set of fulfillment lines are expected to be shipped together from the shipping organization.
EXPECTED_GROUP_ARRIVAL_DATE	DATE				A date attribute that indicates the date on which the set of fulfillment lines are expected to arrive at the customer ship-to site.
ERROR_CODE	VARCHAR2	10			A string that indicates the error code returned by Oracle Fusion Global Order Promising for the fulfillment line availability request.
ERROR_MESSAGE	VARCHAR2	255			ErrorMessages of corresponding ErrorCode.
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.
ENGINE_NAME	VARCHAR2	6			This column is used to capture the system by which the request is processed
IS_PROCESSED	NUMBER		1		This column is used to mark the records which needs to be picked by ESS job for processing .

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_ATP_ORDER_PROMISING_U1	Unique	Default	UNIQUE_ORDER_NUMBER
MSC_ATP_ORDER_PROMISING_N1	Non Unique	Default	LAST_UPDATE_DATE