Tables and Key Fields for Orders

As an administrator or implementor, use or configure these tables and key fields to support the integration.

The creation and fulfillment of an order requires data flow between multiple systems that may work offline or independent of each other. The integration uses these staging tables to store the order information:

DSD Order Request
DSD Order Line Request
DSD Order Status
DSD Order Line Status

DSD Order Request

Here are the key fields in the DSD Order Request (__ORACO__OrderDSD_c) staging table that you use or configure to support the integration. This table captures and stores information about the order requests from telesales and the mobile application. The integrating system must read from this table to identify and process the revisions in order.

Key Fields	API Name	Description
Account	`__ORACO__Account_c`	The account to which the order belongs.
Order Type	`__ORACO__OrderType_c`	Differentiates the types of orders.
Source System Source System Number	`__ORACO__OrderSS_c` `__ORACO__OrderSSN_c`	A unique combination for identifying orders. Source System: A unique identifier that the mobile device issues. This must be unique across different originating systems. Source System Number: A unique number within each source system. Note: Source System and Source System Number of an order is the same across Order Request records and Order Line Request records.
Revision Number	`__ORACO__OrderRN_c`	Represents the revisions of an order. This must start from 1 (when creating an order) and then increment by 1 (for subsequent revisions). Note: Revision Number is the same across the order request and its order line request for each revision. Every revision of an order includes all of its line items.
Process Status	`__ORACO__ProcessStatus_c`	Differentiates between new or processed orders.
Cancellation Requested	`__ORACO__CancelRequestFlag_c`	Captures cancellation request.
Update Requested	`__ORACO__UpdateRequestFlag_c`	Captures update request.
Creation Time	`__ORACO__CreationTime_c`	Captures the order creation time.
Order	`__ORACO__Order_c` `(__ORACO__Order_Id_c)`	The foreign key to Order Rollup record of the Order Request table. The Order Rollup object is internal to Oracle CX Sales for displaying a consolidated order record on the Web UI.

DSD Order Line Request

Here are the key fields in the DSD Order Line Request (__ORACO__OrderLineDSD_c) staging table that you use or configure to support the integration. This table stores the order lines provided by the captured order request. The integrating system must read from this table to identify and process the revisions in order.

Key Fields	API Name	Description
Source System Source System Number Revision Number	`__ORACO__OrderLineSS_c` `__ORACO__OrderLineSSN_c` `__ORACO__OrderLineRN_c`	The source system, source system number, and revision number of the corresponding order request. Source System: A unique identifier that the mobile device issues. This must be unique across different originating systems. Source System Number: A unique number within each source system. Note: Source System and Source System Number of an order is the same across Order Request records and Order Line Request records. Represents the revisions of an Order. This must start from 1 (when creating an order) and then increment by 1 (for subsequent revisions). Note: Revision Number is the same across the Order Request and its Order Line Request for each revision. Every revision of an order includes all of its line items.
Line Number	`__ORACO__OrderLineLN_c`	Uniquely identifies an order line of an order when used together with Source System, Source System Number, and Revision Number.
Product	`__ORACO__Product_c` `(__ORACO__Product_Id_c)`	The product of the order line.
Quantity	`__ORACO__Quantity_c`	The quantity of the products in the order line.
Quantity Delivered at Creating	`__ORACO__QuantDelAtCreate_c`	The quantity already delivered while taking the order. Used for partial deliveries.
Order	`__ORACO__Order_c` `(__ORACO__Order_Id_c)`	The foreign key to order request of the Order Line table.
Order Line	`__ORACO__OrderLine_c` `(__ORACO__OrderLine_Id_c)`	The foreign key to order line rollup of the Order Line table.

The integrating system can uniquely identify orders using a combination of fields in cases where mobile devices may have generated the orders. These fields enable distributed systems to operate in situations where the Order ID is unknown.

These fields are covered in the Order Request and Order Line Request tables:

Source System
Source System Number
Revision Number
Line Number

Note:

These fields don't replace or invalidate the use of ID fields. Oracle CX Sales enforces that the ID fields are available, unique, and automatically populated for all the objects.

If the integrating system posts multiple Order Status revisions (with corresponding lines) for the same order, the application uses the latest revision for calculating the final status.

DSD Order Status

Here are the key fields in the DSD Order Status (__ORACO__OrderStatusDSD_c) staging table that you use or configure to support the integration. This table captures order status updates from the order management system.

Key Fields	API Name	Description
Order	`__ORACO__Order_c` `(__ORACO__Order_Id_c)`	The corresponding order request.
Order - Source System	`__ORACO__OrderSS_c`	The source system of the corresponding order request.
Order - Source System Number	`__ORACO__OrderSSN_c`	The source system number of the corresponding order request.
Order - Revision Number	`__ORACO__OrderRN_c`	The revision number of the corresponding order request.
Revision Number	`__ORACO__RefOrderRN_c`	The revision number of the order status. This must start from 1 and then increment for each subsequent order status of an order.
Last Request Status	`__ORACO__LastRequestStatus_c`	The status of the corresponding order request.
Status	`__ORACO__Status_c`	The final status of the order.

DSD Order Line Status

Here are the key fields in the DSD Order Line Status (__ORACO__OrderLStatusDSD_c) staging table that you use or configure to support the integration. This table provides information about the order lines based on the status update of the orders.

Key Fields	API Name	Description
Order Line	`__ORACO__OrderLine_c`	The corresponding order line request.
Order Line - Source System	`__ORACO__OrderLineSS_c`	The source system of the corresponding order line request.
Order Line - Source System Number	`__ORACO__OrderLineSSN_c`	The source system number of the corresponding order line request.
Order Line - Line Number	`__ORACO__OrderLineNumber_c`	The line number of the corresponding order line request.
Order Line - Revision Number	`__ORACO__OrderLineRN_c`	The revision number of the corresponding order line request.
Order Status	`__ORACO__OrderStatus_c`	The parent order status of the order line status.
Revision Number	`__ORACO__OrderLineStatusRN_c`	The revision number of the order line status.
Last Request Status	`__ORACO__LastRequestStatus_c`	The status of the corresponding order line request.
Status	`__ORACO__Status_c`	The final status of the order line.