Stock Count

the unique identifier for the stock count. this value is generated by sim.

an identifier of the store where the stock count will take place.

the description for the stock count

an identifier of the product group that this stock count is related to.

the description from the product group.

an identifer of the product group schedule that this stock count is related to.

the type of stock count being performed.1- unit, 2 - unit and amount,3 - problem line, 4 - Adhoc,5 - RMS Sync

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

the phase that the stock count is in.0 - Future,1 - Count,2 - Recount,3 - Authorize

the date the stock count is scheduled for.

the time stock count was started

the time stock count last updated

the person or operator that exported the stock count

total number of items of the stock count

indicates if the stock count should happen before the store opens.B - Before store openA - After store openN - N/A

the number of units in standard uom 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 count.

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 %.

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.

The stock count counting methods.1 - Guided, 2 - Unguided, 3 - Thrid Party, 4 - Auto

The breakdown types for a product group associated with the stock count. 1 - Deaprtment, 2 - Class, 3 - Subclass, 4 - Location, 5 - None

indicates if this stock count has been recounted.Value values are: Y, N

Indicate if stock count is auto authorized the count.Valid values are: Y, N

if stock count contains all items in the store.

Indicates if if stock count contains active items.Valid values are: Y, N

Indicates if stock count contains inactive items.Valid values are: Y, N

Indicates if stock count contains discontinued items.Valid values are: Y, N

Indicates if stock count contains items marked for deletion.Values values are: Y,N

allow stock on hand zero items. ex: Y or N.

allow positive stock on hand items. ex: Y or N.

allow negative stock on hand items. ex: Y or N.

pick customer order less than suggested. ex: pick_less_suggested y means include if pick list less than suggested pick_less_suggested n means exclude if pick list less than suggested

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

indicates whether to count serial number discrepant items.

Shelf replenish less than suggested

Valid values are: Y, N.Y indicates you can no longer add items.

the unique identifier of the transaction event associated with this stock count

the unique identifier of the transaction event description