|
This data object is used to display the header information on unit purchase orders. Join to Unit Purchase Order Detail to view the detail level information.
This information can be found in the Sales Purchase Order program within the Fusion business system.
URL
/frw/UnitPurchaseOrderHeader
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given unit purchase order was added to the system. |
| AddUser | This field displays the username of the user who added the given unit purchase order to the system. |
| Branch | This field displays the branch associated with the given unit purchase order. |
| BranchBillToAddressCity | This field displays the city of the bill to address for the branch associated with the given unit purchase order. |
| BranchBillToAddressCountry | This field displays the country of the bill to address for the branch associated with the given unit purchase order. |
| BranchBillToAddressCounty | This field displays the county of the bill to address for the branch associated with the given unit purchase order. |
| BranchBillToAddressPostalCode | This field displays the postal code of the bill to address for the branch associated with the given unit purchase order. |
| BranchBillToAddressRegion | This field displays the region of the bill to address for the branch associated with the given unit purchase order. |
| BranchBillToAddressStreet1 | This field displays the first line of the bill to address for the branch associated with the given unit purchase order. |
| BranchBillToAddressStreet2 | This field displays the second line of the bill to address for the branch associated with the given unit purchase order. |
| CellPhone | This field displays the cell phone for the primary contact at the supplier associated with the given unit purchase order. |
| ClosedDate | This field displays the date on which the given unit purchase order was closed. |
| Department | This field displays the department associated with the given unit purchase order. |
| EmailAddress | This field displays the email address for the primary contact at the supplier associated with the given unit purchase order. |
| FactoryOrderNumber | This field displays the factory order number associated with the given unit purchase order. |
| Fax | This field displays the fax for the primary contact at the supplier associated with the given unit purchase order. |
| HomePhone | This field displays the home phone for the primary contact at the supplier associated with the given unit purchase order. |
| LastUpdateDate | This field displays the date on which the given unit purchase order was last updated in the system. |
| LastUpdateUser | This field displays the username of the user who last updated the given unit purchase order in the system. |
| Pager | This field displays the pager for the primary contact at the supplier associated with the given unit purchase order. |
| 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. |
| POTotal | This field displays the sum of the base cost of all units on the given unit purchase order. |
| POType | This field displays the type of the given unit purchase order (Stock or Customer). |
| PurchasingStatus | This field displays the status of the given unit purchase order. |
| ShipToAddressCity | This field displays the city of the ship to address for the supplier associated with the given unit purchase order. |
| ShipToAddressCountry | This field displays the country of the ship to address for the supplier associated with the given unit purchase order. |
| ShipToAddressCounty | This field displays the county of the ship to address for the supplier associated with the given unit purchase order. |
| ShipToAddressPostalCode | This field displays the postal code of the ship to address for the supplier associated with the given unit purchase order. |
| ShipToAddressRegion | This field displays the region of the ship to address for the supplier associated with the given unit purchase order. |
| ShipToAddressStreet1 | This field displays the first line of the ship to address for the supplier associated with the given unit purchase order. |
| ShipToAddressStreet2 | This field displays the second line of the ship to address for the supplier associated with the given unit purchase order. |
| Supplier | This field displays the identifying code for the customer or vendor who is acting as the supplier for the given unit purchase order. |
| SupplierBillToAddressCity | This field displays the city of the bill to address for the customer or the remit to address for the vendor associated with the given unit purchase order. |
| SupplierBillToAddressCountry | This field displays the country of the bill to address for the customer or the remit to address for the vendor associated with the given unit purchase order. |
| SupplierBillToAddressCounty | This field displays the county of the bill to address for the customer or the remit to address for the vendor associated with the given unit purchase order. |
| SupplierBillToAddressPostalCode | This field displays the postal code of the bill to address for the customer or the remit to address for the vendor associated with the given unit purchase order. |
| SupplierBillToAddressRegion | This field displays the region of the bill to address for the customer or the remit to address for the vendor associated with the given unit purchase order. |
| SupplierBillToAddressStreet1 | This field displays the first line of the bill to address for the customer or the remit to address for the vendor associated with the given unit purchase order. |
| SupplierBillToAddressStreet2 | This field displays the second line of the bill to address for the customer or the remit to address for the vendor associated with 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. |
| SupplierType | This field displays the type of the supplier for the given unit purchase order (Vendor or Customer). |
| TotalUnitsOrdered | This field displays the number of units ordered total on the given unit purchase order. |
| UnitsOutstanding | This field displays the number of units outstanding (yet to be filled) on the given unit purchase order. |
| UnitsReceived | This field displays the number of units received already on the given unit purchase order. |
| WebAddress | This field displays the web address for the primary contact at the supplier associated with the given unit purchase order. |
| WorkPhone | This field displays the work phone for the primary contact at the supplier associated with the given unit purchase order. |