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

  1. Click General ledger> Setup> Financial reports generator> Data typesto open the Extended data typesform.

  2. Press CTRL+N to create a new line.

  3. In the Extended data typefield, enter a unique identification for the data type.

  4. In the Descriptionfield, enter the description for the data type.

  5. In the Base typefield, select the base data type to be used in the XSD schema.

    Note Note

    The XSD schema is the requisite used in XML formats for the element.


  6. Click the Generaltab.

  7. Select the Automatic creationcheck box to create the requisite automatically.

    Note Note

    If this check box is not selected, the requisite is created manually.


  8. In the Minimum lengthfield, enter the minimum value length of the requisite if the Base typeis String.

  9. In the Maximum lengthfield, enter the maximum value length of the requisite if the Base typeis String.

  10. In the String lengthfield, enter the string length of the requisite.

  11. In the Number of digitsfield, enter the number of digits in a number if the Base typeis a number.

  12. In the Number of decimalsfield, enter the number of decimals in a number if the Base typeis a number

  13. In the Min exclusivefield, enter the minimum value of the requisite if the Base typeis integer.

  14. In the Max exclusivefield, enter the maximum value of the requisite if the Base typeis integer.

    Note Note

    For example, if the maximum value is 10, the valid value will be less than 10.


  15. In the Min inclusivefield, enter the minimum value of the requisite if the Base typeis integer.

  16. In the Max inclusivefield, enter the maximum value of the requisite if the Base typeis integer.

    Note Note

    For example, if the maximum value is 10, the valid value will be less than or equal to 10.


  17. Click the Templatestab, and then press CTRL+N to create a new line.

  18. In the Templatefield, enter the templates that define the valid sequence of characters and numbers in a value.

  19. Click the Valuestab, and then press CTRL+N to create a new line.

  20. In the Valuefield, enter a value for the selected base type.

Note 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.


See Also