| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfShipCriVo 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 |
| store_id |
number10 |
1 |
1 |
Include only shipments for this store. |
TSF_SHIP |
STORE_ID |
NUMBER |
10 |
Yes |
Fill this description. |
| update_from_date |
xs:dateTime |
0 |
1 |
Include only shipments with the date related to their status either at or after this date. |
TSF_SHIP |
UPDATE_DATE |
DATE |
7 |
No |
Fill this description. |
| update_to_date |
xs:dateTime |
0 |
1 |
Include only shipments with the date related to their status either at or before this date. |
TSF_SHIP |
UPDATE_DATE |
DATE |
7 |
Yes |
Fill this description. |
| not_after_date |
xs:dateTime |
0 |
1 |
Include only shipments that have a not after date that matches the input. |
TSF_SHIP |
NOT_AFTER_DATE |
DATE |
7 |
No |
Fill this description. |
| destination_type |
tsf_ship_cri_dest_type |
1 |
1 |
Include only shipments that match the destination type. Valid values are FINISHER, STORE, WAREHOUSE, NO_VALUE. |
TSF_SHIP |
DESTINATION_TYPE |
RIB or/and RSB |
2 |
Yes |
The shipment destination type. 1- Store, 3 Warehouse, 4 - Finisher |
| destination_id |
number10 |
0 |
1 |
Include only shipments that match the destination identifier relative to the destination type. |
TSF_SHIP |
DESTINATION_ID. |
NUMBER |
10 |
Yes |
Fill this description. |
| tsf_id |
number15 |
0 |
1 |
Include only shipments with this transfer_id. |
TSF_SHIP |
ADHOC_DOCUMENT_ID |
RIB or/and RSB |
15 |
No |
Fill this description. |
| asn |
varchar2128 |
0 |
1 |
Include only shipments with this ASN external identifier. |
TSF_SHIP |
ASN |
VARCHAR2 |
128 |
No |
Fill this description. |
| customer_order_id |
varchar2128 |
0 |
1 |
Include only shipments for the customer order with this external identifier. |
TSF |
CUST_ORD_EXTERNAL_ID |
RIB or/and RSB |
128 |
No |
Fill this description. |
| fulfillment_order_id |
varchar2128 |
0 |
1 |
Include only shipments for the fulfillment order with this external identifier. |
FUL_ORD |
ID |
NUMBER |
12 |
No |
Fill this description. |
| order_related |
xs:boolean |
0 |
1 |
Include only shipments for any customer order. Ignored if customer/fulfillment order external identifiers are set. |
n/a |
n/a |
RIB or/and RSB |
n/a |
No |
Fill this description. |
| status |
tsf_ship_cri_status |
1 |
1 |
Include only shipments matching this status. Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, ACTIVE, NO_VALUE. |
TSF_SHIP |
STATUS |
NUMBER |
2 |
Yes |
Fill this description. |
| context_type_id |
varchar2128 |
0 |
1 |
Include only shipments matching the supplied context type. |
TSF |
CONTEXT_TYPE_ID |
VARCHAR2 |
15 |
No |
Fill this description. |
| context_value |
varchar225 |
0 |
1 |
Include only shipments matching the context value relative to the context type. |
TSF_SHIP |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
Fill this description. |
