| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SOStatusDesc 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 |
| dc_dest_id |
varchar210 |
1 |
1 |
Contains the location number of the stock order source location. |
tsfhead, alloc_header |
from_loc, wh |
varchar2 |
10 |
No |
Contains the location number of the stock order source location. |
| loc_type |
varchar21 |
1 |
1 |
Type of location in the dc_dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. |
tsfhead |
from_loc_type |
varchar2 |
1 |
No |
Type of location in the dc_dest_id field. Valid values are S = Store, W = Warehouse, E = Finisher. |
| store_type |
varchar21 |
0 |
1 |
Indicates the store type of the dc_dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. |
n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the dc_dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. |
n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| distro_nbr |
varchar212 |
0 |
1 |
Contains the stock order number. This is either the transfer or allocation number in RMS. |
alloc_header, tsfhead |
alloc_no, tsf_no |
number |
10 (alloc_no), 12 (tsf_no) |
No |
Contains the stock order number. This is either the transfer or allocation number in RMS. |
| distro_document_type |
varchar21 |
1 |
1 |
Specifies whether the stock order status pertains to an allocation 'A', or transfer 'T'. Types 'D'C Created Stock Order,'C'ustomer Order, and 'V'irtual Distro are also valid document types but will be ignored by the RMS API. |
n/a |
n/a |
n/a |
n/a |
Yes |
Specifies whether the stock order status pertains to an Allocation (A) or Transfer (T). Types D (DC Created Stock Order, C (Customer Order), and V (Virtual Distro) also are valid document types, but they are ignored by the RMS API. |
|
SOStatusDtl
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
| context_type |
varchar26 |
0 |
1 |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
tsfhead |
context_type |
varchar2 |
6 |
No |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
| context_value |
varchar225 |
0 |
1 |
This field holds the value relating to the context type like promotion number. |
tsfhead |
context_value |
varchar2 |
25 |
No |
This field holds the value relating to the context type like promotion number. |
| inventory_type |
varchar26 |
0 |
1 |
This field indicates if a transfer is made from the available or unavailable inventory. |
tsfhead |
inventory_type |
varchar2 |
6 |
No |
RMS currently doesn't take this value into account. Always assume transfer out of available inventory. |
| cust_order_nbr |
varchar248 |
0 |
1 |
For a stock order associated with a customer order, this field holds the master customer order number from OMS. |
ordcust |
customer_order_no |
varchar2 |
48 |
No |
For a stock order associated with a customer order, this field holds the master customer order number from OMS. |
| fulfill_order_nbr |
varchar248 |
0 |
1 |
For a stock order associated with a customer order, this field holds the number from OMS related to the fulfillment details.
One or more fulfillment orders could relate back to a single customer order in OMS. |
ordcust |
fulfill_order_no |
varchar2 |
48 |
No |
For a stock order associated with a customer order, this field holds the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. |
