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 |
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 |
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 |
|
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. |
|
|
