Order and Inventory Management Data Dictionary

Cycle_Count_Detail__c

Label: Cycle Count Detail

This Object provides the details about the specific part and location to be counted. There can be multiple Cycle Count Details within a Cycle Count batch. All Perpetual and Financial record discrepancies are recorded in the cycle count detail. There are business intelligence reporting’s dependent on this object.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Actual_Inventory_Value__c Expected Inventory Value Pre-Spring 2018 The actual value of the inventory that the system knows about.

Number(17,2) 0.00
Counted_Inventory_Value__c Actual Inventory Value Pre-Spring 2018 The financial value of the counted inventory. If the count is greater than the actual that is in inventory, the additional parts are entered at 0 cost.

Number(17,2) 0.00
Cycle_Count__c Cycle Count Pre-Spring 2018 Details about a specific part to count and where to count it. This is populated by a background process.

Looks up to: Cycle_Count__c
MasterDetail
Discrepancy__c Discrepancy Pre-Spring 2018 Formula:
Quantity__c - Inventory_Quantity__c
Number(18,4)
Financial_Discrepancy__c Financial Discrepancy Pre-Spring 2018 Formula:
Counted_Inventory_Value__c - Actual_Inventory_Value__c
Number(18,2)
ICP__c ICP Pre-Spring 2018 Formula:
Inventory_Location__r.Warehouse__r.ICP__r.Name
Text
Inventory_Location__c Inventory Location Pre-Spring 2018 Location that is to be counted. If the Item master field is null, then all parts in the location must be counted. This field is populated by a background process.

Looks up to: Inventory_Location__c
Lookup
Inventory_Quantity__c Inventory_Quantity Pre-Spring 2018 The quantity that is recorded in the system. This field is not visible to the user and it is only populated after a user has entered the count. This is used to record count descrepancies.

Number(18,4)
Item_Description__c Item Description Pre-Spring 2018 Formula:
Item_Master__r.Item_Description__c
Text
Item_Master__c Item Master Pre-Spring 2018 The part that is being counted. This field is populated by a background process.

Looks up to: Item__c
Lookup
Quantity__c Quantity Pre-Spring 2018 The count of the parts in this location.

Number(18,4)
Status__c Status Pre-Spring 2018 The status of the current count detail.

Picklist:
Complete
New
Warehouse__c Warehouse Pre-Spring 2018 Formula:
Inventory_Location__r.Warehouse__r.Name
Text


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