Skip to main content
Mitratech Success Center

JTranDetail

JTranDetail contains information about the transactions that have been posted against an account record. This information includes the account to which the transaction belongs, a short description, total amount, and whether the amount was deposited or withdrawn.

It also links to RTransaction, which contains the transaction to which the transaction detail belongs. This table represents the Transactions block on the Transactions tab of an account record.

Object: JTranDetail (J_TRAN_DETAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

account-->

ACCOUNT_ID
(NUMBER)

Account
(Transaction block of Expense, Invoice, or Task)

x

x

TAccount

object

8 The account to which the transaction detail belongs.

--> Links to specific information about the account record.

   

objectID

OBJECT_
ID (NUMBER)

Used to display the link to the associated record in the Transactions block.

x

   

int

The primary key of the record (such as an account, expense, or task record) with which the transaction detail is associated.

   

owner-->

ACCOUNT_TRANS_
ID (NUMBER)

   

x

RTransaction

object

The transaction to which this transaction detail belongs.

   

primary Key

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the transaction detail.

   

short
Description

SHORT_
DESCRIPTION (VARCHAR2) (250)

Name (Transactions block, Account)

x

   

string (250)

Specifies the name of the financial transaction. Depending on the object, the short description is equal to one of the following:

  • Description of the transfer, deposit, withdrawal, or expense
  • Task subject
  • Invoice number and line item type (task or expense) if it is posted
   

statusType
IID

STATUS_
TYPE_IID 

(NUMBER)

 

x

   

int

Indicates whether the amount was deposited to the account or withdrawn from the account.

  1. Deposit
  2. Withdraw
   

total
Amount

TOTAL_
AMOUNT 

(NUMBER)

One of the following:

 

  • Amount (Transactions block of Expense, Invoice, or Task)
  • Debit/
    Credit (Account Transactions block)

x

   

decimal

The total amount that was deposited, withdrawn, transferred, posted or voided from/to the account.

   

unique
Code

TRANS_
UNIQUE_
CODE (VARCHAR2) (4)

Used in conjunctio n with objectID to display the link to the associate d record in the
Transactions block.

x

   

string (4)

The 4-character unique code of the object to which the record associated with the transaction detail belongs.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the transaction detail was updated.

   
  • Was this article helpful?