XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for CustOrderDesc 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_order_id |
varchar248 |
1 |
1 |
The customer order id. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
external_ref_id |
varchar2120 |
0 |
1 |
The id from an external source that is linked to this order. This is used for integration purpose. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
currency_code |
varchar23 |
0 |
1 |
The currency ISO code. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
lcl:LocaleDesc
|
*
|
0
|
1
|
The order's original receipt locale.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
order_desc |
varchar2250 |
0 |
1 |
The order description in its original receipt locale. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
order_status |
order_status |
1 |
1 |
A enum indicating the order status. The possible
values are "NEW", "OPEN", "PARTIAL", "HELD", "SUSPENDED", "CANCELED",
"COMPLETED", "FILLED", or "ERROR".
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
initiate_loc_type |
initiate_loc_type |
1 |
1 |
A enum indicating the location type where the order is initiated. The possible values are "O"
for online or "S" for store.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
initiate_loc_id |
number10 |
1 |
1 |
The location id where the order is initiated. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
initiate_country_code |
varchar23 |
1 |
1 |
The country code where the order is initiated. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
grand_total |
number20_4 |
0 |
1 |
The grand total order amount that includes discount, tax, and shipping charges. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
sub_total |
number20_4 |
0 |
1 |
The subtotal order amount that does not include discount, tax, and shipping charges. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
tax_total |
number20_4 |
0 |
1 |
Total amount of sales tax paid for this order |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
inclusive_tax_total |
number20_4 |
0 |
1 |
Total amount of VAT tax paid for this order. The VAT tax is already included in the item price. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
shipping_charge_total |
number20_4 |
0 |
1 |
The total amount of shipping charge paid for this order. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
discount_total |
number20_4 |
0 |
1 |
The total amount of discount for this order. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
completed_amount |
number20_4 |
0 |
1 |
The total amount picked up or shipped for this order. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
cancelled_amount |
number20_4 |
0 |
1 |
The total amount cancelled for this order. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
returned_amount |
number20_4 |
0 |
1 |
The total amount returned for this order. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
completed_discount_amount |
number20_4 |
0 |
1 |
The discount amount applied to order items that have
been picked up or shipped.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
cancelled_discount_amount |
number20_4 |
0 |
1 |
The discount amount applied to order items that have
been cancelled.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
returned_discount_amount |
number20_4 |
0 |
1 |
The discount amount applied to order items that have
been returned. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
completed_tax_amount |
number20_4 |
0 |
1 |
The tax amount applied to order items that have
been picked up or shipped.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
cancelled_tax_amount |
number20_4 |
0 |
1 |
The tax amount applied to order items that have
been cancelled.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
returned_tax_amount |
number20_4 |
0 |
1 |
The tax amount applied to order items that have
been returned. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
completed_inclusive_tax_amount |
number20_4 |
0 |
1 |
The VAT tax amount applied to order items that have
been picked up or shipped.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
cancelled_inclusive_tax_amount |
number20_4 |
0 |
1 |
The VAT tax amount applied to order items that have
been cancelled.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
returned_inclusive_tax_amount |
number20_4 |
0 |
1 |
The VAT tax amount applied to order items that have
been returned. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
paid_amount |
number20_4 |
0 |
1 |
The total paid amount for this order. The following formula holds true.
paid_amount + rounding_adjustment = total payment from payment collection - refund_amount_offset_by_sale
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
rounding_adjustment |
number20_4 |
0 |
1 |
The rounding adjustment for this order. It can be positive
or negative. The following formula holds true.
paid_amount + rounding_adjustment = total payment from payment collection - refund_amount_offset_by_sale
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
refund_amount_offset_by_sale |
number20_4 |
0 |
1 |
The refund amount offset by take with items purchased.
This amount is always positive. The following formula holds true.
paid_amount + rounding_adjustment = total payment from payment collection - refund_amount_offset_by_sale
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
cst:CustomerDesc
|
*
|
0
|
1
|
The customer that is assigned to this order.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
gift_receipt_assigned |
gift_receipt_assigned |
0 |
1 |
A boolean flag indicating if a gift receipt is assigned to this order.
The possible values are "Y" or "N".
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
default_gift_registry_id |
varchar214 |
0 |
1 |
The default gift registry id of the order if there is one. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
age_restricted_dob |
xs:dateTime |
0 |
1 |
The birthday of the customer if the order has restrictive items. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
create_timestamp |
xs:dateTime |
1 |
1 |
The order creation timestamp. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
update_timestamp |
xs:dateTime |
1 |
1 |
The order update timestamp. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
itm:CustOrdItmColDesc
|
*
|
0
|
1
|
A collection of order items.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
rtn:CustOrderRtnColVo
|
*
|
0
|
1
|
A collection of returns created on this order.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
ful:CustOrdFulColDesc
|
*
|
0
|
1
|
A collection of order fulfillment details. A fulfullment detail defines how a group of items
will be fulfilled: in store pick up or ship.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
del:CustOrdDelColDesc
|
*
|
0
|
1
|
A collection of order delivery records.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
pay:PaymentColDesc
|
*
|
0
|
1
|
A collection of order payments.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|