UFD1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / User Fields - Description / User Fields - Values Definitions

DTW User Fields - Values Definitions

API User Fields MD / Valid Values MD

UFD1 - User Fields - Values Definitions Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
TableID ^KEY ^UNIQUE	Table	nVarChar	20	PRIMARY	Yes
FieldID	Field	Int	6
IndexID	Index	Int	6
FldValue	Value	nVarChar	127
Descr	Description	nVarChar	127
FldDate	Date Value	Date	8

SELECT statement

SELECT
   UFD1.TableID AS 'Table', 
   UFD1.FieldID AS 'Field', 
   UFD1.IndexID AS 'Index', 
   UFD1.FldValue AS 'Value', 
   UFD1.Descr AS 'Description', 
   UFD1.FldDate AS 'Date Value'
FROM UFD1 AS UFD1

Related information

ValidValuesMD Object· Table: UFD1

ValidValuesMD enables you to add valid values to a specified user defined field (UserFieldsMD). Source table: UFD1.

Parent: User Fields MD UserFieldsMD Object· Table: CUFD

biuan SAP® BUSINESS ONE

Object
UserFieldsMD

Object
ValidValuesMD

Method

Add

Delete

SetCurrentLine

Property

Count

Description

Value

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