L
R
E
BomDataHandler
bom_processes
Get manufacturing processes for a BOM
e.g. processes for BOM 714-249101
L
·
E
BomDataHandler
bom_field_query
One named BOM attribute for an exact part number (not the full card)
e.g. What finishing is on 0010-99622-03A8S?
L
R
E
BomDataHandler
bom_details
Get details of a specific exact BOM part number
e.g. show BOM 714-249101
L
R
E
BomDataHandler
process_work_guide
View work guide images, documents, and operation instructions for a BOM/part number. Displays process images from bom_operation_work_guides table linked through bom_processes.
e.g. 0010-59563 work guide
L
·
E
BomDataHandler
bom_search
Search for BOMs matching a partial part number, then user picks one to see details
e.g. bom maa10
L
·
E
BomDataHandler
bom_components
Get child components of a BOM
e.g. components of BOM 714-249101
L
·
·
BomDataHandler
bom_structure
Get full BOM structure/hierarchy
e.g. BOM structure for 714-249101
L
·
·
BomDataHandler
bom_prices
Get pricing information for a BOM
e.g. price for BOM 714-249101
L
·
·
BomDataHandler
bom_resources
Get resources/suppliers for a BOM
e.g. suppliers for BOM 714-249101
L
·
E
BomDataHandler
bom_search_by_prefix
Search for BOMs where part number starts with a prefix
e.g. search bom partnumber start with 714
L
R
E
CustomerDataHandler
customer_details
Get details of a specific customer by ID or name
e.g. show customer 123
L
·
·
CustomerDataHandler
show_customer
Show customer information (generic request)
e.g. show the customer
L
·
·
CustomerDataHandler
customer_list
List all active customers
e.g. list all customers
L
·
·
CustomerDataHandler
customer_summary
Get summary statistics for a customer
e.g. customer summary for ABC Company
L
·
·
CustomerDataHandler
customer_sales_orders
Get all sales orders for a specific customer
e.g. show sales orders for customer ABC
L
·
·
CustomerDataHandler
customer_work_orders
Get all work orders for a specific customer
e.g. show work orders for customer ABC
L
·
·
CustomerDataHandler
customer_invoices
Get all invoices for a specific customer
e.g. show invoices for customer ABC
L
R
E
InvoiceDataHandler
cancelled_invoices_today
Get invoices cancelled today
e.g. cancelled invoices today
L
R
E
InvoiceDataHandler
cancelled_invoices_this_week
Get invoices cancelled this week
e.g. cancelled invoices this week
L
R
E
InvoiceDataHandler
cancelled_invoices_this_month
Get invoices cancelled this month
e.g. cancelled invoices this month
L
R
E
InvoiceDataHandler
cancelled_invoices_by_date
Get invoices cancelled on a specific date or between dates
e.g. cancelled invoices on 2025-12-01
L
R
E
InvoiceDataHandler
submitted_invoices_today
Get invoices successfully submitted to e-invoice portal (MyInvois) today. Shows invoices with valid e-invoice status (einvoice_status = 2) submitted today.
e.g. show list of invoice that success submit to e-invoice portal today
L
R
E
InvoiceDataHandler
submitted_invoices_this_week
Get invoices successfully submitted to e-invoice portal (MyInvois) this week.
e.g. invoices submitted to e-invoice this week
L
R
E
InvoiceDataHandler
submitted_invoices_this_month
Get invoices successfully submitted to e-invoice portal (MyInvois) this month.
e.g. invoices submitted to e-invoice this month
L
R
E
InvoiceDataHandler
submitted_invoices_by_date
Get invoices successfully submitted to e-invoice portal on a specific date, date range, or relative time period (last week, last month).
e.g. invoices submitted to e-invoice on 2025-12-01
L
R
E
InvoiceDataHandler
new_feature_1767088210
Get invoices successfully submitted to e-invoice portal (MyInvois). Supports flexible query patterns including "please provide", "can you show", and natural language requests for submitted invoice listings.
e.g. please provide a list of invoices that were successfully submitted to the e-invo...
L
R
E
InvoiceDataHandler
invoice_details
Get details of a specific invoice
e.g. show invoice 11250001
L
R
E
InvoiceDataHandler
last_invoice
Get the last (most recent) unapproved invoice with sales order
e.g. last invoice issued
L
R
E
InvoiceDataHandler
outstanding_invoices
Get unpaid or outstanding invoices
e.g. outstanding invoices
L
R
E
InvoiceDataHandler
overdue_invoices
Get overdue invoices past payment terms
e.g. overdue invoices
L
·
E
InvoiceDataHandler
latest_approved_invoice
Get the most recently approved invoice
e.g. latest approved invoice
L
·
E
InvoiceDataHandler
invoices_by_so
Get invoices for a specific sales order
e.g. invoices for SO 25010001
L
·
E
InvoiceDataHandler
invoices_by_customer
Get invoices for a specific customer
e.g. invoices for customer ABC
L
·
E
InvoiceDataHandler
invoices_summary_by_currency
Get invoice summary grouped by currency for a period
e.g. total invoices this month by currency
L
·
·
InvoiceDataHandler
unapproved_invoices
Get invoices waiting for approval
e.g. unapproved invoices
L
·
·
InvoiceDataHandler
unsubmitted_invoices
Get invoices not yet submitted
e.g. unsubmitted invoices
L
·
E
InvoiceDataHandler
einvoice_knowledge
Questions about e-invoice status codes and processes
e.g. what does e-invoice status 2 mean
L
R
E
PurchaseOrderDataHandler
purchase_order_details
Get details of a specific purchase order
e.g. show purchase order 25080011
L
R
E
PurchaseOrderDataHandler
open_purchase_orders
Get list of open purchase orders with optional date filtering
e.g. open purchase orders
L
R
E
PurchaseOrderDataHandler
cancelled_purchase_orders
Get cancelled purchase orders within a date range
e.g. list cancelled purchase orders this month
L
R
E
PurchaseOrderDataHandler
purchase_order_totals_by_currency
Get total purchase order values for a specific month separated by currency
e.g. total purchase order this month with value separated by currency
L
R
E
PurchaseOrderDataHandler
purchase_orders_related_to_entity
Get purchase orders linked to a work order or sales order through purchase requests
e.g. show related purchase orders
L
·
E
PurchaseOrderDataHandler
purchase_orders_pending_receipt
Get purchase orders waiting for goods receipt
e.g. POs pending receipt
L
·
E
PurchaseOrderDataHandler
purchase_orders_by_supplier
Get purchase orders for a specific supplier
e.g. purchase orders for supplier ABC
L
·
E
PurchaseOrderDataHandler
count_purchase_orders_by_supplier_and_date
Count purchase orders created for a specific supplier within a date range
e.g. how many PO created for supplier name TSK INVENT on this month
L
R
E
PurchaseOrderDataHandler
new_feature_1764147444
Get list of suppliers with outstanding balance from open/partial purchase orders
e.g. show all suppliers with outstanding balance
L
·
E
PurchaseOrderDataHandler
purchase_order_payment_terms_analysis
Analyze payment terms distribution across purchase orders for a specific supplier
e.g. show purchase order payment terms analysis for supplier TOYO ENGINEERING
L
·
·
PurchaseOrderDataHandler
unapproved_purchase_orders
Get purchase orders that are not yet approved
e.g. unapproved purchase orders
L
·
E
SalesOrderDataHandler
shipments_by_part
All SOCRD shipments for a part (confirmed and not)
e.g. shipment 714-082666-013AL6S
L
·
E
SalesOrderDataHandler
confirmed_shipments_by_part
Confirmed shipments for a part on SOCRD date, delivery evidence only
e.g. Confirmed shipment 714-082666-013AL6S
L
·
E
SalesOrderDataHandler
shipments_by_part_and_date
Alias of shipments_by_part (all SOCRD for a part)
e.g. shipment for 0042-71858-02A8S
L
·
E
—
shipments_by_customer
Customer shipment report on SOCRD requested_date with traveller current-process status
e.g. shipment customer celestica week 38
L
·
E
—
non_shipments_by_customer
Customer non-shipment report: same SOCRD match and week, excluding Delivered rows
e.g. non shipment celestica
L
R
E
SalesOrderDataHandler
shipments_by_date
Get shipments/deliveries due on a specific date, week, month, or date range
e.g. today shipment
L
R
E
SalesOrderDataHandler
fai_shipments_by_date
Get FAI (First Article Inspection) shipments/deliveries due on a specific date, week, month, or date range - only items with FAI status
e.g. fai today shipment
L
R
E
SalesOrderDataHandler
delayed_customer_deliveries
Get all delayed/overdue customer delivery request dates across all sales orders
e.g. delayed customer deliveries
L
·
E
SalesOrderDataHandler
socrd_horizon
Shipment & Delivery dashboard horizon: first/last customer request date (SOCRD), how many shipments and how many still pending per year, and to what year the schedule runs
e.g. to what year does socrd end
L
R
E
SalesOrderDataHandler
check_new_sales_orders
Check if any new sales orders have been created today/this week - ALL types including customer PO, management forecast, and extra orders
e.g. any new sales orders today
L
R
E
SalesOrderDataHandler
customer_pos_today
Get customer POs (purchase orders) registered/entered today - NOT management forecast or extra orders
e.g. customer POs today
L
R
E
SalesOrderDataHandler
customer_pos_this_week
Get customer POs (purchase orders) registered/entered this week - NOT management forecast or extra orders
e.g. customer POs this week
L
R
E
SalesOrderDataHandler
customer_pos_by_date
Get customer POs registered on a specific date, week number, or date range
e.g. customer POs on 2025-12-01
L
R
E
SalesOrderDataHandler
sales_order_details
Get details of a specific sales order
e.g. show sales order 25010001
L
R
E
SalesOrderDataHandler
open_sales_orders
Get list of open sales orders
e.g. open sales orders
L
R
E
SalesOrderDataHandler
outstanding_po_from_customer
Get outstanding/open sales orders from a customer with customer PO numbers and delivery schedules
e.g. outstanding po from celestica
L
R
E
SalesOrderDataHandler
customer_request_dates
Get customer requested delivery dates for a sales order
e.g. customer request dates for SO 25010001
L
R
E
SalesOrderDataHandler
sales_order_daily_summary
Get sales orders summary with values separated by currency. Supports both "sales order" and "customer order" terminology. Handles queries with month names like "november", "january", etc.
e.g. how many sales order register today. i want total sales order and value separate...
L
R
E
SalesOrderDataHandler
customer_orders_by_order_number
Get all sales orders for the customer who placed a specific order. Use when user provides an order number and wants to see all orders from that customer.
e.g. show me all order for customer order 9201735903
L
·
E
SalesOrderDataHandler
sales_order_items
Get line items of a sales order
e.g. items in sales order 25010001
L
·
·
SalesOrderDataHandler
sales_orders_pending_delivery
Get sales orders waiting for delivery
e.g. sales orders pending delivery
L
·
E
SalesOrderDataHandler
customer_request_date_status
Check delivery status of customer request dates (delivered, delayed, pending)
e.g. delivery status for SO 25010001
L
·
E
SalesOrderDataHandler
sales_orders_by_customer
Get sales orders for a specific customer
e.g. sales orders for customer ABC
L
·
E
SalesOrderDataHandler
sales_orders_by_week
Get sales orders for current week
e.g. this week sales orders
L
·
E
DeliveryDataHandler
delayed_deliveries
Get deliveries that are delayed or overdue
e.g. delayed deliveries
L
·
·
DeliveryDataHandler
upcoming_deliveries
Get upcoming delivery schedules
e.g. upcoming deliveries
L
·
·
SalesOrderDataHandler
customer_po_search
Search for orders by customer PO number
e.g. find customer PO ABC123
L
R
E
BulkLookupDataHandler
bulk_data_lookup
User pastes multiple part numbers or PO numbers and asks for delivery information for each item. Used when user provides a list of items and requests delivery date, ship quantity, DO number, or similar details for all of them.
e.g. 0010-16803-06A8S 9201678365 0022-25824-E2A8S 9201726410 help me provide delivery...
L
R
E
SpecialFeatureDataHandler
new_feature_1765187096
AI Analytics feature implementation 1765187096 with predictive analytics and machine learning metrics
e.g. new feature 1765187096
L
R
E
SpecialFeatureDataHandler
new_feature_1765187564
Blockchain Analytics feature implementation 1765187564 with distributed ledger metrics and smart contract analytics
e.g. new feature 1765187564
L
R
E
SpecialFeatureDataHandler
new_feature_1765266979
Edge Computing feature implementation 1765266979 with IoT device metrics and edge node analytics
e.g. new feature 1765266979
L
R
E
SpecialFeatureDataHandler
new_feature_1765272579
Cloud Native feature implementation 1765272579 with containerization metrics and kubernetes analytics
e.g. new feature 1765272579
L
R
E
SpecialFeatureDataHandler
new_feature_1765353644
Special feature implementation 1765353644 with data analytics and reporting capabilities
e.g. new feature 1765353644
L
R
E
SpecialFeatureDataHandler
new_feature_1765353781
Special feature implementation 1765353781 with data analytics and reporting capabilities
e.g. new feature 1765353781
L
R
E
SpecialFeatureDataHandler
new_feature_1765439932
Data Orchestration feature implementation 1765439932 with ETL pipelines and streaming analytics
e.g. new feature 1765439932
L
R
E
SpecialFeatureDataHandler
new_feature_1765522895
Integration Hub feature implementation 1765522895 with API gateway metrics and message queue analytics
e.g. new feature 1765522895
L
R
E
SpecialFeatureDataHandler
new_feature_1765533804
Service Mesh feature implementation 1765533804 with microservice routing metrics and traffic management analytics
e.g. new feature 1765533804
L
R
E
SpecialFeatureDataHandler
new_feature_1767088782
Special feature implementation 1767088782 with data analytics and reporting capabilities
e.g. new feature 1767088782
L
R
E
SpecialFeatureDataHandler
new_feature_1767605897
Special feature implementation 1767605897 with data analytics and reporting capabilities
e.g. new feature 1767605897
L
R
E
SpecialFeatureDataHandler
new_feature_1767929474
Special feature implementation 1767929474 with data analytics and reporting capabilities
e.g. new feature 1767929474
L
R
E
SpecialFeatureDataHandler
new_feature_1764149246
New feature implementation 1764149246
e.g. new feature 1764149246
L
R
E
SpecialFeatureDataHandler
new_feature_1764165163
New feature implementation 1764165163
e.g. new feature 1764165163
L
R
E
SpecialFeatureDataHandler
new_feature_1764165574
Special feature implementation 1764165574 with enhanced metrics
e.g. new feature 1764165574
L
R
E
SpecialFeatureDataHandler
new_feature_1764206842
Advanced feature implementation 1764206842 with performance metrics and monitoring
e.g. new feature 1764206842
L
R
E
SpecialFeatureDataHandler
new_feature_1764207729
Premium feature implementation 1764207729 with service analytics and subscription management
e.g. new feature 1764207729
L
R
E
SpecialFeatureDataHandler
new_feature_1764207659
Ultimate feature implementation 1764207659 with advanced performance metrics and innovation tracking
e.g. new feature 1764207659
L
R
E
SpecialFeatureDataHandler
new_feature_1764257639
Hyperscale feature implementation 1764257639 with distributed computing metrics and scalability tracking
e.g. new feature 1764257639
L
R
E
SpecialFeatureDataHandler
new_feature_1764258592
Quantum feature implementation 1764258592 with quantum computing metrics and processor analytics
e.g. new feature 1764258592
L
R
E
SpecialFeatureDataHandler
new_feature_1765158262
Special feature implementation 1765158262 with data analytics and reporting capabilities
e.g. new feature 1765158262
L
R
E
SpecialFeatureDataHandler
new_feature_1765533622
Special feature implementation 1765533622 with data analytics and reporting capabilities
e.g. new feature 1765533622
L
R
E
WorkOrderDataHandler
work_order_materials
Get materials and items used in a work order
e.g. materials for WO 25080011
L
R
E
WorkOrderDataHandler
work_order_status
Get status and basic information of a specific work order
e.g. what is the status of WO 25090001
L
·
E
WorkOrderDataHandler
work_order_details
Get comprehensive details of a work order including progress
e.g. show me work order 25080011
L
R
E
WorkOrderDataHandler
work_order_employees
Get list of employees who worked on a work order
e.g. who worked on WO 25080011
L
R
E
WorkOrderDataHandler
work_order_current_process
Get current process/station of a work order
e.g. where is WO 25080011 now
L
R
E
WorkOrderDataHandler
work_order_shipping_balance
Get shipping balance for a work order - shows how many items have been shipped vs ordered (SOCRD comparison)
e.g. balance quantity for WO 25080011
L
R
E
WorkOrderDataHandler
work_order_location
Find the current location of a work order in production
e.g. where is wo 22040983
L
R
E
WorkOrderDataHandler
active_work_orders
Get list of active/open work orders
e.g. show active work orders
L
R
E
WorkOrderDataHandler
delayed_work_orders
Get work orders that are delayed or overdue
e.g. delayed work orders
L
R
E
WorkOrderDataHandler
rejected_work_orders
Get work orders that have been rejected in First Article Inspection (FAI rejected status)
e.g. show rejected work orders
L
R
E
WorkOrderDataHandler
work_orders_in_progress
Get work orders currently in production
e.g. work orders in progress
L
R
E
WorkOrderDataHandler
work_orders_not_started
Get work orders that have not started yet
e.g. work orders not started
L
R
E
WorkOrderDataHandler
progress_query
Get process traveller progress for a work order
e.g. show progress for WO 25080011
L
R
E
WorkOrderDataHandler
work_order_production_output_by_employee
Get production output (quantities completed) grouped by employee for work orders
e.g. show work order production output by employee
L
R
E
WorkOrderDataHandler
work_order_reject_rate_by_process
Get work order reject rate grouped by process for quality analysis
e.g. show work order reject rate by process this month
L
R
E
WorkOrderDataHandler
work_order_cycle_time_by_process
Get work order cycle time analysis grouped by process to identify bottlenecks
e.g. show work order cycle time analysis by process
L
R
E
WorkOrderDataHandler
work_order_throughput_by_location
Get work order throughput analysis grouped by location to see production output per location
e.g. show work order throughput analysis by location
L
R
E
WorkOrderDataHandler
work_order_lead_time_by_customer
Get average work order lead time (creation to completion) grouped by customer
e.g. show work order average lead time by customer
L
R
E
SalesOrderDataHandler
customer_request_dates_by_wo
Get customer requested delivery dates and shipment schedule for a work order
e.g. delivery schedule for WO 25090005
L
R
E
WorkOrderDataHandler
work_orders_by_bom
Find all work orders that use a specific BOM or part number. Useful when you want to see all WOs related to a particular product.
e.g. list work order 0043-04076-03
L
R
E
WorkOrderDataHandler
work_orders_by_material
Get work orders that use a specific material/component (inventory item) in their BOM
e.g. list work order for part number 0043-11558
L
·
E
WorkOrderDataHandler
work_order_item_transfer
Get item transfer quantity and details for a work order - shows transfers between processes/locations
e.g. item transfer for WO {work_order_number}
L
·
E
WorkOrderDataHandler
work_orders_by_date_range
Get work orders within a specific date range
e.g. work orders due this week
L
·
E
WorkOrderDataHandler
work_orders_by_week
Get work orders for current week
e.g. this week work orders
L
·
E
WorkOrderDataHandler
work_orders_by_customer
Get work orders for a specific customer
e.g. work orders for customer ABC
L
·
E
WorkOrderDataHandler
work_orders_by_part_list
Search for parts/BOMs matching a partial number, then user picks one to see work orders
e.g. work order for 69006
L
·
E
WorkOrderDataHandler
work_orders_by_part
Get work orders for a specific exact part number
e.g. work orders with part 714-249101
L
·
E
WorkOrderDataHandler
work_order_rework_rate_by_part
Get work order rework/reject rate grouped by part number (BOM) for quality analysis
e.g. show work order rework rate by part number
L
·
E
WorkOrderDataHandler
work_order_aging_analysis_by_status
Get work order aging analysis grouped by status showing how long work orders have been in each status
e.g. show work order aging analysis by status
L
·
·
—
work_orders_by_creator
Get work orders created by a specific user or employee
e.g. work orders created by John