| Acquisition_Cost__c |
Acquisition Cost |
Pre-Spring 2018 |
Cost for the item from the actual acquisition (PO,Misc receipt)
|
Number(18,9) |
0 |
| Acquisition_Currency__c |
Acquisition Currency |
Pre-Spring 2018 |
The currency the part was acquired in
Looks up to: Currency_Master__c
|
Lookup |
|
| Adjustment_Cost__c |
Adjustment Cost |
Pre-Spring 2018 |
This fields displays the delta between the initial inventory position value and any adjustments made to the current value.
|
Number(18,9) |
0 |
| Availability_Code__c |
Availability Code |
Pre-Spring 2018 |
The availability code indicates specifics about whether the item inventory is available to be used, sold, or lent.
|
Picklist:
After Receiving Inspection
In Stock
In Transit
In WIP
Installed
Missing Cost
On Hold
Out for Service
Out on Service Purchase Order
Received from Miscellaneous Receipt
Received from Purchase Order
Waiting for Receiving Inspection |
|
| Availability__c |
Availability |
Pre-Spring 2018 |
Indicates whether the inventory is available for use.
|
Checkbox |
false |
| Bin__c |
Inventory Location |
Pre-Spring 2018 |
The location of the item in inventory.
Looks up to: Inventory_Location__c
|
Lookup |
|
| CSN__c |
CSN |
Pre-Spring 2018 |
The number of cycles the part has on it since the part was new.
Formula:
Receiving_Inspection__r.CSN__c
|
Text |
|
| CSO__c |
CSO |
Pre-Spring 2018 |
Cycles since last overhaul.
Formula:
Receiving_Inspection__r.CSO__c
|
Text |
|
| CSR__c |
CSR |
Pre-Spring 2018 |
The number of cycles the part has on it since the part was removed.
Formula:
Receiving_Inspection__r.CSR__c
|
Text |
|
| Condition_Code__c |
Condition |
Pre-Spring 2018 |
This information helps describe the condition of the item (e.g., item is serviceable or new).
Looks up to: Condition_Code__c
|
Lookup |
|
| Current_Value__c |
Current Value |
Pre-Spring 2018 |
The current value of the item in inventory.
|
Number(18,9) |
|
| Cycle_Count_Detail__c |
Cycle Count Detail |
Pre-Spring 2018 |
This field is populated when this inventory position is scheduled to be cycle counted. When the cycle count is confirmed the reference is removed. This provides visibility to current inventory and also prevents double scheduling a specific item for cycle count.
Looks up to: Cycle_Count_Detail__c
|
Lookup |
|
| Cycle_Count_Status__c |
Cycle Count Status |
Pre-Spring 2018 |
If the inventory position is included in a cycle count batch, this status indicates, based on the count, whether this position should be added to or removed from inventory. This is here mainly to support parts that are under serial, lot, or shelf life control. This is set by a background process.
|
Picklist:
Add on confirm
Remove on confirm |
|
| Date_Placed_in_Inventory__c |
Date Placed in Inventory |
Pre-Spring 2018 |
The date the item was placed in inventory. This date should be used instead of date created to determine first in for allocation. The split on the inventory position resets created date. Receiving and miscellaneous receipt set this date and time.
|
DateTime |
|
| ICP_Acquisition_Cost__c |
ICP Acquisition Cost |
Pre-Spring 2018 |
The unit cost to acquire in the currency that is used for the ICP.
|
Number(18,9) |
|
| ICP_Currency__c |
ICP Currency |
Pre-Spring 2018 |
The currency used to hold the inventory in the specific ICP.
Looks up to: Currency_Master__c
|
Lookup |
|
| Internal_Repair_Cost__c |
Internal Repair Cost |
Pre-Spring 2018 |
|
Number(18,9) |
0 |
| Inventory_Attachment__c |
Inventory Attachment |
Pre-Spring 2018 |
Looks up to: Inventory_Attachment__c
|
Lookup |
|
| Item_Description__c |
Item Description |
Pre-Spring 2018 |
Item description
Formula:
Item_Master__r.Item_Description__c
|
Text |
|
| Item_Master__c |
Item Master |
Pre-Spring 2018 |
The item number for the part in inventory.
Looks up to: Item__c
|
Lookup |
|
| Item_Serial_Number__c |
Item Serial Number |
Pre-Spring 2018 |
The serial number of the item in inventory. This replaces the serial number field that was originally on the inventory position - it was too short.
|
Text(100) |
|
| Item_Warehouse__c |
Item Warehouse |
Pre-Spring 2018 |
This field is added to the inventory position so that the lookup on the action queue can be a dependent filter. Specifically for put away, only locations within the current warehouse can be selected.
Looks up to: Warehouse__c
|
Lookup |
|
| Labor_Cost__c |
Labor Cost |
Pre-Spring 2018 |
The labor cost for this item per unit.
|
Number(18,9) |
0 |
| Last_Cycle_Count_Performed__c |
Last Cycle Count Performed |
Pre-Spring 2018 |
This date is added as a result of a cycle count confirmation record being generated and is the basis for calculating the next due automated request cycle count
|
Date |
|
| List_Type__c |
List Type |
Pre-Spring 2018 |
The listing type associated with this inventory position when this item is listed. This is set by software only
|
Picklist:
G
M
N
Q
R
S
Y |
|
| List_on_ILS__c |
DEPRECATED: List on ILS |
Pre-Spring 2018 |
This field is obsolete.
|
Checkbox |
false |
| Listed_Date__c |
Listed Date |
Pre-Spring 2018 |
The date and time of registration for the inventory position.
|
DateTime |
|
| Listed_on_ILS__c |
DEPRECATED: Listed on ILS? |
Pre-Spring 2018 |
This inventory position is listed on ILSMart if this field is checked/true. This field is not set by the user.
|
Checkbox |
false |
| Location__c |
Location |
Pre-Spring 2018 |
ICP and Warehose
Formula:
Bin__r.Warehouse__r.ICP__r.Name & BR() & Bin__r.Warehouse__r.Name
|
Text |
|
| Logistics_Cost__c |
Logistics Cost |
Pre-Spring 2018 |
|
Number(18,9) |
0 |
| Logistics_Purchase_Order_Line_Item__c |
Logistics Purchase Order Line Item |
Pre-Spring 2018 |
Looks up to: Purchase_Order_Line_Item__c
|
Lookup |
|
| Lot_Number__c |
Lot Number |
Pre-Spring 2018 |
The lot number for the part(s) in inventory. The lot number must be specified if the part is defined to be a lot controled part.
|
Text(50) |
|
| Manufacturer_CAGE__c |
Manufacturer CAGE |
Pre-Spring 2018 |
Commercial And Government Entity (CAGE) code is a five-character ID number that identifies government contractors.
|
Text(5) |
|
| Manufacturer__c |
Manufacturer |
Pre-Spring 2018 |
Manufacturer of Item
Looks up to: Manufacturer__c
|
Lookup |
|
| Owned_By__c |
Owned By |
Pre-Spring 2018 |
The field indicates who owns the part. This will eventually be a lookup field
|
Text(80) |
|
| Ownership_Code__c |
Ownership Code |
Pre-Spring 2018 |
This information helps describe the Ownership of the item (i.e., item owned by a certain Supplier or Customer)
Looks up to: Ownership_Code__c
|
Lookup |
|
| Production_Order_Line__c |
Production Order Line |
Pre-Spring 2018 |
Production order line to which this is allocated.
Looks up to: Production_Order_Line__c
|
Lookup |
|
| Production_Order__c |
Production Order |
Pre-Spring 2018 |
This refers to the production order that created this item.
Looks up to: Production_Order__c
|
Lookup |
|
| Purchase_Order_Line_Item__c |
Purchase Order Line Item |
Pre-Spring 2018 |
The purchase order line item the parts are allocated to. This field contains data only if the part(s) are allocated to a purchase order. This is usually for outside service.
Looks up to: Purchase_Order_Line_Item__c
|
Lookup |
|
| Quantity_Allocated__c |
Quantity Allocated |
Pre-Spring 2018 |
The quantity that has been reserved to fill a Purchase, Sales, or Transfer Order
|
Number(18,4) |
0 |
| Quantity__c |
Quantity Stored |
Pre-Spring 2018 |
The quantity of the part in the specific location
|
Number(18,4) |
0 |
| Quantity_in_Transit__c |
Quantity in Transit |
Pre-Spring 2018 |
|
Number(18,4) |
0 |
| Receipt_Line__c |
Receipt Line |
Pre-Spring 2018 |
The receipt line that this inventory was received on
Looks up to: Receipt_Line__c
|
Lookup |
|
| Receiving_Inspection__c |
Receiving Inspection |
Pre-Spring 2018 |
Receiving Inspection associated with the parts in this inventory position entry. This field is null for parts that do not require inspection.
Looks up to: Receiving_Inspection__c
|
Lookup |
|
| Repair_Cost__c |
Net Change in Value |
Pre-Spring 2018 |
Formula:
Current_Value__c - ICP_Acquisition_Cost__c
|
Number(18,9) |
|
| Reserve_Price__c |
Reserve Price |
Pre-Spring 2018 |
The minimum price at which a seller is willing to sell an item. Reservation prices are commonly used in auctions.
|
Currency(12,2) |
|
| Revision_Level__c |
Revision Level |
Pre-Spring 2018 |
Engineering control revision of part in inventory
|
Text(2) |
|
| Sale_Price__c |
Sale Price |
Pre-Spring 2018 |
The price that the inventory part is sold for.
|
Number(18,2) |
|
| Sales_Order_Line_Item__c |
Sales Order Line Item |
Pre-Spring 2018 |
If inventory position is allocated to a sales order, this references the line item the allocation is for.
Looks up to: Sales_Order_Line_Item__c
|
Lookup |
|
| Serial_Number_Lookup__c |
Serial Number Lookup |
Pre-Spring 2018 |
Looks up to: Serial_Number__c
|
Lookup |
|
| Serial_Number__c |
Serial Number Obsolete |
Pre-Spring 2018 |
The serial number for the part. It must be present if the part is serialized (defined in the Item Master) This is obsolete because the length is a mismatch to the other objects in the system.
|
Text(50) |
|
| Service_Cost__c |
Service Cost |
Pre-Spring 2018 |
The field is incremented whenever a service type purchase order is received into the system. The receipt of the service PO updates the current value of the item as well as this attribute.
|
Number(18,9) |
0 |
| Shelf_Life_Expiration__c |
Shelf Life Expiration |
Pre-Spring 2018 |
Shelf life is the time that items can be stored, during which the defined quality of a specified proportion of the item remains acceptable under expected (or specified) conditions of distribution and storage.
|
DateTime |
|
| TSN__c |
TSN |
Pre-Spring 2018 |
Time since the part was new. This is hours and tenths or minutes
Formula:
Receiving_Inspection__r.TSN__c
|
Text |
|
| TSO__c |
TSO |
Pre-Spring 2018 |
Time since last overhaul.
Formula:
Receiving_Inspection__r.TSO__c
|
Text |
|
| TSR__c |
TSR |
Pre-Spring 2018 |
Time since the part was removed. This is hours and tenths or minutes.
Formula:
Receiving_Inspection__r.TSR__c
|
Text |
|
| Total_Acquisition_Cost__c |
Total Acquisition Cost |
Pre-Spring 2018 |
Formula:
ICP_Acquisition_Cost__c * Quantity__c
|
Currency(18,9) |
|
| Total_Current_Value__c |
Total Current Value |
Pre-Spring 2018 |
Formula:
Current_Value__c * Quantity__c
|
Currency(18,9) |
|
| Transfer_Request_Line__c |
Transfer Request Line |
Pre-Spring 2018 |
Looks up to: Transfer_Request_Line__c
|
Lookup |
|
| Warehouse__c |
Warehouse |
Pre-Spring 2018 |
This is an internal field only and is used to facilitate summarizing inventory by warehouse. The field is automatically populated.
Formula:
Bin__r.Warehouse__r.Name
|
Text |
|
