JTranDetail
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 |
Account |
x |
x |
object |
8 The account to which the transaction detail belongs. --> Links to specific information about the account record. |
|||
objectID |
OBJECT_ |
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_ |
x |
object |
The transaction to which this transaction detail belongs. |
|||||
primary Key |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the transaction detail. |
|||||
short |
SHORT_ |
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:
|
||||
statusType |
STATUS_ |
x |
int |
Indicates whether the amount was deposited to the account or withdrawn from the account.
|
|||||
total |
TOTAL_ |
One of the following:
|
x |
decimal |
The total amount that was deposited, withdrawn, transferred, posted or voided from/to the account. |
||||
unique |
TRANS_ |
Used in conjunctio n with objectID to display the link to the associate d record in the |
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. |