XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCntDesc 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 |
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. |
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. |
product_group_id |
number10 |
0 |
1 |
The unique identifier for the product group used for the stock count. |
STOCK_COUNT |
PRODUCT_GROUP_ID |
RIB or/and RSB or/and RSL |
NUMBER(12) |
Yes |
Fill this description. |
schedule_id |
number10 |
0 |
1 |
The unique identifier for the product group schedule attached to the stock count.. |
STOCK_COUNT |
PRODUCT_GROUP_SCHEDULE_ID |
RIB or/and RSB or/and RSL |
NUMBER(12) |
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. |
STOCK_COUNT |
TYPE. |
RIB or/and RSB or/and RSL |
NUMBER(2) |
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. |
counting_method |
stk_cnt_method |
1 |
1 |
The counting method of the stock count. Valid values are GUIDED, UNGUIDED, THIRD_PARTY, AUTO, UNKNOWN. |
STOCK_COUNT |
COUNTING_METHOD |
RIB or/and RSB or/and RSL |
NUMBER(2) |
Yes |
Fill this description. |
stock_count_time_frame |
stk_cnt_time_frame |
1 |
1 |
Time frame indicator for whether snapshot of the stock count took place before or after the store opened. Valid values are BEFORE_STORE_OPEN, AFTER_STORE_CLOSE, NONE. |
STOCK_COUNT |
BEFORE_STORE_OPEN |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
group_type |
stk_cnt_breakdown_type |
1 |
1 |
Indicates how the stock count items should be broken into stock count children.. Valid values are DEPARTMENT, CLASS, SUBCLASS, LOCATION, NONE. |
STOCK_COUNT |
BREAKDOWN_TYPE |
RIB or/and RSB or/and RSL |
NUMBER(2) |
Yes |
Fill this description. |
count_desc |
varchar2255 |
1 |
1 |
The description of the stock count. |
STOCK_COUNT |
DESCRIPTION |
RIB or/and RSB or/and RSL |
VARCHAR2(255) |
Yes |
Fill this description. |
group_desc |
varchar2128 |
0 |
1 |
The description of the product group. |
STOCK_COUNT |
PRODUCT_GROUP_DESCRIPTION |
RIB or/and RSB or/and RSL |
VARCHAR2(100) |
Yes |
Fill this description. |
schedule_date |
xs:dateTime |
0 |
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_start_time |
number18 |
0 |
1 |
The time in milliseconds that the count began. |
STOCK_COUNT |
START_TIME |
RIB or/and RSB or/and RSL |
DATE |
Yes |
Fill this description. |
last_updated_time |
xs:dateTime |
0 |
1 |
The date and time the stock count last had an update. |
STOCK_COUNT |
UPDATE_DATE_TIME |
RIB or/and RSB or/and RSL |
DATE |
Yes |
Fill this description. |
export_user |
varchar240 |
0 |
1 |
The person or operator that exported the stock count. |
STOCK_COUNT |
EXPORT_USER |
RIB or/and RSB or/and RSL |
VARCHAR2(20) |
Yes |
Fill this description. |
variance_count |
number12 |
0 |
1 |
The number of units in standard uom that will determine if an item on the count is to be considered discrepant. |
STOCK_COUNT |
VARIANCE_COUNT |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
Fill this description. |
variance_percent |
number12 |
0 |
1 |
The percentage of units in standard uom that will determine if an item on the count is to be considered discrepant. |
STOCK_COUNT |
VARIANCE_PERCENT |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
Fill this description. |
variance_value |
number12 |
0 |
1 |
The cost value variance from expected that will determine if an item on the count is to be considered discrepant. |
STOCK_COUNT |
VARIANCE_VALUE |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
Fill this description. |
recount_active |
xs:boolean |
1 |
1 |
True indicates the stock count items should be recounted. |
STOCK_COUNT |
RECOUNT |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
auto_authorize |
xs:boolean |
1 |
1 |
True indicates the stock count is auto authorized after counting. |
STOCK_COUNT |
AUTO_AUTHORIZE |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
pbl_pick_less_suggested |
xs:boolean |
1 |
1 |
True indicates that items with action pick amount less than suggested amount are included. |
STOCK_COUNT |
PICK_LESS_SUGGESTED |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
pbl_repl_less_suggested |
xs:boolean |
1 |
1 |
True indicates that items with replenishment amount less than suggested amount are included. |
STOCK_COUNT |
REPL_LESS_SUGGESTED |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
pbl_repl_neg_available |
xs:boolean |
1 |
1 |
True indicates items with negative available inventory are included. |
STOCK_COUNT |
REPL_NEGATIVE_AVAILABLE |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
pbl_repl_discrepant_uin |
xs:boolean |
1 |
1 |
True indicates items with serial number discrepancies are included. |
STOCK_COUNT |
UIN_DISCREPANT |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
include_active_items |
xs:boolean |
1 |
1 |
True if the stock count includes active items. |
STOCK_COUNT |
INACTIVE_ITEMS |
RIB or/and RSB or/and RSL |
NUMBER(1) |
Yes |
Fill this description. |
include_inactive_items |
xs:boolean |
1 |
1 |
True if the stock count includes inactive items. |
STOCK_COUNT |
INACTIVE_ITEMS |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
include_discontinued_items |
xs:boolean |
1 |
1 |
True if the stock count includes discontinued items. |
STOCK_COUNT |
DISCONTINUED_ITEMS |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
include_deleted_items |
xs:boolean |
1 |
1 |
True if the stock count includes deleted items. |
STOCK_COUNT |
DELETED_ITEMS |
RIB or/and RSB or/and RSL |
NUMBER(1) |
Yes |
Fill this description. |
include_soh_zero |
xs:boolean |
1 |
1 |
"True if the stock count includes items whose stock on hand is zero. |
STOCK_COUNT |
SOH_ZERO |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
include_soh_less_than_zero |
xs:boolean |
1 |
1 |
"True if the stock count includes items whose stock on hand is less than zero. |
STOCK_COUNT |
SOH_NEGATIVE |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
include_soh_greater_than_zero |
xs:boolean |
1 |
1 |
"True if the stock count includes items whose stock on hand is greater than zero. |
STOCK_COUNT |
SOH_POSITIVE |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
total_on_count |
number12 |
1 |
1 |
The total number of items to be counted. |
STOCK_COUNT |
TOTAL_ITEM_COUNT |
RIB or/and RSB or/and RSL |
NUMBER(12) |
Yes |
Fill this description. |
left_to_count |
number12 |
1 |
1 |
The total remaining items to be counted. |
STOCK_COUNT_CHILD |
TOTAL_ITEM_COUNT |
RIB or/and RSB or/and RSL |
NUMBER(12) |
Yes |
Fill this description. |
all_items |
xs:boolean |
1 |
1 |
True indicates the stock count is an all store items count. |
STOCK_COUNT |
ALL_ITEMS |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
Fill this description. |
CountChild
|
*
|
0
|
1000
|
A collection of stock count children associated with the stock count.
|
|
|
|
|
|
|