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