RTransaction

Last updated
Save as PDF

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.
modified On	MODIFIED_ ON (DATE)		x			date	The date the expense, task, or invoice was voided.
primary Key	PRIMARY_ KEY (NUMBER)		x			int	The unique ID of the financial transaction.
short Description	SHORT_ DESCRIPTION (VARCHAR 2) (250)						Currently not used.
transaction Date	TRANSACT ION_DATE (DATE)	Date (Transactions block in Account)	x			date	The date the transaction took place.
transaction DetailList -->	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.