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 |
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. |
TSF |
EXTERNAL_ID. |
RIB or/and RSB |
128 |
No |
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. |
TSF |
SOURCE_TYPE |
RIB or/and RSB |
2 |
Yes |
source location type. 1- Store, 3 Warehouse, 4 - Finisher |
src_loc_id |
number10 |
1 |
1 |
Identifier of the source of the transfer. |
TSF |
SOURCE_ID |
RIB or/and RSB |
10 |
Yes |
Fill this description. |
src_loc_name |
varchar2150 |
0 |
1 |
Name of the source of the transfer. |
STORE |
NAME |
RIB or/and RSB |
150 |
No |
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. |
dest_loc_name |
varchar2150 |
0 |
1 |
Name of the destination of the transfer. |
STORE |
NAME |
RIB or/and RSB |
150 |
Yes |
Fill this description. |
status |
tsf_status |
1 |
1 |
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. |
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" |
create_date |
xs:dateTime |
1 |
1 |
Date the transfer was created. |
TSF |
CREATE_DATE |
RIB or/and RSB |
7 |
Yes |
Fill this description. |
not_after_date |
xs:dateTime |
0 |
1 |
Date after which the transfer should no longer be processed. |
TSF |
NOT_AFTER_DATE |
RIB or/and RSB |
7 |
No |
Fill this description. |
number_of_line_items |
number10 |
1 |
1 |
Number of line items on the transfer. |
n/a |
.n/a |
RIB or/and RSB |
n/a |
Yes |
number of line items |
fulfillment_order_related |
xs:boolean |
1 |
1 |
True if the transfer is related to a fulfillment order, false otherwise. |
n/a |
n/a |
RIB or/and RSB |
n/a |
No |
Fill this description. |