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 RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
store_id |
number10 |
1 |
1 |
Include only transfers in which this store is the sending or receiving store. |
TRANSFER |
SENDING_STORE_ID, RECEIVING_STORE_ID |
NUMBER |
10,0 |
Yes |
the identifier of the store that will receive/send the items on the transfer. |
other_store_id |
number10 |
0 |
1 |
Include only transfers in which this store is the opposite store to the previous property. If store_id is sending store, then this is receiving store and vica versa. |
TRANSFER |
SENDING_STORE_ID , RECEIVING_STORE_ID |
NUMBER |
10,0 |
Yes |
the identifier of the store that will send/receive the items on the transfer. |
status |
StsTsfCriStatus |
1 |
1 |
Include only transfers in this status. Valid values are ACTIVE, ACTIVE_INBOUND, ACTIVE_OUTBOUND, NEW, PENDING_REQUEST, AWAITING_RESPONSE, OUTBOUND_REJECTED, INBOUND_REJECTED, IN_PROGRESS, SUBMITTED, INBOUND_PICKING, IN_TRANSIT, DISPATCHED, RECEIVING, CLOSED, RECEIVED, CANCELED_INBOUND, CANCELED_REQUEST, CANCELED_TRANSFER, NO_VALUE. |
TRANSFER |
STATUS |
NUMBER |
2,0 |
No |
Transfer status |
transfer_id |
number12 |
0 |
1 |
Include only transfers with this identifier. Entering this will cause the service to return a single unique transfer. |
TRANSFER |
ID |
NUMBER |
12,0 |
Yes |
unique identifier of the transfer |
external_id |
number12 |
0 |
1 |
Include only transfers with this external identifier. |
TRANSFER |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
external id.ex external id is from rms |
item_id |
varchar225 |
0 |
1 |
Include only transfers that contain this SKU number. |
TRANSFER_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
reference to item identifier |
from_date |
xs:dateTime |
0 |
1 |
Include only transfers created on or after this date. |
TRANSFER |
CREATE_DATE, SHIPPED_DATE,RECEIVE_DATE |
Date |
|
Yes |
The date Transfer was created, shipped or received |
to_date |
xs:dateTime |
0 |
1 |
Include only transfers created on or before this date. |
TRANSFER |
CREATE_DATE, SHIPPED_DATE,RECEIVE_DATE |
Date |
|
Yes |
The date the transfer was created, shipped or received |
context_type_id |
varchar215 |
0 |
1 |
Context type identifier. Include only transfers with this context type associated to them. |
TRANSFER |
CONTEXT_TYPE_ID |
VARCHAR2 |
15 |
No |
This field hods the functional area code to which the transfer relates to. For example promotions.
ex PROM - Promotion |