NetSuite work order lifecycle · workflow contract

name	required	type / hint
`assembly_id`	required	integer
`qty`	required	integer
`due_date`	optional	string

3 · Context loaded D1 queries run before fan-out

name

assembly

tables

assemblies

returns

row

SELECT
  id, itemid, displayname, quantityavailable, reorder_point
  FROM assemblies
  WHERE id = ?

name

assembly_bom

tables

assembly_bom

returns

rows

SELECT
  line_key, item_code, qty, uom, estimated_cost
  FROM assembly_bom
  WHERE assembly_id = ?

name

inventory_balance

tables

inventory_balance · assembly_bom

returns

rows

SELECT
  item_code, location_id, quantityavailable, reserved_qty
  FROM inventory_balance
  WHERE item_code IN (SELECT item_code
  FROM assembly_bom
  WHERE assembly_id = ?)

name

recent_builds

tables

transactions

returns

rows

SELECT
  id, trandate, total_cost, actual_qty, planned_qty
  FROM transactions
  WHERE type='Build'
  AND assembly_id=?
  ORDER BY trandate DESC
  LIMIT 10

name

labor_capacity

tables

labor_schedule

returns

rows

SELECT
  date(start_at) AS day, SUM(duration_min)/60.0 AS hours
  FROM labor_schedule
  WHERE start_at >= date('now')
  GROUP BY day

check	rule	severity
`assembly_exists`	`assembly_id IN (SELECT id FROM assemblies)`	block
`qty_positive`	`qty > 0`	block
`components_available`	`every BOM line has on_hand >= qty * bom.qty`	warn
`labor_capacity`	`upcoming_capacity_hours >= estimated_labor_hours`	warn

6 · Fan-out targets 9 total · 3 real · 6 stub

#1`wo_create` stage_proposed_action REAL

action_type

workorder_create

entity_type

workorder

#2`bom_reserve` kv_invalidate REAL

keys

inventory:assembly:?assembly_id
inventory:bom:?assembly_id

#3`component_issue` d1_write STUB

table

inventory_balance

operation

update

stub — not yet implemented in src/lib/workflow_runner.ts (kind d1_write hits the placeholder branch). Documented intent only.

UPDATE inventory_balance
  SET quantityavailable = quantityavailable - ?, reserved_qty = reserved_qty - ?
  WHERE item_code = ?
  AND location_id = ?

#4`build_complete` d1_write STUB

table

transactions

operation

insert

stub — not yet implemented in src/lib/workflow_runner.ts (kind d1_write hits the placeholder branch). Documented intent only.

INSERT INTO transactions (type, assembly_id, trandate, qty, status)
  VALUES ('Build', ?, datetime('now'), ?, 'completed')

#5`wo_close` stage_proposed_action REAL

action_type

workorder_close

entity_type

workorder

#6`variance_audit` flag STUB

table

proposed_actions

field

action_type

value

wo_variance_review

condition (if)

abs((actual_cost - estimated_cost)/estimated_cost) > 0.05

stub — not yet implemented in src/lib/workflow_runner.ts (kind flag hits the placeholder branch). Documented intent only.

#7`finished_goods_increment` d1_write STUB

table

inventory_balance

operation

update

stub — not yet implemented in src/lib/workflow_runner.ts (kind d1_write hits the placeholder branch). Documented intent only.

UPDATE inventory_balance
  SET quantityavailable = quantityavailable + ?
  WHERE item_code = (SELECT itemid
  FROM assemblies
  WHERE id = ?)
  AND location_id = ?

#8`notify_warehouse` hitl_email_draft STUB

tool

propose_email_to_customer

mailbox

warehouse@globalfoodsolutions.co

template

wo_completion_notice

stub — not yet implemented in src/lib/workflow_runner.ts (kind hitl_email_draft hits the placeholder branch). Documented intent only.

#9`reflexion_log_write` d1_write STUB

table

reflexion_log

operation

insert

stub — not yet implemented in src/lib/workflow_runner.ts (kind d1_write hits the placeholder branch). Documented intent only.

INSERT INTO reflexion_log (workflow_run_id, entity_type, entity_id, outcome, tags)
  VALUES (?, 'workorder', ?, ?, 'work_order,build,variance')

7 · Post actions declared + runner-automatic

id	action	source
`runner_log_run`	INSERT into `workflow_run_log` (run_id, workflow_type, status, started_at, completed_at, summary_json)	runner automatic
`runner_reflexion`	INSERT into `reflexion_log` (tags=`work_order_lifecycle`, run_id, narrative)	runner automatic (reflexion_enabled=1)
`log_run`	INSERT workflow_run_log	declared in contract
`reflexion`	INSERT reflexion_log with tags=work_order,build	declared in contract
`event_completed`	FIRE event workflow.completed (workflow_type=work_order_lifecycle)	declared in contract

