Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Variable TypeFormatDescriptionsSample
Date(YYYY-mm-dd)[Year, 4 Digits]-[Month, 2 digits]-[Day, 2 digits]
STRING
Separator by "-" character with year, month and day
Year needed to be 4 digits, month in 2 and day in 2
If month and day less than 10, "0" needed to be add in front
2020-03-17
VarChar(X)STRING, alphanumeric, general text with UTF-8 characters
With maximum X numbers characters. 
Beware of special characters like  
' single quote (apostrophe)
" double quote
\ Black slash
abc1 22h-as_sdasd1
Num(X)NUMBERS only, only digits are allow, 0 until 9.
With maximum X numbers of digits
Only digits are allow, but minus sign are acceptable.12353
Double(X.Y)FLOAT numbers with precision, in this case X can be any number.
Y represent number of precision support

Floating or double number use for amount, separator between X and Y
are the floating precision separator in this case "." (dot).
Minus sign supported BUT no thousand separator

81921.00
TextText in UTF-8 Format, no text limit, however in Linux server back-end,
we d have a 500,000 characters per POST variable
And full text

JHVSADUsa  hduasdgauyxg
SADsabcyaj asdas1231rw
DSADACBdyssd SADAS

XML General Reference

Useful link on w3schools => https://www.w3schools.com/xml/dom_nodes.asp

SymbolEHORS API Document FieldExample
<abcName>data123<abcName>#abcNameNode
<abcName egfAttribute="data123" />@efgAttributeNode attribute

<abcName>
    <xyzName>data123</xyzName>
</abcName>

#abcName/xyxNameSub-element with parent node #abcName