Create JC Transaction

  • Updated on Mar 2, 2026
  • Published on Feb 9, 2026
  • 9 minute(s) read
Prev Next
Post
/jc-rest-api/rest/1/jctran

Overview

The JCTRAN endpoint is used to facilitate the entry of Job Cost Transactions bypassing traditional sub-ledger modules such as Accounts Payable, Accounts Receivable, Subcontracts, Job Billing, and Payroll. This is particularly useful for recording transactions that originate outside these modules, ensuring that all job-related costs are accurately captured.

UI Navigation

Job Costing > Transactions > Enter Cost Transaction

Reference Article

https://docs.cmicglobal.com/portal/Content/E_Reference_Material/JC_-_Job_Costing/Reference/Processing_Job_Costs/EnterCostTransaction.htm

Body Parameters (Jctranh)

Object Name CMiC UI Fieldname Description Type Size Example Required
jctranh JcthCompCode Company Code Identifies the company for the transaction string 8 1001 Yes
jctranh JcthDate Transaction Date Date when the transaction was recorded 2025-02-19 Yes
jctranh JcthPost Posted Status Indicates if the transaction is posted string 80 Y / N Yes
jctranh JcthCompName Company Name Name of the company string 30 ABC Construction No
jctranh JcthBchTypeCode Batch Type Type of transaction batch (e.g., B, C) string 1 B / C No
jctranh JcthBchNum Batch Number Unique identifier for the batch number 11 12345 No
jctranh JcthBchName Batch Name Descriptive name of the batch string 60 January Payroll No
jctranh JcthJourCode Journal Code Code representing the journal type string 2 JC No
jctranh JcthJourName Journal Name Name of the journal string 30 Job Cost Journal No
jctranh JcthNum Transaction Number Unique identifier for the transaction number 11 9876533 No
jctranh JcthCurrCode Currency Code Code of the currency used string 3 USD No
jctranh JcthCurrName Currency Name Name of the currency string 30 US Dollar No
jctranh JcthAccrualFlag Accrual Flag Indicates if the transaction is accrual-based string 1 N No
jctranh JcthUser User User who created the transaction string 30 DA No
jctranh JcthDateTimeEntry Entry Date/Time Timestamp of when the transaction was entered date 2023-10-19T13:20:58-04:00 No
jctranh JcthDesc Description Description of the transaction string 60 Equipment rental No
jctranh JcthDefSrcCode Source Code Default source code of the transaction string 16 SRC001 No
jctranh JcthDefSrcDesc Source Description Description of the source string 30 Job Cost Entry No
jctranh JcthDefRefCode Reference Code Default reference code for the transaction string 25 REF123 No
jctranh JcthDefRefDesc Reference Description Description of the reference string 60 Invoice Payment No
jctranh JcthDefContCode Contract Code Default contract code for the transaction string 16 CONT5678 No
jctranh JcthDsrcCode DSRC Code Code for data source string 2 DS No
jctranh JcthAdjJcdetailFlag Adjustment Flag Indicates if adjustment was made string 1 Y No
jctranh JcthRefDate Reference Date Date related to the reference code 2025-19-02 No
jctranh JcthConvNum Conversion Number Number used in conversion calculations number 16 10000.5 No
jctranh JcthTransactionAmt Transaction Amount Total amount of the transaction bigdecimal 18 2500.75 No
jctranh JcthCalledFromAppCode Application Code Code of the application that called the transaction string 4 PMJS No
jctranh JcthVUuid Unique Identifier Unique identifier for the transaction string 64 Changes to Date No
jctranh JcthIuCreateDate Creation Date Date the transaction was created date 2023-10-19T13:20:58-04:00 No
jctranh JcthIuUpdateDate Update Date Date the transaction was updated date 2023-10-21T13:20:58-04:00 No

Body Parameters (Jctrand)

