Retrieve a Specific JC Forecast Archives By Code
  • 06 Jan 2025
  • 4 Minutes to read
  • Dark
    Light

Retrieve a Specific JC Forecast Archives By Code

  • Dark
    Light

Article summary

Get
/jc-rest-api/rest/1/jccontforecastarch
Security
HTTP
Type basic

Basic authentication

Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
example-0

Successful Response - Finder - SelectCompany

{
  "items": [
    {
      "JccfAdjForecastRevenueAmt": 0,
      "JccfAdjRevenueVarianceAmt": 168500,
      "JccfAdjWipFcastRevAmt": 0,
      "JccfAdjustment": null,
      "JccfAllSpentCommittedAmt": 29000,
      "JccfArchiveDate": "2021-07-21",
      "JccfArchiveFullDate": "2021-07-21T23:15:06Z",
      "JccfBillCatCode": "S",
      "JccfBillCatName": "Subcontracts",
      "JccfBillCode": "15440.S",
      "JccfBillCtrlPhsCode": "15",
      "JccfBillJobCode": "14002",
      "JccfBillPhsCode": "15440",
      "JccfBillPhsName": "Plumbing",
      "JccfBillPhsType": null,
      "JccfBillTypeCode": "COST",
      "JccfBilledToDateAmt": 65103.88,
      "JccfBillingRate": 168500,
      "JccfBillingTypeName": "Cost Plus Markup",
      "JccfCalcCostAtCompl": null,
      "JccfCalculateColumnName": null,
      "JccfCmmName": null,
      "JccfCommAmt": 0,
      "JccfCommCostQty": 0,
      "JccfCompCode": "001",
      "JccfComplPc": 17.211,
      "JccfComplPc2": 17.2106824925816,
      "JccfContCode": "14002",
      "JccfCostAmt": 29000,
      "JccfCostBudmethCode": "A",
      "JccfCostCatCode": "S",
      "JccfCostCodeCount": 1,
      "JccfCostFcstInclPciAmt": 168500,
      "JccfCostJobCode": "14002",
      "JccfCostPhsCode": "15440",
      "JccfCostProjPhsQty": 0,
      "JccfCostToCompl": null,
      "JccfCostToComplOvrdFlag": "N",
      "JccfCostToComplTotal": 139500,
      "JccfCostVarInclPciAmt": 0,
      "JccfCostVarianceAmt": 0,
      "JccfCtcPopupMatchClacFlg": "X",
      "JccfCurrBillBudgAmt": 168500,
      "JccfCurrBillBudgQty": 1,
      "JccfCurrBillQty": 0,
      "JccfCurrBillWmCode": "LS",
      "JccfCurrCostBudgAmt": 168500,
      "JccfCurrCostBudgPhsQty": 0,
      "JccfCurrCostBudgQty": 1,
      "JccfCurrCostSpentPhsQty": 0,
      "JccfCurrCostSpentQty": 0,
      "JccfCurrCostWmCode": "LS",
      "JccfCurrCostWmPhsCode": "LS",
      "JccfCurrPerChgAmt": 0,
      "JccfCurrPerCommAmt": 0,
      "JccfCurrPerCostAmt": 0,
      "JccfCurrSpentAmt": 29000,
      "JccfCurrSpentAmtBaseCont": 29000,
      "JccfEligBillToDateAmt": 0,
      "JccfExtPciToCompleteAmt": 0,
      "JccfExtTrnPciRiskAmt": 0,
      "JccfForecastCostAmt": 168500,
      "JccfForecastRevOvrdFlag": null,
      "JccfForecastRevenueAmt": 0,
      "JccfForecastRevenueQty": 0,
      "JccfForecastRevenueRate": null,
      "JccfForecastRevenueWmCode": "LS",
      "JccfFreezeProjAmtFlag": "N",
      "JccfHasTimePhasedFlag": null,
      "JccfHistoricalDataFlag": "N",
      "JccfIntChgOrdCostPhsQty": null,
      "JccfIntPciToComplAmt": 0,
      "JccfIntPendCoSpentAmt": 0,
      "JccfIntPendCoToComplAmt": 0,
      "JccfIntPendingCoAmt": 0,
      "JccfInvCommAmt": 0,
      "JccfInvCommCostQty": 0,
      "JccfInvQty": 0,
      "JccfIuCreateDate": "2021-07-21T23:15:06Z",
      "JccfIuUpdateDate": null,
      "JccfLabourForecastFlag": "N",
      "JccfMaxBillingAmt": null,
      "JccfMaxBillingQty": null,
      "JccfNinvCommAmt": 29000,
      "JccfNinvCommCostQty": 0,
      "JccfNonSharedSavingAmt": -168500,
      "JccfOpenCommitment": null,
      "JccfOrigBillBudgAmt": 168500,
      "JccfOrigCostBudgAmt": 168500,
      "JccfOrigCostBudgQty": 1,
      "JccfOrigCostProjPhsQty": 0,
      "JccfOrigProjCostQty": 0,
      "JccfOvrdAutoClearFlag": "N",
      "JccfPciRiskCostAmt": 0,
      "JccfPciRiskRevAmt": 0,
      "JccfPciRiskWipCostAmt": 0,
      "JccfPciRiskWipRevAmt": 0,
      "JccfPciToCompleteCostAmt": 0,
      "JccfPciWipToCompleteAmt": 0,
      "JccfPendChgOrdCostAmt": 0,
      "JccfPendChgOrdCostPhsQty": null,
      "JccfPendChgOrdCostQty": null,
      "JccfPendIntChgOrdCostAmt": 0,
      "JccfPendIntChgOrdCostQty": null,
      "JccfPendingChgOrdBillAmt": 0,
      "JccfPendingCoAmt": 0,
      "JccfPer": 6,
      "JccfPopupBillVar": -168500,
      "JccfPopupCostActualPerc": 17.21,
      "JccfPopupCostActualRate": 0,
      "JccfPopupCostPrevPerRate": 0,
      "JccfPopupCostProjRate": 0,
      "JccfPopupCostRate": 168500,
      "JccfPopupCostToCompleRate": 0,
      "JccfPopupCostVar": 0,
      "JccfPopupPrevPerBillVar": 0,
      "JccfPopupPrevPerCostVar": 0,
      "JccfPopupPrevPerUnitVar": 0,
      "JccfPopupQtyActualPerc": 0,
      "JccfPopupQtyToComplePerc": 0,
      "JccfPopupRevActualPerc": 0,
      "JccfPopupRevActualRate": 0,
      "JccfPopupRevPrevPerRate": 0,
      "JccfPopupRevProjRate": 0,
      "JccfPopupRevRate": 168500,
      "JccfPopupRevToCompleRate": 0,
      "JccfPopupToComplQty": 0,
      "JccfPopupUnitVar": -1,
      "JccfPrevPerChgAmt": 0,
      "JccfPrevPerCommAmt": 0,
      "JccfPrevPerCostAmt": 0,
      "JccfPrevPerFcastAmt": 168500,
      "JccfPrevPerOvrdFlg": "N",
      "JccfPrevPerProjBillAmt": 0,
      "JccfPrevPerProjCostQty": 0,
      "JccfPrevPerProjPhsQty": 0,
      "JccfProductivityOverride": null,
      "JccfProfitInclShardSaving": -168500,
      "JccfProjBillBudgAmt": 168500,
      "JccfProjBillQty": null,
      "JccfProjBudgRiskAmt": 168500,
      "JccfProjCostBudgAmt": 168500,
      "JccfProjCostBudgPhsQty": 0,
      "JccfProjCostBudgQty": 1,
      "JccfProjCostQty": 0,
      "JccfProjFcastCostAmtCalc": 168500,
      "JccfProjForecastCostAmt": 168500,
      "JccfProjForecastDfltAmt": 168500,
      "JccfProjectedProfit": -168500,
      "JccfRateOverrideAmt": null,
      "JccfRemLabProj": null,
      "JccfRemainToBillAmt": 0,
      "JccfRevenueVarianceAmt": 168500,
      "JccfRuleCode": null,
      "JccfSharedSavingAmt": 0,
      "JccfSharedSavingFlag": "N",
      "JccfSharedSavingPct": 0,
      "JccfSpentPc": 17.211,
      "JccfStoredCurrCostBudgAmt": null,
      "JccfSysDfltCostToCmplAmt": null,
      "JccfTimePhasedFlag": "N",
      "JccfToComplCostOvrrdeFlag": "N",
      "JccfToCompleteCostAmt": 139500,
      "JccfTrendAdj": null,
      "JccfTrendadjNotes": null,
      "JccfUnbilledRevAmt": 0,
      "JccfWbsPciAmt": 0,
      "JccfWipFcastRevAmt": 0,
      "JccfWipFcastRevQty": 0,
      "JccfWipPendIntChgOrdAmt": 0,
      "JccfWipPendIntTrnChgAmt": 0,
      "JccfWipProjForecastAmt": 168500,
      "JccfWipToComplCostAmt": 139500,
      "JccfYr": 2021,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/jc-rest-api/rest/1/jccontforecastarch/00060000000A323032312D30372D32310000000731353434302E530000000330303100000005313430303200000002C10700000003C21516",
          "name": "jccontforecastarch",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/jc-rest-api/rest/1/jccontforecastarch/00060000000A323032312D30372D32310000000731353434302E530000000330303100000005313430303200000002C10700000003C21516",
          "name": "jccontforecastarch",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 309,
  "count": 1,
  "hasMore": true,
  "limit": 1,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/jc-rest-api/rest/1/jccontforecastarch",
      "name": "jccontforecastarch",
      "kind": "collection"
    }
  ]
}
example-1

