Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/ItemLocDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:ItemLocDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ItemLocDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Not Yet Available |
AS_ITEM_RTL_STR |
ID_ITEM |
VARCHAR2 |
128 |
No |
Not Yet Available |
ItemLocPhys
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfItemLocDesc:ExtOfItemLocDesc
|
*
|
0
|
1
|
Provide an extension hook to customize ItemLocPhys.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ItemLocPhys
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ItemLocPhys |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
physical_loc |
number10 |
1 |
1 |
If the loc_type is 'W', this is the physical warehouse that is assigned to the virtual wh where the item is located. If the loc_type is an 'S' then this is the store where the item is located. |
AS_ITEM_RTL_STR |
ID_STR_RT |
NUMBER |
128 |
No |
Not Yet Available |
ItemLocVirt
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ItemLocVirtRepl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfItemLocDesc:ExtOfItemLocPhys
|
*
|
0
|
1
|
Provide an extension hook to customize ItemLocPhys.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ItemLocVirt
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ItemLocVirt |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
loc |
number10 |
1 |
1 |
Location where the item is to be found. This field may contain a store or a warehouse. |
|
null |
number |
10 |
null |
null |
loc_type |
varchar21 |
1 |
1 |
Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
|
null |
varchar2 |
1 |
null |
null |
local_item_desc |
varchar2250 |
1 |
1 |
NA |
|
null |
varchar2 |
250 |
null |
null |
local_short_desc |
varchar2120 |
0 |
1 |
Not Yet Available |
AS_ITEM_RTL_STR |
SHORT_DESC |
VARCHAR2 |
20 |
No |
Not Yet Available |
status |
varchar21 |
1 |
1 |
Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). |
AS_ITEM_RTL_STR |
SC_ITM |
VARCHAR2 |
20 |
No |
Not Yet Available |
primary_supp |
number10 |
0 |
1 |
Not Yet Available |
AS_ITEM_RTL_STR |
ID_SPR |
NUMBER |
128 |
No |
Not Yet Available |
primary_cntry |
varchar23 |
0 |
1 |
Contains the origin country which will be considered the primary country for the item/location. |
|
null |
varchar2 |
3 |
null |
null |
receive_as_type |
varchar21 |
0 |
1 |
Determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are 'E'ach or 'P'ack. |
|
null |
varchar2 |
1 |
null |
null |
taxable_ind |
varchar21 |
1 |
1 |
Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). |
|
null |
varchar2 |
1 |
null |
null |
source_method |
varchar21 |
0 |
1 |
Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'. |
|
null |
null |
null |
null |
null |
source_wh |
number10 |
0 |
1 |
If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. |
|
null |
number |
10 |
null |
null |
unit_retail |
number20_4 |
0 |
1 |
Unit retail of the item in the selling Unit of Measure. Only published for create not modify. |
|
null |
null |
null |
null |
null |
selling_unit_retail |
number20_4 |
0 |
1 |
Selling unit retail in selling unit of measure. Only published for create, not update |
AS_ITEM_RTL_STR |
RP_SLS_CRT |
NUMBER |
75 |
No |
Not Yet Available |
selling_uom |
varchar24 |
0 |
1 |
Selling Unit of measure. Only published for Create not update. |
|
null |
null |
null |
null |
null |
store_price_ind |
varchar21 |
0 |
1 |
Not Yet Available |
AS_ITEM_RTL_STR |
STR_CTL_PRICING |
VARCHAR2 |
1 |
No |
Not Yet Available |
purchase_type |
varchar26 |
0 |
1 |
Purchase Type |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfItemLocDesc:ExtOfItemLocVirt
|
*
|
0
|
1
|
Provide an extension hook to customize ItemLocVirt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfItemLocVirt
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfItemLocVirt |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ItemLocVirtRepl
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ItemLocVirtRepl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
loc |
number10 |
1 |
1 |
Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. |
AS_ITEM_RTL_STR |
ID_STR_RT |
NUMBER |
128 |
No |
Not Yet Available |
loc_type |
varchar21 |
1 |
1 |
Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. |
|
null |
varchar2 |
1 |
null |
null |
primary_repl_supplier |
number10 |
0 |
1 |
Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment. |
|
null |
number |
10 |
null |
null |
repl_method |
varchar26 |
0 |
1 |
Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders. |
AS_ITEM_RTL_STR |
REPN_TYPE |
VARCHAR2 |
4 |
No |
Not Yet Available |
reject_store_order_ind |
varchar21 |
0 |
1 |
Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid." |
AS_ITEM_RTL_STR |
STR_ORD_REJECT |
VARCHAR2 |
1 |
No |
Not Yet Available |
next_delivery_date |
xs:dateTime |
0 |
1 |
Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date. |
AS_ITEM_RTL_STR |
NEXT_DELIVERY_DATE |
RIBDate |
* |
No |
Not Yet Available |
multiple_runs_per_day_ind |
varchar21 |
0 |
1 |
Indicates if the item-location is replenished multiple times per day. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfItemLocDesc:ExtOfItemLocVirtRepl
|
*
|
0
|
1
|
Provide an extension hook to customize ItemLocVirtRepl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfItemLocVirtRepl
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfItemLocVirtRepl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfItemLocPhys
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfItemLocPhys |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfItemLocDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfItemLocDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|