Report Data Access Documentation

The Data Access API suite exposes self-service reporting views via Unity APIs. These documentation files will provide the parameters to access and use the Unity system to access reporting information successfully.
  1. Data Access via API - How to access and format the request
  2. Data Access — A How-To Guide - A step-by-step walkthrough of using the unity system
  3. Data Field Properties - Data reference documentation for fields, field types, and size


AP Misc PO Header and Detail
Access and view all Miscellaneous Purchase Order information within Fusion
AP Notes
Access all detail information, return unit and control numbers for all payable notes within the system
AP Vendor
Access all accounts payable vendor information from the Fusion business system
Account Allocation
Display the allocation tables specified in Fusion, along with the allocation breakdown for each by Branch/Department and the list of breakdown accounts specified in the setup form of the Allocation Table
Accounting Address Information
Access all addresses stored within the Fusion business system
Accounting Comments
Access the comments from the Comments Tabs located on multiple forms within Fusion
Accounting Period
Allow the user to query the status of an accounting posting period.
Accounts Payable Detail
Access to all accounts payable invoice information.
Accounts Payable General Ledger Detail
Access to all general ledger detail of accounts payable invoices.
Accounts Receivable Customer
Access to all customer information within the Customer program
Accounts Receivable Customer Misc Prompt
Access to all customer information within the Customer program
Accounts Receivable Details
Access the detail information for all open (unpaid balance) accounts receivable invoices, unvoided, voided, or reopened, along with all unapplied payments.
Branch Details (Helper)
Allow the user to query branch details
Branch and Department (Helper)
Allow the user to query branch and department details
Chart of Accounts
Display a listing of all general ledger chart of accounts and their sub category structure down to 6 levels.
Check Register
Return all checks that have been issued in the Fusion Business System
Deal Comission
Access the commission information by salesperson and stock number for a given deal packet invoice.
Deal Detail
Access all detail items on all unit sales deals.
Deal Header
Access all local purchase orders and their associated unit information
Deal Packet
Access all local purchase orders and their associated unit information
Department Lookup (Helper)
Allow the user to query department by branch
Fixed Assets
Display all fixed asset file information from the Fusion business system
Fuel Invoice Summary
Access to display all fuel invoices
General Ledger Balance
Display the current year, the previous 2 years and next 2 years for a max total of 5 years of data.
General Ledger Transaction
Display all GL detail transactions in the Fusion business system.
Invoice Sales Summary
Displays the summarys of all invoices and/or orders, parts orders, invoices, deals, contracts.
Invoice Sales Summary Detail
Ddisplays the detail items on all invoiced and/or voided repair orders, parts orders, LR contracts, finance charges, deals, fuel invoices, and adjustment invoices.
Lease - Rental Contract
Access all customer insurance information from the Fusion business system
Lease - Rental Contract Unit
Access all information from a unit on a lease or rental contract from within the Fusion business system
Lease - Rental Customer Rate Detail
Detail information for lease rental rate overrides that have been setup in the Fusion business system
Lease - Rental Customer Rate Header
Header information for lease rental rate overrides that have been setup in the Fusion business system
Lease - Rental Permit and License
Permit and license information for each of the lease rental permits or licenses in the DMS
Lease - Rental Units
Access all all lease or rental unit information
Lease Rental Billing Group
Display the name and billing information for each of the lease rental billing groups in the Fusion business system
Lease Rental Billing History
Display the overall totals and information about a given LR invoice.
Lease Rental Billing History Detail
Display the detail for all charges associated with a given unit on an LR invoice from the Fusion business system
Lease Rental Charges
Access to lease rental charge information from the Fusion business system
Lease Rental Contract Unit Charge
Access to return charges attached to lease, rental, or maintenance contracts. 
Lease Rental Customer Insurance
Access all customer insurance information from the Fusion business system.
Lease Rental Driver Info
Displays the Driver information as seen in the Driver Information application in Fusion.
Lease Rental Unit Billing History
Access the lease rental billing history information for each unit on a given LR invoice from the Fusion business system
Local Purchase Order
Access all local purchase orders and their associated unit information
Parts Alternate Bin Locations
Displays the alternate bin associated with a part record, if one exists.
Parts Branch Inventory Usage
Display usage of a given parts inventory detail record
Parts Committed
Display all parts that have been committed on parts order, repair orders, and inter-branch orders
Parts Customer Backorders
Display all parts that are backordered on a parts order or repair order
Parts Customer Core Right To Return
Customer Core Right to Return program within the Fusion business system
Parts Customer Purchase and Return
Access a list of parts and miscellaneous charges from invoiced parts orders, repair orders, or 3rd party converted data for a customer.
Parts Fuel Ticket and Detail
Access to display fuel ticket summary information for open and invoiced fuel tickets, as well as fuel tickets that are included on LR Contract invoices.
Parts Inventory
Access to a concise view of all branch specific parts inventory records
Parts Inventory Receiving Detail
Provides detailed information related to parts received against a purchase order.
Parts Inventory Usage
Access to usage of a given parts inventory detail record.
Parts Inventory Yearly Usage
Access to display parts inventory picks and sales by month for each year in which the given part has had picks or sales.
Parts Kit Assembly Detail
Access to various Parts related endpoints
Parts Lost Sales
Display all parts lost sale records in the Fusion business system
Parts Messages
Display a list of all parts messages set up
Parts Order
Access to Parts Order within Fusion
Parts Order Detail
Access to all of the detail records on open, invoiced, and/or voided parts orders.
Parts Physical Inventory
Access to physical inventory available within the Fusion system
Parts Physical Inventory Detail
Access to physical inventory detail information within Fusion
Parts Purchase Order
Access to Purchase Order within Fusion
Parts Purchase Order Detail
Access to Purchase Order Detail within Fusion
Parts Supplier
Access all suppliers that are set up within the Fusion business system
Parts Supplier Core RTR
Display all supplier core right to return records
Parts Transactions
Display all parts transaction records from the Fusion business system
Parts Vendor Rebates
Display all vendor rebate information
Posting Reference Status
Allow the user to query the status of a posting reference, including whether or not the P/O has been received, if it has been referenced on an A/P invoice, and if the A/P Invoice has been posted.
Quick Lists (Helper)
Allow the user to pull back Quick List options from Fusion
Repair Order Detail
Access all detail information about Open and Invoiced Repair Orders.
Repair Order Header
Access all information about Open and Invoiced Repair Orders. This includes the header, task, part, labor, and miscellaneous charge detail items on a given repair order
Repair Order Task
Access to show all repair order task information
Sales Unit
Access to all sales unit records and their characteristics
Sales Unit Flooring
Access to the unit flooring information for a given unit occurrence from the Fusion business system.
Salesperson Commission
Access to the parts and service salesperson commission records
Service
Used to display a list of all deferred repairs from the Fusion business system
Service Technician
Access to view all service technician information
Service Technician Certification
Access to view all technician certificate information
Service Technician Performance
Access to display technician performance by repair group.
Service Technician Productivity
Access to view how productive a technician has been, summarized by month.
Service Technician Time
Access to display all completed technician time records
Service Unit Components
Access to all Unit Component information for a given unit.
Service Unit Master Detail
Access to all unit master detail information.
Service Unit Owning Customer
Access to the owning customer(s) of all Service units
Unit Purchase Order Detail
Access to the unit information detail on unit purchase orders
Unit Purchase Order Header
Access to the header information on unit purchase orders. Join to Unit Purchase Order Detail to view the detail level information.
Velocity Codes
Allow the user to pull back Velocity Codes, to be used in support of the Customer Special Pricing API
View Users
Access to view all users by Branch