Order and Inventory Management Data Dictionary

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 NameField LabelCreated in VersionDescriptionTypeDefault Value
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


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