XSD Element Name | XSD Element Data Type | XSD Min Occurs | XSD Max Occurs | XSD Element Description | Mapping for RTVReqDesc 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 |
rtv_order_no | number12 | 1 | 1 | Contains the number that uniquely identifies the return to vendor within the system. | * | * | number | 10 | * | * |
supplier | varchar210 | 1 | 1 | Description is not available. | * | * | varchar2 | 10 | * | * |
status_ind | number2 | 1 | 1 | Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled. | * | * | number | 2 | * | * |
loc | number10 | 1 | 1 | Contains either the store or warehouse number for the items being returned. | * | * | number | 10 | * | * |
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. | * | * | varchar2 | 1 | * | * |
physical_loc | number10 | 1 | 1 | Contains the store number or the physical warehouse where the items are being returned. | * | * | number | 10 | * | * |
total_order_amt | number20_4 | 0 | 1 | Contains the total amount of the return. This field is stored in the supplier's currency. | * | * | number | 20 | * | * |
ship_to_addr_line1 | varchar2240 | 1 | 1 | Description is not available. | * | * | varchar2 | 240 | * | * |
ship_to_addr_line2 | varchar2240 | 0 | 1 | Description is not available. | * | * | varchar2 | 240 | * | * |
ship_to_addr_line3 | varchar2240 | 0 | 1 | Description is not available. | * | * | varchar2 | 240 | * | * |
ship_to_city | varchar2120 | 1 | 1 | Description is not available. | * | * | varchar2 | 120 | * | * |
state | varchar23 | 0 | 1 | Description is not available. | * | * | varchar2 | 3 | * | * |
ship_to_country_code | varchar23 | 1 | 1 | Description is not available. | * | * | varchar2 | 3 | * | * |
ship_to_postal_code | varchar230 | 0 | 1 | Description is not available. | * | * | varchar2 | 30 | * | * |
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. | * | * | varchar2 | 12 | * | * |
ret_courier | varchar2250 | 0 | 1 | Contains the courier name if the supplier requires that returns be sent by a designated carrier. | * | * | varchar2 | 250 | * | * |
freight_charge | number20_4 | 0 | 1 | Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency. | * | * | number | 20 | * | * |
creation_date | xs:dateTime | 1 | 1 | Description is not available. | * | * | RIBDate | * | * | * |
completed_date | xs:dateTime | 0 | 1 | Description is not available. | * | * | RIBDate | * | * | * |
handling_pct | number12_4 | 0 | 1 | Contains the handling (restocking) percent if a percent is specified at a vendor level. | * | * | number | 12 | * | * |
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. | * | * | number | 20 | * | * |
ext_ref_no | varchar214 | 0 | 1 | Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. | * | * | varchar2 | 14 | * | * |
comment_desc | varchar22000 | 0 | 1 | Description is not available. | * | * | varchar2 | 2000 | * | * |
RTVReqDtl | * | 0 | unbounded | Description is not available. | | | | | | |
not_after_date | xs:dateTime | 0 | 1 | Description is not available. | * | * | RIBDate | * | * | * |