SupFieldDescription
Name: Supplemental Field Descriptions
Type: Application
Modules: Fx-Backup, Fx-TSEInterface, Shared-TpGnr, Exchange-DataImportLib, Exchange-GoogleExport, Exchange-PrestoInterface, Exchange-Tps, Fx-TransXChange, Info-Web, Info-Lookup, Legacy-Fx, Legacy-Shared, Map-AddrMatch, OPS-Lib, Reports
Description: Configuration information for supplementary data on various screens, including the label to be displayed and extended type information.
| Field | Documentation |
|---|---|
| TableName | Name of table for which the user-defined fields are given a label. Must be all capital letters. |
| FieldName | Placeholder name in the original table that are given a new label, e.g., UserString1. |
| Sequence | Order that the fields occur in the Trapeze 4 supplementary data grid. |
| FieldLabel | Name assigned by the user to the field. |
| FieldType | SQL type of field: 1= string, 8 = double, -15 = signed short, -16 = signed long int, -28 = unsigned tiny int. |
| ExtType | Extension type: 0 = None, 1 = Boolean value, 2 = longitude coordinate. 3 = latitude coordinate. 4 = Real-world x coordinate (meters from an origin point). 5 = Real-world y coordinate (meters from an origin point). 10 = timespan in seconds, 11 = timespan in minutes, 20 = time of day as seconds from midnight, 21 = time of day as minutes from midnight, 30 = date packed into a long number with value YYYYMMDD (standard CSchDate format), 40 = distance in meters, 41 = distance in kilometers, 42 = distance in miles, 43 = distance in feet, 44 = distance in yards, 50 = speed in kilometers per hour, 51 = speed in miles per hour, 52 = speed in meters per second, 60 = weekday (same values as defined in WEEKDAY enum), 70 = weekday template (same format as in CSchWeekdays), 80 = overtime rate, 81 = number of items, e.g., 3 oranges, 82 -percentage value stored as LONG to two decimal places (e.g., 99.5% stored as 9950), 83 = rank or ordering value 101 color reference, 102 = datasource name or connection string, 103 = filename, 104 = file path, 105 = image file, 106 = currency value (money), 250 = Combo box type. |
| SupValueTypeId | For Internal Use. |
| DefaultStrValue | Value set as the default for the field. |
| SupFieldAccess | Bitfield : 1 = write, 2 = hide, 4 = required, 16 = pass enabled, 32 = mdt enabled |
| ScreenName | For Internal Use. |
| IsLink | Identifier (e.g., Division id) that is used to look up the abbreviation to display. |
| FieldStyle | Style identifier from SupFieldStyles.FieldStyle. |
| ExtFieldInfo | Available selections in the combo box for fields of extended type combo box. |