XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVDesc 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 that the items are returned from. If the dc_dest_id is a store, the STORE column gets populated with the dc_dest_id value, and the WH column is defaulted to -1. If the dc_dest_id is a warehouse, the WH column gets populated. |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
* |
rtv_id |
varchar214 |
1 |
1 |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
inv_adjustment_to_upload |
rtv_id |
number |
7 |
Yes |
* |
rtn_auth_nbr |
varchar212 |
0 |
1 |
Contains the number that the supplier provides when the decision is made that an order may be returned. This value is not always required and is determined by vendor level data. |
inv_adjustment_to_upload |
RTN_AUTH_NBR |
varchar2 |
12 |
* |
* |
vendor_nbr |
varchar210 |
1 |
1 |
Contains the supplier ID to which the merchandise is being returned. |
rtv |
vendor_nbr |
varchar2 |
10 |
Yes |
* |
ship_address1 |
varchar2240 |
0 |
1 |
Contains the first line of the supplier's address for returns. |
rtv |
address1 |
varchar2 |
240 |
No |
* |
ship_address2 |
varchar2240 |
0 |
1 |
Contains the second line of the supplier's address for returns. |
rtv |
address2 |
varchar2 |
240 |
No |
* |
ship_address3 |
varchar2240 |
0 |
1 |
Contains the third line of the supplier's address for returns. |
rtv |
address3 |
varchar2 |
240 |
No |
* |
state |
varchar23 |
0 |
1 |
Contains the state of the supplier's address for returns. |
rtv |
state |
varchar2 |
3 |
No |
* |
city |
varchar2120 |
0 |
1 |
Contains the city name of the supplier's address for returns. |
rtv |
city |
varchar2 |
120 |
No |
* |
shipto_zip |
varchar230 |
0 |
1 |
Contains the zip code of the supplier's address for returns. |
rtv |
shipto_zip |
varchar2 |
30 |
No |
* |
country |
varchar23 |
0 |
1 |
Contains the country ID of the supplier's address for returns. |
rtv |
country |
varchar2 |
3 |
No |
Country where the merchandise will be returned |
creation_ts |
xs:dateTime |
0 |
1 |
CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed. |
rtv |
creation_ts |
RIBDate |
* |
No |
* |
comments |
varchar22000 |
0 |
1 |
Contains any comments associated with the return. |
* |
* |
varchar2 |
* |
* |
Populated with NULL |
rtv_order_no |
number10 |
0 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
* |
* |
* |
* |
* |
Populated with NULL |
RTVDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
status_ind |
varchar21 |
0 |
1 |
This value is used to determine the current status of the return. If this is 'A', RMS will set the status to 12 (In Progress). If this is 'S' or null, it will be set to 15 (Shipped). |
NA |
NA |
NA |
NA |
NA |
NA |