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

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

objectID

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.

owner-->

ACCOUNT_TRANS_ID

(NUMBER)

x

RTransaction

object

The transaction to which this transaction detail belongs.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the transaction detail.

shortDescription

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

statusTypeIID

STATUS_TYPE_IID

(NUMBER)

x

int

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

1 - Deposit

2 - Withdraw

totalAmount

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.

uniqueCode

TRANS_UNIQUE_CODE

(VARCHAR2) (4)

Used in conjunction with objectID to display the link to the associated 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

VERSION

(NUMBER)

x

int

Indicates how many times the transaction detail was updated.