URL

/frw/PartsPODetail

This data object is used to display all parts purchase order detail records.

This information is located within the Parts Purchase Order program within the Fusion business system.


Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the given part number was added to the given purchase order.
AddUser This field displays the user name that added the record.
AverageCost This field displays the average cost of the part.
BinLocation This field displays the parts bin location.
Branch This field displays the branch the purchase order was created in.
CoreCost This field displays the replacement cost of a core part.
CoreImportCost This field displays the import cost for the given core part.
CorePartDescription This field displays the description of the core part number attached to the part.
CorePartNumber This field displays the number attached to a core part.
Cost This field displays the replacement cost of the part.
DetailDeliveryDate This field displays the estimated delivery date for the given detail item.
Division This field displays the company division associated with the given purchase order.
ExtendedAverageCost This field displays the extended average cost of the part.
ExtendedCoreCost This field displays the extended replacement cost of a core part.
ExtendedCost This field displays the extended replacement cost of the part.
ExtendedInherentAverageCoreCost This field displays the extended inherent average cost of the core.
FillingBranch For inter branch purchase orders, this field displays the branch filling the order.
ImportCost This field displays the import cost for the given part.
InherentAverageCoreCost This field displays the inherent average cost of the core.
InterBranchBackorder This field contains the number of the quantity ordered that will be backordered.
InterBranchStockOrder This field displays whether or not the given purchase order is an Inter-Branch purchase order.
LastUpdateDate This field displays the date on which the given purchase order detail item was last updated.
UpdateUser This field displays the user name of the individual who made the update.
Message This field displays the user entered message/comment for the given purchase order detail item.
PartDescription This field displays the description of the given part number.
PartNumber This field displays the given purchase order detail items part number.
PONumber This field displays the purchase order number assigned to the given detail item.
Quantity This field displays the quantity requested for a given item.
Status This field displays the status of the given purchase order.
StockStatus This field displays the part’s stock status (stock, non-stock, obsolete, superseded, etc.).
SupplierCode This field displays the code attached to a supplier for a part.
SupplierName This field displays the name of the supplier the purchase order if for.
UnitOfMeasure This field displays the unit of measure for the given purchase order detail item.