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.
|
XSD Structure
|
|
|
XML-Schema Name:SORef
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SORef in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
distro_nbr |
varchar212 |
1 |
1 |
N/A |
ALLOCATION |
EXTERNAL_ID |
Number |
12 |
Yes |
The allocation identifier from external system. |
document_type |
varchar21 |
1 |
1 |
N/A |
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 |
N/A |
WAREHOUSE,PARTNER |
ID |
VARCHAR2,NUMBER |
10 |
Yes |
Unique Partner/Warehouse identifier. |
loc_type |
varchar21 |
0 |
1 |
N/A |
TSF_ALLOCATION |
SOURCE_TYPE |
RIB or/and RSB |
NUMBER(2,0) |
Yes |
Fill this description. |
store_type |
varchar21 |
0 |
1 |
N/A |
TSF_ALLOCATION |
SOURCE_TYPE |
RIB or/and RSB |
NUMBER(2,0) |
Yes |
Fill this description. |
stockholding_ind |
varchar21 |
0 |
1 |
N/A |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
SODtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
distro_parent_no |
varchar212 |
0 |
1 |
N/A |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
|
|
XML-Schema Name:SODtlRef
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SODtlRef in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
dest_id |
varchar210 |
1 |
1 |
N/A |
TSF_ALLOCATION |
STORE_ID |
Number |
10 |
Yes |
the unique identifier of the store where this item is will be delivered to. |
loc_type |
varchar21 |
0 |
1 |
N/A |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
possible value LOC_TYPE_STORE("S"), |
store_type |
varchar21 |
0 |
1 |
N/A |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
values are STORE_TYPE_COMPANY("C"),
STORE_TYPE_FRANCHISE("F"), |
stockholding_ind |
varchar21 |
0 |
1 |
N/A |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
values are either "Y" or "N" |
item_id |
varchar225 |
1 |
1 |
N/A |
TSF_ALLOCATION |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item that this allocation is for. |
|
|