8 · Verify checks written to `workflow_verify_results`

name

WO_status_built

when_to_run

1440 min after run

expected

row

SELECT
  status
  FROM transactions
  WHERE type='WorkOrd'
  AND id=?
  AND status='built'

name

variance_within_threshold

when_to_run

2880 min after run

expected

variance <= 0.05

SELECT
  abs((actual_cost - estimated_cost)/estimated_cost) AS variance
  FROM workorder_summary
  WHERE wo_id=?

name

inventory_correctly_updated

when_to_run

1440 min after run

expected

increased by ?qty

SELECT
  quantityavailable
  FROM inventory_balance
  WHERE item_code = (SELECT itemid
  FROM assemblies
  WHERE id=?)

10 · What changes when this workflow runs aggregated side effects

system	table / resource	action	status	source
D1	`proposed_actions`	INSERT (action_type=workorder_create)	REAL	fan-out #1 (wo_create)
KV (CACHE)	`inventory:assembly:?assembly_id, inventory:bom:?assembly_id`	invalidate	REAL	fan-out #2 (bom_reserve)
D1	`proposed_actions`	INSERT (action_type=workorder_close)	REAL	fan-out #5 (wo_close)
D1	`workflow_run_log`	INSERT (run summary)	REAL	runner automatic
D1	`reflexion_log`	INSERT (tags=work_order_lifecycle)	REAL	runner automatic
Event	`workflow.completed (or workflow.failed)`	fire	REAL	runner automatic
D1	`workflow_verify_results`	INSERT pending × 3	REAL	runner verify staging
D1	`proposed_actions`	INSERT (HITL gate envelope)	REAL	runner HITL gate
D1	`inventory_balance`	update	STUB	fan-out #3 (component_issue)
D1	`transactions`	insert	STUB	fan-out #4 (build_complete)
D1	`proposed_actions`	set action_type=wo_variance_review	STUB	fan-out #6 (variance_audit)
D1	`inventory_balance`	update	STUB	fan-out #7 (finished_goods_increment)
D1	`proposed_actions`	INSERT (email draft via propose_email_to_customer)	STUB	fan-out #8 (notify_warehouse)
D1	`reflexion_log`	insert	STUB	fan-out #9 (reflexion_log_write)

NetSuite work order lifecycle risk 3 · mediummanual_or_eventreflexion on

0 · Visual flow NetSuite work order lifecycle — 9 fan-out targets, 3 verify checks

1 · Trigger FIRES WHEN…

2 · Inputs required

3 · Context loaded D1 queries run before fan-out

4 · Preconditions checked before any fan-out

5 · HITL gate

6 · Fan-out targets 9 total · 3 real · 6 stub

#1`wo_create` stage_proposed_action REAL

#2`bom_reserve` kv_invalidate REAL

#3`component_issue` d1_write STUB

#4`build_complete` d1_write STUB

#5`wo_close` stage_proposed_action REAL

#6`variance_audit` flag STUB

#7`finished_goods_increment` d1_write STUB

#8`notify_warehouse` hitl_email_draft STUB

#9`reflexion_log_write` d1_write STUB

7 · Post actions declared + runner-automatic

8 · Verify checks written to `workflow_verify_results`

9 · Retry policy

10 · What changes when this workflow runs aggregated side effects

0 · Visual flow NetSuite work order lifecycle — 9 fan-out targets, 3 verify checks

1 · Trigger FIRES WHEN…

2 · Inputs required

3 · Context loaded D1 queries run before fan-out

4 · Preconditions checked before any fan-out

5 · HITL gate

6 · Fan-out targets 9 total · 3 real · 6 stub

#1wo_create stage_proposed_action REAL

#2bom_reserve kv_invalidate REAL

#3component_issue d1_write STUB

#4build_complete d1_write STUB

#5wo_close stage_proposed_action REAL

#6variance_audit flag STUB

#7finished_goods_increment d1_write STUB

#8notify_warehouse hitl_email_draft STUB

#9reflexion_log_write d1_write STUB

7 · Post actions declared + runner-automatic

8 · Verify checks written to workflow_verify_results

9 · Retry policy

10 · What changes when this workflow runs aggregated side effects

#1`wo_create` stage_proposed_action REAL

#2`bom_reserve` kv_invalidate REAL

#3`component_issue` d1_write STUB

#4`build_complete` d1_write STUB

#5`wo_close` stage_proposed_action REAL

#6`variance_audit` flag STUB

#7`finished_goods_increment` d1_write STUB

#8`notify_warehouse` hitl_email_draft STUB

#9`reflexion_log_write` d1_write STUB

8 · Verify checks written to `workflow_verify_results`