AD04
Workflow & Approval Management
Approval workflows, their steps, and the requests waiting on them.
Schema v01 has no workflow engine: no workflow, step, condition or approval-request table. The only approval flags are substitution_rule.needs_approval and allocation.override_reason, and a quote has no approval state in quote_status.
Active Workflows
—
no workflow table in schema v01
Pending Approvals
—
no approval-request table
Overdue
—
no approval-request table, so no due date
Avg Approval Time
—
no approval events on the ledger
Completed
—
no approval-request table
Approval Requests
RequestModuleRequested BySubmittedDueStatus
No approval-request rows: a quotation, a price list, a purchase order or a contract has no approval step in schema v01.
What the database does hold
substitution_rule rowsasking
allocation rowsasking
SUBSTITUTION_APPROVED eventsasking
Workflows
Customer Creation, Supplier Onboarding, Material Master Change, Price List, Sales Quotation, Purchase Order, Contract, Inventory Adjustment, Data Import, User Access Request
Nothing to show yet
No workflow definition table: name, module, type (sequential / parallel / conditional), steps, version and status have no home.
Approval Trend
Nothing to show yet
No approval events to count per month.
Approvals by Module
Nothing to show yet
No approval-request table.
Status Distribution
Pending / Overdue / Completed / Rejected / Approved
Nothing to show yet
No approval-request table, so no status.
My Tasks
Nothing to show yet
No task or approval inbox; the ledger has no assignment event beyond CLAIMED and REASSIGNED on an enquiry.
Templates
Nothing to show yet
No workflow-template table.