Inventory_Transaction_Perpetual_Record__c

Label: Inventory Transaction Perpetual Record

This Object describes the transactions related to acquiring, managing, and selling inventory items. This includes the who, what, when, where, and why specific transactions occurred. In addition, this will enable users to review the history of the perpetual inventory positions.

Field Name	Field Label	Created in Version	Description	Type
AP_Voucher__c	AP Voucher	Spring 2018	During the match process, when the Track Purchase Price Variance (PPV) custom setting is enabled, this AP Voucher generates the Inventory Transaction Perpetual Record. Looks up to: AP_Voucher__c	Lookup
CSN__c	CSN	Pre-Spring 2018	Cycles since New	Text(255)
CSO__c	CSO	Pre-Spring 2018	Cycles since overhaul.	Text(255)
CSR__c	CSR	Pre-Spring 2018	Cycles since removal.	Text(255)
Comment__c	Comment	Pre-Spring 2018	A comment field that is entered by a user for certain inventory transactions.	TextArea
Condition_Code__c	Condition	Pre-Spring 2018	The condition code associated with the parts involved in the transaction. The location balances include all parts regardless of the condition code. Looks up to: Condition_Code__c	Lookup
Customer_Return_Line__c	Customer Return Line	Spring 2020	Refers to a customer return line with items to return to inventory. Looks up to: Customer_Return_Line__c	Lookup
Cycle_Count_Detail__c	Cycle Count Detail	Pre-Spring 2018	The cycle count detail record that caused this cycle count transaction record to be written. Looks up to: Cycle_Count_Detail__c	Lookup
Expiry_Date__c	Expiry Date	Pre-Spring 2018	The date and time when the item can no longer be used.	DateTime
Export_Error__c	Export Error	Pre-Spring 2018	Error that occurred during the GL transaction export process.	TextArea
Export_Status__c	Export Status	Pre-Spring 2018	The status of the export of this transaction.	Picklist: Export Error Export in Process Exported New
Foreign_Transaction_Number__c	Foreign Transaction Number	Pre-Spring 2018		Text(100)
ICP__c	ICP	Pre-Spring 2018	Formula: Inventory_Location__r.Warehouse__r.ICP__r.Name	Text
Inventory_Location__c	Inventory Location	Pre-Spring 2018	Looks up to: Inventory_Location__c	Lookup
Inventory_Position__c	Inventory Position	Pre-Spring 2018	Looks up to: Inventory_Position__c	Lookup
Inventory_Transactions__c	Inventory Transactions	Pre-Spring 2018		Picklist: AP Voucher Credit Accrual Reversal Add Logistics Cost Add Service Cost Adjust Condition Adjust Current Value Adjust Ownership Allocate Customer Items Allocate Production Order Items Allocate Supplier Items Bill Drop Ship Item Confirm Production Order Pick-list Credit Drop Ship Item Cycle Count Inspection Inspection Accept Inspection Accept Us as Is Inspection Accept Use as Is Inspection Accept with Deviation Inspection Reject Inspection Reject Return Parts to Vendor Inspection Reject Scrap Parts Issue Customer Items Pick-list Issue Production Order Pick Issue Supplier Items Pick-list Item Changed Ownership Item Hold Item Transfer Inbound Item Transfer Outbound Locate Inventory Manufacture Item Miscellaneous Issue Miscellaneous Receipt PPV Receive Customer Returned Material Receive Exchanged Items (Cores) Receive Purchased Material Removed from Inventory - Consumed in Service Purchase Order Return to Stock Reverse Allocate Supplier Items Reverse Customer Allocation Reverse Cycle Count Reverse Inspection Reverse Issue Customer Items Pick-list Reverse Issue Supplier Items Pick-List Reverse Item Hold Reverse Item Transfer Inbound Reverse Item Transfer Outbound Reverse Locate Inventory Reverse Miscellaneous Issue Reverse Production Order Allocation Reverse Receive Customer Returned Material Reverse Receive Exchanged Items (Cores) Reverse Receive Purchased Material Reverse Return to Stock Reverse Scrap Inventory Scrap Inventory Use Tax Void PPV
Item_Master__c	Item Master	Pre-Spring 2018	Looks up to: Item__c	Lookup
Item_Serial_Number__c	Item Serial Number	Pre-Spring 2018	The serial number of the item being referenced. This replaces the original serial number field since the length of the original is too short	Text(100)
Lot_Number__c	Lot Number	Pre-Spring 2018		Text(50)
New_Location_Balance__c	New Location Balance	Pre-Spring 2018	The balance in the location after the transaction.	Number(18,4)
Old_Location_Balance__c	Old Location Balance	Pre-Spring 2018	The number of parts in the location before the transaction.	Number(18,4)
Owned_By__c	Owned By	Pre-Spring 2018	The owner of the inventory. This is valid only with appropriate Ownership Code	Text(80)
Ownership_Code__c	Ownership Code	Pre-Spring 2018	A reference to the ownership code associated with the inventory referenced on this perpetual record. Looks up to: Ownership_Code__c	Lookup
Production_Order_Line__c	Production Order Line	Pre-Spring 2018	The production order line associated with this transaction. Looks up to: Production_Order_Line__c	Lookup
Production_Order__c	Production Order	Pre-Spring 2018	The production order associated with this transaction. Used for completion of production order. Looks up to: Production_Order__c	Lookup
Purchase_Order_Line_Item__c	Purchase Order Line Item	Pre-Spring 2018	This refers to a purchase order line where parts are being shipped out for some sort of outside service. Looks up to: Purchase_Order_Line_Item__c	Lookup
Quantity__c	Quantity	Pre-Spring 2018		Number(18,4)
Reason_Code__c	Reason Code	Pre-Spring 2018	Looks up to: Reason_Code__c	Lookup
Receipt_Line__c	Receipt Line	Pre-Spring 2018	The receipt line that is associated with this specific inventory transaction Looks up to: Receipt_Line__c	Lookup
Receiving_Inspection__c	Receiving Inspection	Pre-Spring 2018	This is a reference to the receiving inspection record associated with the part referenced in this record. Looks up to: Receiving_Inspection__c	Lookup
Sales_Order_Line_Item__c	Sales Order Line Item	Pre-Spring 2018	Looks up to: Sales_Order_Line_Item__c	Lookup
Serial_Number__c	Serial Number Obsolete	Pre-Spring 2018	This is obsolete because the length is too short. Use Item Serial Number instead.	Text(15)
TSN__c	TSN	Pre-Spring 2018	Time since new. Time is in hours and tenths or minutes.	Text(255)
TSO__c	TSO	Pre-Spring 2018	Time since overhaul.	Text(255)
TSR__c	TSR	Pre-Spring 2018	Time since removal.	Text(255)
Transfer_Request_Line__c	Transfer Request Line	Pre-Spring 2018	Looks up to: Transfer_Request_Line__c	Lookup
Unit_of_Measure__c	Unit of Measure	Pre-Spring 2018	Looks up to: Unit_of_Measure__c	Lookup
Warehouse__c	Warehouse	Pre-Spring 2018	Formula: Inventory_Location__r.Warehouse__r.Name	Text