This data object is used to show all parts that are backordered on a parts order or repair order.

This information can be found in the Parts Order and Repair Order programs within the Fusion business system.

URL

/frw/PartsBackOrders

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the back order was created.
AddUser This field displays the user name that added the record.
Street1 This field displays line one of the street address for the customer.
Street2 This field displays line two of the street address for the customer.
APVendor This field displays the A/P vendor.
APVendorName This field displays the name of an  Accounts Payable vendor associated with a customer core right to return.
BackorderAging This field displays the aging category the part falls into based on the Add Date of the part to the order.
BackorderDate This field displays the date on which a part was backordered.
BackorderPriority This field displays the backorder priority flag assigned to the parts.
Quantity This field displays the quantity requested for a given item.
Status This field displays the status of a given backorder.
BranchCode This field displays the branch that requested the order.
City This field displays Bill-To city of the customer the back order is associated with.
CoreDescription This field displays the description of a core associated with a part.
CorePartNumber This field displays the number attached to a core part.
CorePrice This field displays the price of the inherent core.
CoreSupplierCode This field displays the code attached to a supplier for a core part.
CustomerKey This field displays the customer identification number.
CompanyName This field displays the company name of the customer associated with the back order.
DaysOld This field displays the age of a given back ordered part, expressed in number of days.
Department This field displays the department that requested the part.
Description This field displays the description of a given part.
DetailDeliveryDate This field displays the expected delivery date of the given back ordered part.
FromBranch This field displays the filling branch of the given back ordered part.
InsideSalesperson This field displays the inside salesperson attached to a backorder.
DirectShip This field displays whether or not an item will be a direct ship to a given location.
LastUpdate This field displays the date on which the backorder was last updated.
UpdateUser This field displays the user name of the individual who made the update.
OrderingDepartment This field displays the module, parts or service, that ordered the part.
NoCharge This field displays whether or not the part was sold as no charge to the customer on a parts or repair order invoice.
OriginalCorePrice This field displays the original price of the part.
OriginalPrice This field displays the original price of the inherent core.
Salesperson This field displays the salesperson attached to a customer.
PartNumber This field displays the part number of the part being backordered.
PartTypeDescription This field displays the description of a part type for a backordered part.
ShipComplete This field displays whether or not the given backorderd part can be partially filled or not.
SalesOrderNumber This field displays the number attached to a sales order.
PostalCode This field displays the customer’s postal code.
Price This field displays the price the customer was charged for the part.
PONumber This field displays the Parts Purchase Order Number.
PurchaseOrderStatus This field displays the order status of the backorder.
QuantityAvailable 0
Region This field displays the customer’s region or state.
RepairOrderNumber This field displays the number attached to a repair order.
CustomerPONumber This field displays the Customer’s purchase order number.
SupplierCode This field displays the code attached to a supplier for a part.
TaskNumber This field displays the number attached to a given task.