XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfHdrDesc 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 |
transfer_id |
number12 |
1 |
1 |
Unique internal identifier |
TRANSFER |
ID |
number |
12,0 |
Yes |
unique identifier of the transfer |
external_id |
varchar2128 |
0 |
1 |
External identifier |
TRANSFER |
EXTERNAL_ID |
varchar2 |
128 |
No |
external id. ex external id is from rms |
sending_store_id |
number10 |
1 |
1 |
Identifier of store sending the items. |
TRANSFER |
SENDING_STORE_ID |
number |
10,0 |
Yes |
the identifier of the store that will send the items on the transfer. |
receiving_store_id |
number10 |
1 |
1 |
Identifier of store receiving the items. |
TRANSFER |
RECEIVING_STORE_ID |
number |
10,0 |
Yes |
the identifier of the store that will receive the items on the transfer. |
status |
StsTsfStatus |
1 |
1 |
Current status Valid values are NEW, PENDING, REJECTED, CANCELED_REQUEST, IN_PROGRESS, DISPATCHED, SUBMITTED, RECEIVING, RECEIVED, CANCELED_TRANSFER, UNKNOWN. |
TRANSFER |
STATUS |
number |
2,0 |
No |
The status of transfer. valid values
5 - New Request,
10 - Awaiting Response,
15 - Inbond Rejected Request,
20 - Canceled Request,
25 - In progress Inbond - Picking,
26 - Submitted Inbond - Picking,
30 - In Transit
35 - Receiving,
40 - Received,
50 - Inbound Canceled |
status_date |
xs:dateTime |
1 |
1 |
Date current status occurred through processing. |
TRANSFER |
CREATE_DATE, SHIPPED_DATE, RECEIVE_DATE |
date |
|
No |
the date transfer was created/ shipped/ received |
create_user_name |
varchar2128 |
1 |
1 |
User that created the transfer. |
TRANSFER |
CREATE_USER |
varchar2 |
128 |
No |
a person or personel create a transfer |
approval_user_name |
varchar2128 |
0 |
1 |
User that approved the transfer. |
TRANSFER |
APPROVAL_USER |
varchar2 |
128 |
No |
the user that approved the transfer. |
receive_user_name |
varchar2128 |
0 |
1 |
User that received the transfer. |
TRANSFER |
RECEIVE_USER |
varchar2 |
128 |
No |
the user that received the transfer. |
number_of_line_items |
number10 |
1 |
1 |
Number of line items on the transfer. |
|
. |
|
|
Yes |
number of line items |