-
Notifications
You must be signed in to change notification settings - Fork 0
Data Model
Anubha Parashar edited this page Jul 10, 2026
·
1 revision
work_order_number is the shared key.
| Dataset | Grain |
|---|---|
| Work order | One row per work order |
| Work-unit revenue | One row per sales-order work-unit line |
| Activity/labor | One row per activity event |
| Billing | One row per billing event |
| Other cost | One row per expense event |
One work order can have multiple sales orders, work units, activity records, invoices, and costs.
See DATA_DICTIONARY.md in the repository for all columns.
This Wiki documents a synthetic-data demonstration. Validate financial rules and security requirements before any real-data implementation.
Engineering Work Order Profit and Loss Analytics