Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

code

CODE

(VARCHAR) (3)

Currency code

x

string (3)

The universal 3-digit code of the currency item.

createdBy-->

CREATED_BY_ID

(NUMBER)

x

x

YUser

object

8 The user who created the currency item.

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

createdOn

CREATED_ON

(DATE)

x

date

The date that the currency item was created.

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

x

x

YUser

object

8 The user who last modified the currency item.

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

modifiedOn

MODIFIED_ON

(DATE)

Last Modified On

x

date

The date that the currency item was modified.

name

NAME

(VARCHAR2) (50)

Name

x

string (50)

The name of the currency item.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the currency item.

rate

RATE

(NUMBER)

Exchange Rate

x

decimal

The exchange rate of the currency item.

symbol

SYMBOL

(VARCHAR) (3)

Symbol

x

string (3)

The ISO symbol of the currency item.

version

VERSION

(NUMBER)

x

int

Indicates how many times the currency item was updated.