| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for GiftListDesc 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 |
| id |
varchar240 |
1 |
1 |
Unique identifier of the gift list.
|
RXM_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
|
cust:CustomerRef
|
*
|
1
|
1
|
The unique identifier for the owning customer of this list,
as provided by the customer system of record.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
| name |
varchar264 |
0 |
1 |
The name of the list that describes its purpose, such as
"My Wedding", or "Joe's Wishlist".
|
DCS_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| event_type |
event_type |
0 |
1 |
Contains the event type. Gift lists (or registries) for a
special event should specify this.
|
DCS_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| event_date |
xs:dateTime |
0 |
1 |
A gift list that is created for a special event, can
specify the date of that event here.
|
DCS_GIFTLIST |
EVENT_DATE |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| published_flag |
xs:boolean |
0 |
1 |
Indicates whether the gift/wish list is published, i.e. whether
the list is visible to and can be search for by other specific
customers. See "public_flag". Absence of this element should indicate "true".
|
DCS_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| public_flag |
xs:boolean |
0 |
1 |
Setting this value to true indicates that anyone can view the
list. This is a broader visibility than "published_flag".
Absence of this element should indicate "false".
|
DCS_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| location_created |
varchar240 |
0 |
1 |
ID for the location where the gift list was created.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not used. |
| comments |
varchar2254 |
0 |
1 |
Comments on the gift list.
|
DCS_GIFTLIST |
COMMENTS |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| instructions |
varchar2254 |
0 |
1 |
Instructions for the gift list.
|
DCS_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| image_data |
varchar2254 |
0 |
1 |
Contains the URL of the image associated with the gift list.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not used. |
| create_date |
xs:dateTime |
0 |
1 |
Date the gift list was created.
|
DCS_GIFTLIST |
CREATION_DATE |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| update_date |
xs:dateTime |
0 |
1 |
Date the gift list was most recently updated.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
not used |
| expiration_date |
xs:dateTime |
0 |
1 |
Gift list expiration date.
|
RXM_GIFTLIST |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| create_user_id |
varchar240 |
0 |
1 |
Id of user who created the gift list.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
not used |
| update_user_id |
varchar240 |
0 |
1 |
Id of user who updated the gift list.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
not used |
|
addr:GeoAddrDesc
|
*
|
0
|
10
|
The shipping addresses to where items purchased off of the
list should be shipped to.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
itms:GiftListItemColDesc
|
*
|
0
|
1
|
Collection of gift list items or wish list items.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
