XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfHdrCriVo 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 transfers for this store. |
TSF |
SOURCE_ID, DESTINATION_ID |
NUMBER |
10,0 |
Yes |
the identifier of the store that will receive/send the items on the transfer. |
tsf_id |
number15 |
0 |
1 |
Transfer internal identifier. Include only transfers with this identifier. |
TSF |
ID |
NUMBER |
15 |
Yes |
unique identifier of the transfer |
ext_tsf_id |
varchar2128 |
0 |
1 |
External transfer identifier. Include only transfers with this external identifier. |
TSF |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
external identifier for extenally requested transfers |
status |
tsf_cri_status |
1 |
1 |
Include only transfers of this status. Valid values are NEW_REQUEST, REQUESTED, REQUEST_IN_PROGRESS, REJECTED, CANCELED_REQUEST, TRANSFER_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, CANCELED, ACTIVE, NO_VALUE. |
TSF |
STATUS |
NUMBER |
2,0 |
Yes |
"The status of transfer.1 - New Request, 2-Requested,
3-Request In Progress,4-Rejected Request,
5-Canceled Request,6-Transfer In Progress,7-Approved,
8-In Shipping,9-Completed Transfer,10-Canceled Transfer" |
src_loc_type |
tsf_cri_location_type |
1 |
1 |
Include only transfers source by this location type. Valid values are STORE, WAREHOUSE, FINISHER, NO_VALUE. |
TSF |
SOURCE_TYPE. |
NUMBER |
2 |
Yes |
source location type. 1- Store, 3 Warehouse, 4 - Finisher |
src_loc_id |
number10 |
0 |
1 |
Include only transfers source by this location identifier depending on the source location type. |
TSF |
SOURCE_ID |
NUMBER |
10 |
Yes |
the identifier of the source that will send the items on the transfer. |
dest_loc_type |
tsf_cri_location_type |
1 |
1 |
Include only transfers where destination is this location type. Valid values are STORE, WAREHOUSE, FINISHER, NO_VALUE. |
TSF |
DESTINATION_TYPE. |
NUMBER |
2 |
Yes |
destination location type for the transfer. 1- Store, 3 Warehouse, 4 - Finisher |
dest_loc_id |
number10 |
0 |
1 |
Include only transfers where destination is this location identifier depending on the destination location type. |
TSF |
DESTINATION_ID |
NUMBER |
10 |
Yes |
the identifier of the destination that will receive the items on the transfer. |
from_update_date |
xs:dateTime |
0 |
1 |
Include only transfers updated on or after this date. |
TSF |
UPDATE_DATE |
DATE |
|
Yes |
the date the transfer was last updated. |
to_update_date |
xs:dateTime |
0 |
1 |
Include only transfers updated on or before this date. |
TSF |
UPDATE_DATE |
DATE |
|
Yes |
the date the transfer was last updated. |
item_id |
varchar2250 |
0 |
1 |
Include only transfers that contain this item. |
TSF_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
item identifier |
update_user |
varchar2250 |
0 |
1 |
Include only transfers last updated by this user. |
TSF |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
the last user to update the transfer. |
context_id |
number18 |
0 |
1 |
Context type identifier. Include only transfers with this context type associated to them. |
TSF |
CONTEXT_ID |
NUMBER |
18 |
No |
Context identifier. |
context_value |
varchar225 |
0 |
1 |
Context type value. Include only transfers with this context type value associated to them. |
TSF |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
Context Value |
customer_order_id |
varchar2128 |
0 |
1 |
Include only transfers with this customer order external identifier associated to them. |
TSF |
CUST_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Customer order identifier. |
fulfillment_order_id |
varchar2128 |
0 |
1 |
Include only transfers with this fulfillment order external identifier associated to them. |
TSF |
FUL_ORD_EXTERNAL_ID. |
VARCHAR2 |
128 |
No |
Fulfillment order external identifier |
all_customer_orders |
xs:boolean |
1 |
1 |
Includes only transfers which are associated to fulfillment orders. |
|
|
|
|
No |
Flag to denote if customer order related transfers are to be selected. |