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

XML-Schema Name:CustomerCriVo 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 CustomerCriVo 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
search_type customer_search_type 1 1 Can be one of the following: by customer id, by employee id, by tax id, by customer info or by business info. These are mutually exclusive Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
customerRef:CustomerRef * 0 1 If search by customer id, it contains the customer id; otherwise is empty NA NA NA NA NA NA
employeeRef:EmployeeRef * 0 1 If search by employee id, it contains the employee id linked with a customer; otherwise it is empty. NA NA NA NA NA NA
tax_id varchar21000 0 1 If search by tax id, it contains the customer tax id; otherwise it is empty Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
phone_number varchar230 0 1 If search by phone number, it contains the phone number; otherwise it is empty Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
email_address varchar230 0 1 If search by email address, it contains the email address; otherwise it is empty Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
loyalty:LoyAcctRef * 0 1 If search by loyalty card number, it contains the card id; otherwise is empty NA NA NA NA NA NA
CustomerInfoCriteria * 0 1 If regular customer, and search by customer info, contains the customer information search criteria.Otherwise it is empty
BusinessInfoCriteria * 0 1 If business customer, and search by business info, it contains the business information search criteria. Otherwise the field is empty.
wildcard_search xs:boolean 0 1 Indicates if a wildcard search needs to be performed; always true for ORPOS Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
ignore_case_search xs:boolean 0 1 Indicates if an igonore case search needs to be performed; if missing it defaults to 'false' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
max_record number4 0 1 If multiple matches found, it indicates how many records need to be returned for this search Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustomerInfoCriteria 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 CustomerInfoCriteria 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
first_name varchar2120 0 1 Contains customer's first name used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
last_name varchar2120 0 1 Contains customer's last name used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
postal_code varchar230 0 1 Contains customer's postal code used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
address_1 varchar2240 0 1 Contains Address Line 1. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
phone_number varchar230 0 1 Contains customer's phone number used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:BusinessInfoCriteria 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 BusinessInfoCriteria 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
company_name varchar2120 0 1 Contains the business name used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
postal_code varchar230 0 1 Contains the business postal code used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
address_1 varchar2240 0 1 Contains Address Line 1. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
phone_number varchar230 0 1 Contains the business phone number used for searching. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.