Rules

ACCOUNT_ID
(NUMBER)

Account
(Transaction block of Expense, Invoice, or Task)

x

x

TAccount

object

8 The account to which the transaction detail belongs.

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

OBJECT_
ID (NUMBER)

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.

ACCOUNT_TRANS_
ID (NUMBER)

x

RTransaction

object

The transaction to which this transaction detail belongs.

PRIMARY_KEY (NUMBER)

x

int

The unique ID of the transaction detail.

SHORT_
DESCRIPTION (VARCHAR2) (250)

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:

• Description of the transfer, deposit, withdrawal, or expense
• Task subject
• Invoice number and line item type (task or expense) if it is posted

STATUS_
TYPE_IID 
(NUMBER)

x

int

Indicates whether the amount was deposited to the account or withdrawn from the account.

1. Deposit
2. Withdraw

TOTAL_
AMOUNT 
(NUMBER)

One of the following:

• Amount (Transactions block of Expense, Invoice, or Task)
• Debit/
  Credit (Account Transactions block)

x

decimal

The total amount that was deposited, withdrawn, transferred, posted or voided from/to the account.

TRANS_
UNIQUE_
CODE (VARCHAR2) (4)

Used in conjunctio n with objectID to display the link to the associate d record in the
Transactions block.

x

string (4)

The 4-character unique code of the object to which the record associated with the transaction detail belongs.

VERSION (NUMBER)

x

int

Indicates how many times the transaction detail was updated.