biuan SAP® BUSINESS ONE SDK
SQL Administration / Grid Filter Rules
DTW Inventory / Inventory Transactions / Goods Receipt
API GFL1
GFL1 - Grid Filter Rules Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormID KEY UNIQUEForm IDnVarChar
20
PRIMARYYes
GridIDGrid IDnVarChar
11
UserCodeUser CodeInt
6
FilterIDFilter IDInt
11
GridColumnGrid ColumnInt
6
FilterRuleFilterRuleInt
6
ValueValuenVarChar
127
ValueToValueTonVarChar
127

SELECT statement

SELECT GFL1.FormID AS 'Form ID', GFL1.GridID AS 'Grid ID', GFL1.UserCode AS 'User Code', GFL1.FilterID AS 'Filter ID', GFL1.GridColumn AS 'Grid Column', GFL1.FilterRule AS 'FilterRule', GFL1.Value AS 'Value', GFL1.ValueTo AS 'ValueTo' FROM GFL1 AS GFL1

Related information
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates