Those who utilize SAP Crystal Reports or Excel Queries may need to access information from the Acctivate Database. This KB outlines commonly accessed Database Views for Product information.
All bulleted points are the exact Database View names. It's recommend to use Views (rather than Tables) to access this information.
Acctivate uses a 3rd party report software, Crystal Reports, to display all reports, forms, labels, and barcodes in the program. Crystal Reports in Acctivate is only available as a read-only form. To make report changes or customizations, there are a few options listed here. However, if you decide to use Crystal Reports to modify or design your own reports, please review our resources here.
- Product
- Product header information (highlighted in Red). This view contains most Product header information such as ProductID, Description, UPC, Alt Product ID, Item Type, Product Type, Product Class, Sales Category, Stocking Unit, Sales Unit, Purchasing Unit, Packaging Unit, and more.
- Product header information (highlighted in Red). This view contains most Product header information such as ProductID, Description, UPC, Alt Product ID, Item Type, Product Type, Product Class, Sales Category, Stocking Unit, Sales Unit, Purchasing Unit, Packaging Unit, and more.
- ProductAlt
- The Alt IDs tab in Product window (highlighted in Green). This view contains all Alt IDs configured for Products and their Type, i.e., Alt Product ID, UPC, and Web Store.
- ProductAlt can join to Product on Product.GUIDProduct/ProductAlt.GUIDProduct.
- ProductComponent
- The Components tab in the Product window (highlighted in Yellow). This view contains all components for a Kit or Assembly product, including Quantity, Warehouse, and whether or not if the component is Variable.
- ProductComponent can join to Product on Product.GUIDProduct/ProductComponent.GUIDProduct and Product.GUIDProduct/ProductComponent.GUIDProductComponent
- For Warehouse information, ProductComponent can join to ProductWarehouseSummary on ProductWarehouseSummary.GUIDWarehouse/ProductComponent.GUIDComponentWarehouse
- ProductSupplier
- The Vendors tab in the Product window (highlighted in Blue). This view contains all Product specific information per Vendor, including Preferred ID, Vendor Product ID, Lead Time, Price, Unit, Last PO Price, and more.
- ProductSupplier can join to Product on Product.GUIDProduct/ProductSupplier.GUIDProduct
- For Vendor information, ProductSupplier can join to ProductSupplier.GUIDVendor/Vendor.GUIDVendor
