1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Content Manager OnDemand Database Tables (view source)
Revision as of 14:49, 30 May 2016
, 14:49, 30 May 2016Added more examples, turned hex - char - descriptions into lists.
(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|| | ||
|} | |} | ||