Object Name CMiC UI Fieldname Description Type Size Example Required
jctrand JctdCompCode Company Code Represents the company identifier. string 8 1001 No
jctrand JctdBchNum Batch Number Unique identifier for the transaction batch. number 11 12345 No
jctrand JctdNum Transaction Number Unique identifier for each transaction. number 11 98765 No
jctrand JctdTypeCode Type Code Specifies the type of transaction. string 1 J / G Yes
jctrand JctdJobCode Job Code Identifier for the job associated with the transaction. string 10 JOB123 No
jctrand JctdJobName Job Name The name of the job associated with the transaction. string 60 Office Renovation No
jctrand JctdJobCtrlCode Job Control Code Code used to control job-related processing. string 10 CTRL01 No
jctrand JctdPhsCode Phase Code Identifier for the specific phase of the job. string 16 PHASE01 No
jctrand JctdPhsName Phase Name The name of the phase within the job. string 50 Foundation No
jctrand JctdPhsCtrlCode Phase Control Code Control code for the phase. string 16 CTRL02 No
jctrand JctdCatCode Job Category Code Represents the category of the job. string 16 CAT001 No
jctrand JctdCatCtrlCode Category Control Code Control code for the job category. string 16 CATCTRL No
jctrand JctdDeptCode Department Code Department responsible for the transaction. string 6 DEPT10 No
jctrand JctdAccCode Account Code Account associated with the transaction. string 16 ACC987 No
jctrand JctdUnit Unit Quantity or measurement associated with the transaction. number (12,4) 150.25 No
jctrand JctdWmCode WM Code Code representing work management. string 2 HR No
jctrand JctdSrcCode Employee Code Code representing the employee involved in the transaction. string 16 EMP1234 No
jctrand JctdTranType Transaction Type Indicates the type of transaction performed. string 1 T No
jctrand JctdDebitAmt Debit Amount Amount debited in the transaction. number (18,2) 5000.75 No
jctrand JctdCreditAmt Credit Amount Amount credited in the transaction. number (18,2) 5000.75 No
jctrand JctdSrcCode2 Employee Trade Code Code representing the trade of the employee. string 16 TRD456 No
jctrand JctdSrcCode3 Transaction Code Hour Type for the Transaction string 16 NWHR No
jctrand JctdSrcDesc3 Transaction Description Description of the transaction. string 30 Normal Hours No
jctrand JctdDsrcDescription Transaction Source Desc. Detailed description of the transaction source. string 120 Test Entry No
jctrand JctdVUuid Unique UUID of Row Universally unique identifier for the row. string 64 Changes to Date No
jctrand JctdJcthVUuid Link to JCTRANH Table Represents the JCTH_V_UUID. string 64 Changes to Date No
jctrand JctdUnionCode Union Code Code representing the union involved in the transaction. string 4 UNION No
jctrand JctdPyTranType Payroll Tran Type Type of payroll transaction. string 2 BW No
jctrand JctdPyTranDesc Payroll Tran Description Description of the payroll transaction. string 30 Basic Wage No
jctrand JctdDsrcCode Transaction Source Code representing the source of the transaction. string 16 SRC999 No
jctrand JctdBillRateTypeCode Bill Rate Type Code Indicates the rate type, e.g., 'R' for Rate. string 1 R No
jctrand JctdShiftCode Shift Code Code representing the shift associated with the transaction. string 2 S2 No
jctrand JctdBurdenFlag Burden Flag Burden Flag (Y/N) string 1 N No
jctrand JctdRefCode Reference Code Represents the Pay run Code string 25 PR12 No
jctrand JctdRefDesc Reference Description Description of the Pay run code string 60 Payroll Run No
jctrand JctdOverrideTradeCode Override Trade Code Represents the trade code override string 4 TT No
Security
HTTP
Type basic

Basic authentication

Header parameters
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourceitem+json
Body parameters
object
Example{ "JcthCompCode": "ZZ", "JcthBchTypeCode": "C", "JcthDate": "2025-02-19", "JcthJourCode": "JC", "JcthPost": "N", "JcthVUuid": "1", "JctrandViewObj": [ { "JctdUserTypeCode": "J", "JctdCompCode": "ALT", "JctdJobCode": "ALJ100", "JctdCatCode": "2000", "JctdPhsCode": "0100-01-01T00:00:00Z", "JctdWmCode": "$", "JctdDebitAmt": "10", "JctdCreditAmt": "" }, { "JctdUserTypeCode": "G", "JctdCompCode": "ALT", "JctdAccCode": "6900.PAYROLL_TAX", "JctdDeptCode": "30", "JctdDebitAmt": "", "JctdCreditAmt": "10" } ] }
Responses
201

