Difference between revisions of "Database Format"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 19: Line 19:
|
|
* The [[Record ID]] of a record in the target object.
* The [[Record ID]] of a record in the target object.
* ''Ex:'' 123A456B78
''Ex:'' 123A456B78


|-
|-

Revision as of 00:29, 23 August 2013

The database format is the format in which data is stored in the database.

Field Format
Date, DateTime, Date UTC Format
Currency, Number,
Number with Decimal, Percent
  • No currency symbol or percent sign
  • No grouping characters (e.g. commas) in whole-number portion
  • A decimal point (.) before fractional portion

Ex: 84954.32

Lookup
  • The Record ID of a record in the target object.

Ex: 123A456B78

Multi Object Lookup

Ex: 849Z:123A456B78

See also: User Format