Skip to main content

JournalTransaction

JournalTransactions. Represents a general ledger journal transaction.

type JournalTransaction {
  tranId: Int!
  branchId: Int!
  ledgerId: Int!
  batchNbr: String!
  tranType: String!
  accountId: Int!
  finPeriodId: String!
  tranDate: DateTime!
  refNbr: String
  lineNbr: Int!
  debitAmt: Decimal
  creditAmt: Decimal
  debitTotal: Decimal
  creditTotal: Decimal
  curyId: String! @deprecated
  currencyId: String!
  curyDebitAmt: Decimal
  curyCreditAmt: Decimal
  amount: Decimal @deprecated
  lineAmount: Decimal
  curyAmount: Decimal @deprecated
  lineCuryAmount: Decimal
  subaccountId: Int!
  tranDesc: String
  supplierId: Int
  customerId: Int
  uom: String
  inventoryId: Int
  projectId: Int
  taskId: Int
  attachments: [Attachment!]
  reclassBatchNbr: String
  isReclassReverse: Boolean!
  reclassSourceTranBatchNbr: String
  reclassSourceTranLineNbr: Int
  reclassSourceTranModule: String
  reconRefNbr: String
  reconDate: DateTime
  reconDescription: String
  releasedUserId: UUID
  reconHide: Boolean
  batchBranchId: Int!
  tranCode: String
  batchDescription: String
  autoReverse: Boolean
  autoReverseCopy: Boolean
  postedDateTime: DateTime
  quantity: Decimal!
  transactionCodeDescription: String
  lastModifiedDateTime: DateTime!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
  module(
    shortModule: Boolean = false
  ): String!
}

Fields​

JournalTransaction.tranId ● Int! non-null scalar​

tranId > The unique identifier of the DataMart TransactionId.

JournalTransaction.branchId ● Int! non-null scalar​

branchId > The unique identifier of the branch.

JournalTransaction.ledgerId ● Int! non-null scalar​

ledgerId > The unique identifier of the ledger. The ledger used for the batch.

JournalTransaction.batchNbr ● String! non-null scalar​

batchNbr > (PK) The unique identifier of the batch, generated by the numbering sequence assigned to batches.

JournalTransaction.tranType ● String! non-null scalar​

tranType > The type of this general ledger batch, which is specified by the system automatically.

JournalTransaction.accountId ● Int! non-null scalar​

accountId > The account (associated with the specified branch) whose balance will be updated by the journal entry.

JournalTransaction.finPeriodId ● String! non-null scalar​

finPeriodId > The financial period of the transaction.

JournalTransaction.tranDate ● DateTime! non-null scalar​

tranDate > The date when the batch was created, which relates to the transaction dates of the journal entries.

JournalTransaction.refNbr ● String scalar​

refNbr > The reference number of the external or internal document associated with the journal transaction.

JournalTransaction.lineNbr ● Int! non-null scalar​

lineNbr > (PK) Number that is indicating the line number of the record (JournalTransaction).

JournalTransaction.debitAmt ● Decimal scalar​

debitAmt > The debit amount of the journal entry.

JournalTransaction.creditAmt ● Decimal scalar​

creditAmt > The credit amount of the journal entry.

JournalTransaction.debitTotal ● Decimal scalar​

debitTotal > The total debit amount in currency for the document.

JournalTransaction.creditTotal ● Decimal scalar​

creditTotal > The total credit amount in currency for the document.

JournalTransaction.currencyId ● String! non-null scalar​

currencyId > The currency used for all the journal transactions in the selected batch.

JournalTransaction.curyDebitAmt ● Decimal scalar​

curyDebitAmt > Background calculation giving you the debit amount in your default currency. This field is applicable if the amount is given in another currency than your default.

JournalTransaction.curyCreditAmt ● Decimal scalar​

curyCreditAmt > Background calculation giving you the Credit amount in your default currency. This field is applicable if the amount is given in another currency than your default.

JournalTransaction.lineAmount ● Decimal scalar​

lineAmount > The line amount of the journal entry, lineAmount = debitAmt - creditAmt.

JournalTransaction.lineCuryAmount ● Decimal scalar​

lineCuryAmount > The line amount in currency for the journal entry, lineCuryAmount = curyDebitAmt - curyCreditAmt.

JournalTransaction.subaccountId ● Int! non-null scalar​

subaccountId > The unique identifier of the subaccount.

