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:14.1.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. |
|
|
|
|
Yes |
* |
doc_type |
varchar21 |
1 |
1 |
Specifies the type of document. This value will always be 'A' to signify an allocation. |
* |
* |
|
|
* |
* |
physical_wh |
number10 |
1 |
1 |
Contains the number of the physical warehouse location where the allocation will originate. |
|
|
|
|
Yes |
* |
wh |
number10 |
1 |
1 |
Contains the number of the warehouse location where the allocation will originate. |
* |
* |
|
|
* |
* |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item. |
|
|
|
|
Yes |
* |
AllocDtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
XML-Schema Name:AllocDtlRef
|
Version:14.1.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. |
|
|
|
|
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. |
NA |
NA |
NA |
NA |
NA |
NA |
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. |
NA |
NA |
NA |
NA |
NA |
NA |
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. |
NA |
NA |
NA |
NA |
NA |
NA |
|
|