XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCountSchDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's 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.
|
|
|
|
|
|
|