Back to ER Diagram
Service Procurement

Service Procurement

Complete service procurement lifecycle including Statement of Work (SOW) management, Service Entry Sheets (SES), timesheet and labor tracking, and milestone-based payment processing.

PostgreSQL
4 Tables
Schema: services
Time & Materials

Service Procurement Flow

SOW CREATED
SERVICE DELIVERED
SES SUBMITTED
PAYMENT
4
Service Processes
SOW
Scope Control
SES
Service Entry
T&M
Time & Materials

1. Statement of Work (SOW) Management

1

SOW Creation & Management

Define service scope, deliverables, milestones, and payment terms in structured Statement of Work documents.

services.sow_documents

  • sow_number - Unique SOW identifier
  • scope - JSON: Detailed scope definition
  • deliverables - JSON: Expected outputs
  • milestones - JSON: Key milestones with dates
  • total_value / currency_code - Contract value
  • start_date / end_date - Service period

SOW Components

Background/objectives, scope (in/out), deliverables with acceptance criteria, timeline/milestones, resource requirements, assumptions, risks, payment terms, change control process.

2. Service Entry Sheet (SES)

1

Service Confirmation

Record and confirm services rendered for payment processing. Links to SOW and PO.

services.service_entry_sheets

  • ses_number - Unique SES identifier
  • service_period_start / service_period_end - Period covered
  • service_description - Work performed
  • quantity / unit_price / total_value - Pricing
  • status - DRAFT, SUBMITTED, APPROVED, REJECTED

SES Approval Flow

  • 1. Vendor submits SES
  • 2. Project manager reviews
  • 3. Technical acceptance
  • 4. Finance verification
  • 5. Payment triggered

Payment Types

  • TIME Hourly/daily rates
  • FIXED Fixed deliverable
  • MILESTONE Progress-based

3. Timesheet & Labor Tracking

1

Time Tracking

Track contractor hours for time & materials contracts with approval workflow.

services.timesheet_entries

  • resource_id / resource_name - Worker identification
  • work_date - Date of work
  • hours_regular / hours_overtime - Hours worked
  • hourly_rate / overtime_rate - Billing rates
  • task_description - Work performed

4. Milestone-Based Payment

1

Milestone Payment Tracking

Track deliverable completion and trigger payments based on milestone achievement.

services.milestone_payments

  • milestone_number / milestone_name - Milestone identification
  • deliverable_description - What must be delivered
  • acceptance_criteria - How to verify completion
  • milestone_value - Payment amount
  • planned_date / actual_completion_date - Timeline
PLANNED
DELIVERED
VERIFIED
PAID

Database Schema Summary

TablePurposeKey Columns
services.sow_documentsSOW managementscope, deliverables, milestones
services.service_entry_sheetsSES trackingservice_period, quantity, status
services.timesheet_entriesTime trackinghours, rates, task_description
services.milestone_paymentsMilestone paymentsacceptance_criteria, milestone_value