Successful Response - Finder - selectJob

{
  "items": [
    {
      "JccfAdjForecastRevenueAmt": 0,
      "JccfAdjRevenueVarianceAmt": 168500,
      "JccfAdjWipFcastRevAmt": 0,
      "JccfAdjustment": null,
      "JccfAllSpentCommittedAmt": 29000,
      "JccfArchiveDate": "2021-07-21",
      "JccfArchiveFullDate": "2021-07-21T23:15:06Z",
      "JccfBillCatCode": "S",
      "JccfBillCatName": "Subcontracts",
      "JccfBillCode": "15440.S",
      "JccfBillCtrlPhsCode": "15",
      "JccfBillJobCode": "14002",
      "JccfBillPhsCode": "15440",
      "JccfBillPhsName": "Plumbing",
      "JccfBillPhsType": null,
      "JccfBillTypeCode": "COST",
      "JccfBilledToDateAmt": 65103.88,
      "JccfBillingRate": 168500,
      "JccfBillingTypeName": "Cost Plus Markup",
      "JccfCalcCostAtCompl": null,
      "JccfCalculateColumnName": null,
      "JccfCmmName": null,
      "JccfCommAmt": 0,
      "JccfCommCostQty": 0,
      "JccfCompCode": "001",
      "JccfComplPc": 17.211,
      "JccfComplPc2": 17.2106824925816,
      "JccfContCode": "14002",
      "JccfCostAmt": 29000,
      "JccfCostBudmethCode": "A",
      "JccfCostCatCode": "S",
      "JccfCostCodeCount": 1,
      "JccfCostFcstInclPciAmt": 168500,
      "JccfCostJobCode": "14002",
      "JccfCostPhsCode": "15440",
      "JccfCostProjPhsQty": 0,
      "JccfCostToCompl": null,
      "JccfCostToComplOvrdFlag": "N",
      "JccfCostToComplTotal": 139500,
      "JccfCostVarInclPciAmt": 0,
      "JccfCostVarianceAmt": 0,
      "JccfCtcPopupMatchClacFlg": "X",
      "JccfCurrBillBudgAmt": 168500,
      "JccfCurrBillBudgQty": 1,
      "JccfCurrBillQty": 0,
      "JccfCurrBillWmCode": "LS",
      "JccfCurrCostBudgAmt": 168500,
      "JccfCurrCostBudgPhsQty": 0,
      "JccfCurrCostBudgQty": 1,
      "JccfCurrCostSpentPhsQty": 0,
      "JccfCurrCostSpentQty": 0,
      "JccfCurrCostWmCode": "LS",
      "JccfCurrCostWmPhsCode": "LS",
      "JccfCurrPerChgAmt": 0,
      "JccfCurrPerCommAmt": 0,
      "JccfCurrPerCostAmt": 0,
      "JccfCurrSpentAmt": 29000,
      "JccfCurrSpentAmtBaseCont": 29000,
      "JccfEligBillToDateAmt": 0,
      "JccfExtPciToCompleteAmt": 0,
      "JccfExtTrnPciRiskAmt": 0,
      "JccfForecastCostAmt": 168500,
      "JccfForecastRevOvrdFlag": null,
      "JccfForecastRevenueAmt": 0,
      "JccfForecastRevenueQty": 0,
      "JccfForecastRevenueRate": null,
      "JccfForecastRevenueWmCode": "LS",
      "JccfFreezeProjAmtFlag": "N",
      "JccfHasTimePhasedFlag": null,
      "JccfHistoricalDataFlag": "N",
      "JccfIntChgOrdCostPhsQty": null,
      "JccfIntPciToComplAmt": 0,
      "JccfIntPendCoSpentAmt": 0,
      "JccfIntPendCoToComplAmt": 0,
      "JccfIntPendingCoAmt": 0,
      "JccfInvCommAmt": 0,
      "JccfInvCommCostQty": 0,
      "JccfInvQty": 0,
      "JccfIuCreateDate": "2021-07-21T23:15:06Z",
      "JccfIuUpdateDate": null,
      "JccfLabourForecastFlag": "N",
      "JccfMaxBillingAmt": null,
      "JccfMaxBillingQty": null,
      "JccfNinvCommAmt": 29000,
      "JccfNinvCommCostQty": 0,
      "JccfNonSharedSavingAmt": -168500,
      "JccfOpenCommitment": null,
      "JccfOrigBillBudgAmt": 168500,
      "JccfOrigCostBudgAmt": 168500,
      "JccfOrigCostBudgQty": 1,
      "JccfOrigCostProjPhsQty": 0,
      "JccfOrigProjCostQty": 0,
      "JccfOvrdAutoClearFlag": "N",
      "JccfPciRiskCostAmt": 0,
      "JccfPciRiskRevAmt": 0,
      "JccfPciRiskWipCostAmt": 0,
      "JccfPciRiskWipRevAmt": 0,
      "JccfPciToCompleteCostAmt": 0,
      "JccfPciWipToCompleteAmt": 0,
      "JccfPendChgOrdCostAmt": 0,
      "JccfPendChgOrdCostPhsQty": null,
      "JccfPendChgOrdCostQty": null,
      "JccfPendIntChgOrdCostAmt": 0,
      "JccfPendIntChgOrdCostQty": null,
      "JccfPendingChgOrdBillAmt": 0,
      "JccfPendingCoAmt": 0,
      "JccfPer": 6,
      "JccfPopupBillVar": -168500,
      "JccfPopupCostActualPerc": 17.21,
      "JccfPopupCostActualRate": 0,
      "JccfPopupCostPrevPerRate": 0,
      "JccfPopupCostProjRate": 0,
      "JccfPopupCostRate": 168500,
      "JccfPopupCostToCompleRate": 0,
      "JccfPopupCostVar": 0,
      "JccfPopupPrevPerBillVar": 0,
      "JccfPopupPrevPerCostVar": 0,
      "JccfPopupPrevPerUnitVar": 0,
      "JccfPopupQtyActualPerc": 0,
      "JccfPopupQtyToComplePerc": 0,
      "JccfPopupRevActualPerc": 0,
      "JccfPopupRevActualRate": 0,
      "JccfPopupRevPrevPerRate": 0,
      "JccfPopupRevProjRate": 0,
      "JccfPopupRevRate": 168500,
      "JccfPopupRevToCompleRate": 0,
      "JccfPopupToComplQty": 0,
      "JccfPopupUnitVar": -1,
      "JccfPrevPerChgAmt": 0,
      "JccfPrevPerCommAmt": 0,
      "JccfPrevPerCostAmt": 0,
      "JccfPrevPerFcastAmt": 168500,
      "JccfPrevPerOvrdFlg": "N",
      "JccfPrevPerProjBillAmt": 0,
      "JccfPrevPerProjCostQty": 0,
      "JccfPrevPerProjPhsQty": 0,
      "JccfProductivityOverride": null,
      "JccfProfitInclShardSaving": -168500,
      "JccfProjBillBudgAmt": 168500,
      "JccfProjBillQty": null,
      "JccfProjBudgRiskAmt": 168500,
      "JccfProjCostBudgAmt": 168500,
      "JccfProjCostBudgPhsQty": 0,
      "JccfProjCostBudgQty": 1,
      "JccfProjCostQty": 0,
      "JccfProjFcastCostAmtCalc": 168500,
      "JccfProjForecastCostAmt": 168500,
      "JccfProjForecastDfltAmt": 168500,
      "JccfProjectedProfit": -168500,
      "JccfRateOverrideAmt": null,
      "JccfRemLabProj": null,
      "JccfRemainToBillAmt": 0,
      "JccfRevenueVarianceAmt": 168500,
      "JccfRuleCode": null,
      "JccfSharedSavingAmt": 0,
      "JccfSharedSavingFlag": "N",
      "JccfSharedSavingPct": 0,
      "JccfSpentPc": 17.211,
      "JccfStoredCurrCostBudgAmt": null,
      "JccfSysDfltCostToCmplAmt": null,
      "JccfTimePhasedFlag": "N",
      "JccfToComplCostOvrrdeFlag": "N",
      "JccfToCompleteCostAmt": 139500,
      "JccfTrendAdj": null,
      "JccfTrendadjNotes": null,
      "JccfUnbilledRevAmt": 0,
      "JccfWbsPciAmt": 0,
      "JccfWipFcastRevAmt": 0,
      "JccfWipFcastRevQty": 0,
      "JccfWipPendIntChgOrdAmt": 0,
      "JccfWipPendIntTrnChgAmt": 0,
      "JccfWipProjForecastAmt": 168500,
      "JccfWipToComplCostAmt": 139500,
      "JccfYr": 2021,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/jc-rest-api/rest/1/jccontforecastarch/00060000000A323032312D30372D32310000000731353434302E530000000330303100000005313430303200000002C10700000003C21516",
          "name": "jccontforecastarch",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/jc-rest-api/rest/1/jccontforecastarch/00060000000A323032312D30372D32310000000731353434302E530000000330303100000005313430303200000002C10700000003C21516",
          "name": "jccontforecastarch",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 98,
  "count": 1,
  "hasMore": true,
  "limit": 1,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/jc-rest-api/rest/1/jccontforecastarch",
      "name": "jccontforecastarch",
      "kind": "collection"
    }
  ]
}
object