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
|