Tuhund - Job Order List API

API # : 8801 | API Name : joborders

Get filtered and sort list of job orders.

URL : <domain>/apic/joborders
Methods Allowed : POST
Request Body : JSON Payload

Payload Structure :

Name Description Type
search Search text. String
sdate Starting date in DD/MM/YYYY format. For example 01/04/2020 would get all records starting from April 1, 2020 String
fdate Ending date in DD/MM/YYYY format. For example 31/03/2021 would get all records till from March 31, 2021 String
itemid Company ID of the customer. String
show Status of the Job Order. String
show2 Job Order Type. String
show3 Job Type.
  • 1 : Production
  • 2 : Sampling
  • ALL or null value : Both Types
String
pp Number of records per page.
All the matching records are split in sets similar to pages. This value tells the system how many records have to be grouped under each page. Default value is 100
Integer
page Page number. Default is 1 Integer
srt Sort by. Possible values are :
  • JOBNUMBER : Job number
  • PARENT : Link
  • STARTDATE : Start date
  • CLOSEDDATE : Closed date
  • DESCRIPTION : Description
  • STATUS : Status
  • TOTALCOST : Total cost
  • TOTALVALUE : Total value
String
order Sort Order. ASC or DESC String

Request Headers :

Name Description
device A short name of your application. Device is mandatory but any value between 3 and 20 characters is accepted.
Authentication Authentication code generated for API call.

Sample Payload :
{
  "order": "ASC",
  "show": "ALL",
  "srt": "CIDATE",
  "sdate": "01/04/2020",
  "fdate": "30/04/2020",
  "itemid": "BSLUqT"
}
Sample success response :
{
  "result": 1,
  "records": 2,
  "pages": 1,
  "data": [
    {
        "consumed": 0,
        "branchid": "ENTERPRISE",
        "parent": "PI No. 1098",
        "createddate": "15/10/2015",
        "prefix": "COM-",
        "description": "Job order for Proforma Invoice no. 1098",
        "deliveredproducts": 0,
        "startdate": "15/10/2015",
        "parentid": "R9sXbS",
        "products": 1,
        "totalcost": 40000,
        "jobid": "R9tUgV",
        "stockchange": -24962500,
        "createdby": "w2ggjG",
        "stockreduced": 24962500,
        "productionstatus": 0,
        "totalvalue": 0,
        "parenttype": "PI",
        "remainingprice": -30000,
        "quantity": 1,
        "servicebillpending": 0,
        "hoursrequired": 0,
        "productioncost": 0,
        "otherexpenses": 0,
        "hourstaken": 0,
        "approvedby": "w2ggjG",
        "requiredprice": 10000,
        "jobordertypeid": "unaXII",
        "finished": 1,
        "usedprice": 40000,
        "stockadded": 0,
        "deliveredquantity": 0,
        "jobnumber": 1073,
        "materials": 2,
        "status": 60
    },
    {
        "consumed": 0,
        "branchid": "ENTERPRISE",
        "parent": "PI No. 1107",
        "createddate": "02/11/2015",
        "prefix": "COM-",
        "description": "Job order for Proforma Invoice no. 1107",
        "deliveredproducts": 1,
        "startdate": "02/11/2015",
        "parentid": "Ss4eBu",
        "products": 1,
        "totalcost": 0,
        "jobid": "Ss4mDo",
        "companyid": "JgfM7v",
        "stockchange": 22801550,
        "createdby": "w2ggjG",
        "stockreduced": 0,
        "tag": "A S",
        "productionstatus": 0,
        "totalvalue": 45603.1015625,
        "parenttype": "PI",
        "remainingprice": 0,
        "quantity": 2,
        "servicebillpending": 0,
        "hoursrequired": 0,
        "productioncost": 0,
        "otherexpenses": 0,
        "hourstaken": 0,
        "approvedby": "w2ggjG",
        "requiredprice": 0,
        "jobordertypeid": "unaXII",
        "finished": 2,
        "usedprice": 0,
        "shortname": "A S",
        "stockadded": 22801550,
        "deliveredquantity": 1,
        "jobnumber": 1080,
        "materials": 0,
        "companyname": "A S Computers",
        "status": 60
    }
  ]
}
Sample failure response :
{
  "result": -1,
  "message": "Operation failed.",
  "errors": [
    {
      "code": 500,
      "error": "Unknown system exception"
    }
  ]
}
Tuhund Logo
TUHUND®
Home About us Modules CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers Community Blog
M Home Schedule Demo About us Community Blog
CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers
API Documents
Request Demo