| CURRENCYSYMBOL |
nvarchar(4) |
|
Default = '' |
Character or characters used to represent the currency symbol (obsolete). |
| CURRENCYGROUPSEPARATOR |
nvarchar(4) |
|
Default = '' |
Character or characters used to separate groups of digits. |
| CURRENCYDECIMALSEPARATOR |
nvarchar(4) |
|
Default = '' |
Character or characters used to denote the decimal places of the number. |
| CURRENCYDECIMALDIGITS |
tinyint |
|
Default = 0 |
Number of digits used to represent the decimal portion of the number. |
| DATEFORMAT |
nvarchar(50) |
|
Default = '' |
Format in which date fields will be displayed when exported. |
| FUZZYDATEFORMAT |
nvarchar(50) |
|
Default = '' |
Format in which fuzzy date fields will be displayed when exported. |
| MONTHDAYFORMAT |
nvarchar(50) |
|
Default = '' |
Format in which month/day fields will be displayed when exported. |
| HOURMINUTEFORMAT |
nvarchar(50) |
|
Default = '' |
Format in which hour/minute fields will be displayed when exported. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| CURRENCYSYMBOLDISPLAYSETTINGCODE |
tinyint |
|
Default = 0 |
Indicates how currency symbol display should be handled. |
| CURRENCYSYMBOLDISPLAYSETTING |
nvarchar(20) (Computed) |
yes |
CASE [CURRENCYSYMBOLDISPLAYSETTINGCODE] WHEN 0 THEN N'Use currency setting' WHEN 1 THEN N'Display ISO code' WHEN 2 THEN N'Display symbol' WHEN 3 THEN N'Display no symbol' END |
Provides a translation for the 'CURRENCYSYMBOLDISPLAYSETTINGCODE' field. |
| CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE |
tinyint |
|
Default = 0 |
Indicates how the characters used to separate groups of digits should be handled. |
| CURRENCYGROUPSEPARATORDISPLAYSETTING |
nvarchar(21) (Computed) |
yes |
CASE [CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE] WHEN 0 THEN N'Use system setting' WHEN 1 THEN N'Display space' WHEN 2 THEN N'Display custom symbol' WHEN 3 THEN N'Display no symbol' END |
Provides a translation for the 'CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE' field. |
| CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE |
tinyint |
|
Default = 0 |
Indicates how the character or characters used to denote the decimal places of the value should be handled. |
| CURRENCYDECIMALSEPARATORDISPLAYSETTING |
nvarchar(21) (Computed) |
yes |
CASE [CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE] WHEN 0 THEN N'Use system setting' WHEN 1 THEN N'Display space' WHEN 2 THEN N'Display custom symbol' END |
Provides a translation for the 'CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE' field. |
| CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE |
tinyint |
|
Default = 0 |
Indicates how the number of digits used to represent the decimal portion of the value should be handled. |
| CURRENCYDECIMALDIGITSDISPLAYSETTING |
nvarchar(20) (Computed) |
yes |
CASE [CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE] WHEN 0 THEN N'Use currency setting' WHEN 1 THEN N'Use custom setting' END |
Provides a translation for the 'CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE' field. |
| CSVLINEBREAKCODE |
tinyint |
|
Default = 0 |
|
| CSVLINEBREAK |
nvarchar(9) (Computed) |
yes |
CASE [CSVLINEBREAKCODE] WHEN 0 THEN N'LF' WHEN 1 THEN N'CR' WHEN 2 THEN N'CRLF' WHEN 3 THEN N'Unchanged' END |
|