project BLF > class BCustomField > business logic query GetCustomFieldsForTable

Description

CustomFieldsForTable


Parameters


icTableNamecharacter
icComponentNamecharacter


query condition


  each CustomField where
CustomField.CustomFieldFieldName begins icTableName + '.' AND
CustomField.CustomFieldComponent = icComponentName


query resultset tqCustomFieldsForTable


field namedata typedb fielddescription
tiCustomField_IDintegerCustomField.CustomField_IDRecord ID
tcCustomFieldColumnLabelcharacterCustomField.CustomFieldColumnLabelColumn Label
tcCustomFieldDataTypecharacterCustomField.CustomFieldDataTypepossible values:
c (character)
d (decimal)
i (integer)
l (logical)
t (date)
tcCustomFieldDescriptioncharacterCustomField.CustomFieldDescriptionDescription
tcCustomFieldDisplayFormatcharacterCustomField.CustomFieldDisplayFormatprogress style display format
tiCustomFieldDisplayLengthintegerCustomField.CustomFieldDisplayLengthmaximum number of characters (or digits for numerics) in the field value
tcCustomFieldFieldNamecharacterCustomField.CustomFieldFieldNamefield name in the class dataset
tlCustomFieldIsMandatorylogicalCustomField.CustomFieldIsMandatoryMandatory
tiCustomFieldPrecisionintegerCustomField.CustomFieldPrecisionmaximum number of digits right of the decimal poiunt (decimal only)
tcCustomFieldSideLabelcharacterCustomField.CustomFieldSideLabelSide Label
tcCustomFieldSSReturnFieldcharacterCustomField.CustomFieldSSReturnFieldName of the return field, in case a lookup function is defined on the custom business field
tcCustomFieldUIControlTypecharacterCustomField.CustomFieldUIControlTypedefault control type when adding the field on a user interface
tcCustomFieldValueListChoicecharacterCustomField.CustomFieldValueListChoice(unused)
tiStoredSearch_IDintegerCustomField.StoredSearch_IDStored Search


Internal usage


BLF
method business.CustomFields
method database.GetBusinessFields
method database.ValidateCustomFields
method database.XmlColumnDetail
method BResource.GetReportCBF
method breport.GetBusinessFields
method query.GetBusinessFields

QadFinancials
method BDebtor.ApiGetCustomFields
method Session.GetBusinessFieldsExtended