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.| 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 Extended | |
| Access to physical inventory extended detail information within Fusion | |
| 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. | |
| Preventive Maintenance | |
| Access all Preventive Maintenance information | |
| 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 | |