Order and Inventory Management Data Dictionary

Cycle_Count__c

Label: Cycle Count

This object supports the generation of the cycle-count-batch number which controls what Item/Location combinations are to be counted within the batch. Also provides the user with status of the batch in terms of being counted or confirmed and tracks the completion of each item count within the batch. For any one specific cycle count, there may be one or multiple items and/or one or multiple locations to be counted. There are business intelligences dependent on this object.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Actual_Batch_Count__c Actual Batch Count Pre-Spring 2018 This is the sum of all item counts in a specific Cycle Count Batch that were actually confirmed.

Summary
Actual_Valuation__c Actual Valuation Pre-Spring 2018 This is the fiscal valuation sum of all items in a specific Cycle Count Batch that were actually confirmed.

Summary
Batch_Discrepancy__c Batch Discrepancy Pre-Spring 2018 The count discrepancy for the cycle count batch.

Summary
Batch_Financial_Discrepancy__c Batch Financial Discrepancy Pre-Spring 2018 Formula:
Expected_Valuation__c - Actual_Valuation__c
Currency(18,2)
Count_Accuracy__c Count Accuracy Pre-Spring 2018 This is a calculation between the Expected Batch Count and the Actual Batch Count to provide the accuracy level achieved in performing a cycle count batch from a count perspective.

Formula:
if ( Actual_Batch_Count__c < Expected_Batch_Count__c , Actual_Batch_Count__c / Expected_Batch_Count__c, 1-( (Expected_Batch_Count__c - Actual_Batch_Count__c )/ Expected_Batch_Count__c ))
Percent(18,4)
Count_Status__c Count Status Pre-Spring 2018 Formula:
IF( Item_Locations_Counted__c = 0, $Label.StatusNew, IF( Item_Locations_Counted__c = Item_Locations_To_Count__c, $Label.StatusCounted, $Label.StatusInProcess) )
Text
Expected_Batch_Count__c Expected Batch Count Pre-Spring 2018 This is the sum of all item counts in a specific Cycle Count Batch that were expected to be confirmed.

Summary
Expected_Valuation__c Expected Valuation Pre-Spring 2018 This is the fiscal valuation sum of all items in a specific Cycle Count Batch that were expected to be confirmed.

Summary
Financial_Accuracy__c Financial Accuracy Pre-Spring 2018 This is a calculation between the Expected Valuation and the Actual Valuation to provide the accuracy level achieved in performing a cycle count batch from a financial perspective.

Formula:
Actual_Valuation__c / Expected_Valuation__c
Percent(18,4)
ICP__c ICP Pre-Spring 2018 Formula:
Warehouse__r.ICP__r.Name
Text
Item_Locations_Counted__c Item Locations Counted Pre-Spring 2018 This is the number of item locations within the batch that have been counted.

Summary
Item_Locations_To_Count__c Item Locations To Count Pre-Spring 2018 This is the number of item locations to count in the batch.

Summary
Status__c Status Pre-Spring 2018 Picklist:
Approved
Cancelled
Confirmed
Counted
New
Rejected
Submitted for Approval
Type__c Type Pre-Spring 2018 The type of cycle count requested. A manual item request or an automated requested causes the date of the last cycle count to be updated.

Picklist:
Automated Request
Manual Item Request
Manual Location Request
Warehouse__c Warehouse Pre-Spring 2018 Specific warehouse or stockroom within an ICP

Looks up to: Warehouse__c
Lookup


© Copyright 2009–2024 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.