Difference between revisions of "Database Format"

Latest revision as of 21:57, 9 September 2013

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

Field	Format
Date, DateTime, Time	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

@@ Line 1: / Line 1: @@
+<noinclude>
 The ''database format'' is the format in which data is stored in the database.
-:{| border="1" cellpadding="3" class="tight-rows"
+:''See also:'' [[User Format]]
-! Field !! Format
+</noinclude>
+:{| border="1" cellpadding="3"
+| '''''Field''''' || '''''Format'''''
 |-
-| Date, DateTime, Date || [[UTC Format]]
+| '''Date, DateTime, Time'''
+|
+* [[UTC Format]]
 |-
-|| Currency, Number, Number with Decimal, Percent
+| valign="top" | '''Currency, Number,<br>Number with Decimal,<br>Percent'''
 |
 * No currency symbol or percent sign
-* No grouping characters for whole number amounts
+* No grouping characters (e.g. commas) in whole-number portion
-* A decimal point (.) before fractional amounts
+* 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
 |}