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/AllocRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:AllocRef 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 AllocRef 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
alloc_no number10 1 1 Contains the number that uniquely identifies the allocation within the system. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes *
doc_type varchar21 1 1 Specifies the type of document. This value will always be 'A' to signify an allocation. * * RIB or/and RSB or/and RSL Fill column length. * *
physical_wh number10 1 1 Contains the number of the physical warehouse location where the allocation will originate. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes *
wh number10 1 1 Contains the number of the warehouse location where the allocation will originate. * * RIB or/and RSB or/and RSL Fill column length. * *
item varchar225 1 1 Unique alphanumeric value that identifies the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes *
AllocDtlRef * 0 unbounded Description is not available.

XML-Schema Name:AllocDtlRef 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 AllocDtlRef 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
to_loc varchar210 1 1 This field contains the location to which the allocation is being sent. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes *
loc_type varchar21 0 1 This field contains the type of location in the to_loc field. Valid values are 'S'tore and 'W'arehouse. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
store_type varchar21 0 1 Indicates the store type of the to_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
stockholding_ind varchar21 0 1 Indicates if the to_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.