This data object is used to display all parts transaction records from the Fusion business system.

Transactions where the price level fields were updated due to pricing changes will have the field column set to be “blank”, and you can see the changes by referencing the price level and previous price level fields.

This information can be found in the Parts Transactions program within the Fusion business system. 

URL

/frw/PartsTransactions

Field Details…

SQL Field Name Column Description
Application This field displays the application in which the part transaction originated.
AverageCost This field displays the parts new average cost after the transaction occurred.
PartBranch This field displays the branch associated with the part transaction.
DateTime This field displays the date on which the part transaction took place.
PartDescription This field displays the description of the part the transactions is for.
Difference This field displays the difference between the new and old value (New Value - Old Value).
ChangedField This field displays the name of the parts inventory field that was changed as a part of the part transaction.  Transactions where the price level fields were updated due to pricing changes will have the field column set to be “blank”, and you can see the changes by referencing the price level and previous price level fields.
InherentAverageCost This field displays the Inherent Average Cost of core records.
InherentReplacementCost This field displays the Inherent Replacement Cost of core records.
ListPrice This field displays the given part’s new list price at the time the transaction took place based on the parts cost change.  This value would be different from Previous List Price on transactions where replacement cost was changed and price were recalculated.
NewValue This field displays the New Value based on the Changed field.
OldValue This field displays the Old Value based on the Changed field.
PartNumber This field displays the part number of the part transaction is for.
PartType This field displays the type of a part.
PreviousAverageCost This field displays the average cost of the given part prior to the transaction taking place.
PreviousInherentAverageCost This field displays the average cost of the inherent core associated with the given part prior to the transaction taking place.
PreviousInherentReplacementCost This field displays the replacement cost of the inherent core associated with the given part prior to the transaction taking place.
PreviousListPrice This field displays the given part’s list price prior to the transaction taking place.
PreviousPrice1 This field displays the given part’s price level 1 prior to the transaction taking place.
PreviousPrice2 This field displays the given part’s price level 2 prior to the transaction taking place.
PreviousPrice3 This field displays the given part’s price level 3 prior to the transaction taking place.
PreviousPrice4 This field displays the given part’s price level 4 prior to the transaction taking place.
PreviousPrice5 This field displays the given part’s price level 5 prior to the transaction taking place.
PreviousPrice6 This field displays the given part’s price level 6 prior to the transaction taking place.
PreviousPrice7 This field displays the given part’s price level 7 prior to the transaction taking place.
PreviousQuantityAvailable This field displays the quantity available of the given part prior to the transaction taking place.
PreviousReplacementCost This field displays the replacement cost of the given part prior to the transaction taking place.
Price1 This field displays the given part’s new price level 1 at the time the transaction took place.  This value would be different from Previous Price 1 on transactions where replacement cost was changed and price were recalculated.
Price2 This field displays the given part’s new price level 2 at the time the transaction took place.  This value would be different from Previous Price 2 on transactions where replacement cost was changed and price were recalculated.
Price3 This field displays the given part’s new price level 3 at the time the transaction took place.  This value would be different from Previous Price 3 on transactions where replacement cost was changed and price were recalculated.
Price4 This field displays the given part’s new price level 4 at the time the transaction took place.  This value would be different from Previous Price 4 on transactions where replacement cost was changed and price were recalculated.
Price5 This field displays the given part’s new price level 5 at the time the transaction took place.  This value would be different from Previous Price 5 on transactions where replacement cost was changed and price were recalculated.
Price6 This field displays the given part’s new price level 6 at the time the transaction took place.  This value would be different from Previous Price 6 on transactions where replacement cost was changed and price were recalculated.
Price7 This field displays the given part’s new price level 7 at the time the transaction took place.  This value would be different from Previous Price 7 on transactions where replacement cost was changed and price were recalculated.
QuantityAdjustmentReason This field displays the description of reasoning behind a quantity adjustment.
QuantityAvailable This field displays the quantity available of the part at the time the transaction took place.
ReplacementCost This field displays the parts new replacement cost after the transaction occurred.
SourceDocument This field displays the Invoice Number or Price File record that initiated the change.
Supplier This field displays the supplier associated with the given part transaction.
SupplierName This field displays the supplier’s name.
ChangeAction This field displays the type of parts transaction that was completed (add, update, delete, merge).
Username This field displays the user responsible for the parts transaction.