Application
|
Retail Merchandizing System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/StkCountSchDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:StkCountSchDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For StkCountSchDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
cycle_count |
number8 |
1 |
1 |
Contains the number which uniquely identifies the stock or cycle count. |
stake_head |
cycle_count |
number |
8 |
Yes |
Contains the number to uniquely identify the stock or cycle count. |
cycle_count_desc |
varchar2250 |
1 |
1 |
Contains a description of the cycle or stock count which, along with the cycle count number, identifies the cycle or stock count. |
stake_head |
cycle_count_desc |
varchar2 |
250 |
Yes |
Contains a description of the cycle or stock count that along with the cycle count number, identifies the cycle or stock count. |
location_type |
varchar21 |
1 |
1 |
Contains an indicator which identifies whether the cycle count will be for Stores or Warehouses. Valid values are 'S' - Store and 'W' - Warehouse. |
stake_head |
loc_type |
null |
null |
Yes |
Indicates whether the cycle count is for stores or warehouses. Valid values are S (store) and W (warehouse). |
stocktake_date |
xs:dateTime |
1 |
1 |
Contains the date on which the stock or cycle count even will take place. |
stake_head |
stocktake_date |
RIBDate |
* |
Yes |
Contains the date on which the stock or cycle count event will take place. |
stocktake_type |
varchar21 |
1 |
1 |
Contains a value which indicates the type of stock take. Valid values are 'B' -Both Unit and Dollar and 'U' - Unit only. However the RIB interface only allows 'B'. |
stake_head |
stocktake_type |
varchar2 |
1 |
Yes |
Indicates the type of stock take. Valid values are B (Both Unit and Dollar) and U (Unit Only). However, the RIB interface allows only B. |
StkCountSchProd
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
StkCountSchLoc
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfStkCountSchDesc:ExtOfStkCountSchDesc
|
*
|
0
|
1
|
Provide an extension hook to customize StkCountSchDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfStkCountSchDesc:LocOfStkCountSchDesc
|
*
|
0
|
1
|
Provide an extension hook to localize StkCountSchDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:StkCountSchProd
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For StkCountSchProd |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
dept |
number4 |
1 |
1 |
Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments. |
stake_product |
dept |
null |
null |
Yes |
Contains the department number for which the cycle count will occur. If the value = -1, the stock count will apply to all departments. |
class |
number4 |
0 |
1 |
Contains the class number where the cycle count will occur. |
stake_product |
class |
null |
null |
No |
Contains the class number for which the cycle count will occur. |
subclass |
number4 |
0 |
1 |
Contains the subclass number where the cycle count will occur. |
stake_product |
subclass |
null |
null |
No |
Contains the subclass number for which the cycle count will occur. |
ExtOfStkCountSchDesc:ExtOfStkCountSchProd
|
*
|
0
|
1
|
Provide an extension hook to customize StkCountSchProd.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfStkCountSchDesc:LocOfStkCountSchProd
|
*
|
0
|
1
|
Provide an extension hook to localize StkCountSchProd.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfStkCountSchProd
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfStkCountSchProd |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfStkCountSchProd
|
Version:13.2.0
|
Return to Top
|
|
|
XML-Schema Name:StkCountSchLoc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For StkCountSchLoc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
location |
number10 |
1 |
1 |
Contains the store or wh number on the cycle count. |
stake_location |
location |
null |
null |
Yes |
Contains the store or warehouse number on the cycle count. |
ExtOfStkCountSchDesc:ExtOfStkCountSchLoc
|
*
|
0
|
1
|
Provide an extension hook to customize StkCountSchLoc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfStkCountSchDesc:LocOfStkCountSchLoc
|
*
|
0
|
1
|
Provide an extension hook to localize StkCountSchLoc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfStkCountSchLoc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfStkCountSchLoc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:ExtOfStkCountSchDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfStkCountSchDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfStkCountSchDesc
|
Version:13.2.0
|
Return to Top
|
|
|