|
Parts Order Detail
This data object is used to display all of the detail records on open, invoiced, and/or voided parts orders.
This information is located in the Parts Order application in the Fusion business system.
URL
/frw/PartsOrderDetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given part was added to the parts order. |
| AddUser | This field displays the username of the user who added the given parts order detail item to the parts order. |
| AverageCost | This field displays the average cost of the given part. |
| BackOrderPriority | This field displays the priority flag assigned to the given part on backorder when it was added to the parts order. |
| IsBackorder | This field displays whether the given part was backordered. |
| BinLocation | This field displays the Bin Location that the user selected when adding the part to the parts order, it will defualt to the part’s primary bin location. |
| Branch | This field displays the branch in which the parts order was created. |
| CalculatedPrice | This field displays the price of the given detail item before override price is taken into consideration. |
| CreationDate | This field displays the date on which the parts order that the given detail item is attached to was created. |
| DeliveryDate | This field displays the date on which the given part was picked up by or delivered to the customer. |
| Department | This field displays the department in which the parts order was created. |
| DetailPartMessage | This field displays the message associated with the given part detail item. |
| Division | This field displays the division in which the parts order was created. |
| ExtendedAverageCost | This field displays the extended average cost (average cost * quantity) of the given part. |
| ExtendedPrice | This field displays the extended price (price * quantity) of the given part. |
| ExtendedReplacementCost | This field displays the extended replacement cost (replacement cost * quantity) of the given part. |
| ExtendedSellingCost | This field displays the extended selling cost (selling cost * quantity) of the given part. |
| InsidePartsSalesperson | This field displays the inside parts salesperson that sold the given parts order detail record. |
| InvoiceDate | This field displays the date on which the given parts order was invoiced. |
| InvoiceNumber | This field displays the invoice number of the given invoiced parts order. |
| ItemDescription | This field displays the description of the given parts order detail item. |
| PartNumber | This field displays the part number of the given part on the parts order. |
| ItemType | This field displays the item type (Part for all parts, MISC for a miscellaneous charge, or EHC for an environmental handling charge) of the given detail item. |
| LastUpdateDate | This field displays the date on which the given parts order detail item was last updated. |
| LastUpdateUser | This field displays the username of the user who last updated the given parts order detail item on the parts order. |
| Local | This field displays whether the parts order should have the local sales tax applied to it. |
| MPOReference | This field displays the miscellaneous purchase order referenced to the given parts order, if one exists. |
| IsNoChargeTransaction | This field displays whether the given part was sold at no charge to the customer on the given invoice. |
| OEMPrice | This field displays the customer’s selling price of the part that was received from the OEM in a price verification. |
| OEMRebateAmount | This field displays the rebate amount received from the OEM in a price verification that the cost of the transaction can be reduced by. |
| OrderStatus | This field displays the status of the parts order that the given detail item is attached to. |
| OutsidePartsSalesperson | This field displays the outside parts salesperson associated with the customer on the given parts order. |
| OverridePrice | This field displays the override price entered for the given detail item when it was added to the parts order. |
| PartType | This field displays the type (Part, Core, or Exchange) of the given part. |
| IsPartialFill | This field displays whether the given parts order was partially filled. |
| PartsAccounting | This field displays the parts accounting code associated with the given parts order invoice. |
| PartsActionType | This field displays the action type (sale, sale - force fill, sale - no usage update) chosen when the part was added to the parts order. |
| PartsOrderNumber | This field displays the parts order number that the given detail item is attached to. |
| PickupDeliveryMethod | This field displays either the delivery method by which the part will be delivered to the customer or that the customer will pick it up. |
| IsPOSAssembly | This field will identify if the give record is a point of sale assembly. |
| Price | This field displays the price at which the given detail item was sold (Override Price if there is one, Calculated Price if not). |
| PriceOverrideReason | This field displays the price override reason associated with the given part. |
| Quantity | This field displays the quantity of the given part requested on the parts order. |
| ReadyForPickup | This field displays whether the given detail item(s) on a parts order is(are) ready to be picked up. |
| ReplacementCost | This field displays the replacement cost of the given part. |
| ReturnReason | This field displays the reason supplied as to why the given part was returned by the customer. |
| SellingCost | This field displays the cost of the given part sold on the parts order, based on either average cost or replacement cost, depending on the enterprise setting. |
| Supplier | This field displays the supplier of the given part detail record. |
| UnitOfMeasure | This field displays the units in which the given part is sold. |