biuan SAP® BUSINESS ONE SDK
API CSHS / Formatted Searches
CSHS - User-Defined Values Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormID KEY UNIQUEForm IDnVarChar
20
DETAILSYes
ItemIDFieldnVarChar
20
ColIDColumn IDnVarChar
20
-1
ActionTActionInt
0
1) Valid Values
2) Query
6
0
QueryIdQuery IDInt
11OUQR
Queries
IndexID KEY UNIQUEIndexInt
11
PRIMARYYes
RefreshRefreshVarChar
Y) Yes
N) No
1
N
FieldIDFieldnVarChar
20
FrceRfrshForce RefreshVarChar
Y) Yes
N) No
1
N
ByFieldBy FieldVarChar
Y) When Field Changes
N) When Exiting Altered Column
1
N

Table relationship map

SELECT statement

SELECT CSHS.FormID AS 'Form ID', CSHS.ItemID AS 'Field', CSHS.ColID AS 'Column ID', CSHS.ActionT AS 'Action', CSHS.QueryId AS 'Query ID', CSHS.IndexID AS 'Index', CSHS.Refresh AS 'Refresh', CSHS.FieldID AS 'Field', CSHS.FrceRfrsh AS 'Force Refresh', CSHS.ByField AS 'By Field' FROM CSHS AS CSHS

Related information


Formatted Searches FormattedSearches Object· Table: CSHS
The FormattedSearches object enables to assign a formatted search function to a specified field, so that SAP Business One users can enter values, originated by a pre-defined search process, to the field.  The formatted search is applicable...

CSHS SQL Table

Queries OUQR SQL Table



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