|
|
API CSHS / / Formatted Searches
CSHS - User-Defined Values Table
Formatted Searches FormattedSearches Object· Table: CSHS
CSHS SQL Table
Queries OUQR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FormID KEY UNIQUE | Form ID | nVarChar | 20 | DETAILS | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemID | Field | nVarChar | 20 | |||||
| ColID | Column ID | nVarChar | 20 | -1 | ||||
| ActionT | Action | Int | 0 1) Valid Values 2) Query | 6 | 0 | |||
| QueryId | Query ID | Int | 11 | OUQR Queries | ||||
| IndexID KEY UNIQUE | Index | Int | 11 | PRIMARY | Yes | |||
| Refresh | Refresh | VarChar | Y) Yes N) No | 1 | N | |||
| FieldID | Field | nVarChar | 20 | |||||
| FrceRfrsh | Force Refresh | VarChar | Y) Yes N) No | 1 | N | |||
| ByField | By Field | VarChar | 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
FormattedSearches
Enumeration
Method
Object
UserValidValues CUVV
Property
Action
DB
ByField
DB
FieldID
DB
ForceRefresh
DB
FormID
DB
Index
DB
ItemID
DB
QueryID
DB
Refresh
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
