|
This data object is used to show a list of parts and miscellaneous charges from invoiced parts orders, repair orders, or 3rd party converted data for a customer.
This information is from the Customer Purchases/Returns program within the Fusion business system.
URL
/frw/CustomerPurchasesandReturns
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the record was added. |
| AddUser | This field displays the user name that added the record. |
| AverageCost | This field displays the average cost of the given item at the time the item was purchased. |
| Branch | This field displays the branch associated with the purchase. |
| CompanyName | This field displays the company name of the customer associated with the purchase/return. |
| IsCore | This field displays whether or not the given detail item is a core. |
| Customer | This field displays the customer attached to an invoiced sale. |
| Department | This field displays the department associated with the given order. |
| Division | This field displays the company division in which the given order was created. |
| ExtendedPrice | This field shows the extended price of the given detail item. |
| InvoiceDate | This field displays the date on which the order was invoiced. |
| InvoiceNumber | This field displays the invoice number of the given invoice. |
| ItemNumber | This field displays the identifying name of the given detail item (part number for parts, charge name for miscellaneous charges). |
| ItemDescription | This field displays the description of the given detail item. |
| ItemType | This field displays the type of the given item. (Part for Parts, EXC for Exchange parts, RET for Return Cores, INH for Inherent Cores, and Misc for Miscelaneous charges). |
| LastUpdate | This field displays the date on which the item was last updated on the order. |
| UpdateUser | This field displays the user name of the individual who made the update. |
| IsMiscCharge | This field displays whether or not the given detail item is a miscellaneous charge. |
| MiscellaneousCharge | This field displays the name of the given miscellaneous charge. |
| MiscellaneousChargeDescription | This field displays the description of the given miscellaneous charge. |
| OrderType | This field displays what type of order the part was sold on or Converted Data if the record was converted in to the system. |
| PartDescription | For parts, this field will display the description of the part. |
| PartNumber | For parts, this field will display the part number of the part. |
| PartsOrderActionType | This field displays the Action Type associated with the part sale and will only by populated for part records that were not converted into the system from another source. |
| Price | This field displays the selling price of the given item. |
| CustomerPurchaseOrder | This field displays the purchase order number associated with the given order. |
| Quantity | This field displays the quantity purchased for the given item. |
| IsQCInvoiceNumber | This field displays if the parts invoice was created via Quick Credit. |
| IsRepairOrder | This field displays whether or not the given detail item is from a repair order. |
| ReplacementCost | This field displays the replacement cost of the givem item at the time the item was purchased. |
| Supplier | This field displays the supplier of the given item. |
| IsVoided | This field displays whether or not the given order has been voided. |