API Catalog

Create JC Transaction

01 Oct 2025
9 Minutes to read

Print
Dark
Light

Create JC Transaction

Updated on 01 Oct 2025
9 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

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.

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-01", "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

What's Next

Create JC Units Complete Transaction

Create JC Transaction

Overview

UI Navigation

Reference Article

Body Parameters (Jctranh)

Body Parameters (Jctrand)

What's Next

Contact Us