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 |
tsf_id |
number15 |
1 |
1 |
Transfer Unique internal identifier. |
TSF |
ID |
RIB or/and RSB |
15 |
Yes |
Fill this description. |
ext_tsf_id |
varchar2128 |
0 |
1 |
External transfer identifier. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
store_id |
number10 |
1 |
1 |
Identifier of store requesting the operation. |
TSF |
SOURCE_ID |
RIB or/and RSB |
10 |
Yes |
Fill this description. |
src_loc_type |
tsf_location_type |
1 |
1 |
Location type of the source of the transfer. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
src_loc_id |
number10 |
1 |
1 |
Identifier of the source of the transfer. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
dest_loc_type |
tsf_location_type |
1 |
1 |
Location type of the destination of the transfer. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. |
TSF |
DESTINATION_TYPE. |
RIB or/and RSB |
2 |
Yes |
destination location type for the transfer. 1- Store, 3 Warehouse, 4 - Finisher |
dest_loc_id |
number10 |
1 |
1 |
Identifier of the destination of the transfer. |
TSF |
DESTINATION_ID |
RIB or/and RSB |
10 |
Yes |
Fill this description. |
orgin_type |
tsf_origin_type |
1 |
1 |
Transfer origin type. Valid values are EXTERNAL, INTERNAL, ADHOC, UNKNOWN. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
status |
tsf_status |
1 |
1 |
Current status of the transfer. Valid values are NEW_REQUEST, REQUESTED, REQUEST_IN_PROGRESS, REJECTED, CANCELED_REQUEST, TRANSFER_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, CANCELED, 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 |
not_after_date |
xs:dateTime |
0 |
1 |
NDate after which the transfer should no longer be processed. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
auth_code |
varchar212 |
0 |
1 |
Authorization Number for the transfer. |
TSF |
AUTHORIZATION_CODE |
RIB or/and RSB |
12 |
No |
Fill this description. |
context_type_id |
varchar215 |
0 |
1 |
Context type identifier. |
TSF |
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 |
Context type value. |
TSF |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
This field holds value relating to the context type, ex promotin number. |
partial_delivery_allowed |
xs:boolean |
1 |
1 |
True if partial delivery is allowed for the transfer. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
customer_order_id |
varchar2128 |
0 |
1 |
Customer order external identifier. |
TSF |
CUST_ORD_EXTERNAL_ID |
RIB or/and RSB |
128 |
No |
Fill this description. |
fulfillment_order_id |
varchar2128 |
0 |
1 |
Fulfillment order external identifier. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
request_user |
varchar2250 |
0 |
1 |
User requested the transfer. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
approval_user |
varchar2250 |
0 |
1 |
User approved the transfer. |
TSF |
APPROVAL_USER |
RIB or/and RSB |
128 |
No |
Fill this description. |
create_user |
varchar2250 |
1 |
1 |
User created the transfer. |
TSF |
CREATE_USER. |
RIB or/and RSB |
128 |
Yes |
Fill this description. |
update_user |
varchar2250 |
1 |
1 |
User last updated the transfer. |
TSF |
UPDATE_USER |
RIB or/and RSB |
128 |
Yes |
Fill this description. |
request_date |
xs:dateTime |
0 |
1 |
Date on which transfer was requested. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
approval_date |
xs:dateTime |
0 |
1 |
Date on which transfer was approved. |
TSF |
APPROVAL_DATE |
RIB or/and RSB |
7 |
Yes |
Fill this description. |
create_date |
xs:dateTime |
1 |
1 |
Date on which transfer was created. |
TSF |
CREATE_DATE |
Date |
Fill column length. |
No |
orginal or create date of a transfer |
update_date |
xs:dateTime |
1 |
1 |
Last update date for the transfer. |
TSF |
UPDATE_DATE |
Date |
7 |
No |
the date the transfer was last updated. |
use_available |
xs:boolean |
1 |
1 |
True if available inventory is to be used for shipment, false if unavailable inventory.. |
TSF |
USE_AVAILABLE |
RIB or/and RSB |
1 |
Yes |
Fill this description. |
StsTsfItm
|
*
|
0
|
5000
|
Collection of transfer line items.
|
|
|
|
|
|
|
StsTsfDescNote
|
*
|
0
|
1000
|
Notes associated to the transfer.
|
|
|
|
|
|
|