| rtv_id |
rtv_head |
ext_ref_no |
Yes |
Audit trail
reference to external system when an external transaction initiates master
record creation in the Retek system. |
| item_id |
rtv_detail |
item |
Yes |
Unique
identifier for the item on the RTV. |
| rtn_auth_nbr |
rtv_head |
ret_auth_num |
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 |
rtv_detail |
qty_returned |
Yes |
Contains the
quantiy of items being returned to the supplier under this RTV
number. |
| container_qty |
n/a |
n/a |
No |
Not used by
RMS. |
| vendor_nbr |
rtv_head |
supplier |
Yes |
Contains the
supplier ID to which the merchandise is being returned. |
| ship_address1 |
rtv_head |
ship_to_add_1 |
No |
Contains the
first line of the supplier's address for returns. |
| ship_address2 |
rtv_head |
ship_to_add_2 |
No |
Contains the
second line of the supplier's address for returns. |
| ship_address3 |
rtv_head |
ship_to_add_3 |
No |
Contains the
third line of the supplier's address for returns. |
| state |
rtv_head |
state |
No |
Contains the
state of the supplier's address for returns. |
| city |
rtv_head |
ship_to_city |
No |
Contains the
city name of the supplier's address for returns. |
| shipto_zip |
rtv_head |
ship_to_pcode |
No |
Contains the zip
code of the supplier's address for returns. |
| country |
rtv_head |
ship_to_country_id |
No |
Contains the
country ID of the supplier's address for returns. |
| from_disposition |
inv_status_codes |
inv_status_code |
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 |
n/a |
n/a |
No |
Not used by
RMS. |
| creation_ts |
rtv_head |
created_date, completed_date |
No |
CREATED_DATE
contains the date the vendor return was created, COMPLETED_DATE contains
the date the vendor return was completed. |
| unit_cost |
rtv_detail |
unit_cost |
No |
Contains the
cost per unit for the SKU being returned. This field is stored in the
supplier's currency. |
| reason |
rtv_detail |
reason |
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 |
rtv_head |
comment_desc |
No |
Contains any
comments associated with the return. |
| rtv_order_no |
rtv_head |
rtv_order_no |
No |
Contains the
number that uniquely identifies the return to vendor within the
system. |
| weight |
n/a |
n/a |
No |
Actual weight
shipped for the item on the RTV. |
| weight_uom |
n/a |
n/a |
No |
Unit of Measure
for the weight (e.g. pounds, kilograms). |
| RTVDtl |
* |
* |
* |
* |
