API Catalog

Retrieve all JB Contracts By Code

25 Sep 2024
1 Minute to read

Print
Dark
Light

Retrieve all JB Contracts By Code

Updated on 25 Sep 2024
1 Minute to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/jb-rest-api/rest/1/jbcont

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select By Code
By UUID

Select By Code

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
CompCode	Company Code	001
ContCode	Contract Code	14001
AuditDate	Create or Update Date Time Filter	2016-01-01

By UUID

This is an optional finder for querying a specific Job Billing Contract by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/jb-rest-api/rest/1/jbcont/E7C9D2CAF8622E6CE05316821FAC2D6C

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectByCode; CompCode=001, ContCode=14001, AuditDate=2016-01-01

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleJbcVUuid:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "JbcCompCode": "001",
      "JbcCompName": "CMiC Construction Inc",
      "JbcContCode": "14001",
      "JbcJobCode": "14001",
      "JbcJobName": "1 ULV Facilities Upgrade",
      "JbcJobCtrlCode": "ALL",
      "JbcJobCtrlName": null,
      "JbcJobBillingRateCode": "DFLT",
      "JbcNegMaxBillAmtFlag": "N",
      "JbcCustCode": "ULV",
      "JbcCustName": "University of La Verne",
      "JbcDefaultBillingType": null,
      "JbcName": "1 ULV Facilities Upgrade",
      "JbcCurrCode": "USD",
      "JbcCurrName": "US Dollar",
      "JbcTermCode": "NET30",
      "JbcTermName": "Net 30",
      "JbcHldbkPc": null,
      "JbcTax1Code": null,
      "JbcTax1Name": null,
      "JbcTax2Code": null,
      "JbcTax2Name": null,
      "JbcTax3Code": null,
      "JbcTax3Name": null,
      "JbcBidDate": null,
      "JbcContDate": "2015-01-06",
      "JbcLstrevDate": null,
      "JbcClosedDate": null,
      "JbcAddTypeCode": null,
      "JbcAddTypeName": null,
      "JbcContactName": null,
      "JbcAdd1": "3040 Antoinette Lane",
      "JbcAdd2": null,
      "JbcAdd3": "San Francisco",
      "JbcRegionCode": "CA",
      "JbcRegionName": "California",
      "JbcCountry": "USA",
      "JbcPostalCode": "94080",
      "JbcPhoneNum": "415-555-1212",
      "JbcFaxNum": "415-555-9999",
      "JbcDesc": null,
      "JbcEngName": "Dean T Harris",
      "JbcArcName": "Candice Francis",
      "JbcLawName": null,
      "JbcSupName": null,
      "JbcApprovedDate": "2015-05-22T02:28:06Z",
      "JbcApprovedUser": "STEVE",
      "JbcMaxBillingAmt": null,
      "JbcBudgBillingAmt": null,
      "JbcDefaultInvFormatCode": "1",
      "JbcDefaultInvFormatName": "Standard Invoice Format",
      "JbcProjectManager": null,
      "JbcDefaultTax1TaxablePct": null,
      "JbcDefaultTax2TaxablePct": null,
      "JbcDefaultTax3TaxablePct": null,
      "JbcArchitectBpCode": null,
      "JbcArchitectBpName": null,
      "JbcStartingDrawNum": 1,
      "JbcMinCode": null,
      "JbcMinName": null,
      "JbcInvoiceCurrCode": "USD",
      "JbcInvoiceCurrName": "US Dollar",
      "JbcFixedCurrFactorNum": null,
      "JbcPmContactPartnTypeCode": null,
      "JbcPmContactPartnCode": null,
      "JbcPmContactCode": null,
      "JbcPmContactName": null,
      "JbcRetCode": "DFLT",
      "JbcRetDescription": "10% Entire Job",
      "JbcStartDate": "2015-01-01",
      "JbcEndDate": "2017-06-30",
      "JbcRuleCode": "STANDARD",
      "JbcTimePhasedFlag": "Y",
      "JbcAlternateCustName": null,
      "JbcDeptCode": "113",
      "JbcDeptName": "New York Operations",
      "JbcJbpytradeXrefCode": null,
      "JbcJbpytradeXrefName": null,
      "JbcAltCustAddCode": null,
      "JbcExclNoninvReceipts": "N",
      "JbcHldbkMethod": "P",
      "JbcScRfpCostFlag": "Y",
      "JbcWCatNoBillCodeFlag": "Y",
      "JbcInvoiceLevelRetFlag": "N",
      "JbcBpAddTypeCode": null,
      "JbcBpAddTypeName": null,
      "JbcMatStoredInternal": "N",
      "JbcMatStoredPrintFlag": "N",
      "JbcGrpMaxSeqGrp1": 1,
      "JbcGrpMaxSeqGrp2": null,
      "JbcGrpMaxSeqGrp3": null,
      "JbcGrpMaxSeqGrp4": null,
      "JbcGrpMaxSeqGrp5": null,
      "JbcUseScrfpHldbkRelFlag": "N",
      "JbcWipRollInFlag": "N",
      "JbcDtlPciBilling": "N",
      "JbcCPciDisableFlag": "Y",
      "JbcIuCreateDate": "2015-05-22T02:28:06Z",
      "JbcIuUpdateDate": "2016-10-14T12:38:07Z",
      "JbcCompCurrCode": "USD",
      "JbcEtcUseUnbilledRev": "N",
      "JbcRoundBillAmtTo": 2,
      "JbcRoundBillMethod": "R",
      "JbcRoundHldbkAmtTo": 2,
      "JbcRoundHldbkMethod": "R",
      "JbcTaxOnGrossAmt": "N",
      "JbcAcctDescription": null,
      "JbcContractName": "1 ULV Facilities Upgrade",
      "JbcNoRecalCurComplFlag": null,
      "JbcRemitDetails": null,
      "JbcVUuid": "E7C9D2CAF8622E6CE05316821FAC2D6C",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jb-rest-api/rest/1/jbcont/E7C9D2CAF8622E6CE05316821FAC2D6C",
          "name": "jbcont",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jb-rest-api/rest/1/jbcont/E7C9D2CAF8622E6CE05316821FAC2D6C",
          "name": "jbcont",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jb-rest-api/rest/1/jbcont",
      "name": "jbcont",
      "kind": "collection"
    }
  ]
}

object

What's Next

Update a Specific JB Group

Retrieve all JB Contracts By Code

Query Standards

Finder

Select By Code

By UUID

What's Next

Contact Us