AcademyDesign SystemFeedback

Schedule of Rates (archive)

This page describes the low level design for the SOR and rates services

Overview

Schedule of rates are defined by the state to provide detailed specifications for materials, labour, machinery etc..Rates are also defined at the state level but can be customized at the ULB level. This service provides a way to create/update/search for SORs and add rates to the SORs.

API Specifications

API Contract Link

16KB
sor-rates-1.0.0.yaml

APIs

Create an SOR

post

Create a SOR in the system with relevant details

Body

Request for SOR _create and _update api's

Responses
202
Successful created SOR
*/*
post
POST /works/SOR-Service/1.0.0/sor/v1/_create HTTP/1.1
Host: virtserver.swaggerhub.com
Content-Type: application/json
Accept: */*
Content-Length: 372

{
  "requestInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text"
  },
  "sors": [
    {
      "tenantId": "pb",
      "description": "K.B. bricks (25 Cm x 12Cm x 8Cm) having crushing strength not less than 75 Kg./Cm2 with dimensional tolerance ± 8 percent.",
      "isActive": true,
      "details": [
        null
      ],
      "additionalDetails": {}
    }
  ]
}
{
  "responseInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text",
    "userInfo": {
      "tenantId": "text",
      "id": 1,
      "uuid": "text",
      "userName": "text",
      "mobileNumber": "text",
      "emailId": "text",
      "roles": [
        {
          "tenantId": "text",
          "id": "text",
          "name": "text",
          "description": "text"
        }
      ]
    },
    "correlationId": "text"
  },
  "sors": [
    {
      "id": "251c51eb-e970-4e01-a99a-70136c47a934",
      "tenantId": "pb",
      "sorNumber": "LD-00001",
      "sorType": "Material, Works, Labour",
      "sorSubType": "Earth Work, RCC work",
      "sorVariant": "FN",
      "uom": "kg, sqm, cm",
      "uomValue": "10kg, 100sqm",
      "description": "K.B. bricks (25 Cm x 12Cm x 8Cm) having crushing strength not less than 75 Kg./Cm2 with dimensional tolerance ± 8 percent.",
      "isActive": true,
      "details": [
        null
      ],
      "auditDetails": {
        "createdBy": "text",
        "lastModifiedBy": "text",
        "createdTime": 1,
        "lastModifiedTime": 1
      },
      "additionalDetails": {}
    }
  ]
}

Update an SOR

post

Submit SOR with the head details to update SORs in the system

Body

Request for SOR _create and _update api's

Responses
202
Successful created SOR
*/*
post
POST /works/SOR-Service/1.0.0/sor/v1/_update HTTP/1.1
Host: virtserver.swaggerhub.com
Content-Type: application/json
Accept: */*
Content-Length: 372

{
  "requestInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text"
  },
  "sors": [
    {
      "tenantId": "pb",
      "description": "K.B. bricks (25 Cm x 12Cm x 8Cm) having crushing strength not less than 75 Kg./Cm2 with dimensional tolerance ± 8 percent.",
      "isActive": true,
      "details": [
        null
      ],
      "additionalDetails": {}
    }
  ]
}
{
  "responseInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text",
    "userInfo": {
      "tenantId": "text",
      "id": 1,
      "uuid": "text",
      "userName": "text",
      "mobileNumber": "text",
      "emailId": "text",
      "roles": [
        {
          "tenantId": "text",
          "id": "text",
          "name": "text",
          "description": "text"
        }
      ]
    },
    "correlationId": "text"
  },
  "sors": [
    {
      "id": "251c51eb-e970-4e01-a99a-70136c47a934",
      "tenantId": "pb",
      "sorNumber": "LD-00001",
      "sorType": "Material, Works, Labour",
      "sorSubType": "Earth Work, RCC work",
      "sorVariant": "FN",
      "uom": "kg, sqm, cm",
      "uomValue": "10kg, 100sqm",
      "description": "K.B. bricks (25 Cm x 12Cm x 8Cm) having crushing strength not less than 75 Kg./Cm2 with dimensional tolerance ± 8 percent.",
      "isActive": true,
      "details": [
        null
      ],
      "auditDetails": {
        "createdBy": "text",
        "lastModifiedBy": "text",
        "createdTime": 1,
        "lastModifiedTime": 1
      },
      "additionalDetails": {}
    }
  ]
}

