This data object is used to display all parts order header records.

This information is located within the Parts Order program in the Fusion business system.

URL

/frw/PartsOrder

Field Details…

SQL Field Name Column Description
AddUser This field displays the username of the user who added the given parts order to Fusion or, for invoiced parts orders, displays the username of the user who added the original parts order, pre-invoicing, to Fusion. Note that at this point this field is not exposed in Fusion.
AverageCost This field displays the total average cost of the given parts order.
AverageCostGrossProfit This field displays the gross profit of the given parts order based on average cost.
AverageCostGrossProfitMargin This field displays the gross profit margin of the given parts order based on average cost.
BillingCompanyName This field displays the name of a billing company for a parts order.
BillingContactName This field displays the contact name for a billing customer.
BillingCustomerAccountStatus This field displays the status of an account for a billing customer.
BillingCustomerNumber This field displays the Customer Number of a billing customer for a parts order.
BillingHomePhone This field displays the billing customer’s home phone number.
BillingWorkPhone This field displays the billing customer’s work phone number.
Branch This field displays the branch associated with the parts order.
CanadianTaxID This field displays the Canadian tax ID listed on the customer form or entered at the time of invoicing.
CompanyName This field displays the company name associated with the customer on the parts order.
ContactHomePhone This field displays the contact’s home phone number.
ContactName This field displays the contact’s name.
ContactWorkPhone This field displays the contact’s work phone number.
CreationDate This field displays the date on which a parts order was created.
CustomerAccountStatus This field displays the status of a customer account for a parts order.
CustomerNumber This field displays the identifying number attached to a customer.
CustomerPO This field displays the customer purchase order associated with an invoiced sale.
DeliveryDate This field displays the delivery date assigned to the given parts order.
Department This field displays the department associated with a parts order.
Division This field displays the company division associated with the given parts order.
InvoiceDate This field displays the invoice date of the given parts order.
InvoiceNumber If present, this field displays the invoice number of the parts order.
InvoiceUser This field displays the username of the user who invoiced or voided the given invoiced or voided parts order.
ItemsReadyforPickup This field displays whether or not items on a parts order are ready for pickup.
LastUpdate This field displays the date the parts order Header was last updated.  Note, at this point in time this field is not exposed in Fusion.
UpdateUser This field displays the username of the user who last updated the header of the given parts order or, for invoiced parts orders, displays the username of the user who last updated the given invoice. Note that at this point this field is not exposed in Fusion.
IsLocal This field displays whether or not a given parts order is local.
LPO This field displays the local purchase order number tied to the parts order if one exists.
OrderStatus This field displays the status of an order on a miscellaneous purchase order.
OrderSubtotal This field displays the order total not including tax.
OrderTotal This field displays the total amount for a parts order.
OutsidePartsSalesperson This field displays the outside parts salesperson attached to a given parts order.
PartsAccounting This field displays the alternate parts accounting if any has been selected.
PartsOrderNumber This field displays the number attached to a given parts order.
PaymentMethod This field displays the payment method of the given parts order.
PickupDeliveryMethod This field displays how a parts order will reach the customer.
QuebecTaxID This field displays the Quebec tax ID listed on the customer form or entered at the time of invoicing.
ReplacementCost This field displays the total replacement cost of the given parts order.
ReplacementCostGrossProfit This field displays the gross profit of the given parts order based on replacement cost.
ReplacementCostGrossProfitMargin This field displays the gross profit margin of the given parts order based on replacement cost.
SalesTaxTotal This field displays the total amount of sales tax charged for a parts order.
SalesTerritory This field displays the sales territory associated with a part order.
ShipToAddress1 This field displays line one of the customer’s shipping address, found on the address entry tab of parts order.
ShipToAddress2 This field displays line two of the customer’s shipping address, found on the address entry tab of parts order.
ShipToCity This field displays the customer’s shipping city, found on the address entry tab of parts order.
ShipToCustomerName This field displays the ship-to company name, found on the address entry tab of parts order.
ShipToEmail This field displays the ship-to email address, found on the address entry tab of parts order.
ShipToFax This field displays the ship-to fax number, found on the address entry tab of parts order.
ShipToOfficePhone This field displays the ship-to office phone number, found on the address entry tab of parts order.
ShipToPostalCode This field displays the customer’s shipping postal code, found on the address entry tab of parts order.
ShipToRegion This field displays the customer’s shipping region, found on the address entry tab of parts order.
ShipToShopPhone This field displays the ship-to shop phone, found on the address entry tab of parts order.
Source This field displays the source from which the given parts order originated.  Valid sources are: Parts Counter, Business Online, WHI, Channel Advisor, EDI, and DTNA.
TaxBody This field displays the tax body associated with a customer address.
TaxCode This field displays the tax code assigned to a customer.
Territory This field displays the territory field found on the billing customer tab of the parts order.
TrackingNumber This field displays the tracking number entered in the Tracking Number field in the header of the parts order.
IsVoided This field display wether the the given parts order has been voided or not.