arsagfld - Application Group Fields Table
This table contains a list of all of the fields defined in CMOD Application Groups.
| Field |
Sample Values |
Type |
Description
|
| AGID |
5001, 5357, 3525 |
Integer |
Specifies the Application Group that the fields are related to. Relates to ARSAG.AGID.
|
| Field |
0,1,2,3,4,5 |
Integer |
Sequential number representing the field number, starting at 0.
|
| Name |
RPT_ID,CUST_NUM |
String |
The text name of the field.
|
| Type |
x'49', x'53', x'62' |
HexChar |
The hex values represent single-byte characters which describe a field type.
- x'49' = "I" = Integer
- x'53' = "S" = String
- x'62' = "b" = Database Internal Date
|
| Qual |
x'42', x'44' |
HexChar |
x'42 = "B", x'44' = "D"
|
| Mask |
1, 2, 32770 |
Integer |
This is a vectored field that stores the information in the field checkboxes in the Application Group Field Information Tab.
|
| String_Type |
x'00', x'46', x'56' |
HexChar |
The hex values represent single-byte characters which describe a string type.
|
| String_Len |
0, 1, 2, 5, 10, 60 |
Integer |
The length of the string field. '0' if the field is a date or numeric field like Integer or Float.
|
| String_Case |
x'4D', x'55' |
HexChar |
Represents a string field's case.
- x'4D' = "M" = Mixed
- x'55' = "U" = UPPER
- x'4C' = "L" = lower
|
| Leading |
$, #, <space>, - |
String |
A list of characters to remove from the FRONT of the string before inserting them into the database.
|
| Strip |
$, #, <space>, - |
String |
A list of characters to remove from ANYWHERE in the string before inserting them into the database.
|
| Trailing |
$, #, <space, -> |
String |
A list of characters to remove from the END of the string before inserting them into the database.
|
| Map_Field |
NULL, -1, 0, 1, 25 |
NULL or Integer |
|
arsagfld.mask
These are the values for this field. This field is a 'vectored' field. Checking the associated checkbox increases the value by the specified value below:
| Value |
Checkbox Name |
Description
|
| 1 |
|
| 2 |
|
| 4 |
|
| 8 |
|
| 16 |
|
| 32 |
Log |
Inserts the value of this field into the System Log for DocGets (retrievals) - message number 66
|
| 64 |
|
| 128 |
|
| 256 |
|
| 512 |
|
| 1024 |
|
| 2048 |
|
| 4096 |
|
| 8192 |
|
| 16384 |
|
| 327678 |
|