Search an SOR

post

Submit SOR search request to get SOR list from the system

Body

Request for SOR _create and _update api's

Responses
202
Successful search SOR
*/*
post
POST /works/SOR-Service/1.0.0/sor/v1/_search HTTP/1.1
Host: virtserver.swaggerhub.com
Content-Type: application/json
Accept: */*
Content-Length: 361

{
  "requestInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text"
  },
  "criteria": {
    "ids": [
      "text"
    ],
    "tenantId": "text",
    "sorNumbers": [
      "text"
    ],
    "sorType": "text",
    "sorSubType": "text",
    "sorVariant": "text"
  },
  "pagination": {
    "limit": 10,
    "offSet": 0,
    "sortBy": "text",
    "order": {
      "0": "a",
      "1": "s",
      "2": "c"
    }
  }
}
{
  "responseInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text",
    "userInfo": {
      "tenantId": "text",
      "id": 1,
      "uuid": "text",
      "userName": "text",
      "mobileNumber": "text",
      "emailId": "text",
      "roles": [
        {
          "tenantId": "text",
          "id": "text",
          "name": "text",
          "description": "text"
        }
      ]
    },
    "correlationId": "text"
  },
  "sors": [
    {
      "id": "251c51eb-e970-4e01-a99a-70136c47a934",
      "tenantId": "pb",
      "sorNumber": "LD-00001",
      "sorType": "Material, Works, Labour",
      "sorSubType": "Earth Work, RCC work",
      "sorVariant": "FN",
      "uom": "kg, sqm, cm",
      "uomValue": "10kg, 100sqm",
      "description": "K.B. bricks (25 Cm x 12Cm x 8Cm) having crushing strength not less than 75 Kg./Cm2 with dimensional tolerance ± 8 percent.",
      "isActive": true,
      "details": [
        null
      ],
      "auditDetails": {
        "createdBy": "text",
        "lastModifiedBy": "text",
        "createdTime": 1,
        "lastModifiedTime": 1
      },
      "additionalDetails": {}
    }
  ]
}

Create an rates of SOR

post

Submit SOR with the rate details to create an SOR in the system

Body

Request for Rate _create and _update api's

Responses
202
Successful created rate details
*/*
post
POST /works/SOR-Service/1.0.0/sor/rate/v1/_create HTTP/1.1
Host: virtserver.swaggerhub.com
Content-Type: application/json
Accept: */*
Content-Length: 444

{
  "requestInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text"
  },
  "rateDetails": [
    {
      "tenantId": "pb.jalandhar OR dwss",
      "sorId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "detailId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "validFrom": 1,
      "validTo": 1,
      "amountDetail": [
        {
          "type": "Gst, cess, charge ",
          "amount": 1,
          "additionalDetails": {}
        }
      ],
      "isActive": true,
      "additionalDetails": {}
    }
  ]
}
{
  "ResponseInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text",
    "userInfo": {
      "tenantId": "text",
      "id": 1,
      "uuid": "text",
      "userName": "text",
      "mobileNumber": "text",
      "emailId": "text",
      "roles": [
        {
          "tenantId": "text",
          "id": "text",
          "name": "text",
          "description": "text"
        }
      ]
    },
    "correlationId": "text"
  },
  "rateDetails": [
    {
      "id": "251c51eb-e970-4e01-a99a-70136c47a934",
      "tenantId": "pb.jalandhar OR dwss",
      "sorId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "detailId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "validFrom": 1,
      "validTo": 1,
      "amountDetail": [
        {
          "id": "251c51eb-e970-4e01-a99a-70136c47a934",
          "type": "Gst, cess, charge ",
          "amount": 1,
          "additionalDetails": {}
        }
      ],
      "isActive": true,
      "additionalDetails": {},
      "auditDetails": {
        "createdBy": "text",
        "lastModifiedBy": "text",
        "createdTime": 1,
        "lastModifiedTime": 1
      }
    }
  ]
}

Create an rates of SOR

post

Submit SOR with the rate details to create an SOR in the system

Body

Request for Rate _create and _update api's

