biuan SAP® BUSINESS ONE SDK
SQL Administration / Preferences
DTW Purchasing / Purchase Order
API OPRF
OPRF - Preferences Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormNumber KEY UNIQUEUser Form No.Int
11
PRIMARYYes
ExPref1Ex preferences 1nVarChar
127
ExPref2Ex preferences 2nVarChar
127
ExPref3Ex preferences 3nVarChar
127
ExPref4Ex preferences 4nVarChar
127
ExPref5Ex preferences 5nVarChar
127
ExPref6Ex preferences 6nVarChar
127
ExPref7Ex preferences 7nVarChar
127
ExPref8Ex preferences 8nVarChar
127
ExPref9Ex preferences 9nVarChar
127
ExPref10Ex preferences 10nVarChar
127
ExPref11Ex preferences 11nVarChar
127
ExPref12Ex preferences 12nVarChar
127
ExPref13Ex preferences 13nVarChar
127
ExPref14Ex preferences 14nVarChar
127
ExPref15Ex preferences 15nVarChar
127
UserSignUser SignatureInt
6OUSR
Users

SELECT statement

SELECT OPRF.FormNumber AS 'User Form No.', OPRF.ExPref1 AS 'Ex preferences 1', OPRF.ExPref2 AS 'Ex preferences 2', OPRF.ExPref3 AS 'Ex preferences 3', OPRF.ExPref4 AS 'Ex preferences 4', OPRF.ExPref5 AS 'Ex preferences 5', OPRF.ExPref6 AS 'Ex preferences 6', OPRF.ExPref7 AS 'Ex preferences 7', OPRF.ExPref8 AS 'Ex preferences 8', OPRF.ExPref9 AS 'Ex preferences 9', OPRF.ExPref10 AS 'Ex preferences 10', OPRF.ExPref11 AS 'Ex preferences 11', OPRF.ExPref12 AS 'Ex preferences 12', OPRF.ExPref13 AS 'Ex preferences 13', OPRF.ExPref14 AS 'Ex preferences 14', OPRF.ExPref15 AS 'Ex preferences 15', OPRF.UserSign AS 'User Signature' FROM OPRF AS OPRF

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