Show/Hide Toolbars

RTransaction contains information about instances of complete financial transactions, usually comprised of smaller transactions across multiple accounts. This information includes the user who created the transaction and the transaction date. It also links to JTranDetail, which contains transaction details for particular accounts. This table represents the Transaction tab of an invoice record, which displays the entire transaction.

Object: RTransaction (R_TRANSACTION)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

createdBy-->

CREATED_BY_ID

(NUMBER)

 

x

x

YUser

object

8 The user who created the financial transaction.

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

 

 

createdOn

CREATED_ON

(DATE)

Created On

(Transactions block of Expense, Task or Invoice)

x

 

 

date

The date the transaction was created.

 

 

modifiedBy-->

MODIFIED_BY

(NUMBER)

 

x

x

YUser

object

8 The user who voided the expense, task, or invoice.

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

 

 

modifiedOn

MODIFIED_ON

(DATE)

 

x

 

 

date

The date the expense, task, or invoice was voided.

 

 

primaryKey

PRIMARY_KEY

(NUMBER)

 

x

 

 

int

The unique ID of the financial transaction.

 

 

shortDescription

SHORT_DESCRIPTION

(VARCHAR2) (250)

 

 

 

 

 

Currently not used.

 

 

transactionDate

TRANSACTION_DATE

(DATE)

Date

(Transactions block in Account)

x

 

 

date

The date the transaction took place.

 

 

transactionDetailList-->

n/a

 

x

x

JTranDetail

 

Links to the join table that contains information for all transaction details of this financial transaction.

 

 

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates how many times the transaction has been updated.

Note: The version is updated only when financial transactions are voided or re-posted.