Responses
202
Successful updated Rates
*/*
post
POST /works/SOR-Service/1.0.0/sor/rate/v1/_update HTTP/1.1
Host: virtserver.swaggerhub.com
Content-Type: application/json
Accept: */*
Content-Length: 444

{
  "requestInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text"
  },
  "rateDetails": [
    {
      "tenantId": "pb.jalandhar OR dwss",
      "sorId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "detailId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "validFrom": 1,
      "validTo": 1,
      "amountDetail": [
        {
          "type": "Gst, cess, charge ",
          "amount": 1,
          "additionalDetails": {}
        }
      ],
      "isActive": true,
      "additionalDetails": {}
    }
  ]
}
{
  "ResponseInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text",
    "userInfo": {
      "tenantId": "text",
      "id": 1,
      "uuid": "text",
      "userName": "text",
      "mobileNumber": "text",
      "emailId": "text",
      "roles": [
        {
          "tenantId": "text",
          "id": "text",
          "name": "text",
          "description": "text"
        }
      ]
    },
    "correlationId": "text"
  },
  "rateDetails": [
    {
      "id": "251c51eb-e970-4e01-a99a-70136c47a934",
      "tenantId": "pb.jalandhar OR dwss",
      "sorId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "detailId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "validFrom": 1,
      "validTo": 1,
      "amountDetail": [
        {
          "id": "251c51eb-e970-4e01-a99a-70136c47a934",
          "type": "Gst, cess, charge ",
          "amount": 1,
          "additionalDetails": {}
        }
      ],
      "isActive": true,
      "additionalDetails": {},
      "auditDetails": {
        "createdBy": "text",
        "lastModifiedBy": "text",
        "createdTime": 1,
        "lastModifiedTime": 1
      }
    }
  ]
}

Search Rates for SOR and SOR heads

post

Submit Rate search request to get Rate list list from the system

Body

Request for rate _sarch api

Responses
202
Successful search Rates
*/*
post
POST /works/SOR-Service/1.0.0/sor/rate/v1/_search HTTP/1.1
Host: virtserver.swaggerhub.com
Content-Type: application/json
Accept: */*
Content-Length: 323

{
  "requestInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text"
  },
  "criteria": {
    "ids": [
      "text"
    ],
    "tenantId": "text",
    "sorIds": [
      "text"
    ],
    "headCodeIds": [
      "text"
    ]
  },
  "pagination": {
    "limit": 10,
    "offSet": 0,
    "sortBy": "text",
    "order": {
      "0": "a",
      "1": "s",
      "2": "c"
    }
  }
}
{
  "ResponseInfo": {
    "apiId": "text",
    "ver": "text",
    "ts": 1,
    "action": "text",
    "did": "text",
    "key": "text",
    "msgId": "text",
    "requesterId": "text",
    "authToken": "text",
    "userInfo": {
      "tenantId": "text",
      "id": 1,
      "uuid": "text",
      "userName": "text",
      "mobileNumber": "text",
      "emailId": "text",
      "roles": [
        {
          "tenantId": "text",
          "id": "text",
          "name": "text",
          "description": "text"
        }
      ]
    },
    "correlationId": "text"
  },
  "rateDetails": [
    {
      "id": "251c51eb-e970-4e01-a99a-70136c47a934",
      "tenantId": "pb.jalandhar OR dwss",
      "sorId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "detailId": "251c51eb-e970-4e01-a99a-70136c47a934",
      "validFrom": 1,
      "validTo": 1,
      "amountDetail": [
        {
          "id": "251c51eb-e970-4e01-a99a-70136c47a934",
          "type": "Gst, cess, charge ",
          "amount": 1,
          "additionalDetails": {}
        }
      ],
      "isActive": true,
      "additionalDetails": {},
      "auditDetails": {
        "createdBy": "text",
        "lastModifiedBy": "text",
        "createdTime": 1,
        "lastModifiedTime": 1
      }
    }
  ]
}

Data Model

DB Schema Diagram

Web Sequence Diagrams

SOR APIs

Rates

Master Data Types

The following masters need to be created as part of this module:

  • SOR Type

  • SOR Subtype

  • Unit of measurement

PreviousExpenseNextDetailed Measurement Book

Was this helpful?