|
This data object is used to return all MPO detail information from the Fusion business system.
This is found within the Accounting Miscellaneous Purchase Order program within the Fusion business system.
URL
/frw/MiscPODetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the Misc PO detail item was added. |
| AddUser | This field displays the user name that added the record. |
| BillableType | This field displays if the MPO is of Type Billable or Non-Billable. |
| BillingDate | This field displays the date on which a miscellaneous purchase order was billed. |
| BillingReference | This field displays the branch, department, and parts or repair order number that the miscellaneous purchase order references. |
| BillingStatus | This field displays the billing status of a miscellaneous purchase order. |
| Branch | This field displays the branch associated with the Misc PO detail item. |
| CustomerKey | This field displays the key for a customer associated with AR detail. |
| Department | This field displays the department associated with a Misc PO. |
| IsDetailItem | This field displays whether the Detail Item checkbox in Miscellaneous Purchase Order is checked, which indicates whether the item must be referenced individually when billed to a Parts Order or Repair Order. |
| ExtendedPrice | This field displays the extended price (price * quantity) of the detail item on the miscellaneous purchase order. |
| ItemCostDifference | This field displays the difference between the cost of the item entered on a miscellaneous purchase order and the cost of the item entered on a parts or repair order. |
| ItemExtCostDifference | This field displays the difference between the extended cost of an item on the miscellaneous purchase order and the extended cost of that item on the parts or repair order. |
| ItemType | This field displays the type of item on a miscellaneous purchase order. |
| LastUpdate | This field displays the date on which an A/P invoice was last updated. |
| UpdateUser | This field displays the user name of the individual who made the update. |
| MPODate | This field displays the date on which a miscellaneous purchase order was created. |
| MPOItemSequence | This field displays the line number of the detail item on the miscellaneous purchase order. |
| MPOType | This field displays the type of a miscellaneous purchase order. |
| OrderCost | This field displays the cost of a given order. |
| OrderExtCost | This field displays the extended cost of an order. |
| OrderExtPrice | This field displays the extended price of a given order. |
| OrderNumber | This field displays the order number for a miscellaneous purchase order. |
| OrderPrice | This field displays the price of a given order. |
| OrderQuantity | This field displays the quantity ordered on a miscellaneous purchase order. |
| OrderStatus | This field displays the status of an order on a miscellaneous purchase order. |
| PartDescription | This field displays the description of a part on a miscellaneous purchase order. |
| PartNumber | This field displays the part number of a part on a miscellaneous purchase order. |
| PartPrice | This field displays the price of the given detail item on the miscellaneous purchase order, at the time it was purchased. |
| PartVendor | This field displays the vendor for a given part. |
| POCode | This field displays the PO code attached to an item on a mischellaneous purchase order. |
| POCodeDescription | This field displays the description of a PO code attached to an item on a miscellaneous purchase order. |
| PostDate | This field displays the date on which appreciation was posted for a fixed asset. |
| Quantity | This field displays the quantity requested for a given item. |
| Supplier | This field displays the supplier of an item on a miscellaneous purchase order. |
| TotalCostDifference | This field displays the difference between the total cost for all items on the miscellaneous purchase order and the total cost for all items on the miscellaneous purchase order that have been referenced to the parts or repair order. |
| UnitOfMeasure | This field displays the unit of measure for a given item. |
| VendorName | This field displays the AP vendor name the MPO is for. |
Accounting Misc PO Header
This data object is used to return all MPO header information from the Fusion business system.
This is found within the Accounting Miscellaneous Purchase Order program within the Fusion business system.
URL
/frw/MiscPOHeader
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the Misc PO was added. |
| APVendor | This field displays the A/P vendor. |
| IsBillable | This field displays yes, if the MPO is considered billable and no if it considered non-billable. |
| BillableType | This field displays if the MPO is of Type Billable or Non-Billable. |
| BillingAmount | This field displays the total price the customer was billed for the items on the MPO. |
| BillingCost | This field displays the total cost of the items on the MPO the customer was billed for. |
| BillingDate | This field displays the date on which a miscellaneous purchase order was billed. |
| BillingInvoiceNumber | This field displays the invoice number of the order the MPO is associated with. |
| CreatedBy | This field displays the user who created the MPO. |
| LastUpdate | This field displays the date on which an A/P invoice was last updated. |
| IsManuallyReferenced | This field displays whether or not the given MPO number has been marked as Manually Referenced for accounting purposes. |
| MPODate | This field displays the date on which a miscellaneous purchase order was created. |
| MPOIsFor | This field displays the purchase summary of the MPO. |
| MPOSequence | This field displays the extension number of the MPO. |
| OrderNumber | This field displays the order number for a miscellaneous purchase order. |
| PONumber | This field displays the PO number assigned to the given MPO. |
| ShipInstructions1 | This field displays Shipping Instructions line 1 of the MPO found on the shipping instructions tab. |
| ShipInstructions2 | This field displays Shipping Instructions line 2 of the MPO found on the shipping instructions tab. |
| ToName | If the MPO is non-billable, this field displays the branch name. If the MPO is billable, this field displays the customer key the MPO is billable to. |
| Total | This field displays the total amount the MPO is for. |
| TotalValue | This field displays the total extended price of the MPO detail items less the Billing Cost of the MPO. |