XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PurchHistDesc 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 |
initiate_loc_type |
initiate_loc_type |
0 |
1 |
A enumeration indicating the location type where the order/transaction was initiated. The possible values are "W"
for Web orders, "M" for mail orders, "S" for store and "O" for others.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
initiate_loc_id |
varchar210 |
0 |
1 |
The location id where the order/transaction was initiated. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
purchase_type |
purchase_type |
1 |
1 |
An enumeration indicating the type of purchase this record represents.Can be 'T' for TRANSACTION or 'O' for ORDER
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
id |
varchar248 |
1 |
1 |
The unique order identifier or the unique transaction identifier. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
currency_code |
varchar23 |
1 |
1 |
The currency ISO code used in the purchase. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
status |
purchase_status |
1 |
1 |
A enumeration indicating the current status of the transaction or order.Valid values may be PENDING,PARTIAL,NEW,COMPLETED,FILLED,INPROCESS,CANCELLED,DELIVERED,UNKNOWN.
|
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/transaction 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. |
submitted_date |
xs:dateTime |
1 |
1 |
The submission timestamp for the order or transaction this record represents. For an order,this denotes the time the order was submitted. For a transaction this reflects the time the transaction was ended. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
number_of_items |
number10 |
1 |
1 |
The total number of items in this order/transaction. It does not include the individual quantities of items in the count.For example, if there are 2 items with quantities 2m and 3.5 kg, this element reflects only 2 as the total count of items. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
itm:PurchItmHdrColDesc
|
*
|
0
|
1
|
A collection of order/transaction items.The occurrence and size of this collection is governed by the line_item_population element, in PurchHistCriVo.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|