Retail Integration Mappings Report Release:16.0.21 (RCE)
Application RCE
Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrderDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:CustOrderDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrderDesc in RCE application.
RCE's Table Name RCE's Column Name Integration API(RIB or/and RSB or/and RSL) RCE's Column Length Is Column Required in RCE's API? RCE's API Description
customer_order_id varchar248 1 1 The customer order id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
external_ref_id varchar2120 0 1 The id from an external source that is linked to this order. This is used for integration purpose. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
currency_code varchar23 0 1 The currency ISO code. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
lcl:LocaleDesc * 0 1 The order's original receipt locale. NA NA NA NA NA NA
order_desc varchar2250 0 1 The order description in its original receipt locale. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
order_status order_status 1 1 A enum indicating the order status. The possible values are "NEW", "OPEN", "PARTIAL", "HELD", "SUSPENDED", "CANCELED", "COMPLETED", "FILLED", or "ERROR". Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
initiate_loc_type initiate_loc_type 1 1 A enum indicating the location type where the order is initiated. The possible values are "O" for online or "S" for store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
initiate_loc_id number10 1 1 The location id where the order is initiated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
initiate_country_code varchar23 1 1 The country code where the order is initiated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
grand_total number20_4 0 1 The grand total order amount that includes discount, tax, and shipping charges. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
sub_total number20_4 0 1 The subtotal order amount that does not include discount, tax, and shipping charges. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
tax_total number20_4 0 1 Total amount of sales tax paid for this order Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
inclusive_tax_total number20_4 0 1 Total amount of VAT tax paid for this order. The VAT tax is already included in the item price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
shipping_charge_total number20_4 0 1 The total amount of shipping charge paid for this order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
discount_total number20_4 0 1 The total amount of discount for this order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
completed_amount number20_4 0 1 The total amount picked up or shipped for this order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
cancelled_amount number20_4 0 1 The total amount cancelled for this order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
returned_amount number20_4 0 1 The total amount returned for this order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
completed_discount_amount number20_4 0 1 The discount amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
cancelled_discount_amount number20_4 0 1 The discount amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
returned_discount_amount number20_4 0 1 The discount amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
completed_tax_amount number20_4 0 1 The tax amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
cancelled_tax_amount number20_4 0 1 The tax amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
returned_tax_amount number20_4 0 1 The tax amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
completed_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been picked up or shipped. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
cancelled_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been cancelled. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
returned_inclusive_tax_amount number20_4 0 1 The VAT tax amount applied to order items that have been returned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
paid_amount number20_4 0 1 The total paid amount for this order. The following formula holds true. paid_amount + rounding_adjustment = total payment from payment collection - refund_amount_offset_by_sale Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
rounding_adjustment number20_4 0 1 The rounding adjustment for this order. It can be positive or negative. The following formula holds true. paid_amount + rounding_adjustment = total payment from payment collection - refund_amount_offset_by_sale Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
refund_amount_offset_by_sale number20_4 0 1 The refund amount offset by take with items purchased. This amount is always positive. The following formula holds true. paid_amount + rounding_adjustment = total payment from payment collection - refund_amount_offset_by_sale Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
cst:CustomerDesc * 0 1 The customer that is assigned to this order. NA NA NA NA NA NA
gift_receipt_assigned gift_receipt_assigned 0 1 A boolean flag indicating if a gift receipt is assigned to this order. The possible values are "Y" or "N". Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
default_gift_registry_id varchar214 0 1 The default gift registry id of the order if there is one. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
age_restricted_dob xs:dateTime 0 1 The birthday of the customer if the order has restrictive items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
create_timestamp xs:dateTime 1 1 The order creation timestamp. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
update_timestamp xs:dateTime 1 1 The order update timestamp. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
itm:CustOrdItmColDesc * 0 1 A collection of order items. NA NA NA NA NA NA
rtn:CustOrderRtnColVo * 0 1 A collection of returns created on this order. NA NA NA NA NA NA
ful:CustOrdFulColDesc * 0 1 A collection of order fulfillment details. A fulfullment detail defines how a group of items will be fulfilled: in store pick up or ship. NA NA NA NA NA NA
del:CustOrdDelColDesc * 0 1 A collection of order delivery records. NA NA NA NA NA NA
pay:PaymentColDesc * 0 1 A collection of order payments. NA NA NA NA NA NA