Job Master (GJZJ28J)

The GJZJ28J function creates new Jobs in the Job Master and exports existing Job data. Rows are sent via JC_JobMaster_tbl, with the Job code, Customer code, estimator and project manager all referenced by their Jonas lookups.

User security

(one of the following)

System Administration > Jonas Template Uploads > Job Costing > Job Master Upload
Job Costing > Files > Job/Project Master

WebMethod

GJZJ28J

4 sample payloads

Options overview

Option	Purpose
`template`	An empty Job Master template with every field present and blank.
`download`	An existing Job exported via `Option: download`.
`scan`	Validate a Job payload before committing — the response lists any field-level errors.
`update`	Once the scan is clean, switch `Option` to `update` to commit the Job(s).

Template

An empty Job Master template with blank text fields and zero numeric values.

Job Master TemplateJSON payload

{
  "WebMethod": "GJZJ28J",
  "Option": "template",
  "CompanyCode": "",
  "JC_JobMaster_tbl": [
    {
      "JobNumber": "",
      "JobDescription1": "",
      "CustomerCode": "",
      "JC_JobAddress_tbl": {
        "AddressLine1": "",
        "AddressLine2": "",
        "AddressLine3": "",
        "PostalZipCode": ""
      },
      "JobStartingDate": "",
      "EstimatedCompletionDate": "",
      "SalesTaxGroup": "",
      "JobDescription2": "",
      "ContractValue": 0,
      "ServiceContractNumber": "",
      "HoldBackRetainagePercentage": 0,
      "ArchitectsHoldbackRetainagePercentage": 0,
      "BillToCustomerCode": "",
      "JC_JobSortCategories_tbl": {
        "SortCategory1": "",
        "SortCategory2": "",
        "SortCategory3": "",
        "SortCategory4": "",
        "SortCategory5": "",
        "SortCategory6": "",
        "SortCategory7": "",
        "SortCategory8": "",
        "SortCategory9": "",
        "SortCategory10": ""
      },
      "JobStatus": "",
      "JC_JobOtherOptions_tbl": {
        "SalesCategoryCode": "",
        "TerritorySalespersonCode": ""
      }
    }
  ]
}

Download

An existing Job exported via Option: download.

Job Master DownloadSOAP envelope

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><JonasAPIResponse xmlns="jonas.jonasportal.com/"><JonasAPIResult>{"message":"Login Successful : UserID GJSYSTEM (User 7/10) ","Data: {"WebMethod":"GJZJ28J","Option":"download","CompanyCode":"JC","JC_JobMaster_tbl":[{"JobNumber":"000003","JobDescription1":"123456789012345678901234567890","CustomerCode":"AAAABAAA","JC_JobAddress_tbl":{"AddressLine1":"","AddressLine2":"","AddressLine3":"","PostalZipCode":""},"JobStartingDate":"2004-06-01T00:00:00Z","EstimatedCompletionDate":"2004-06-01T00:00:00Z","SalesTaxGroup":"PAPN","JobDescription2":"","ContractValue":100000.00,"ServiceContractNumber":"","HoldBackRetainagePercentage":10.00,"ArchitectsHoldbackRetainagePercentage":0,"BillToCustomerCode":"        11","JC_JobSortCategories_tbl":{"SortCategory1":"","SortCategory2":"","SortCategory3":"","SortCategory4":"","SortCategory5":"","SortCategory6":"","SortCategory7":"","SortCategory8":"","SortCategory9":"","SortCategory10":""},"JobStatus":"Y","JC_JobOtherOptions_tbl":{"SalesCategoryCode":"","TerritorySalespersonCode":""}}]}</JonasAPIResult></JonasAPIResponse></soap:Body></soap:Envelope>

Scan

Validate a Job payload before committing — the response lists any field-level errors.

Job Master Error ScanSOAP envelope

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:jon="jonas.jonasportal.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <jon:JonasAPI>
         <!--Optional:-->
         <jon:securityToken>fe02f84b459a4a317dd6080678bd8140</jon:securityToken>
         <!--Optional:-->
         <jon:username>****</jon:username>
         <!--Optional:-->
         <jon:password>****</jon:password>
         <!--Optional:-->
         <jon:apiParams><![CDATA[
         		{"WebMethod":"GJZJ28J","Option":"scan","CompanyCode":"JC","JC_JobMaster_tbl":[{"JobNumber":"*1003","JobDescription1":"Quebec Job","CustomerCode":"QUEBEC","JC_JobAddress_tbl":{"AddressLine1":"12552 Younge St","AddressLine2":"Richmond Hill","AddressLine3":"Ontario","PostalZipCode":"M4L 5P2"},"JobStartingDate":"2000-05-29T00:00:00Z","EstimatedCompletionDate":"2000-12-01T00:00:00Z","SalesTaxGroup":"","JobDescription2":"","ContractValue":0.00,"ServiceContractNumber":"1238","HoldBackRetainagePercentage":10.00,"ArchitectsHoldbackRetainagePercentage":0.00,"BillToCustomerCode":"        11","JC_JobSortCategories_tbl":{"SortCategory1":"JIM","SortCategory2":"ROBIN","SortCategory3":"CARL SMITH","SortCategory4":"LABOUR","SortCategory5":"","SortCategory6":"","SortCategory7":"","SortCategory8":"","SortCategory9":"","SortCategory10":""},"JobStatus":"Y","JC_JobOtherOptions_tbl":{"SalesCategoryCode":"","TerritorySalespersonCode":""}}]}
         ]]></jon:apiParams>
      </jon:JonasAPI>
   </soapenv:Body>
</soapenv:Envelope>

Update

Once the scan is clean, switch Option to update to commit the Job(s).

Job Master UpdateSOAP envelope

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:jon="jonas.jonasportal.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <jon:JonasAPI>
         <!--Optional:-->
         <jon:securityToken>fe02f84b459a4a317dd6080678bd8140</jon:securityToken>
         <!--Optional:-->
         <jon:username>****</jon:username>
         <!--Optional:-->
         <jon:password>****</jon:password>
         <!--Optional:-->
         <jon:apiParams><![CDATA[
         		{"WebMethod":"GJZJ28J","Option":"update","CompanyCode":"JC","JC_JobMaster_tbl":[{"JobNumber":"*10003","JobDescription1":"Quebec Job","CustomerCode":"QUEBEC","JC_JobAddress_tbl":{"AddressLine1":"12552 Younge St","AddressLine2":"Richmond Hill","AddressLine3":"Ontario","PostalZipCode":"M4L 5P2"},"JobStartingDate":"2000-05-29T00:00:00Z","EstimatedCompletionDate":"2000-12-01T00:00:00Z","SalesTaxGroup":"","JobDescription2":"","ContractValue":0.00,"ServiceContractNumber":"1238","HoldBackRetainagePercentage":10.00,"ArchitectsHoldbackRetainagePercentage":0.00,"BillToCustomerCode":"        11","JC_JobSortCategories_tbl":{"SortCategory1":"JIM","SortCategory2":"ROBIN","SortCategory3":"CARL SMITH","SortCategory4":"LABOUR","SortCategory5":"","SortCategory6":"","SortCategory7":"","SortCategory8":"","SortCategory9":"","SortCategory10":""},"JobStatus":"Y","JC_JobOtherOptions_tbl":{"SalesCategoryCode":"","TerritorySalespersonCode":""}}]}
         ]]></jon:apiParams>
      </jon:JonasAPI>
   </soapenv:Body>
</soapenv:Envelope>