Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/RTVDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:RTVDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RTVDesc 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
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. transshipment_setup dc_dest_id varchar2 10 Yes *
rtv_id varchar214 1 1 Audit trail reference to external system when an external transaction initiates master record creation in the Retek system. inv_adjustment_to_upload rtv_id number 7 Yes Unique identifier for a Return to Vendor.
rtn_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. inv_adjustment_to_upload RTN_AUTH_NBR varchar2 12 * *
vendor_nbr varchar210 1 1 Contains the supplier ID to which the merchandise is being returned. rtv vendor_nbr varchar2 10 Yes An identifier that uniquely identifies a vendor.
ship_address1 varchar2240 0 1 Contains the first line of the supplier's address for returns. rtv address1 varchar2 240 No First line of a mailing address.
ship_address2 varchar2240 0 1 Contains the second line of the supplier's address for returns. rtv address2 varchar2 240 No Second line of the mailing address.
ship_address3 varchar2240 0 1 Contains the third line of the supplier's address for returns. rtv address3 varchar2 240 No Third line of the mailing address.
state varchar23 0 1 Contains the state of the supplier's address for returns. rtv state varchar2 3 No State where the merchandise will be returned
city varchar2120 0 1 Contains the city name of the supplier's address for returns. rtv city varchar2 120 No Address City
shipto_zip varchar230 0 1 Contains the zip code of the supplier's address for returns. rtv shipto_zip varchar2 30 No Shipping address zip code
country varchar23 0 1 Contains the country ID of the supplier's address for returns. rtv country varchar2 3 No Country where the merchandise will be returned
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 creation_ts RIBDate * No A timestamp representing the moment at which a data record is created
comments varchar22000 0 1 Contains any comments associated with the return. * * varchar2 * * Populated with NULL
rtv_order_no number10 0 1 Contains the number that uniquely identifies the return to vendor within the system. * * * * * Populated with NULL
RTVDtl * 0 unbounded Description is not available.
status_ind varchar21 0 1 This value is used to determine the current status of the return. If this is 'A', RMS will set the status to 12 (In Progress). If this is 'S' or null, it will be set to 15 (Shipped). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:RTVDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RTVDtl 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
item_id varchar225 1 1 Unique identifier for the item on the RTV. rtv_detail item_id varchar2 25 * Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
unit_qty number12_4 0 1 Contains the quantiy of items being returned to the supplier under this RTV number. inv_adjustment_to_upload unit_qty number 12 * Number of individual units.
container_qty number6 0 1 Not used by RMS. RTV container_qty number 6 No Number of containers of this unit. Will be 1 normally, but greater than 1 to represent unlabeled containers. E.g. unit_qty= 100, container qty= 10 means 10 unlabeled (not in the container table) containers of casepack 10.
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_adjustment_to_upload from_disposition varchar2 4 * *
to_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_adjustment_to_upload to_disposition varchar2 4 No *
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. * * * * * Populated with NULL
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). * * * * * Populated with NULL
weight number12_4 0 1 Actual weight shipped for the item on the RTV. inv_adjustment_to_upload weight_adjustment number 12 No The weight adjustment of an item found during the cycle count process.
weight_uom varchar24 0 1 Unit of Measure for the weight (e.g. pounds, kilograms). * * * * No Derived - If weight_adjustment is NOT NULL populate with SCP sys_weight_uom
gross_cost number20_4 0 1 Contains the Unit cost and Expenses incurred on an item in a particular transaction * * * * * Populated with NULL
RTVDtlUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:RTVDtlUin Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RTVDtlUin 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
uin varchar2128 1 1 Universal Identification Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status number4 1 1 Status associated with the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.