Skip to content
Site Management Software
Share
Explore

Models

Users
ID
First name
Last name
Email
Phone
Password
Role
Created At
Updated At
Companies
ID
Name
Code
Address
Email
Phone
GST Number
Created AT
Updated AT
Sites
ID
Code
Name
Address
Company Id (Foreign Key)
created at
updated at
Company Users
id
user_id(engineer id)
company_id
created at
updated at
Site users
id
user_id(site manager id)
site_id
created at
updated at
Requisition
id
Req. Number(auto generated)(companyname-sitename-year-month-number = ABCSTYYMM-01)
Deliver Before (date)
Urgency
site id (For Site)
Status
Draft (site manager is making the requisition)
Pending Approval (site manager has sent to engineer for approval)
Approved/Reject (engineer has approved, sent to Purchase or rejected)
Awaiting finalization (Purchase manager has asked for quotes, waiting)
Finalized (Preferred quote has been finalized)
Goods Received (goods have been received)
Closed (Requisition closed)
Any other remarks
Requisition item
Item Name(site manager)
Requested Quantity(site manager)
Ordered quantity(purchase manager)
Received quantity
Ordered Price
Billed Price
Requisition id
Item Status
Pending
Partially Received
Received
Remarks
Documents
Requisition id
Document name
Document Type
approved_quote
other_quote
invoice
log
id
activity
user
req_num
req_item_name


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.