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 |
Unique identifier for a Return to Vendor. |
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 |
An identifier that uniquely identifies a vendor. |
ship_address1 |
varchar2240 |
0 |
1 |
Contains the first line of the supplier's address for returns. |
rtv |
address1 |
varchar2 |
240 |
No |
First line of a mailing address. |
ship_address2 |
varchar2240 |
0 |
1 |
Contains the second line of the supplier's address for returns. |
rtv |
address2 |
varchar2 |
240 |
No |
Second line of the mailing address. |
ship_address3 |
varchar2240 |
0 |
1 |
Contains the third line of the supplier's address for returns. |
rtv |
address3 |
varchar2 |
240 |
No |
Third line of the mailing address. |
state |
varchar23 |
0 |
1 |
Contains the state of the supplier's address for returns. |
rtv |
state |
varchar2 |
3 |
No |
State where the merchandise will be returned |
city |
varchar2120 |
0 |
1 |
Contains the city name of the supplier's address for returns. |
rtv |
city |
varchar2 |
120 |
No |
Address City |
shipto_zip |
varchar230 |
0 |
1 |
Contains the zip code of the supplier's address for returns. |
rtv |
shipto_zip |
varchar2 |
30 |
No |
Shipping address zip code |
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 |
A timestamp representing the moment at which a data record is created |
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). |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |