Difference between revisions of "Database Format"

Revision as of 00:22, 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	An Object ID, to identify the target object, a colon, and a Record ID. Ex: 849Z:123A456B78

See also: User Format

@@ Line 3: / Line 3: @@
 :{| border="1" cellpadding="3"
 | '''''Field''''' || '''''Format'''''
 |-
 | '''Date, DateTime, Date''' || [[UTC Format]]
 |-
 | valign="top" | '''Currency, Number,<br>Number with Decimal, Percent'''
@@ Line 12: / Line 14: @@
 * 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'''
+|
+* An [[Object ID]], to identify the target object, a colon, and a [[Record ID]].
+''Ex:'' 849Z:123A456B78
 |}
 ''See also:'' [[User Format]]