Data Types

Back to Qbyte Optix Logical Model

Attributes in the Optix Logical Model have data formats assigned to them. These formats are defaulted based on the data type of the attribute. For example an amount attribute will default to the NUMBER data type with its corresponding format. Another example is the accounting period which will default to the DATE_YEAR_MONTH format. Defaulting occurs based on the data type and for attributes suffixed with "Id" they will default to the ID type unless the ID type attribute is a string in which case it will default to STRING. Formatting can be overridden by locale. Currently these formats are used only on the summary listings (Cost Centre Summary, AFE Summary, Business Associate Summary and Voucher Summary) and generic detail reports (Organization Detail, etc).

Optix supports a number of different data types including the following:

Name	Data Type	Description	Default Format

Name	Data Type	Description	Default Format
DATE	DATE	Date
DATE_LONG	DATE	Date in Long Format	MMMM dd, yyyy
DATE_YEAR_MONTH	DATE	Date with Year and Month	MM yyyy
DATETIME	DATETIME	Date with Time
FLAG_YES_NO	MAP	Flag	N,No,Y,Yes
CURRENCY_0	NUMBER	Currency with no decimal	#,##0;(#,##0)
CURRENCY_2	NUMBER	Currency with 2 decimals	#,##0.00;(#,##0.00)
CURRENCY_TOTAL_0	NUMBER	Currency Totals with no decimal	$#,##0;($#,##0)
CURRENCY_TOTAL_2	NUMBER	Currency Totals with 2 decimal	$#,##0.00;($#,##0.00)
FACTOR_5	NUMBER	Factor with 5 decimals	#,##0.00000
FACTOR_8	NUMBER	Factor with 8 decimals	#,##0.00000000
ID	NUMBER	Identifier	###0
INTEGER	NUMBER	Integer	###0
NUMBER	NUMBER	Number
PERCENT_0	NUMBER	Percent with no decimal	###0
PERCENT_2	NUMBER	Percent with 2 decimals	###0.00
PERCENT_8	NUMBER	Percent with 8 decimals	###0.00000000
VOLUME_0	NUMBER	Volume with no decimal	#,##0;(#,##0)
VOLUME_1	NUMBER	Volume with 1 decimal	#,##0.0;(#,##0.0)
VOLUME_2	NUMBER	Volume with 2 decimals	#,##0.00;(#,##0.00)
VOLUME_4	NUMBER	Volume with 4 decimals	#,##0.0000;(#,##0.0000)
VOLUME_TOTAL_0	NUMBER	Total volume with no decimal	#,##0;(#,##0)
VOLUME_TOTAL_1	NUMBER	Total volume with 1 decimal	#,##0.0;(#,##0.0)
VOLUME_TOTAL_2	NUMBER	Total volume with 2 decimals	#,##0.00;(#,##0.00)
VOLUME_TOTAL_4	NUMBER	Total volume with 4 decimals	#,##0.0000;(#,##0.0000)
STRING	STRING	String
TIME	TIME	Time