View Categories

Glossary

< 1 min read

  • Project: A header record with name, description, start/end dates, status, and totals for materials/tasks.
  • Components: Sub-sections of a project (e.g., phases), with name, quantity, dates, and linked materials/tasks.
  • Materials: Items under components, with quantity, cost, unit, and transaction links.
  • Tasks: Activities under components, with name, assigned_to, due_date, speed/rate calculations, and totals.
  • Status ID: Integer for states (e.g., 1 = Pending, 2 = Active, 3 = Cancelled, 4 = Template).
  • Order ID: Sequencing field for components/materials/tasks (used in move up/down).
  • Total Hours/Materials/Tasks: Aggregated calculations for project/component summaries.
  • Schedule Project: Stored procedure (spScheduleProject) to assign dates based on include_days_id (e.g., every day, weekends).
  • Copy Component: Function to duplicate components within a project.
  • Filter Materials: Checkbox to show only filtered materials (param filter_id in qryProjectMaterials).
  • PgDAC: Database components for queries like qryProjectHeader.
  • DevExpress Grid (TcxGridDBTableView): For displaying/editing projects, components, materials, tasks.

Leave a Comment