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
OK
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-22T14: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-22T14: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