Revision to Estimate / Change Orders

This API records Estimate/Change Orders in the system.

WebMethod

GJJC1J – required

Option

scan – error scan only
update – Upload equipment usage
Template – Get upload template

CompanyCode

Required

errorsFound

returned result (read-only)

recordsProcessed

returned result (read-only)

NextChangeOrderNumber

automatically assign Change Order Numbers
Boolean (default = false, ie: Change Order Numbers must be specified)
cannot be used with mixed datasets

pdfReport

Boolean (default = false)

pdfReportOut

base64 encoded pdf (read-only)

ChangeOrders

Field	Description
`JobNumber`	required
`ChangeOrderNumber`	required • must be unique for each Job
`Description`
`ChangeOrderDate`	required
`ChangeOrderStatus`	A \| P \| C \| O (Required) • A - Approved • P – Pending • C – Contemplated • O - On-Hold
`ApprovalDate`	required if `ChangeOrderStatus`=`A`
`OriginId`	Internal use only

LineItems

Field	Description
`CostItem`	required
`CostType`	required
`Units`	number (-999999999.99)
`Amount`	number (-999999999.99)
`Hours`	number (-999999999.99) hours N/A for non Labor Cost Type
`BillingApplication`	Refers to Progress Billing Lines, Report column (optional)

template

{
        "WebMethod":"GJJC1J",
        "Option":"template",
        "NextChangeOrderNumber":true,
        "pdfReport":false,
        "CompanyCode":"",
        "ChangeOrders":[{
               "JobNumber":"",
               "ChangeOrderNumber":"",
               "Description":"",
               "ChangeOrderDate":"1970-01-01T00:00:00Z",
               "ChangeOrderStatus":"",
               "ApprovalDate":"1970-01-01T00:00:00Z",
               "OriginId":"",
               "LineItems": [{
                      "CostItem":"",
                      "CostType":"",
                      "Units":0,
                      "Amount":0,
                      "Hours":0,
                      "BillingApplication":""
               }]
        }]
}

example

{
    "WebMethod":"GJJC1J",
    "Option":"scan",
    "pdfReport":false,
    "CompanyCode":"01",
    "ChangeOrders":[{
         "JobNumber":"ANYJOB",
         "ChangeOrderNumber":"00005",
         "Description":"Any Text",
         "ChangeOrderDate":"1985-10-05T00:00:00Z",
         "ChangeOrderStatus":"A",
         "ApprovalDate":"1985-10-05T00:00:00Z",
         "LineItems": [{
                "CostItem":"00000025",
                "CostType":"MA",
                "Units":999.99,
                "Amount":999.99,
                "Hours":999.99,
                "BillingApplication":"1"
         }]
    }]
}

result with error

{
        "WebMethod": "GJJC1J",
        "Option": "scan",
        "CompanyCode": "01",
        "recordsProcessed": 1,
        "errorsFound": 1,
        "errors":["C/O Status (missing)"]
}

successful result

{
        "WebMethod": "GJJC1J",
        "Option": "scan",
        "CompanyCode": "01",
        "DateOfRecord": "2020-09-29T00:00:00Z",
        "errorsFound": 0,
        "recordsProcessed": 1,
        "pdfReport": false
}