biuan SAP® BUSINESS ONE SDK
SQL Reports / 856 Report - Selection Criteria
API FLT1
FLT1 - 856 Report - Selection Criteria Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormNo KEY UNIQUEForm No.nVarChar
20
PRIMARYYes
CodeCodenVarChar
50
UserSignUser SignatureInt
6OUSR
Users
ExNumData1Extra Numeric Data 1Int
11
ExNumData2Extra Numeric Data 2Int
11
ExNumData3Extra Numeric Data 3Int
11
ExStrData1Extra String Data 1nVarChar
127
ExStrData2Extra String Data 2nVarChar
127
ExStrData3Extra String Data 3nVarChar
127
FilterNameFilter NamenVarChar
30
_

SELECT statement

SELECT FLT1.FormNo AS 'Form No.', FLT1.Code AS 'Code', FLT1.UserSign AS 'User Signature', FLT1.ExNumData1 AS 'Extra Numeric Data 1', FLT1.ExNumData2 AS 'Extra Numeric Data 2', FLT1.ExNumData3 AS 'Extra Numeric Data 3', FLT1.ExStrData1 AS 'Extra String Data 1', FLT1.ExStrData2 AS 'Extra String Data 2', FLT1.ExStrData3 AS 'Extra String Data 3', FLT1.FilterName AS 'Filter Name' FROM FLT1 AS FLT1

Related information


Users OUSR 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