|
Application
|
Retail Warehouse Management System
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/SORef/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:SORef
|
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 SORef 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 |
| distro_nbr |
varchar212 |
1 |
1 |
N/A |
stock_allocation |
distro_nbr |
varchar2 |
10 |
Yes |
* |
| document_type |
varchar21 |
1 |
1 |
N/A |
stock_order |
document_type |
varchar2 |
1 |
Yes |
* |
| dc_dest_id |
varchar210 |
1 |
1 |
N/A |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
* |
| loc_type |
varchar21 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
| store_type |
varchar21 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
| stockholding_ind |
varchar21 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
|
SODtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
| distro_parent_no |
varchar212 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
|
|
|
XML-Schema Name:SODtlRef
|
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 SODtlRef 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 |
| dest_id |
varchar210 |
1 |
1 |
N/A |
stock_allocation |
dest_id |
varchar2 |
10 |
Yes |
* |
| loc_type |
varchar21 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
| store_type |
varchar21 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
| stockholding_ind |
varchar21 |
0 |
1 |
N/A |
NA |
NA |
NA |
NA |
NA |
NA |
| item_id |
varchar225 |
1 |
1 |
N/A |
stock_allocation |
item_id |
varchar2 |
25 |
Yes |
* |
|
|
