XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SOStatusDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
dc_dest_id |
varchar210 |
1 |
1 |
Contains the location number of the stock order source location. |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
|
loc_type |
varchar21 |
1 |
1 |
Type of location in the dc_dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. |
NA |
NA |
varchar2 |
1 |
Yes |
Always W |
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. |
NA |
NA |
varchar2 |
1 |
Yes |
Populated with NULL |
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. |
NA |
NA |
varchar2 |
1 |
Yes |
Populated with NULL |
distro_nbr |
varchar212 |
0 |
1 |
Contains the stock order number. This is either the transfer or allocation number in RMS. |
stock_order_info_upload |
distro_nbr |
varchar2 |
12 |
Yes |
distro_nbr |
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. |
stock_order or stock_order_info_upload |
document_type |
varchar2 |
1 |
Yes |
IF stock_order.document_type is NULL use stock_order_info_upload.document_type. If that is null default to E |
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. |
stock_order |
order_type |
|
* |
No |
NULL or REPAIR based on Stock Order |
context_value |
varchar225 |
0 |
1 |
This field holds the value relating to the context type like promotion number. |
NA |
NA |
|
* |
No |
Populated with NULL |
inventory_type |
varchar26 |
0 |
1 |
This field indicates if a transfer is made from the available or unavailable inventory. |
NA |
NA |
|
|
No |
Populated with NULL |
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. |
stock_order |
cust_order_nbr |
varchar2 |
48 |
|
Valid Customer Order Number |
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. |
stock_order |
fulfill_order_nbr |
varchar2 |
48 |
Yes |
|