Difference between revisions of "Content Manager OnDemand Database Tables"

From CMOD.wiki
Jump to navigation Jump to search
m (Added more examples, turned hex - char - descriptions into lists.)
(Addition of arsagfld.mask table.)
Line 38: Line 38:
|-
|-
|Map_Field||NULL, -1, 0, 1, 25||NULL or Integer||
|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:
{| class="wikitable"
|-
!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||
|-
|}
|}

Revision as of 16:30, 30 May 2016

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
Retrieved from "https://CMOD.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables&oldid=347"