Difference between revisions of "Content Manager OnDemand Database Tables"
Jump to navigation
Jump to search
(Initial Edit for ARSAGFLD.) |
m (Added more examples, turned hex - char - descriptions into lists.) |
||
| Line 13: | Line 13: | ||
|Name||RPT_ID,CUST_NUM||String||The text name of the field. | |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 | |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|| | |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. | |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. | ||
| Line 23: | Line 26: | ||
|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_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 | |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. | |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. | |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. | |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|| | |Map_Field||NULL, -1, 0, 1, 25||NULL or Integer|| | ||
|} | |} | ||
Revision as of 14:49, 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.
|
| 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.
|
| 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 |