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