XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCntHdrCriVo in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
store_id |
number10 |
1 |
1 |
Retrieves only stock counts for this store. |
STOCK_COUNT |
STORE_ID |
NUMBER |
10 |
Yes |
the unique identifier of the store where the stock count is taking place. |
schedule_date |
xs:dateTime |
0 |
1 |
Retrieves only stock counts for the date the count is scheduled to commence. |
STOCK_COUNT |
SCHEDULE_DATE |
DATE |
|
Yes |
the date the stock count is scheduled for. |
count_phase |
stk_cnt_phase |
1 |
1 |
Retrieves only stock counts at this phase. Valid values are FUTURE, COUNT, RECOUNT, AUTHORIZE, UNKNOWN. |
STOCK_COUNT |
PHASE |
NUMBER |
2 |
Yes |
"the phase that the stock count is in.
0 - Future, 1 - Count, 2 - Recount, 3 - Authorize" |
display_status |
stk_cnt_display_status |
1 |
1 |
Retrieves only stock counts with this display status. Valid values are NONE, NEW, ACTIVE, IN_PROGRESS, PENDING, PROCESSING, AUTHORIZED, COMPLETED, CANCELED, VIEW_ONLY. |
STOCK_COUNT |
STATUS |
NUMBER |
2 |
Yes |
Derived from status of the stock count. |
department_id |
number12 |
0 |
1 |
Retrieves only stock counts associated to this department. |
STOCK_COUNT_LINE_ITEM |
DEPARTMENT_ID |
NUMBER |
12 |
Yes |
an identifier of the department of an item that is being counted as part of this stock count. |
class_id |
number12 |
0 |
1 |
Retrieves only stock counts associated to this class. Cannot enter class without first entering department. |
STOCK_COUNT_LINE_ITEM |
CLASS_ID |
NUMBER |
12 |
Yes |
an identifier of the class of an item that is being counted as part of this stock count. |
subclass_id |
number12 |
0 |
1 |
Retrieves only stock counts associated to this subclass. Cannot enter subclass without first entering department and class. |
STOCK_COUNT_LINE_ITEM |
SUBCLASS_ID |
NUMBER |
12 |
Yes |
n identifier of the subclass of an item that is being counted as part of this stock count. |