|
This data object is used to display the unit information on unit purchase orders. Join to Unit Purchase Order Header to view the header level information.
This information can be found in the Sales Purchase Order program within the Fusion business system.
URL
/frw/UnitPurchaseOrderDetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AcquiringSalesperson | This field displays the salesperson responsible for acquiring the given unit into inventory. |
| AcquisitionDate | This field displays the date on which the given unit was acquired into inventory. |
| AcquisitionMethod | This field displays the method by which the given unit was acquired into inventory. |
| ActualShipDate | This field displays the date on which the given unit was shipped. |
| AddDate | This field displays the date on which the given unit was added to the given unit purchase order. |
| AddUser | This field displays the username of the user who added the given unit to the given unit purchase order. |
| BaseCost | This field displays the base cost of the given unit. |
| Branch | This field displays the branch associated with the given unit purchase order. |
| BuildDate | This field displays the date on which the given unit was scheduled to be built. |
| ClosedDate | This field displays the date the given purchase order was closed. |
| CurrencyCode | This field displays the currency code which indicates which currency the cost of the given unit should be converted to. |
| Customer | This field displays the customer number of the customer who purchased the given unit. |
| CustomerPO | This field displays the purchase order number for the customer associated with the deal on which the unit was sold. |
| DealNumber | This field displays the deal number of the deal on which the given unit was sold. |
| Department | This field displays the department associated with the given unit purchase order. |
| EstimatedArrivalDate | This field displays the date on which the given unit was estimated to arrive. |
| InventoryType | This field displays the inventory type of the given unit. |
| LastUpdateDate | This field displays the date on which the given unit was last updated on the given unit purchase order. |
| LastUpdateUser | This field displays the username of the user who last updated the given unit on the given unit purchase order. |
| Make | This field displays the make of the given unit. |
| Model | This field displays the model of the given unit. |
| OrderDate | This field displays the date the given purchase order was placed (defaults to the date it was added to the system, but can be manually changed in Fusion). |
| PODate | This field displays the date of the given unit purchase order (defaults to the date it was added to the system, but can be manually changed in Fusion). |
| PONumber | This field displays the purchase order number associated with the given unit purchase order. |
| PurchasingStatus | This field displays the status of the given unit purchase order. |
| RequestedShipDate | This field displays the date on which the given unit was requested to be shipped. |
| Salesperson | This field displays the salesperson associated with the deal on which the given unit was sold. |
| SerialNumber | This field displays the serial number associated with the given unit. |
| StockNumber | This field displays the stock number for the given unit. |
| Supplier | This field displays the identifying code for the customer or vendor who is acting as the supplier for the given unit purchase order. |
| SupplierName | This field displays the company name of the customer or vendor who is acting as the supplier for the given unit purchase order. |
| UnitShipToAddressCity | This field displays the city of the ship to address for the unit on the given unit purchase order. |
| UnitShipToAddressCountry | This field displays the country of the ship to address for the unit on the given unit purchase order. |
| UnitShipToAddressCounty | This field displays the county of the ship to address for the unit on the given unit purchase order. |
| UnitShipToAddressPostalCode | This field displays the postal code of the ship to address for the unit on the given unit purchase order. |
| UnitShipToAddressRegion | This field displays the region of the ship to address for the unit on the given unit purchase order. |
| UnitShipToAddressStreet1 | This field displays the first line of the ship to address for the unit on the given unit purchase order. |
| UnitShipToAddressStreet2 | This field displays the second line of the ship to address for the unit on the given unit purchase order. |
| VIN | This field displays the vehicle identification number for the given unit. |
| Year | This field displays the year of the given unit. |