Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For RTVDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
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. |
rtv_head |
store, wh |
null |
null |
Yes |
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. |
rtv_id |
varchar214 |
1 |
1 |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
rtv_head |
ext_ref_no |
number |
7 |
Yes |
Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. |
item_id |
varchar225 |
0 |
1 |
Unique identifier for the item on the RTV. |
rtv_detail |
item |
null |
null |
Yes |
Unique identifier for the item on the RTV. |
rtn_auth_nbr |
varchar212 |
1 |
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 |
null |
null |
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. |
unit_qty |
number12_4 |
0 |
1 |
Contains the quantiy of items being returned to the supplier under this RTV number. |
rtv_detail |
qty_returned |
null |
null |
Yes |
Contains the quantiy of items being returned to the supplier under this RTV number. |
container_qty |
number6 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
vendor_nbr |
varchar210 |
1 |
1 |
Contains the supplier ID to which the merchandise is being returned. |
rtv_head |
supplier |
null |
null |
Yes |
Contains the supplier ID to which the merchandise is being returned. |
ship_address1 |
varchar2240 |
0 |
1 |
Contains the first line of the supplier's address for returns. |
rtv_head |
ship_to_add_1 |
varchar2 |
240 |
No |
Contains the first line of the supplier's address for returns. |
ship_address2 |
varchar2240 |
0 |
1 |
Contains the second line of the supplier's address for returns. |
rtv_head |
ship_to_add_2 |
varchar2 |
240 |
No |
Contains the second line of the supplier's address for returns. |
ship_address3 |
varchar2240 |
0 |
1 |
Contains the third line of the supplier's address for returns. |
rtv_head |
ship_to_add_3 |
varchar2 |
240 |
No |
Contains the third line of the supplier's address for returns. |
state |
varchar23 |
0 |
1 |
Contains the state of the supplier's address for returns. |
rtv_head |
state |
varchar2 |
3 |
No |
Contains the state of the supplier's address for returns. |
city |
varchar2120 |
0 |
1 |
Contains the city name of the supplier's address for returns. |
rtv_head |
ship_to_city |
varchar2 |
120 |
No |
Contains the city name of the supplier's address for returns. |
shipto_zip |
varchar230 |
0 |
1 |
Contains the zip code of the supplier's address for returns. |
rtv_head |
ship_to_pcode |
varchar2 |
30 |
No |
Contains the zip code of the supplier's address for returns. |
country |
varchar23 |
0 |
1 |
Contains the country ID of the supplier's address for returns. |
rtv_head |
ship_to_country_id |
varchar2 |
3 |
No |
Contains the country ID of the supplier's address for returns. |
from_disposition |
varchar24 |
0 |
1 |
This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. |
inv_status_codes |
inv_status_code |
varchar2 |
4 |
No |
This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. |
to_disposition |
varchar24 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
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_head |
created_date, completed_date |
null |
null |
No |
CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed. |
unit_cost |
number20_4 |
0 |
1 |
Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency. |
rtv_detail |
unit_cost |
number |
20 |
No |
Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency. |
reason |
varchar26 |
0 |
1 |
Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. Other values may also be entered via the codes table under code type 'RTVR', however, the two codes listed previously may never be deleted. Note that any value added can only be related to RTV from existing inventory (e.g. overstock). |
rtv_detail |
reason |
null |
null |
No |
Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. Other values may also be entered via the codes table under code type 'RTVR', however, the two codes listed previously may never be deleted. Note that any value added can only be related to RTV from existing inventory (e.g. overstock). |
comments |
varchar22000 |
0 |
1 |
Contains any comments associated with the return. |
rtv_head |
comment_desc |
varchar2 |
2000 |
No |
Contains any comments associated with the return. |
rtv_order_no |
number10 |
0 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
rtv_head |
rtv_order_no |
number |
10 |
No |
Contains the number that uniquely identifies the return to vendor within the system. |
weight |
number12_4 |
0 |
1 |
Actual weight shipped for the item on the RTV. |
n/a |
n/a |
null |
null |
No |
Actual weight shipped for the item on the RTV. |
weight_uom |
varchar24 |
0 |
1 |
Unit of Measure for the weight (e.g. pounds, kilograms). |
n/a |
n/a |
null |
null |
No |
Unit of Measure for the weight (e.g. pounds, kilograms). |
RTVDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
status_ind |
varchar21 |
0 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfRTVDesc:ExtOfRTVDesc
|
*
|
0
|
1
|
Provide an extension hook to customize RTVDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|