Retail Integration Mappings Report Release:16.0.21 (RCE)
Application RCE
Target Name Space http://www.oracle.com/retail/integration/base/bo/PurchHistColDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PurchHistColDesc 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 PurchHistColDesc 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
collection_size number3 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
PurchHistDesc:PurchHistDesc * 0 999 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:PurchHistDesc 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 PurchHistDesc 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
initiate_loc_type initiate_loc_type 0 1 A enumeration indicating the location type where the order/transaction was initiated. The possible values are "W" for Web orders, "M" for mail orders, "S" for store and "O" for others. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
initiate_loc_id varchar210 0 1 The location id where the order/transaction was initiated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
purchase_type purchase_type 1 1 An enumeration indicating the type of purchase this record represents.Can be 'T' for TRANSACTION or 'O' for ORDER Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
id varchar248 1 1 The unique order identifier or the unique transaction identifier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
currency_code varchar23 1 1 The currency ISO code used in the purchase. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
status purchase_status 1 1 A enumeration indicating the current status of the transaction or order.Valid values may be PENDING,PARTIAL,NEW,COMPLETED,FILLED,INPROCESS,CANCELLED,DELIVERED,UNKNOWN. 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/transaction 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.
submitted_date xs:dateTime 1 1 The submission timestamp for the order or transaction this record represents. For an order,this denotes the time the order was submitted. For a transaction this reflects the time the transaction was ended. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
number_of_items number10 1 1 The total number of items in this order/transaction. It does not include the individual quantities of items in the count.For example, if there are 2 items with quantities 2m and 3.5 kg, this element reflects only 2 as the total count of items. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
itm:PurchItmHdrColDesc * 0 1 A collection of order/transaction items.The occurrence and size of this collection is governed by the line_item_population element, in PurchHistCriVo. NA NA NA NA NA NA