Field Types supported by the record editor


Id Type Name Description
0 Char Text Field
1 Char (right justified) Right Justified Text Field
2 Char Null terminated Character String that is terminated by nul (0h). C-style string.
3 Char Null padded Character String that is null padded on the right
4 Hex Hex Field (max length 8 bytes).
5 Num (Left Justified) Left justified numeric field
6 Num (Right Justified space padded) Right Justified space padded Numeric field
7 Num (Right Justified zero padded) Right Justified zero padded Numeric field
8 Num Assumed Decimal (Zero padded) Right Justified zero padded Numeric field with an assumed Decimal space
9 Num Sign Separate Leading Numeric Sign separate from the field and at the front.
10 Num Sign Separate Trailing Numeric Sign separate from the field and at the end of the field.
11 Decimal Unsigned Decimal (i.e. 121 is represented as hex x'0121'
15 Binary Integer PC format (i.e. Low to High) Binary integer. A value of 255 is represented as hex x'FF00'.
16 Positive Binary Integer PC format positive Integer
17 Float Standard Floating point number
18 Double Standard Double
21 Bit Show the individual bits.
31 Mainframe Packed Decimal (comp-3) Mainframe packed decimal (Pic s9(#) comp-3 in mainframe Cobol). In this format, 255 would be stored as hex x'255F'
32 Mainframe Zoned Numeric Corresponds to Cobol PIC S999. on the mainframe.

The format dates to the Punch Card days when a fields sign was entered by over punching the last byte of a numeric field. This saved 1 byte per numeric field - big advantages in the 1960's.

35 Binary Integer Big Endian (Mainframe, AIX etc) Standard Java / Mainframe / Power PC /etc Binary Integer. The number of is stored as high to low format i.e. 255 is stored as hex x'00FF'.
41 Fujitsu Zoned Numeric Fujitsu Cobol Zoned Numeric
71 Date - Date Format is held in Parameter field (on the record Definition table).
72 Date - Format YYMMDD
73 Date - Format YYYYMMDD
74 Date - Format DDMMYY
75 Date - Format DDMMYYYY
110 Check Box True / Space
111 Checkbox Y/N for a Y/N field (ie Yes / No)
112 Checkbox T/F for a T/F field (ie True / False)
115 CSV array
116 XML Name Tag
117 Edit Multi Line field Display a text file that contains more than one line. It primarly for XML files.

Note: At this stage, the maximum editable size of all binary fields is 8 bytes.