XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVReqDesc 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 |
rtv_order_no |
number12 |
1 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
rtv_head |
rtv_order_no |
number |
10 |
Yes |
Contains the number that uniquely identifies the return to vendor within the system. |
supplier |
varchar210 |
1 |
1 |
Description is not available. |
rtv_head |
supplier |
varchar2 |
10 |
Yes |
Contains the supplier number to which the merchandise is being returned. |
status_ind |
number2 |
1 |
1 |
Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. |
rtv_head |
status_ind |
null |
05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. |
Yes |
Contains the current status of the return. Valid values include |
loc |
number10 |
1 |
1 |
Contains either the store or warehouse number for the items being returned. |
rtv_head |
store, wh |
null |
null |
Yes |
Contains either the store or warehouse number for the items being returned. |
loc_type |
varchar21 |
1 |
1 |
Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse. |
n/a |
n/a |
null |
null |
Yes |
Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse. |
physical_loc |
number10 |
1 |
1 |
Contains the store number or the physical warehouse where the items are being returned. |
rtv_head, wh |
store, physical_wh |
null |
null |
Yes |
Contains the store number or the physical warehouse where the items are being returned. |
total_order_amt |
number20_4 |
0 |
1 |
Contains the total amount of the return. This field is stored in the supplier's currency. |
rtv_head |
total_order_amt |
number |
20 |
No |
Contains the total amount of the return. This field is stored in the supplier's currency. |
ship_to_addr_line1 |
varchar2240 |
1 |
1 |
Description is not available. |
rtv_head |
ship_to_add_1 |
varchar2 |
240 |
Yes |
Contains the first line of the supplier's address for returns. |
ship_to_addr_line2 |
varchar2240 |
0 |
1 |
Description is not available. |
rtv_head |
ship_to_add_2 |
varchar2 |
240 |
No |
Contains the second line of the supplier's address for returns. |
ship_to_addr_line3 |
varchar2240 |
0 |
1 |
Description is not available. |
rtv_head |
ship_to_add_3 |
varchar2 |
240 |
No |
Contains the third line of the supplier's address for returns. |
ship_to_city |
varchar2120 |
1 |
1 |
Description is not available. |
rtv_head |
ship_to_city |
varchar2 |
120 |
Yes |
Contains the city name of the supplier's address for returns. |
state |
varchar23 |
0 |
1 |
Description is not available. |
rtv_head |
state |
varchar2 |
3 |
Yes |
Contains the state of the supplier's address for returns. |
ship_to_country_code |
varchar23 |
1 |
1 |
Description is not available. |
rtv_head |
ship_to_country_id |
varchar2 |
3 |
Yes |
Contains the country ID of the supplier's address for returns. |
ship_to_postal_code |
varchar230 |
0 |
1 |
Description is not available. |
rtv_head |
ship_to_pcode |
varchar2 |
30 |
No |
Contains the zip code of the supplier's address for returns. |
ret_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. |
rtv_head |
ret_auth_num |
varchar2 |
12 |
No |
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. |
ret_courier |
varchar2250 |
0 |
1 |
Contains the courier name if the supplier requires that returns be sent by a designated carrier. |
rtv_head |
courier |
varchar2 |
250 |
No |
Contains the courier name if the supplier requires that returns be sent by a designated carrier. |
freight_charge |
number20_4 |
0 |
1 |
Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency. |
rtv_head |
freight |
number |
20 |
No |
Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency. |
creation_date |
xs:dateTime |
1 |
1 |
Description is not available. |
rtv_head |
created_date |
RIBDate |
* |
Yes |
Contains the date the vendor return was created. |
completed_date |
xs:dateTime |
0 |
1 |
Description is not available. |
rtv_head |
completed_date |
RIBDate |
* |
No |
Contains the date the vendor return was completed. |
handling_pct |
number12_4 |
0 |
1 |
Contains the handling (restocking) percent if a percent is specified at a vendor level. |
rtv_head |
restock_pct |
null |
null |
No |
Contains the handling (restocking) percent if a percent is specified at a vendor level. |
handling_cost |
number20_4 |
1 |
1 |
Contains the handling (restocking) cost for the vendor return if a handling (restocking) percent is specified at a supplier level. The cost is calculated by taking the total order amount multiplied by the handling (restocking) percent. This field is stored in the supplier's currency. |
rtv_head |
restock_cost |
null |
null |
Yes |
Contains the handling (restocking) cost for the vendor return if a handling (restocking) percent is specified at a supplier level. The cost is calculated by taking the total order amount multiplied by the handling (restocking) percent. This field is stored in the supplier's currency. |
ext_ref_no |
varchar214 |
0 |
1 |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
rtv_head |
ext_ref_no |
varchar2 |
14 |
No |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
comment_desc |
varchar22000 |
0 |
1 |
Description is not available. |
rtv_head |
comment_desc |
varchar2 |
2000 |
No |
Contains any comments associated with the return. |
RTVReqDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
not_after_date |
xs:dateTime |
0 |
1 |
Description is not available. |
rtv_head |
not_after_date |
RIBDate |
* |
No |
Contains the last date that delivery of the order will be accepted. |