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

XML-Schema Name:CustomerColDesc 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 CustomerColDesc 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 number4 1 1 Number of records to be returned in one call Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
total_records number9 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 Fill this description.
CustomerDesc:CustomerDesc * 0 unbounded Customer object; 0 if none are found NA NA NA NA NA NA

XML-Schema Name:CustomerDesc 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 CustomerDesc 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
CustomerRef:CustomerRef * 0 1 Unique identifier for customer. NA NA NA NA NA NA
AlternateKeys * 0 999 Contains list of alternates keys associated with the customer. This must no include sensitive customer information like nationalIDs, credit card numbers, passport numbers etc.
customer_type customer_type 0 1 Contains the customer type: regular customer or business. dps_user user_type RSB 38,0 Yes user type
first_name varchar2120 0 1 Customer first name dps_user first_name RSB 40 No First name of customer/user.
last_name varchar2120 0 1 Customer Last name dps_user last_name RSB 40 No Last name of customer/user
middle_name varchar2120 0 1 Customer middle name dps_user middle_name RSB 40 No Middle name of customer/user
company_name varchar2250 0 1 If this customer is a business, this field contains the name of the business. RXM_USER company_name RSB 40 No Company name of user.
contact_by_mail xs:boolean 0 1 Indicates if the customer wants to be contacted by mail. Defaults to false if not specified. RXM_USER RECEIVE_MAIL RSB 1,0 No Boolean to know if user can be contacted by mail
contact_by_phone xs:boolean 0 1 Indicates if the customer wants to be contacted by phone. Defaults to false if not specified. RXM_USER RECEIVE_PHONE RSB 1,0 No boolean value for contact by phone
contact_by_email xs:boolean 0 1 Indicates if the customer wants to be contacted by email. Defaults to false if not specified. DPS_USER RECEIVE_EMAIL RSB 38,0 No enum field with options yes and no
contact_by_fax xs:boolean 0 1 Indicates if the customer wants to be contacted by fax. Defaults to false if not specified. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
gender gender_type 0 1 Contains the customer gender. dps_user gender RSB 38,0 No Gender of user. Options: male, female
ethnicity ethnicity_type 0 1 Contains the customer ethnicity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
marital_status marital_status_type 0 1 Contains the customer gender. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
birth_date xs:dateTime 0 1 Contains the customer birth date. dps_user date_of_birth RSB Date No DOB of user of type date
anniversary_date xs:dateTime 0 1 Contains anniversary date for the customer Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
annual_income number20_4 0 1 Annual income for this customer Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
net_worth number20_4 0 1 Contains the net worth for this customer Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
highest_education_level education_type 0 1 Contains the highest education level for this customer Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
industry varchar2120 0 1 industry customer belongs to. Sample values 'Consumer', 'Entertaining', 'Medical' etc. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
created_by_loc created_by_loc_type 0 1 An enum indicating the location type from where the customer got created. Valid values are 'STORE' (store walk-in), 'WEB' (web channel), 'RENTED' (rented list) and 'Unknown' (unknown). If this element is missing, then 'UNKNOWN' (unknown) is assumed. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
receipt_preference receipt_preference_type 0 1 Contains the customer receipt preference. Customer can opt for printed, or email or both printed and email receipts. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
tax_id varchar21000 0 1 Contains the federal identifier assigned by a national government. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
tax_certificate varchar2230 0 1 Contains the number provided for sales tax exemption issued separately by the state where doing business. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
tax_exempt_reason_code varchar220 0 1 Contains the tax exempt reason code. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
job_title varchar2100 0 1 Contains the job title. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
CreatedBy * 0 1 The employee that created this customer
CustomerPhones * 0 1 Contains all the phones the customer can be reached at
CustomerEmails * 0 1 Contains all the emails the customer can be reached at
AddrBook * 0 1 Contains all the addresses for this customer, such as 'Home', 'Office'
CustomerSegment * 0 999 A collection of customer segments (such as senior_citizen, teacher, veteran, contractor, etc) that this customer has been assigned to that would impact the pricing offered to the customer.
CustomerPromotion * 0 999 A collection of promotion ids of promotions that this customer may choose to activate, such as by presenting a coupon, or may automatically be applied to their purchases for discounting the total.
Cards * 0 1 Contains a collection of cards. Here we can save the details of various cards a customer possess. For eg., credit/debit, loyalty/giftcard, etc.
CustomerOrg * 0 1 Contains the organization information that the customer belongs to.
lcl:LocaleDesc * 0 1 Contains the customer preferred language. NA NA NA NA NA NA
create_timestamp xs:dateTime 0 1 The timestamp at which this record was created. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
update_timestamp xs:dateTime 0 1 The timestamp at which this record was last updated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustomerRef 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 CustomerRef 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_id varchar214 1 1 Contains the unique identifier for the customer RXM_USER EXT_USER_ID RSB 40 Yes External customer ID , being mapped to commerce profile/user ID.