Views
This section provides a quick reference index of all available Xorosoft Reporting Server database views, along with a one-line functional description of each view. Detailed column-level definitions for every view are available in the Views Schema tab.
Description
This document will provide a comprehensive description of the View(s) used for reporting
View Name
Description
This view provides the inventory summary
This view displays details of application comments, including the comment text, type, and related records.
This view provides detailed information for the Advance Shipment Notice (ASN) item lines
This view provides header-level information for Advance Shipment Notices
This view provides line-level details for bank deposits, including payment references and amounts.
This view provides header information for bank deposits, such as the deposit number, date, and customer.
This view provides line-level item or expense details for vendor bills
This view provides detailed information for bill expense lines
This view provides header-level information for vendor bills, including vendor, date, and totals.
This view provides header information for Bill of Materials (BOM).
This view provides component-level details for Bill of Materials items.
This view provides line-level item details for customer credit memos
This view provides header information for customer credit memos.
This view provides information on customer deposits, including amounts, dates, and linked transactions.
This view provides detailed customer master information.
This view provides detailed line information for cycle count tasks.
This view provides extended header-level information for cycle counts.
This view provides detailed inventory movement transactions by item and location.
This view provides inventory snapshot quantities for items at specific points in time.
This view provides header-level information for sales invoices
This view provides line-level item details for sales invoices
This view provides item pricing information in foreign and home currency
This view provides detailed item master information.
This view provides extended item master information, including additional attributes
This view provides header information for product-level item configurations.
This view provides reorder point and quantity information for items.
This view provides mapping details between items and their vendors.
This view provides allocation information for inventory quantities at each location.
This view provides detailed information about warehouse locations.
This view provides header-level information for Manufacturing Orders (MO).
This view provides component and finished-good line details for Manufacturing Orders.
This view provides ASN information related to Purchase Orders.
This view provides information about project classes and groupings.
This view provides line-level item or expense details for Purchase Orders (PO)
This view provides header-level information for Purchase Orders.
This view provides header-level information for item receipts.
This view provides line-level item details for Return Merchandise Authorizations (RMA)
This view provides header-level information for RMAs.
This view provides line-level item details for Sales Orders.
This view provides header-level information for Sales Orders.
This view provides financial transaction entries, including debits and credits.
This view provides details about application users.
This view provides expense-line details for vendor credit memos.
This view provides header-level information for vendor credit.
This view provides item-line details for vendor credit.
This view provides detailed vendor master information.
This view provides allocation-level information for wave picking details.
This view provides detailed information for wave-picking lines.
This view provides extended header information for wave processing, including status and warehouse.
Last updated
Was this helpful?