XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrFordHdrCriVo in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
release_from_date |
xs:dateTime |
0 |
1 |
Include only fulfillment orders with the release date at or after this date. |
FUL_ORD |
RELEASE_DATE |
date |
Fill column length. |
No |
The date in which the fulfillment order must be shipped or picked up in the store. |
release_to_date |
xs:dateTime |
0 |
1 |
Include only fulfillment orders with the release date at or before this date. |
FUL_ORD |
RELEASE_DATE |
Date |
Fill column length. |
No |
The date in which the fulfillment order must be shipped or picked up in the store. |
status |
StrFordCriStatus |
1 |
1 |
Include only fulfillment orders matching this status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, ACTIVE, NO_VALUE. |
FUL_ORD |
STATUS |
number |
0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active |
Yes |
Indicates the status of the fulfillment order. Valid values are |
int_fulfillment_order_id |
number12 |
0 |
1 |
Include only fulfillment orders with this internal fulfillment order identifier. |
FUL_ORD |
ID |
NUMBER |
12,0 |
Yes |
Unique SIM identifier. |
ext_fulfillment_order_id |
varchar2128 |
0 |
1 |
Include only fulfillment orders with this external fulfillment order identifier. |
FUL_ORD |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
External identifier for the fulfillment order. |
customer_order_id |
varchar2128 |
0 |
1 |
Include only fulfillment orders with this customer order identifier. |
FUL_ORD |
CUST_ORDER_ID |
varchar2 |
128 |
Yes |
External identifier of the customer order being fulfilled. |
bin_id |
varchar2128 |
0 |
1 |
Include only fulfillment orders with this BIN identifier. |
FUL_ORD_BIN |
BIN_ID |
varchar2 |
128 |
Yes |
Identifier of a bin associated to the fulfillment order. |
order_type |
StrFordCriType |
1 |
1 |
Include only fulfillment orders of this type Valid values are LAYAWAY, PICKUP_AND_DELIVERY, CUSTOMER_ORDER, PENDING_PURCHASE, SPECIAL_ORDER, WEB_ORDER, NO_VALUE. |
FUL_ORD |
ORDER_TYPE |
NUMBER |
4,0 |
Yes |
The type of fulfillment order. Valid values are
1- Layaway,
2- Pickup and Delivery Orders,
3- Customer Order,
4- Pending Purchase,
5- Special Order,
6- Web Order |
customer_name |
varchar2128 |
0 |
1 |
Include only deliveries with this customer name. |
ADDRESS |
CONTACT_NAME, FIRST_NAME, LAST_NAME |
varchar2 |
120 |
No |
Holds the contact's last name/first name/ supplier name for address type |
item_id |
varchar225 |
0 |
1 |
Include only fulfillment orders containing this item SKU. |
FUL_ORD_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item identifier for this line item. |
store_id |
number10 |
1 |
1 |
Include only fulfillment orders at this store |
FUL_ORD |
STORE_ID |
number |
10,0 |
Yes |
Store identifier at which this order is being fulfilled. |