|
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. |