XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfRef in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
tsf_no |
number12 |
1 |
1 |
The number that uniquely identifies the transfer within the system. |
tsfhead |
tsf_no |
number |
12 |
Yes |
The number to uniquely identify the transfer within the system. |
doc_type |
varchar21 |
1 |
1 |
Defaults to T for RMS transfers. |
n/a |
n/a |
n/a |
n/a |
Yes |
Defaults to T for RMS transfers. |
physical_from_loc |
number10 |
1 |
1 |
Holds the physical_wh value for the from location if it is a warehouse. Otherwise, this will be equal to the value of the from location. |
store, wh |
store, physical_wh |
number |
10 |
Yes |
Holds the physical_wh value for the from location if it is a warehouse. Otherwise, this will be equal to the value for the from location. |
from_loc |
varchar210 |
1 |
1 |
The location number of the transfer from location. This will be either a store or warehouse number based on the from_loc_type field. |
tsfhead |
from_loc |
varchar2 |
10 |
Yes |
The location number of the Transfer From location. This will be either a store or warehouse number, based on the from_loc_type field. |
from_loc_type |
varchar21 |
0 |
1 |
Type of location in the from_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. |
tsfhead |
from_loc_type |
varchar2 |
1 |
Yes |
Type of location in the from_loc field. Valid values are S = Store, W = Warehouse, E = external finisher. |
from_store_type |
varchar21 |
0 |
1 |
Indicates the store type of the from_loc store. Only populated if from_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. |
store |
store_type |
varchar2 |
6 |
No |
Indicates the store type of the from_loc store. Only populated if from_loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store. |
from_stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the from_loc store is stockholding or not. Only populated if from_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. |
store |
stockholding_ind |
varchar2 |
1 |
No |
Indicates if the from_loc store is stockholding or not. Only populated if from_loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no. |
physical_to_loc |
number10 |
1 |
1 |
Holds the physical_wh value for to location if it is a warehouse. Otherwise, this will be equal to the value of the to location. |
store, wh |
store, physical_wh |
number |
10 |
Yes |
Holds the physical_wh value for the value in the TO_LOC field if TO_LOC holds a
wh. This will be equal to TO_LOC if TO_LOC is a store. |
to_loc |
varchar210 |
1 |
1 |
The location number of the transfer to location. This will be either a store or warehouse number based on the to_loc_type field. |
tsfhead |
to_loc |
varchar2 |
10 |
Yes |
The location number of the Transfer To location. This will be either a store or warehouse number, based on the to_loc_type field. |
to_loc_type |
varchar21 |
0 |
1 |
Type of location in the to_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. |
tsfhead |
to_loc_type |
varchar2 |
1 |
Yes |
Type of location in the to_loc field. Valid values are S = Store, W = Warehouse, E = external finisher. |
to_store_type |
varchar21 |
0 |
1 |
Indicates the store type of the to_loc store. Only populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. |
store |
store_type |
varchar2 |
6 |
No |
Indicates the store type of the to_loc store. Only populated if to_loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store. |
to_stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the to_loc store is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. |
store |
stockholding_ind |
varchar2 |
1 |
No |
Indicates if the to_loc store is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no. |
TsfDtlRef
|
*
|
0
|
unbounded
|
Child Node - see below.
|
|
|
|
|
|
|
tsf_parent_no |
number12 |
0 |
1 |
Identifies the transfer at the level above the transfer. |
n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |