XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCntHdrDesc 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 |
store_id |
number10 |
1 |
1 |
The store where the stock is being counted. |
STOCK_COUNT |
STORE_ID |
RIB or/and RSB or/and RSL |
NUMBER(10) |
Yes |
Fill this description. |
stock_count_id |
number12 |
1 |
1 |
The unique identifier for the stock count. |
STOCK_COUNT |
ID |
RIB or/and RSB or/and RSL |
NUMBER(12) |
Yes |
Fill this description. |
count_desc |
varchar2255 |
1 |
1 |
The description for the stock count. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
group_desc |
varchar2100 |
1 |
1 |
The description of the product group associated to the stock count. |
STOCK_COUNT |
PRODUCT_GROUP_DESCRIPTION |
RIB or/and RSB or/and RSL |
VARCHAR2(1000) |
Yes |
Fill this description. |
schedule_date |
xs:dateTime |
1 |
1 |
The date the stock count is scheduled for. |
STOCK_COUNT |
SCHEDULE_DATE |
RIB or/and RSB or/and RSL |
DATE |
Yes |
Fill this description. |
count_type |
stk_cnt_type |
1 |
1 |
The type of stock count being performed. Valid values are UNIT, UNIT_AMOUNT, PROBLEM_LINE, ADHOC, RMS_SYNC, UNKNOWN. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
status |
stk_cnt_status |
1 |
1 |
The status of the stock count. Valid values are NEW, COUNT_SCHEDULED, COUNT_IN_PROGRESS, COUNT_COMPLETE, RECOUNT_SCHEDULED, RECOUNT_IN_PROGRESS, RECOUNT_COMPLETE, APPROVAL_SCHEDULED, APPROVAL_IN_PROGRESS, APPROVAL_PROCESSING, APPROVAL_AUTHORIZED, APPROVAL_COMPLETE, CANCELED, UNKNOWN. |
STOCK_COUNT |
STATUS |
RIB or/and RSB or/and RSL |
NUMBER(2) |
Yes |
Fill this description. |
display_status |
stk_cnt_display_status |
1 |
1 |
The display status of the stock count. Valid values are NONE, NEW, ACTIVE, IN_PROGRESS, PENDING, PROCESSING, AUTHORIZED, COMPLETED, CANCELED, VIEW_ONLY. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
left_to_count |
number12 |
1 |
1 |
The total remaining items from all the stock count child(ren). |
STOCK_COUNT_CHILD |
ITEMS_LEFT_TO_COUNT |
RIB or/and RSB or/and RSL |
NUMBER(12) |
Yes |
Fill this description. |