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

XML-Schema Name:LoyInvcDesc 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 LoyInvcDesc 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
transaction_id varchar2128 0 1 The full identifier for the retail transaction from the point-of-sale system. This element should be missing if the invoice is for an order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
customer_order_id varchar248 0 1 The full identifier for the customer order from the order management system. This element should be missing if the invoice is for a transaction. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
loyalty_account_id varchar232 0 1 The id of the loyalty account that was attached to the transaction or order as per the loyalty system of record. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
loyalty_program_id varchar232 0 1 The id of the loyalty program that the loyalty account is a part of. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
loyalty_program_level_id number2 0 1 The id of the loyalty program that the loyalty account is a part of. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
LineItemPoints * 0 999 A list of LineItemPoints may exist here to breakdown the points that were issued (or projected to be depending on the request) per line. Limited to 999 to prevent XML overflow.
TotalPoints * 1 1 A breakdown of the points issued (or projected to be depending on the request) for the entire order or transaction.

XML-Schema Name:LineItemPoints 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 LineItemPoints 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
line_index number3 1 1 The index of the line item within the context of the order or transaction. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
line_item_id varchar225 0 1 The item id, such as the sku or upc, that identifies the item(s) for this line. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
earned number9 1 1 The points earned for this line item purchase/order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
escrow number9 0 1 The points in escrow for this line item purchase/order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
bonus number9 0 1 The points awarded in bonus for this line item purchase/order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:TotalPoints 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 TotalPoints 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
earned number9 1 1 The points earned for this order or transaction. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
escrow number9 0 1 The points in escrow for this order or transaction. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
bonus number9 0 1 The points awarded in bonus for this order or transaction. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.