Currencies

Currency parameters may use the "currencyType" from the Oracle New Media Type. When used, this mandates an ISO4217 currency code. Example:

{

"value":21.99,

"currency":"GBP"

}

In all other cases, the currency data type will reflect a number data type with decimal precision as available in Simphony unless specified in the specifications for higher precision.

Dates

Dates that include only the date segment may be defined as a string, format = "date". Example:

"2017-03-07"

Date-Times

In line with the Oracle REST Standard, dates and times will be expressed only as RFC3339 dates or ISO 8601 dates. Both these formats mandate time zones where they include times.

Phone Number Prefixes

Translated String

The Translated String resource type is used for strings that can be translated into multiple languages, such as menu item name. A translated string contains key value pairs consisting of the language's culture key and the text that is used by the system when that language is active.

V1 example:

{ 
"en-US": "coffee", 
"es-ES": "cafe", 
"lt-LT": "kavos" 
}

V2 example:

{ 
  "1": "coffee", 
  "2": "cafe", 
  "3": "kavos" 
}

In some unique cases, when two languages have the same culture code, the API generates an error indicating the duplicate languages are not permitted.

Option String

Option Strings are used in many tables to efficiently store yes/no (enabled/disabled) settings. These settings are represented in arrays, whose values are only 1 or 0. The position of the 1 or 0 determines what option has been enabled or disabled for the record.

A very common example, found in menu item definitions, is the menu level settings, which look like this:

"mainLevel": "11111111",

In this case, there are 8 main levels, each represented by a single digit. Since each digit is a 1, this Option String indicates that all 8 menu levels are enabled. If only menu levels 1 and 7 are enabled, the values will look like this:

"mainLevel": "10000010",

The easiest way to way with the options is to first configure a sample record using the Enterprise Management Console (EMC) and then export the data after saving the record.

Some endpoints support the ability to provide more detailed information on the options' meaning by including the <field nam>Ext data, as can be seen in the highlighted portion of the Auto Menu Level object shown below:

{
	"hierUnitId": 2,
      "hierUnitObjNum": 1,
	"hierUnitName":{
		"en-US": "Location 1",
		"es-SS": ...,
		"lt=LT": ...,
		....
	},
	"index": 1,
	"start": "10:00",
	"end": "18:00",
	"mainLevelIndex": 1,
	"subLevelIndex": 1,
	"options": "10000000",
	"optionsExt": {
		"activeEntry": false,
		"activeOnSunday": false,
		"activeOnMonday": false,
		"activeOnTuesday": false,
		"activeOnWednesday": false,
		"activeOnThursday": false,
		"activeOnFriday": false,
		"activeOnSaturday": false,
	}
}

Pre-Delete Dependency Checks

Some objects support a pre-delete dependency check, which checks for foreign key references that will prevent a successful delete operation.

Language Codes

The following table lists supported languages with their localeID and localeKey values.