XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvHdrCriVo 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 |
store_id |
number10 |
1 |
1 |
Include only deliveries for this store. |
TSF_DELV |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
expected_from_date |
xs:dateTime |
0 |
1 |
Include only transfer deliveries with an expected date equal to or after this date. |
TSF_DELV |
EXPECTED_DATE |
DATE |
|
No |
Include only transfer deliveries with an expected date equal to or after this date. |
expected_to_date |
xs:dateTime |
0 |
1 |
Include only transfer deliveries with an expected date equal to or before this date. |
TSF_DELV |
EXPECTED_DATE |
DATE |
|
No |
Include only transfer deliveries with an expected date equal to or before this date. |
received_from_date |
xs:dateTime |
0 |
1 |
Include only transfer deliveries with the received date equal to or after this date. |
TSF_DELV |
RECEIVED_DATE |
DATE |
|
No |
Received date |
received_to_date |
xs:dateTime |
0 |
1 |
Include only transfer deliveries with the received date equal to or before this date. |
TSF_DELV |
RECEIVED_DATE |
DATE |
|
No |
Delivery received date |
source_type |
tsf_delv_cri_source_type |
1 |
1 |
Include only transfer deliveries from this source type. Valid values are WAREHOUSE, FINISHER, STORE, NO_VALUE. |
TSF_DELV |
SOURCE_TYPE |
NUMBER |
4 |
Yes |
The Transfer delivery source type. 1- Store, 3 Warehouse, 4 - Finisher |
source_id |
number10 |
0 |
1 |
Include only transfer deliveries from this source. |
TSF_DELV |
TSF_DELV |
NUMBER |
10 |
Yes |
Include only transfer deliveries from this source. |
delivery_id |
number15 |
0 |
1 |
The unique identifier of the transfer delivery. |
TSF_DELV |
ID |
NUMBER |
15 |
Yes |
Transfer delivery unique identifier. |
asn |
varchar2128 |
0 |
1 |
Include only transfer deliveries with this ASN external identifier. |
TSF_DELV |
ASN_ID |
VARCHAR2 |
128 |
No |
ASN external identifier. |
external_id |
varchar2128 |
0 |
1 |
Container external identifier. |
TSF_DELV_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Container external identifier. |
item_id |
varchar225 |
0 |
1 |
Include only transfer deliveries containing this item SKU. |
TSF_DELV_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
Item identifier |
status |
tsf_delv_cri_status |
1 |
1 |
Includes only transfer deliveries matching this status. Valid values are NEW, IN_PROGRESS, RECEIVED, NO_VALUE. |
TSF_DELV |
STATUS |
NUMBER |
4 |
Yes |
The status of Transfer Delivery.0 - New,1 - In Progress,2 - Received. |
document_id |
number15 |
0 |
1 |
Include only transfer deliveries containing this document identifier. |
TSF_DELV |
DOCUMENT_ID |
NUMBER |
15 |
No |
transfer document identifier |
customer_order_id |
varchar2128 |
0 |
1 |
Include only transfer deliveries for the customer order with this external identifier. |
TSF_DELV_LINE_ITEM |
CUST_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
customer order external identifier |
fulfillment_order_id |
varchar2128 |
0 |
1 |
Include only transfer deliveries for the fulfillment order with this external identifier. |
TSF_DELV_LINE_ITEM |
FUL_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
Yes |
fulfillment order external id |
order_related |
xs:boolean |
0 |
1 |
Include only transfer deliveries related to a customer order. Ignored if customer/fulfillment order external identifiers are set. |
|
|
|
|
No |
Deliveries which has line items associated to customer order. |
context_id |
number18 |
0 |
1 |
Include only shipments matching the supplied context. |
TSF |
CONTEXT_ID |
NUMBER |
18 |
No |
The context identifier |
context_value |
varchar225 |
0 |
1 |
Include only transfer deliveries with this context value. |
TSF |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
Include only transfer deliveries with this context value. |