Created

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

Successful Response

{
  "JcthCompCode": "001",
  "JcthCompName": null,
  "JcthBchTypeCode": "C",
  "JcthBchNum": 4461335,
  "JcthBchName": "RTIJCDETAIL2023-01-23",
  "JcthJourCode": "JC",
  "JcthJourName": null,
  "JcthNum": 3001119,
  "JcthCurrCode": null,
  "JcthCurrName": null,
  "JcthAccrualFlag": "N",
  "JcthUser": null,
  "JcthDate": "2022-12-20",
  "JcthDateTimeEntry": "2023-01-23",
  "JcthDesc": null,
  "JcthDefSrcCode": null,
  "JcthDefSrcDesc": null,
  "JcthDefRefCode": null,
  "JcthDefRefDesc": null,
  "JcthDefContCode": "N",
  "JcthDsrcCode": null,
  "JcthAdjJcdetailFlag": "N",
  "JcthRefDate": null,
  "JcthConvNum": 1,
  "JcthTransactionAmt": null,
  "JcthCalledFromAppCode": "JC",
  "JcthVUuid": "F2F020D31C113255E05316821FAC577A",
  "JcthPost": "N",
  "JcthIuCreateDate": null,
  "JcthIuUpdateDate": null,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jctran/F2F020D31C113255E05316821FAC577A",
      "name": "jctran",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jctran/F2F020D31C113255E05316821FAC577A",
      "name": "jctran",
      "kind": "item"
    },
    {
      "rel": "child",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jctran/F2F020D31C113255E05316821FAC577A/child/JctrandViewObj",
      "name": "JctrandViewObj",
      "kind": "collection"
    }
  ]
}
example-1

Successful Response

{
  "JcthCompCode": "ZZ",
  "JcthCompName": null,
  "JcthBchTypeCode": "C",
  "JcthBchNum": 96404,
  "JcthBchName": "RTIJCDETAIL2024-11-28",
  "JcthJourCode": "JC",
  "JcthJourName": null,
  "JcthNum": 57843,
  "JcthCurrCode": null,
  "JcthCurrName": null,
  "JcthAccrualFlag": "N",
  "JcthUser": null,
  "JcthDate": "2024-11-30",
  "JcthDateTimeEntry": "2024-11-28",
  "JcthDesc": null,
  "JcthDefSrcCode": null,
  "JcthDefSrcDesc": null,
  "JcthDefRefCode": null,
  "JcthDefRefDesc": null,
  "JcthDefContCode": "N",
  "JcthDsrcCode": null,
  "JcthAdjJcdetailFlag": "N",
  "JcthRefDate": null,
  "JcthConvNum": null,
  "JcthTransactionAmt": null,
  "JcthCalledFromAppCode": "JC",
  "JcthVUuid": "27FE3EA8A3472330E06327261DAC17A3",
  "JcthPost": "N",
  "JcthIuCreateDate": null,
  "JcthIuUpdateDate": null,
  "links": [
    {
      "rel": "self",
      "href": "https://qamob.cmicpaas.com:443/cmicqadaily/jc-rest-api/rest/1/jctran/27FE3EA8A3472330E06327261DAC17A3",
      "name": "jctran",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "https://qamob.cmicpaas.com:443/cmicqadaily/jc-rest-api/rest/1/jctran/27FE3EA8A3472330E06327261DAC17A3",
      "name": "jctran",
      "kind": "item"
    },
    {
      "rel": "child",
      "href": "https://qamob.cmicpaas.com:443/cmicqadaily/jc-rest-api/rest/1/jctran/27FE3EA8A3472330E06327261DAC17A3/child/JctrandViewObj",
      "name": "JctrandViewObj",
      "kind": "collection"
    }
  ]
}
example-2

Successful Response

