AI Data Catalog

Explore the business views used by the ACECloudify AI Assistant to understand user requests and generate Query Builder definitions. The assistant never accesses database tables directly. Instead, it works with a curated catalog of business views.

search

AI Query Engine

Semantic Query Orchestration layer that converts natural language requests into structured Query Definitions for controlled execution by the Query Builder engine.

Core Engine
schema

Query Definition Contract

Standard structure used by AI to communicate with Query Builder. Includes view selection, filters, metrics, grouping, sorting and limits.
contract semantic json ai-router
Validation Layer
gavel

Query Execution Rules

Rules that validate Query Definitions before execution. Ensures security, field-level access control, and safe aggregation.
security validation guardrails
Expression Engine
filter_alt

Query Operators

Standard set of filtering and comparison operators used in Query Definitions. Includes equals, contains, between, greater than, and time-based operators.
filters operators logic

Fundamental concepts used by the AI Assistant.

Core Specification
schema

Query Builder

Learn how Query Definitions are structured, including filters, sorting, grouping, aggregations and limits.
query schema
AI Rules
gavel

Query Rules

Rules that govern how the AI Assistant constructs valid query definitions.
validation security
Operators
filter_alt

Supported Operators

Review supported filtering operators such as Equal, Contains, Between and ThisMonth.
filters operators

Business Views

Curated views available to the ACECloudify AI Assistant.

Business View
receipt_long

SalesInvoiceView

Provides access to sales invoice data for reporting and customer analysis.
sales invoice
Business View
monitoring

OrderFinancialSummaryView

Unified order-level financial view for analyzing customer debt, payments, settlements, returns and real outstanding balances.
finance collections settlements AI-ready
Business View
inventory_2

OrderReturnSummaryView

Provides detailed product-level return data including return amounts, discounts, net refund value, customer information, sales and delivery agents, and financial reconciliation data for reverse logistics and return analysis.
returns refunds reverse-logistics finance
Business View
query_stats

OrderCollectionAnalyticsView

AI-ready financial analytics view for analyzing order payments, outstanding balances, payment speed, and receivable aging. Designed for cashflow tracking and customer payment behavior analysis.
collection cashflow aging finance
Business View
inventory_2

InventoryView

AI-ready inventory analytics view for analyzing real stock, reserved orders, in-transit goods, and available-to-sell quantity. All values are stored in unit level and can be converted to carton using QtyPackage.
inventory stock warehouse supply chain
Business View
group

CustAssignToSellerView

AI-ready relationship view that maps customers to their assigned sales representatives for coverage analysis and territory management.
customers salesforce territory assignment
Business View
route

SellerVisitPathCustomersView

AI-ready route planning view that defines which customers should be visited by each salesperson on scheduled dates.
visit-plan routing salesforce coverage
Business View
event_note

CustomerVisitLogsView

AI-ready execution log view for tracking actual customer visits by sales representatives, including visit duration, success/failure status, and order outcome per visit attempt. Each visit is recorded separately and multiple visits per customer per day are allowed.
visit-log execution salesforce activity
AI Analytics View
psychology

CustomerPotentialAnalyticsView

AI-driven customer intelligence view based on 90-day behavioral, financial, and purchase patterns. Used for customer scoring, segmentation, churn prediction, and sales targeting.
customer-intelligence scoring segmentation ai-analytics
Logistics View
local_shipping

DeliveryOperationAnalyticsView

AI-ready delivery lifecycle analytics view combining planning, execution, and logistics capacity. Includes order details, vehicle utilization, volume/weight metrics, and delivery performance tracking.
delivery logistics distribution capacity

AI Examples

Real-world examples of how user requests become Query Definitions.

Examples
psychology

AI Query Examples

Explore practical examples showing how the assistant interprets user requests.
examples prompts query
```