XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfDesc 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 |
Internal identifier |
TRANSFER |
ID |
NUMBER |
12,0 |
Yes |
unique identifier of the transfer |
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. |
create_store_id |
number10 |
1 |
1 |
Identifier of store that created the transfer |
TRANSFER |
CREATE_STORE_ID |
NUMBER |
10,0 |
Yes |
the identifier of the store that created the transfer |
external_id |
varchar2128 |
0 |
1 |
External identifier |
TRANSFER |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
external id. ex external id is from rms |
status |
sts_tsf_status |
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 |
create_user_name |
varchar2128 |
1 |
1 |
User that created the transfer |
TRANSFER |
CREATE_USER |
VARCHAR2 |
128 |
No |
a person or personel create a transfer |
update_user_name |
varchar2128 |
0 |
1 |
Last user that last updated the transfer. |
TRANSFER |
UPDATE_USER |
VARCHAR2 |
128 |
No |
the last user to update the transfer. |
approval_user_name |
varchar2128 |
0 |
1 |
User that approved the transfer |
TRANSFER |
APPROVAL_USER |
VARCHAR2 |
128 |
No |
the user that approved the transfer. |
ship_user_name |
varchar2128 |
0 |
1 |
User that shipped the transfer |
TRANSFER |
SHIPPED_USER |
VARCHAR2 |
128 |
No |
the user that shipped 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. |
create_date |
xs:dateTime |
1 |
1 |
Date the transfer was created. |
TRANSFER |
CREATE_DATE |
Date |
|
No |
orginal or create date of a transfer |
update_date |
xs:dateTime |
0 |
1 |
Date the transfer was last updated. |
TRANSFER |
UPDATE_DATE |
Date |
|
No |
the date the transfer was last updated. |
approve_date |
xs:dateTime |
0 |
1 |
Date the transfer was approved. |
TRANSFER |
APPROVAL_DATE |
Date |
|
No |
the date the transfer was approved. |
ship_date |
xs:dateTime |
0 |
1 |
Date the transfer was shipped. |
TRANSFER |
SHIPPED_DATE |
Date |
|
No |
the date the transfer was shipped. |
receive_date |
xs:dateTime |
0 |
1 |
Date the transfer was received. |
TRANSFER |
RECEIVE_DATE |
Date |
|
No |
the date the transfer was received. |
request_comments |
varchar22000 |
0 |
1 |
Comments associated to the transfer during the request stage. |
TRANSFER |
REQUEST_COMMENT |
VARCHAR2 |
2000 |
No |
comments associated with the original request. |
transfer_comments |
varchar22000 |
0 |
1 |
Comments associated to the transfer during the transfer stage |
TRANSFER |
TRANSFER_COMMENT |
VARCHAR2 |
2000 |
No |
comments associated with the transfer. |
delivery_slot_id |
varchar215 |
0 |
1 |
Identifier of the delivery time slot associated to the transfer |
TRANSFER |
DELIVERY_SLOT_ID |
VARCHAR2 |
15 |
No |
delivery slot id |
context_type_id |
varchar215 |
0 |
1 |
Identifier of the context type associated to the transfer. |
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 |
context_value |
varchar225 |
0 |
1 |
Value of the context associated to the transfer |
TRANSFER |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
This field holds value relating to the context type, ex promotin number. |
StsTsfBol
|
*
|
0
|
1
|
Information about bill of lading for the transfer.
|
|
|
|
|
|
|
StsTsfItm
|
*
|
0
|
unbounded
|
Collection of transfer line items
|
|
|
|
|
|
|