P4 Collection
P4 Warehouse English
P4 Warehouse English
  • P4 Warehouse Change Log
  • Getting Started Quick Setup
    • Overview
    • FAQ
    • Supply Chain Glossary
    • Create a Warehouse
      • Edit Warehouse
      • Add Zone & Bins
    • Create Users
    • Create a Product
    • Create Provider
    • Create Customer
    • Setup Printers
  • Web Documentation
  • Setup
    • Active Mobile Devices
    • Tenant Configuration
    • System - Configuration
      • Cycle Count
      • Products
      • Communication
      • Calendar View
      • License Plates - LPN
      • Three PL -3PL
      • Reason Codes
      • Fulfillment
        • Releasing
        • Data Entry
        • Shipping Setup
          • Truck Load
            • Email
          • Master Truck Load
            • Operations
            • Email
          • Packslip Configuration
          • Small Parcel Setup
          • Private Fleet Setup
            • Email Notification
          • Small Parcel
            • Email Notification
        • Closing
          • Email Notification
          • Backorders
        • Automation
        • Allocation
        • Waving
        • Document Printing
      • Receiving
        • Document Printing
        • Email Notification
        • Automation
        • Handhelds
        • Operations
        • Data Entry
      • Calendar
      • Reason Codes
    • Products
      • Product Audit
      • Decimal controlled
      • BOM- Bill of Materials
      • Serial Control
      • Lot Control
      • Expiry Product
      • Packsize
      • Product Bundles
    • System Logs
    • System– Audit
    • Query Builder
    • Custom Actions
    • Warehouse
      • Warehouses
      • Zones
      • Bins
      • Dock Doors
    • Translations
    • Reports & KPI
      • Database backups
      • Report Creation
      • KPI Creation
  • Permissions- Users
    • Permission Profiles
    • Add Users
    • User Sessions
  • Printing & Labels
    • Printers
      • Print Queue
      • Print Agent
      • Printer Setup
    • Labels
      • Templates
      • Label Design
  • Fulfillment
    • Fulfillment Operational Setup
      • Customer
      • Cartonization Profiles
      • Carton Sizes
      • Carriers
    • Pick Ticket Creation
      • Back Order
    • Allocation
    • Waving
    • Totes
    • Grouping
    • Truck Load
    • Master Truck Load
    • Totes
    • Shipping
    • Delivery
    • Staging
  • Purchasing
    • Vendors
    • Receiving Calendar
    • Open Purchase Orders
    • Closed Purchase Orders
    • LPN Receiving
  • Production
    • Production Workflow
    • Open Work Orders
    • Closed Work Orders
  • Returns - RMA
    • Open Returns
    • Closed Returns
  • 3rd Party Logistics
    • 3PL Billing Profiles
    • 3PL Clients
    • 3PL Client Invoicing
  • Collaboration
    • Task
    • Cycle Count Approval
  • Analytics - Reporting
    • Reports
      • Create Reports
    • KPI
      • Create KPI
  • Mobile Device Documentation
    • Information for Android Mobile
  • Receiving
    • General Receiving Information
    • PO List
    • PO Receiving
    • PO Photo
    • Product Barcode
    • Un-Receive PO
    • Non-PO Receiving
  • Fulfillment
    • Picking
      • Pick List
      • Pick Ticket Picking
      • Wave Picking
      • Full Pack Picking
      • Carton Picking
    • Staging
      • Tote Merge
      • Tote Counting
      • Print Content Label
      • Un-Picking
      • Tote Move
      • Re-Packing
    • Shipping Pick Tickets
      • Tote / Pallet to Stage
      • Tote to Dock
      • Ship
      • Photo
      • Deliver
      • Pallet / Carton Dimensions
    • Shipping Truck Loads
      • Tote to Dock
      • Ship
      • Photo
  • RMA
    • Returns Process
      • RMA List
      • RMA Receiving
      • Photo
      • Non RMA Receiving
      • Un-Receive RMA
  • Production
    • Production Process
      • Work Order List
      • Picking
      • Production
  • Adjustments
    • Adjustments Process
      • Vendor Return
      • Adjust in
      • Adjust in by Bin
      • Adjust out
      • Adjust out by bin
  • Miscellaneous
    • Pallet Dimensions
    • Inventory
      • Packsize Convert
      • Product Move
      • Full Bin Move
      • Bin Contents
      • Packsize Breakdown
      • Substitute Convert
    • Bulk - LPN
      • LPN Letdown by Bin
      • LPN Letdown by Sku
      • Product Letdown by Bin
      • Product Letdown by Sku
      • LPN Move
    • Cycle Count
      • Cycle Count by Bin
      • Cycle Count by Product
      • Cycle Count by Assignment
    • Product Data
      • Product Dimensions
      • Product Photo
      • Product Location
  • Collaboration
    • Task Assignments
    • Messaging - Chat
  • Contact Us
    • Support
      • Costa Rica
      • USA
      • Peru
      • Panamá
      • Mexico
      • Ecuador
  • REST API
    • P4Warehouse REST API
    • Product Master
      • Create new product
      • Update or edit existing products
      • Retrieve a list of products
      • Delete Product
    • Vendor Master
      • Create new vendor
      • Update or edit existing vendors
      • Retrieve a list of vendors
Powered by GitBook
On this page
  1. Setup

Query Builder

P4 Warehouse Query Builder

Last updated 2 years ago

Query the database to see data or create reports by typing in TSQL and clicking execute.

Results from the query can be exported to excel format.

In this screen P4 Warehouse will only accept "select" commands, you cannot update or delete data from this screen.

P4 Warehouse Query Builder