rtv_order_no |
rtv_head |
rtv_order_no |
Yes |
Contains the
number that uniquely identifies the return to vendor within the
system. |
supplier |
rtv_head |
supplier |
Yes |
Contains the
supplier number to which the merchandise is being returned. |
status_ind |
rtv_head |
status_ind |
Yes |
Contains the
current status of the return. Valid values include: 05- Input, 10 -
Approved, 15 - Shipped, 20 - Cancelled. |
loc |
rtv_head |
store, wh |
Yes |
Contains either
the store or warehouse number for the items being returned. |
loc_type |
n/a |
n/a |
Yes |
Indicates the
location type. Contains an 'S' if the location is a store or 'W' if the
location is a warehouse. |
physical_loc |
rtv_head, wh |
store, physical_wh |
Yes |
Contains the
store number or the physical warehouse where the items are being
returned. |
total_order_amt |
rtv_head |
total_order_amt |
No |
Contains the
total amount of the return. This field is stored in the supplier's
currency. |
ship_to_addr_line1 |
rtv_head |
ship_to_add_1 |
Yes |
Contains the
first line of the supplier's address for returns. |
ship_to_addr_line2 |
rtv_head |
ship_to_add_2 |
No |
Contains the
second line of the supplier's address for returns. |
ship_to_addr_line3 |
rtv_head |
ship_to_add_3 |
No |
Contains the
third line of the supplier's address for returns. |
ship_to_city |
rtv_head |
ship_to_city |
Yes |
Contains the
city name of the supplier's address for returns. |
state |
rtv_head |
state |
Yes |
Contains the
state of the supplier's address for returns. |
ship_to_country_code |
rtv_head |
ship_to_country_id |
Yes |
Contains the
country ID of the supplier's address for returns. |
ship_to_postal_code |
rtv_head |
ship_to_pcode |
No |
Contains the zip
code of the supplier's address for returns. |
ret_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. |
ret_courier |
rtv_head |
courier |
No |
Contains the
courier name if the supplier requires that returns be sent by a designated
carrier. |
freight_charge |
rtv_head |
freight |
No |
Contains the
freight cost associated with the vendor return. This field is stored in
the supplier's currency. |
creation_date |
rtv_head |
created_date |
Yes |
Contains the
date the vendor return was created. |
completed_date |
rtv_head |
completed_date |
No |
Contains the
date the vendor return was completed. |
handling_pct |
rtv_head |
restock_pct |
No |
Contains the
handling (restocking) percent if a percent is specified at a vendor
level. |
handling_cost |
rtv_head |
restock_cost |
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 |
rtv_head |
ext_ref_no |
No |
Audit trail
reference to external system when an external transaction initiates master
record creation in the Retek system. |
comment_desc |
rtv_head |
comment_desc |
No |
Contains any
comments associated with the return. |
RTVReqDtl |
* |
* |
* |
* |
not_after_date |
rtv_head |
not_after_date |
No |
Contains the
last date that delivery of the order will be
accepted. |