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. |