|
Application
|
Store Inventory Management
|
|
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.
|
|
|
|
|
|
XML-Schema Name:SORef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For SORef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
RK_ALLOCATIONS |
ALLOCATION_ID |
Number |
12 |
Yes |
Contains the stock order number. this is inventory control document number for a transfer or return in SIM |
| document_type |
varchar21 |
1 |
1 |
Description is not available. |
n/a |
n/a |
varchar2 |
1 |
Yes |
Specifies whether the stock order status pertains to an allocation (A) or transfer T. Types D (Created Stock Order),C (Customer Order), and V (Virtual Distro) are also valid document types. But they are ignored by the RMS API. |
| dc_dest_id |
varchar210 |
1 |
1 |
Description is not available. |
RK_ALLOCATIONS |
FROM_LOCATION_ID |
varchar2 |
128 |
No |
Contains the location number of the stock order receiving location |
|
SODtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
| distro_parent_no |
varchar210 |
0 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
|
ExtOfSORef:ExtOfSORef
|
*
|
0
|
1
|
Provide an extension hook to customize SORef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfSORef:LocOfSORef
|
*
|
0
|
1
|
Provide an extension hook to localize SORef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:SODtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For SODtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| dest_id |
varchar210 |
1 |
1 |
Description is not available. |
RK_ALLOCATIONS |
STORE_ID |
Number |
10 |
Yes |
Store Id |
| item_id |
varchar225 |
1 |
1 |
Description is not available. |
RK_ALLOCATIONS |
ITEM_ID |
varchar2 |
25 |
Yes |
An identifier which represents an ITEM. |
|
ExtOfSORef:ExtOfSODtlRef
|
*
|
0
|
1
|
Provide an extension hook to customize SODtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfSORef:LocOfSODtlRef
|
*
|
0
|
1
|
Provide an extension hook to localize SODtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfSODtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfSODtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfSODtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For LocOfSODtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InSORef:InSODtlRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrSORef:BrSODtlRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfSORef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfSORef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfSORef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For LocOfSORef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InSORef:InSORef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrSORef:BrSORef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
