Item__c

Label: Item Master

This describes the elements of data that detail an Item that can be purchased received, stored, and consumed, i.e sold

Field Name	Field Label	Created in Version	Description	Type	Default Value
ABC_Classification__c	ABC Classification	Pre-Spring 2018	Setting the ABC Classification defines the stratification of inventory by Item Price and will invoke Cycle Counting rules. Please refer to cycle counting information	Picklist: A B C Other
Acquisition_Lead_Time__c	Acquisition Lead Time	Pre-Spring 2018	The sum of time in calendar days for the total acquisition process for an item to be performed Formula: Approval_Lead_Time__c + Supplier_Procurement_L_T__c + Supplier_Repair_Service_L_T__c + Receiving_Inspection_L_T__c	Number(18,0)
Acquisition__c	Acquisition	Pre-Spring 2018		Picklist: Make Purchase Transfer
Active_Status__c	Active Status?	Pre-Spring 2018	Only Active Items can be bought or sold. Inactive items can be stored and issued	Checkbox	true
Approval_Lead_Time__c	Approval Lead Time	Pre-Spring 2018	Approval time is the estimated process time to establish a sourcing selection and process internal purchase approvals	Number(2,0)
Box_Height__c	Box Height	Pre-Spring 2018		Number(7,2)
Box_Length__c	Box Length	Pre-Spring 2018		Number(7,2)
Box_Width__c	Box Width	Pre-Spring 2018		Number(7,2)
CAGE_Controlled__c	CAGE Controlled?	Pre-Spring 2018	Commercial And Government Entity (CAGE) code is a five-character ID number that identifies government contractors.	Checkbox	false
Commodity_Code__c	Commodity Code	Pre-Spring 2018	Segregation of product used typically for acquisition process (e.g., spend by commodity code) Looks up to: Commodity_Code__c	Lookup
Configurable__c	Configurable	Pre-Spring 2018	Checking this allows the item to be configured with options	Checkbox	false
Conversion_Factor__c	Conversion Factor	Pre-Spring 2018	This is the factor by which Supplier UOM will be used to establish stocking levels for Stocking UOM	Picklist: Divide Multiply
Conversion_Value__c	Conversion Value	Pre-Spring 2018	This is the value that is used along with the conversion factor to convert supplier UOM to stocking UOM.	Number(18,6)
ElectroStatic_Discharge_ESD_Sensitive__c	ElectroStatic Discharge (ESD) Sensitive	Pre-Spring 2018	Flagging this Item as ESD Sensitive will provide informational warnings to users during Receiving, Inspections, and warehouse operations	Checkbox	false
Eligible_for_ILS__c	DEPRECATED: Eligible for ILS	Pre-Spring 2018	This field is obsolete.	Checkbox	false
Exportation__c	Exportation allowed	Pre-Spring 2018	Exportation allowed to foreign countries may be restricted during shipping processes by selecting "no"	Picklist: No Yes
FSC__c	FSC	Pre-Spring 2018	A four character code that is combined with the NIIN to form the NSN.	Text(4)
Hazardous_Material__c	Hazardous Material	Pre-Spring 2018	Hazardous Material requires MSDS control sheets and may require special handling and storage requirements. Rules are established to enforce these requirements.	Checkbox	false
ILS_Condition_Codes__c	DEPRECATED: ILS Condition Codes	Pre-Spring 2018	This field is obsolete.	MultiselectPicklist: AR NE NS OH SV
Inbound_Outbound_Serial_Number__c	Inbound Outbound Serial Number?	Pre-Spring 2018	Serial Number tracking on inbound Receipt and outbound only shipment. Relieves requirement to pick specific serial numbers during order fulfillment.	Checkbox	false
Inspection_Required__c	Inspection Required?	Pre-Spring 2018	Items checked as requiring Inspections must have an inspection record in the system before being able to be stored or sold	Checkbox	false
Intangible__c	Intangible?	Pre-Spring 2018	As opposed to a physical item, an intangible one is not stocked, allocated, or shipped. Examples include labor and software licenses.	Checkbox	false
Internal_Repair_L_T__c	Internal Repair L/T	Pre-Spring 2018	The estimated time in calendar days for internal repair services for an item to be performed	Number(2,0)
Item_Description__c	Item Description	Pre-Spring 2018	Text to describe an Item Number	TextArea
Item_Type__c	Item Type	Pre-Spring 2018	Item Type establishes warnings within the system based on capabilities	Picklist: Capital Equipment Consumable Kit Material Repairable Rotable Time Tool
Item_and_Description__c	Item and Description	Pre-Spring 2018	Formula: Name + '- ' + Item_Description__c	Text
Items_per_Box__c	Items per Box	Pre-Spring 2018		Number(5,0)
Kit__c	Kit	Pre-Spring 2018	The kit type determines how the item is managed through the system. If not a kit, then the item is managed as a single item. A virtual kit is a group of items that is stocked separately but actions on the kit, affect all the components. A manufactured kit is stocked as a single item but when a production receipt is done for the item, the components in the kit are back flushed.	Picklist: Manufactured kit Not a kit item Virtual kit
Life_Limited_Control__c	Life Limited Control?	Pre-Spring 2018	Life Limited Controlled parts will have master counts associated with them and therefore are typically Serialized Items. During Inspection this flag is utilized to ensure master counts are added to the inventory record	Checkbox	false
Long_Description__c	Long Description	Pre-Spring 2018		LongTextArea(32000)
Lot_Number_Control__c	Lot Number Control?	Pre-Spring 2018		Checkbox	false
Manufacturing_L_T__c	Manufacturing L/T	Pre-Spring 2018	The estimated time in calendar days for internal manufacturing services for an item to be performed	Number(3,0)
Model_Relationship__c	Model Relationship	Pre-Spring 2018	This field specifies various models or high level assemblies that this part is used on.	MultiselectPicklist: Airbus 319 Airbus 320 Airbus 340 Airbus 380 Boeing 727 Boeing 737 Boeing 747 Boeing 757 Boeing 767 Boeing 787
NIIN__c	NIIN	Pre-Spring 2018	National (or NATO) Item Identification Number (NIIN) is a 9-digit numeric code which uniquely identifies an item of supply in the NATO Codification System	Text(9)
NSN__c	NSN	Pre-Spring 2018	This is the National Stock Number associated with an Item Number Formula: FSC__c & NIIN__c	Text
Packaged_Weight__c	Packaged Weight	Pre-Spring 2018		Number(7,2)
Product_Group__c	Product Group	Pre-Spring 2018	Defines the logical group this items belongs to (e.g., computing equipment, printing supplies). Looks up to: Product_Group__c	Lookup
Product__c	Product	Pre-Spring 2018	The Salesforce product that relates to the item. Looks up to: Product2	Lookup
Receiving_Inspection_L_T__c	Receiving / Inspection L/T	Pre-Spring 2018	Receiving / Inspection time is the estimated time in calendar days for internal Dock-to-Stock processing for a part	Number(2,0)
Revision_Control__c	Revision Control	Pre-Spring 2018	Checking this determines if an Item is under revision controls. Typically used for recording engineering document levels within the system	Checkbox	false
Serial_Number_Control__c	Serial Number Control?	Pre-Spring 2018		Checkbox	false
Shelf_Life_Control__c	Shelf Life Control?	Pre-Spring 2018	Shelf Life Controlled items enforce rules for issue within the system	Checkbox	false
Shipping_Volume__c	Shipping Volume	Pre-Spring 2018		Number(7,2)
Single_Lot_Fulfillment__c	Single Lot Fulfillment	Pre-Spring 2018	When allocating this item, it will be completely fulfilled by items from a single lot.	Checkbox	false
Stocking_UOM__c	Stocking UOM	Pre-Spring 2018	The unit of measure used for stocking and issuing. Looks up to: Unit_of_Measure__c	Lookup
Supplier_Procurement_L_T__c	Supplier Procurement L/T	Pre-Spring 2018	Supplier Procurement time is the estimated time in calendar days for a supplier to provide a new part	Number(3,0)
Supplier_Repair_Service_L_T__c	Supplier Repair Service L/T	Pre-Spring 2018	Supplier Repair Service time is the estimated time in calendar days for a supplier to provide repair services for a part	Number(3,0)
Supplier_UOM__c	Supplier UOM	Pre-Spring 2018	The unit of measure in which a supplier delivers this item. This is not necessarily the same as the Stocking UOM. Looks up to: Unit_of_Measure__c	Lookup
Supply_Requisition_Auto_Firm__c	Supply Requisition Auto Firm	Pre-Spring 2018	When supply is required to meet MIN/MAX, reorder Point, or Safety Stock Levels, a Supply Requisition is automatically generated	Picklist: No Yes