field name | data type | description |
---|---|---|
ttValueDate | date | |
tdValueDec | decimal | |
tiValueInt | integer | |
tcValueString | character | |
tcValueUsed | character | Describes which value field is used |
CustomField_ID | integer | |
StoredSearch_ID | integer | |
CustomFieldComponent | character | business component name |
CustomFieldFlexfieldSeq | integer | (unused) |
CustomFieldDescription | character | |
CustomFieldDataType | character | possible values: c (character) d (decimal) i (integer) l (logical) t (date) |
CustomFieldUIControlType | character | default control type when adding the field on a user interface |
CustomFieldDisplayFormat | character | progress style display format |
CustomFieldFieldName | character | field name in the class dataset |
CustomFieldValueListChoice | character | (unused) |
CustomFieldSideLabel | character | |
CustomFieldColumnLabel | character | |
CustomFieldDisplayLength | integer | maximum number of characters (or digits for numerics) in the field value |
CustomFieldPrecision | integer | maximum number of digits right of the decimal poiunt (decimal only) |
CustomFieldIsMandatory | logical | |
CustomFieldSSReturnField | character | Name of the return field, in case a lookup function is defined on the custom business field |
tcStoredSearchName | character | |
tcStoredSearchLookupReference | character | |
tcLookupType | character | |
LastModifiedDate | date | |
LastModifiedTime | integer | |
LastModifiedUser | character | |
QADC01 | character | unused QAD reserved field |
QADC02 | character | unused QAD reserved field |
QADT01 | date | unused QAD reserved field |
QADD01 | decimal(10) | unused QAD reserved field |
tc_Rowid | character | |
tc_ParentRowid | character | |
tc_Status | character |