XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrFordDesc 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 |
1 |
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 |
|
Yes |
The date this fulfillment order was created in SIM. |
release_date |
xs:dateTime |
0 |
1 |
Date the fulfillment order is to be released |
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. |
delivery_date |
xs:dateTime |
0 |
1 |
Date the fulfillment order is to be delivered |
FUL_ORD |
DELIVERY_DATE |
DATE |
Fill column length. |
No |
The date in which the fulfillment order is to be delivered. |
delivery_type |
str_ford_delivery_type |
1 |
1 |
Delivery type Valid values are PICKUP, SHIPMENT, UNKNOWN. |
FUL_ORD |
DELIVERY_TYPE |
NUMBER |
4,0 |
Yes |
Identifier that represents the type of delivery for this order. Valid values are
1- Customer Pickup
2- Ship to Customer |
delivery_carrier_code |
varchar2128 |
0 |
1 |
Delivery carrier code |
SHIPMENT_CARRIER |
CODE |
VARCHAR2 |
4 |
Yes |
Unique code identifier for a carrier |
delivery_service_code |
varchar2128 |
0 |
1 |
Delivery carrier service code |
SHIPMENT_CARRIER_SERVICE |
CODE |
VARCHAR2 |
6 |
Yes |
Unique identifier that represents the delivery service |
allow_partial_delivery |
xs:boolean |
1 |
1 |
True if the order allows for partial delivery, false otherwise, |
FUL_ORD |
ALLOW_PARTIAL_DELIVERY |
VARCHAR2 |
1 |
Yes |
Indicator whether all items on the order must be there to be delivered. |
comments |
varchar22000 |
0 |
1 |
Comments about the fulfillment order. |
FUL_ORD |
COMMENTS |
VARCHAR2 |
2000 |
No |
Comments defined by the external system for this order. |
customer_id |
varchar214 |
0 |
1 |
Customer identifier |
FUL_ORD |
CUSTOMER_ID |
VARCHAR2 |
14 |
No |
Customer identifier for this fulfillment order. |
StrFordItm
|
*
|
0
|
unbounded
|
Collection of fulfillment order line items
|
|
|
|
|
|
|