JournalTransaction.tranDesc ● String scalar​

tranDesc > A description of the transaction or any comments relevant to the transaction.

JournalTransaction.supplierId ● Int scalar​

supplierId > The supplier associated with the entry.

JournalTransaction.customerId ● Int scalar​

customerId > The customer associated with the entry.

JournalTransaction.uom ● String scalar​

uom > The unit of measurement / quantity of items associated with the transaction, if relevant.

JournalTransaction.inventoryId ● Int scalar​

inventoryId > The item Id of the line item, if applicable.

JournalTransaction.projectId ● Int scalar​

projectId > The project with which this batch is associated, or the code indicating that this batch is not associated with any project.

JournalTransaction.taskId ● Int scalar​

taskId > The particular task of the project with which this batch is associated.

JournalTransaction.attachments ● [Attachment!] list object​

attachments > Files that have been uploaded to this Journal Transaction.

JournalTransaction.reclassBatchNbr ● String scalar​

reclassBatchNbr > The created BatchNbr for the reclassification.

JournalTransaction.isReclassReverse ● Boolean! non-null scalar​

isReclassReverse > The reverse of the original transaction.

JournalTransaction.reclassSourceTranBatchNbr ● String scalar​

reclassSourceTranBatchNbr > The BatchNbr of the original transaction.

JournalTransaction.reclassSourceTranLineNbr ● Int scalar​

reclassSourceTranLineNbr > The LineNbr of the original transaction.

JournalTransaction.reclassSourceTranModule ● String scalar​

reclassSourceTranModule > The Module of the original transaction.

JournalTransaction.reconRefNbr ● String scalar​

reconRefNbr > The reference number of the reconciliation.

JournalTransaction.reconDate ● DateTime scalar​

reconDate > The date of the reconciliation.

JournalTransaction.reconDescription ● String scalar​

reconDescription > The description of the reconciliation.

JournalTransaction.releasedUserId ● UUID scalar​

releasedUserId > The user id that released the reconciliation transaction.

JournalTransaction.reconHide ● Boolean scalar​

reconHide > Indicates whether the reconciliation is hidden.

JournalTransaction.batchBranchId ● Int! non-null scalar​

batchBranchId > The unique identifier of the branch associated with the batch.

JournalTransaction.tranCode ● String scalar​

tranCode > The transaction code.

JournalTransaction.batchDescription ● String scalar​

batchDescription > The description of the batch.

JournalTransaction.autoReverse ● Boolean scalar​

autoReverse > Indicates whether the transaction is automatically reversed.

JournalTransaction.autoReverseCopy ● Boolean scalar​

autoReverseCopy > Indicates whether the transaction is a copy of an automatically reversed transaction.

JournalTransaction.postedDateTime ● DateTime scalar​

postedDateTime > The date and time when the document was posted.

JournalTransaction.quantity ● Decimal! non-null scalar​

quantity > The quantity associated with the transaction (defaults to 0).

JournalTransaction.transactionCodeDescription ● String scalar​

transactionCodeDescription > Description of the transaction code.

JournalTransaction.lastModifiedDateTime ● DateTime! non-null scalar​

lastModifiedDateTime > The last modified date and time of the journal transaction.

JournalTransaction.companyId ● Int! non-null scalar​

companyId > (PK) The unique identifier of the company.

JournalTransaction.id ● String! non-null scalar​

id > The unique identifier of the document in DataMart.

JournalTransaction.createdInDataMartDateTime ● DateTime! non-null scalar​

createdInDataMartDateTime > The UTC DateTime when this document has been added to DataMart.

JournalTransaction.updatedInDataMartDateTime ● DateTime! non-null scalar​

updatedInDataMartDateTime > The UTC DateTime when this document has been updated in DataMart.

JournalTransaction.module ● String! non-null scalar​

module > (PK) The workspace where the batch originates. [ModuleGL, ModuleAP, ModuleAR, ModuleCA, ModuleCM, ModuleIN, ModuleSO, ModulePO, ModuleDR, ModuleFA, ModuleEP, ModulePM, ModuleTX, ModuleCR]

JournalTransaction.module.shortModule ● Boolean scalar​

Optional. If true, returns the abbreviated module code (e.g., 'AR'). Default is false for backward compatibility; future versions will default to true.

Show deprecated

Returned By​

journalTransactionById query ● journalTransactions query