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

XML-Schema Name:GiftListItemColDesc 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 GiftListItemColDesc 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
GiftListItemDesc:GiftListItemDesc * 0 5000 Description of gift item or wish list item. NA NA NA NA NA NA
collection_size number4 0 1 The number of GiftListItemDesc objects. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Dynamic data. Not stored to database.
total_records number4 0 1 The total records of the result set if maximum result set count specified in request criteria is ignored. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Dynamic data. Not stored to database.

XML-Schema Name:GiftListItemDesc 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 GiftListItemDesc 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
item_id varchar240 1 1 Unique identifier for this gift list item or wish list item. DCS_GIFTITEM PRODUCT_ID RIB or/and RSB Fill column length. Yes
xref_item_id varchar240 0 10 An item id that any system can use to cross-reference the item from another list. This is an alternate id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Not used. All item ids are expected to be sync'ed between systems. Xref is an alternative item id which is not needed.
desired_quantity number19_4 0 1 Desired quantity for the gift list item or wish list item. DCS_GIFTITEM QUANTITY_DESIRED RIB or/and RSB Fill column length. Yes Fill this description.
purchased_quantity number19_4 0 1 Purchased quantity for a gift list item. DCS_GIFTITEM QUANTITY_PURCHASED RIB or/and RSB Fill column length. Yes Fill this description.