JAcctTransactionDetail
JAcctTransactionDetail contains all information about Account Transaction Detail.
Object: JAcctTransactionDetail (J_ACCT_TRANSACTION_DETAIL)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
---|---|---|---|---|---|---|---|
Account Id | ACCOUNT_ID | TAccount | NUMBER | Account Id | |||
Account Trans Id | ACCOUNT_TRANS_ID | NUMBER | Account Trans Id | ||||
Object Id | OBJECT_ID | JAcctTransaction | NUMBER | Object Id | |||
Primary Key | PRIMARY_KEY | NUMBER | Primary Key | ||||
Short Description | SHORT_DESCRIPTION | NVARCHAR2(500) | Short Description | ||||
Status Type |
STATUS_TYPE | NUMBER | Status Type 1 - Allocated 2 - Used |
||||
Total Amount | TOTAL_AMOUNT | NUMBER | Total Amount | ||||
Transaction Unique Code | TRANS_UNIQUE_CODE | NVARCHAR2(8) | Transaction Unique Code | ||||
Version | VERSION | NUMBER | Version |