 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:StkCountSchDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| cycle_count | stake_head | cycle_count | Yes | Contains the number which uniquely identifies the stock or cycle count. |
| cycle_count_desc | stake_head | cycle_count_desc | Yes | Contains a description of the cycle or stock count which, along with the cycle count number, identifies the cycle or stock count. |
| location_type | stake_head | loc_type | Yes | Contains an indicator which identifies whether the cycle count will be for Stores or Warehouses. Valid values are 'S' - Store and 'W' - Warehouse. |
| stocktake_date | stake_head | stocktake_date | Yes | Contains the date on which the stock or cycle count even will take place. |
| stocktake_type | stake_head | stocktake_type | Yes | 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'. |
| StkCountSchProd | * | * | * | * |
| StkCountSchLoc | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:StkCountSchProd |
| Tag Name | Table Name | Column Name | API Req | Description |
| dept | stake_product | dept | Yes | Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments. |
| class | stake_product | class | No | Contains the class number where the cycle count will occur. |
| subclass | stake_product | subclass | No | Contains the subclass number where the cycle count will occur. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:StkCountSchLoc |
| Tag Name | Table Name | Column Name | API Req | Description |
| location | stake_location | location | Yes | Contains the store or wh number on the cycle count. |