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 |
Fill this description. |
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 |
A number which uniquely identifies a distribution order. |
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 |
RIB or/and RSB |
* |
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 |
RIB or/and RSB |
* |
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 |
RIB or/and RSB |
Fill column length. |
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 |
Yes |
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 |
Fill this description. |