XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCountSchDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
cycle_count |
number8 |
1 |
1 |
Contains the number which uniquely identifies the stock or cycle count. |
PRODUCT_GROUP_SCHEDULE |
ID |
Number |
8 |
Yes |
Contains the number which uniquely identifies 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. |
PRODUCT_GROUP_SCHEDULE |
DESCRIPTION |
varchar2 |
250 |
No |
Contains a description of the cycle or stock count which, 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. |
n/a |
n/a |
null |
null |
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 |
xs:dateTime |
1 |
1 |
Contains the date on which the stock or cycle count even will take place. |
PRODUCT_GROUP_SCHEDULE |
START_DATE |
RIBDate |
Date |
No |
Contains the date on which the stock or cycle count even 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'. |
n/a |
n/a |
null |
null |
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
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
StkCountSchLoc
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|