Data types are relevant to you if you exchange data with TB.One via XML or CSV. Most data fields take one specific data type.
The descriptions of the files used for data exchange list a data type for each field. You may come across the following data types:
DATA TYPE |
DESCRIPTION |
|---|---|
CHAR(XY) |
To simplify the guides, all text fields are labelled as CHAR. In the XSD files describing the TB.Cat (1.2/1.4) or TB.Order XML, these fields may also be defined as TEXT or STRING. The data type CHAR(XY) generally takes letters, numbers, or special characters. The number in brackets shows how many characters the field may contain in total. If no number is provided, the length of the text is not limited. |
DATE YYYY-MM-DD |
A hyphenated date in the format "year-month-day", e.g. "2022-01-30". |
DATE (UTC) |
A date that contains information about the time zone. If the time zone is UTC, add the letter "Z" after the date. For other time zones, indicate the time difference (+/-) to UTC in hours. Format the date as follows: "yyyy-mm-dd-hh:mm", "yyyy-mm-dd+hh:mm", or "yyyy-mm-ddZ". Examples: "2021-09-24-06:00", "2021-09-24+06:00", "2021-09-24Z". |
DATETIME |
Date and time in the format "yyyy-mm-ddThh:mm:ss", e.g. "2021-10-19T22:07:21". |
FLOAT |
A floating point number with up to seven digits. |
INT(X/Y) |
Only integer values may be provided for this field. Numbers in brackets either indicate the allowed values for the field or the integer's maximum length. The actual meanings of the integers are detailed in the descriptions of respective data fields. |
XML |
This data type only appears in XMLs. It means that the node in question does not directly contain any values. It is a parent node and is expected to contain subordinate XML nodes. |
ENUM |
This data type only appears in XMLs. It means that the corresponding node/XML attribute must contain one of a fixed group of values. Generally, ENUM is used in the "identifier" attribute and contains the possible values "key" and "name". |