XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrFordHdrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
int_fulfillment_order_id |
number12 |
1 |
1 |
Internal fulfillment order identifier |
FUL_ORD |
ID |
NUMBER |
12,0 |
Yes |
Unique SIM identifier. |
ext_fulfillment_order_id |
varchar2128 |
0 |
1 |
External fulfillment order identifier |
FUL_ORD |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
External identifier for the fulfillment order. |
customer_order_id |
varchar2128 |
1 |
1 |
Customer order identifier |
FUL_ORD |
CUST_ORDER_ID |
VARCHAR2 |
128 |
Yes |
External identifier of the customer order being fulfilled. |
order_type |
str_ford_type |
1 |
1 |
Type of order Valid values are LAYAWAY, PICKUP_AND_DELIVERY, CUSTOMER_ORDER, PENDING_PURCHASE, SPECIAL_ORDER, WEB_ORDER, UNKNOWN. |
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 |
status |
str_ford_status |
1 |
1 |
Current status Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. |
FUL_ORD |
STATUS |
NUMBER |
4,0 |
Yes |
Indicates the status of the fulfillment order. Valid values are
0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active |
create_date |
xs:dateTime |
1 |
1 |
Date the fulfillment order was created |
FUL_ORD |
CREATE_DATE |
DATE |
Fill column length. |
Yes |
The date this fulfillment order was created in SIM. |
release_date |
xs:dateTime |
0 |
1 |
Date the fulfillment order was released |
FUL_ORD |
RELEASE_DATE |
DATE |
|
No |
The date in which the fulfillment order must be shipped or picked up in the store. |
number_of_skus |
number9 |
1 |
1 |
Total number of items on the order |
|
|
|
|
No |
number of items on the customer order |