You can use the data type directory to store and manage a list of all possible data types for requisites that might appear in the electronic reporting templates. Data from this directory is used to verify report data.
Every data type includes the following parameters:
Type Name |
Description |
Processing Rules |
---|---|---|
string |
Line |
Any lines are valid. |
boolean |
Boolean |
Valid values: {true, false, 1, 0}. |
decimal |
Decimal |
Integers and fractions are valid. |
integer |
Integer |
Only integers are valid. |
long |
Integer |
Value range [-9223372036854775807; 9223372036854775808]. |
int |
Integer |
Value range [-2147483648; 2147483647]. |
short |
Integer |
Value range [-32768; 32767]. |
byte |
Integer |
Value range [-128; 127]. |
nonPositiveInteger |
Integer |
Value must be less than or equal to zero. |
nonNegativeInteger |
Integer |
Value must be greater than or equal to zero. |
unsignedLong |
Integer |
Value range [0; 18446744073709551615]. |
positiveInteger |
Integer |
Value must be greater than zero. |
unsignedInt |
Integer |
Value range [0; 4294967295]. |
unsignedShort |
Integer |
Value range [0; 65535]. |
unsignedByte |
Integer |
Value range [0; 255]. |
float |
Decimal |
Integers and fractions are valid. |
double |
Decimal |
Integers and fractions are valid. |
dateTime |
Date and time |
Must be in the following format: '-'? yyyy '-' mm '-' dd 'T' hh ':' mm ':' ss ('.' s+)? (zzzzzz)?, where: '-'? yyyy – year, must contain four characters '-' – sign is not required '-' – delimiter between date value parts mm – month, two characters md – day, two characters T – delimiter between date and time hh – hours, two characters ':' – delimiter between time value parts mm – minutes, two characters ss – seconds, two characters ('.' s+)? – milliseconds, optional value (zzzzzz)? – time zone code, optional value Example: 1999-01-01T13:20:21.12. |
time |
Time |
Must be in the following format: hh:mm:ss.sss, where: hh – hours, two characters mm – minutes, two characters ss – seconds, two characters sss – milliseconds, three characters Example: 13:20:21.233. |
date |
Day |
Must be in the following format: '-'? yyyy '-' mm '-' dd zzzzzz?, where: '-'? yyyy ' – four characters and minus sign (if required) mm – month, two characters dd – day, two characters zzzzzz? – time zone code, optional |
gYearMonth |
Year and month |
Must be in the following format: CCYY-MM, where: CCYY– year, four characters MM – month, two characters |
gYear |
Year |
Value range: [0001; 9999]. |
gMonthDay |
Day of the month |
Must be in the following format: mm-dd zzzzzz?, where: mm – month, two characters dd – day, two characters zzzzzz? – time zone code, optional |
gDay |
Day |
Must be in the following format: dd, where: dd – day, two characters |
gMonth |
Month |
Must be in the following format: mm, where: mm – month, two characters |
-
Click General ledger> Setup> Financial reports generator> Data typesto open the Extended data typesform.
-
Press CTRL+N to create a new line.
-
In the Extended data typefield, enter a unique identification for the data type.
-
In the Descriptionfield, enter the description for the data type.
-
In the Base typefield, select the base data type to be used in the XSD schema.
Note The XSD schema is the requisite used in XML formats for the element.
-
Click the Generaltab.
-
Select the Automatic creationcheck box to create the requisite automatically.
Note If this check box is not selected, the requisite is created manually.
-
In the Minimum lengthfield, enter the minimum value length of the requisite if the Base typeis String.
-
In the Maximum lengthfield, enter the maximum value length of the requisite if the Base typeis String.
-
In the String lengthfield, enter the string length of the requisite.
-
In the Number of digitsfield, enter the number of digits in a number if the Base typeis a number.
-
In the Number of decimalsfield, enter the number of decimals in a number if the Base typeis a number
-
In the Min exclusivefield, enter the minimum value of the requisite if the Base typeis integer.
-
In the Max exclusivefield, enter the maximum value of the requisite if the Base typeis integer.
Note For example, if the maximum value is 10, the valid value will be less than 10.
-
In the Min inclusivefield, enter the minimum value of the requisite if the Base typeis integer.
-
In the Max inclusivefield, enter the maximum value of the requisite if the Base typeis integer.
Note For example, if the maximum value is 10, the valid value will be less than or equal to 10.
-
Click the Templatestab, and then press CTRL+N to create a new line.
-
In the Templatefield, enter the templates that define the valid sequence of characters and numbers in a value.
-
Click the Valuestab, and then press CTRL+N to create a new line.
-
In the Valuefield, enter a value for the selected base type.
Note |
---|
Data types in a directory are created automatically when you refresh the structure in the Document Templatesform or when you transfer settings from one template to another. If necessary, you can also create a data type manually using the standard method. |