| 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 |
QadFinancials