{
  "items": [
    {
      "JcthCompCode": "113344",
      "JcthCompName": "TestME",
      "JcthBchTypeCode": "B",
      "JcthBchNum": 37555,
      "JcthBchName": "DENIS 2020-01-29 B",
      "JcthJourCode": "PY",
      "JcthJourName": "Payroll",
      "JcthNum": 28733,
      "JcthCurrCode": "US",
      "JcthCurrName": "US Dollars",
      "JcthAccrualFlag": "N",
      "JcthUser": "WALID",
      "JcthDate": "2020-05-05",
      "JcthDateTimeEntry": "2020-05-05T18:32:56Z",
      "JcthDesc": null,
      "JcthDefSrcCode": null,
      "JcthDefSrcDesc": null,
      "JcthDefRefCode": null,
      "JcthDefRefDesc": null,
      "JcthDefContCode": null,
      "JcthDsrcCode": null,
      "JcthAdjJcdetailFlag": "N",
      "JcthRefDate": "2020-05-05",
      "JcthConvNum": 1,
      "JcthTransactionAmt": null,
      "JcthCalledFromAppCode": "JC",
      "JcthVUuid": "B0A0AE07C4BD9907E053508010ACAADF",
      "JcthPost": null,
      "JcthIuCreateDate": "2020-05-05T18:32:56Z",
      "JcthIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B0A0AE07C4BD9907E053508010ACAADF",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B0A0AE07C4BD9907E053508010ACAADF",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "child",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B0A0AE07C4BD9907E053508010ACAADF/child/JctrandViewObj",
          "name": "JctrandViewObj",
          "kind": "collection"
        }
      ]
    },
    {
      "JcthCompCode": "17",
      "JcthCompName": "Sewer Construction Group",
      "JcthBchTypeCode": "C",
      "JcthBchNum": 11327,
      "JcthBchName": "GORD 2013-04-23 C",
      "JcthJourCode": "JC",
      "JcthJourName": "Job Costing",
      "JcthNum": 33428,
      "JcthCurrCode": "US",
      "JcthCurrName": "US Dollars",
      "JcthAccrualFlag": "N",
      "JcthUser": "DA",
      "JcthDate": "2020-12-08",
      "JcthDateTimeEntry": "2020-12-08T21:46:04Z",
      "JcthDesc": null,
      "JcthDefSrcCode": null,
      "JcthDefSrcDesc": null,
      "JcthDefRefCode": null,
      "JcthDefRefDesc": null,
      "JcthDefContCode": null,
      "JcthDsrcCode": null,
      "JcthAdjJcdetailFlag": "N",
      "JcthRefDate": "2020-12-08",
      "JcthConvNum": 1,
      "JcthTransactionAmt": null,
      "JcthCalledFromAppCode": "JC",
      "JcthVUuid": "B5FBDE994D168618E053508010AC71FC",
      "JcthPost": null,
      "JcthIuCreateDate": "2020-12-08T21:46:04Z",
      "JcthIuUpdateDate": "2023-09-28T18:05:58Z",
      "links": [
        {
          "rel": "self",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B5FBDE994D168618E053508010AC71FC",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B5FBDE994D168618E053508010AC71FC",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "child",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B5FBDE994D168618E053508010AC71FC/child/JctrandViewObj",
          "name": "JctrandViewObj",
          "kind": "collection"
        }
      ]
    },
    {
      "JcthCompCode": "17",
      "JcthCompName": "Sewer Construction Group",
      "JcthBchTypeCode": "C",
      "JcthBchNum": 48025,
      "JcthBchName": "LOUI 2021-01-05 C",
      "JcthJourCode": "JC",
      "JcthJourName": "Job Costing",
      "JcthNum": 33806,
      "JcthCurrCode": "US",
      "JcthCurrName": "US Dollars",
      "JcthAccrualFlag": "N",
      "JcthUser": "LOUI",
      "JcthDate": "2020-12-31",
      "JcthDateTimeEntry": "2021-01-05T21:56:43Z",
      "JcthDesc": null,
      "JcthDefSrcCode": null,
      "JcthDefSrcDesc": null,
      "JcthDefRefCode": "TEST",
      "JcthDefRefDesc": "test",
      "JcthDefContCode": null,
      "JcthDsrcCode": null,
      "JcthAdjJcdetailFlag": "N",
      "JcthRefDate": "2021-01-05",
      "JcthConvNum": 1,
      "JcthTransactionAmt": null,
      "JcthCalledFromAppCode": "JC",
      "JcthVUuid": "B82F2F1617E51184E053508010ACE7E7",
      "JcthPost": null,
      "JcthIuCreateDate": "2021-01-05T21:56:43Z",
      "JcthIuUpdateDate": "2021-01-05T21:59:47Z",
      "links": [
        {
          "rel": "self",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B82F2F1617E51184E053508010ACE7E7",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B82F2F1617E51184E053508010ACE7E7",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "child",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B82F2F1617E51184E053508010ACE7E7/child/JctrandViewObj",
          "name": "JctrandViewObj",
          "kind": "collection"
        }
      ]
    },
    {
      "JcthCompCode": "17",
      "JcthCompName": "Sewer Construction Group",
      "JcthBchTypeCode": "C",
      "JcthBchNum": 48021,
      "JcthBchName": "LOUI 2021-01-05 C",
      "JcthJourCode": "JC",
      "JcthJourName": "Job Costing",
      "JcthNum": 33805,
      "JcthCurrCode": "US",
      "JcthCurrName": "US Dollars",
      "JcthAccrualFlag": "N",
      "JcthUser": "LOUI",
      "JcthDate": "2020-12-31",
      "JcthDateTimeEntry": "2021-01-05T21:55:36Z",
      "JcthDesc": null,
      "JcthDefSrcCode": null,
      "JcthDefSrcDesc": null,
      "JcthDefRefCode": "TEST",
      "JcthDefRefDesc": "test",
      "JcthDefContCode": null,
      "JcthDsrcCode": null,
      "JcthAdjJcdetailFlag": "N",
      "JcthRefDate": "2020-12-31",
      "JcthConvNum": 1,
      "JcthTransactionAmt": null,
      "JcthCalledFromAppCode": "JC",
      "JcthVUuid": "B82F2F1617E41184E053508010ACE7E7",
      "JcthPost": null,
      "JcthIuCreateDate": "2021-01-05T21:55:36Z",
      "JcthIuUpdateDate": "2023-09-28T18:05:38Z",
      "links": [
        {
          "rel": "self",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B82F2F1617E41184E053508010ACE7E7",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B82F2F1617E41184E053508010ACE7E7",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "child",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B82F2F1617E41184E053508010ACE7E7/child/JctrandViewObj",
          "name": "JctrandViewObj",
          "kind": "collection"
        }
      ]
    },
    {
      "JcthCompCode": "17",
      "JcthCompName": "Sewer Construction Group",
      "JcthBchTypeCode": "O",
      "JcthBchNum": 48094,
      "JcthBchName": "LOUI 2021-01-07 O",
      "JcthJourCode": "JC",
      "JcthJourName": "Job Costing",
      "JcthNum": 33842,
      "JcthCurrCode": "US",
      "JcthCurrName": "US Dollars",
      "JcthAccrualFlag": "N",
      "JcthUser": "LOUI",
      "JcthDate": "2020-12-31",
      "JcthDateTimeEntry": "2021-01-07T21:19:46Z",
      "JcthDesc": null,
      "JcthDefSrcCode": null,
      "JcthDefSrcDesc": null,
      "JcthDefRefCode": null,
      "JcthDefRefDesc": null,
      "JcthDefContCode": null,
      "JcthDsrcCode": null,
      "JcthAdjJcdetailFlag": "N",
      "JcthRefDate": "2021-01-07",
      "JcthConvNum": 1,
      "JcthTransactionAmt": null,
      "JcthCalledFromAppCode": "JC",
      "JcthVUuid": "B856CFAD725C0F20E053508010AC57B3",
      "JcthPost": null,
      "JcthIuCreateDate": "2021-01-07T21:19:46Z",
      "JcthIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B856CFAD725C0F20E053508010AC57B3",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B856CFAD725C0F20E053508010AC57B3",
          "name": "jctran",
          "kind": "item"
        },
        {
          "rel": "child",
          "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran/B856CFAD725C0F20E053508010AC57B3/child/JctrandViewObj",
          "name": "JctrandViewObj",
          "kind": "collection"
        }
      ]
    }
  ],
  "count": 5,
  "hasMore": true,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://127.0.0.1:7101/jc-rest-api/rest/1/jctran",
      "name": "jctran",
      "kind": "collection"
    }
  ]
}
object
Contact Us
Copyright © 2024 CMiC All Rights Reserved