×
Menu
Index

Element Types

 

Introduction

Element Types gives you the opportunity to change the formatting of numbers, dates, etc. per Format Type. For every type of element (weight of a car, horsepower, length in meters, currency in 2 decimals or currency with no decimals, etc.) you can define an Element Type. For every defined Element Type you can enter a format string per Format Type.
 
For example:
Suppose you want to see the price Element Type in your backoffice without currency symbol and using a dot (.) as a decimal separator. But you want to see the same price Element Type on a quote using a currency symbol (for example €)  and using the target country's decimal separator, for example a comma (,). In that case you declare a Format Type Dutch Documents and a Format Type Backoffices. In case of the Backoffice, you can enter #.00 as a format string, in case of the Dutch Documents you can enter C (see example format strings below).
 

Name

The name of the Element Type, example Price.
 

Base Type

Element Base Type. Chose from:
 
None
 
No Base type. Is used for strings that can contain any value.
Alpha-numeric
 
Strings that contain only values from this list of characters: 0123456789ABZDEFGHIJKLMNOPQRSTUVWXYZ
Array
 
The element can contain a list of values. Every assignment of a value to this kind of elements, result in the addition of an element to the list.
Integer
 
The elementvalue is an integer.
Floating Point
 
The elementvalue is a floating point.
Currency
 
The elementvalue is currency.
Date
 
The elementvalue is a date.
Time
 
The elementvalue is a time.
 
 

Format examples

 
Characters
Description
Result
Numbers
 
 
00000
Number with 5 digits
15 becomes 00015
 
 
15,45 becomes 00015
#.00
Number with 2 decimals
15,4 becomes 15,40
 
 
 
Date
 
 
d
Short date
01-01-2010
(according to settings in Local Configuration)
D
Long date
Friday 1 january 2010
(according to settings in Local Configuration)
dd/MM/yyyy
custom format
01/01/2010
yyyyMMdd
custom format
20100101
 
 
 
Time
 
 
t
Short time
10:00 PM
(according to settings in Local Configuration)
T
Long time
10:00:00 PM
(according to settings in Local Configuration)
hh-mm-ss
custom format
10-00-00
 
 
 
Currency
 
 
C
Currency
€ 150,45
(according to settings in Local Configuration)
$ #.00
custom format
$ 150,45