This data object is used to display all local purchase orders and their associated unit information.

This information can be found in the Local Purchase Order program within the Fusion business system.

URL

/frw/LPO

Field Details…

SQL Field Name Column Description
ActualAmount This field displays the actual cost of the given local purchase order, after it was closed.
AddDate This field displays the date on which the given local purchase order was added.
Addon This field displays the addon fee associated with the unit on the given local purchase order.
AddOnName This field displays the name of the addon fee associated with the unit on the given local purchase order.
AddOnPrice This field displays the price of the addon fee associated with the unit on the given local purchase order.
AddUser This field displays the username of the user who added the given local purchase order.
Branch This field displays the branch associated with the given local purchase order.
CharacteristicType This field displays the characteristic type (truck, trailer, reefer, etc.) of the unit that the given local purchase order was created for.
CloseDate This field displays the date on which the given local purchase order was closed.
CompanyName This field displays the company name of the customer for the repair order or deal that the given local purchase order is associated with.
ControlBranch This field displays the control branch of the unit that the given local purchase order was created for.
ControlDepartment This field displays the control department of the unit that the given local purchase order was created for.
CurrencyCode This field displays the currency code for the given local purchase order if it has been issued to a vendor in another country, with a different currency than the local currency.
CustomerNumber This field displays the customer number of the customer for the repair order or deal that the given local purchase order is associated with.
DealNumber This field displays the deal number of the deal that the given local purchase order is associated with.
Department This field displays the department associated with the given local purchase order.
Description This field displays the description for the given local purchase order.
ExpectedAmount This field displays the estimated cost of the given local purchase order.
ExpectedCloseDate This field displays the date on which the given local purchase order is expected to be closed out.
InventoryType This field displays the inventory type of the unit that the given local purchase order was created for.
InvoiceNumber This field displays the invoice number that the given local purchase order is associated with.
IssueDate This field displays the date on which the given local purchase order was issued (defaults to the date on which it was created, but can be manually updated).
LastUpdateDate This field displays the date on which the given local purchase order was last updated.
LastUpdateUser This field displays the username of the user who last updated the given local purchase order.
IsLimit This field displays whether the value in the Expected Amount field should be considered a spending limit for the given local purchase order.
LPO This field displays the LPO number of the given local purchase order.
LPOCostConversion This field displays an indication of when the cost of the given local purchase order will be converted to the other currency, indicated by the value in the Currency Code field.
LPOType This field displays the type of the given local purchase order.
Make This field displays the make of the unit that the given local purchase order was created for.
Model This field displays the model of the unit that the given local purchase order was created for.
OrderedBy This field displays the username of the user who ordered the given local purchase order.
OverUnder This field displays the amount by which the actual amount was over or under the estimated amount.
RONumber This field displays the repair order number of the repair order that the given local purchase order is associated with.
SerialNumber This field displays the serial number of the unit that the given local purchase order was created for.
ShipToAddress1 This field displays the first line of the ship to address for the given local purchase order.
ShipToAddress2 This field displays the second line of the ship to address for the given local purchase order.
ShipToCity This field displays the city of the ship to address for the given local purchase order.
ShipToCountry This field displays the country of the ship to address for the given local purchase order.
ShipToCounty This field displays the county of the ship to address for the given local purchase order.
ShipToPostalCode This field displays the postal code of the ship to address for the given local purchase order.
ShipToRegion This field displays the region or state of the ship to address for the given local purchase order.
Status This field displays the status of the given local purchase order.
StockNumber This field displays the stock number of the unit that the given local purchase order was created for.
ToBranch This field displays the branch that the given local purchase order is created to.
ToDepartment This field displays the department that the given local purchase order is created to.
ToVendor This field displays the name of the vendor that the given local purchase order is created to.
ToVendorNumber This field displays the identifying code for the vendor that the given local purchase order is created to.
UnitIndicator This field displays the unit indicator for the unit that the given local purchase order is associated with.
UnitNumber This field displays the unit number of the unit that the given local purchase order was created for.
Usage This field displays the usage of the given local purchase order.
VIN This field displays the vehicle identification number of the unit that the given local purchase order was created for.
Year This field displays the year of the unit that the given local purchase order was created for.