 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Store Inventory Management |
|
XML-Schema or Node Name:StkCountSchDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| cycle_count | RK_STK_CT | STK_CT_ID | Yes | Contains the number which uniquely identifies the stock count |
| cycle_count_desc | RK_STK_CT | DESCRIPTION | No | Contains a description of the stock count |
| location_type | n/a | n/a | 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 | RK_STK_CT | START_DATE | Yes | Contains the date on which the stock or cycle count even will take place |
| stocktake_type | n/a | n/a | 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: Store Inventory Management |
|
XML-Schema or Node Name:StkCountSchProd |
| Tag Name | Table Name | Column Name | API Req | Description |
| dept | RK_STK_CT_GRP_MH | MH_ID | Yes | Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments. |
| class | RK_STK_CT_GRP_MH | MH_ID | No | Contains the class number where the cycle count will occur. |
| subclass | RK_STK_CT_GRP_MH | MH_ID | No | Contains the subclass number where the cycle count will occur. |
| Application Name: Store Inventory Management |
|
XML-Schema or Node Name:StkCountSchLoc |
| Tag Name | Table Name | Column Name | API Req | Description |
| location | RK_STK_CT_STORE | ID_STR_RT | No | Contains the store or wh number on the stock count. |