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 BDI) |
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 |
NUMBER |
(12) |
Yes |
the unique identifier for the stock count. this value is generated by sim. |
store_id |
number10 |
1 |
1 |
The store where the stock is being counted. |
STOCK_COUNT |
STORE_ID |
NUMBER |
(10) |
Yes |
an identifier of the store where the stock count will take place. |
product_group_id |
number10 |
0 |
1 |
The unique identifier for the product group used for the stock count. |
STOCK_COUNT |
PRODUCT_GROUP_ID |
NUMBER |
(12) |
No |
an identifier of the product group that this stock count is related to. |
schedule_id |
number10 |
0 |
1 |
The unique identifier for the product group schedule attached to the stock count.. |
STOCK_COUNT |
PRODUCT_GROUP_SCHEDULE_ID |
NUMBER |
(12) |
No |
an identifer of the product group schedule that this stock count is related to. |
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. |
NUMBER |
(2) |
Yes |
the type of stock count being performed.
1- unit, 2 - unit and amount,
3 - problem line, 4 - Adhoc, 5 - RMS Sync |
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 |
NUMBER |
(2) |
Yes |
"the status that the stock count is currently in.
0 - New, 1 - Count Scheduled, 2 - Count In progress,
3 - Count Complete, 4 - Recount Scheduled,
5 - Count in progress, 6 - Recount Complete,
7 - Approval Scheduled, 8 - Approval in Progress,
10 - Approval Processing, 12 - Approval Authorized,
14 - Approval Complete, 20 - Canceled" |
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. |
|
|
|
|
No |
Derived value from status and phase of the stock count. |
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 |
NUMBER |
(2) |
Yes |
The stock count counting methods.1 - Guided, 2 - Unguided, 3 - Thrid Party, 4 - Auto |
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 |
VARCHAR2 |
(1) |
No |
"indicates if the stock count should happen before the store opens.
B - Before store open
A - After store open
N - N/A" |
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 |
NUMBER |
(2) |
Yes |
The breakdown types for a product group associated with the stock count. 1 - Deaprtment, 2 - Class, 3 - Subclass, 4 - Location, 5 - None |
count_desc |
varchar2255 |
1 |
1 |
The description of the stock count. |
STOCK_COUNT |
DESCRIPTION |
VARCHAR2 |
(255) |
Yes |
the description for the stock count |
group_desc |
varchar2128 |
0 |
1 |
The description of the product group. |
STOCK_COUNT |
PRODUCT_GROUP_DESCRIPTION |
VARCHAR2 |
(100) |
No |
the description from the product group. |
schedule_date |
xs:dateTime |
0 |
1 |
The date the stock count is scheduled for. |
STOCK_COUNT |
SCHEDULE_DATE |
DATE |
|
No |
the date the stock count is scheduled for. |
count_start_time |
number18 |
0 |
1 |
The time in milliseconds that the count began. |
STOCK_COUNT |
START_TIME |
DATE |
|
Yes |
the time stock count was started |
last_updated_time |
xs:dateTime |
0 |
1 |
The date and time the stock count last had an update. |
STOCK_COUNT |
UPDATE_DATE_TIME |
DATE |
|
Yes |
the time stock count last updated |
export_user |
varchar240 |
0 |
1 |
The person or operator that exported the stock count. |
STOCK_COUNT |
EXPORT_USER |
VARCHAR2 |
(20) |
No |
the person or operator that exported the stock count |
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 |
NUMBER |
(12,4) |
No |
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 |
NUMBER |
(12,4) |
No |
the percentage of units as defined on the product group that will determine if any item on the stock count is to be considered discrepant. the system will compare the total soh inventory level with the quantity entered on the stock count by the user. an item is discrepant if it deviates + or ? over or equal to the variance %. |
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 |
NUMBER |
12,4 |
No |
the threshold in terms of a dollar amount as defined for the product group for an item to be considered discrepant for unit and amount stock counts. this will be a cash amount that will be compared to the number of discrepant units x unit retail of the goods. if the calculated value exceeds the variance value, then the item would be considered discrepant during the stock counting process. an item is discrepant if it deviates + or ? over or equal to the variance value. |
recount_active |
xs:boolean |
1 |
1 |
True indicates the stock count items should be recounted. |
STOCK_COUNT |
RECOUNT |
VARCHAR2 |
(1) |
Yes |
"indicates if this stock count has been recounted.
Value values are: Y, N" |
auto_authorize |
xs:boolean |
1 |
1 |
True indicates the stock count is auto authorized after counting. |
STOCK_COUNT |
AUTO_AUTHORIZE |
VARCHAR2 |
(1) |
Yes |
Indicate if stock count is auto authorized the count. |
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 |
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 |
VARCHAR2 |
(1) |
Yes |
Shelf replenish less than suggested |
pbl_repl_neg_available |
xs:boolean |
1 |
1 |
True indicates items with negative available inventory are included. |
STOCK_COUNT |
REPL_NEGATIVE_AVAILABLE |
VARCHAR2 |
(1) |
Yes |
pick customer order negative available. ex: pick_negative_available y means include if pick list negative available pick_negative_available n means exclude if pick list negative available |
pbl_repl_discrepant_uin |
xs:boolean |
1 |
1 |
True indicates items with serial number discrepancies are included. |
STOCK_COUNT |
UIN_DISCREPANT |
VARCHAR2 |
(1) |
No |
indicates whether to count serial number discrepant items. |
include_active_items |
xs:boolean |
1 |
1 |
True if the stock count includes active items. |
STOCK_COUNT |
ACTIVE_ITEMS |
NUMBER |
(1) |
Yes |
Indicates if if stock count contains active items. |
include_inactive_items |
xs:boolean |
1 |
1 |
True if the stock count includes inactive items. |
STOCK_COUNT |
INACTIVE_ITEMS |
VARCHAR2 |
1 |
Yes |
Indicates if stock count contains inactive items. Valid values are Y, N |
include_discontinued_items |
xs:boolean |
1 |
1 |
True if the stock count includes discontinued items. |
STOCK_COUNT |
DISCONTINUED_ITEMS |
VARCHAR2 |
(1) |
Yes |
Indicates if stock count contains discontinued items. |
include_deleted_items |
xs:boolean |
1 |
1 |
True if the stock count includes deleted items. |
STOCK_COUNT |
DELETED_ITEMS |
VARCHAR2 |
(1) |
Yes |
Indicates if stock count contains discontinued items. |
include_soh_zero |
xs:boolean |
1 |
1 |
"True if the stock count includes items whose stock on hand is zero. |
STOCK_COUNT |
SOH_ZERO |
VARCHAR2 |
(1) |
Yes |
allow stock on hand zero items. ex: Y or N. |
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 |
VARCHAR2 |
1 |
Yes |
allow negative stock on hand items. i.e.Y and N |
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 |
VARCHAR2 |
1 |
Yes |
allow positive stock on hand items. i.e.Y and N |
total_on_count |
number12 |
1 |
1 |
The total number of items to be counted. |
STOCK_COUNT |
TOTAL_ITEM_COUNT |
NUMBER |
(12) |
Yes |
total number of items of the stock count |
left_to_count |
number12 |
1 |
1 |
The total remaining items to be counted. |
STOCK_COUNT_CHILD |
ITEMS_LEFT_TO_COUNT |
NUMBER |
(12) |
Yes |
a remaining items to be counted. |
all_items |
xs:boolean |
1 |
1 |
True indicates the stock count is an all store items count. |
STOCK_COUNT |
ALL_ITEMS |
VARCHAR2 |
(1) |
Yes |
if stock count contains all items in the store. |
CountChild
|
*
|
0
|
1000
|
A collection of stock count children associated with the stock count.
|
|
|
|
|
|
|