biuan SAP® BUSINESS ONE SDK
API CUFD / User Fields MD
CUFD - User Fields - Description Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableID KEY UNIQUETablenVarChar
20
ALIASYes
FieldIDFieldInt
6
AliasIDTitlenVarChar
18
DescrDescriptionnVarChar
30
TypeIDTypeVarChar
1
EditTypeEdit TypeVarChar
1
SizeIDSizeInt
6
EditSizeEdit SizeInt
6
DfltDefaultnVarChar
127
NotNullRequired Entry FieldVarChar
Y) Yes
N) No
1
N
IndexIDCreate IndexVarChar
Y) Yes
N) No
1
N
RTableLinked TablenVarChar
20OUTB
User Tables
RFieldLinked FieldInt
6
ActionActionVarChar
1
SysSystem Defined?VarChar
Y) Yes
N) No
1
N
DfltDateDefault DateDate
8
RelUDORelated UDOnVarChar
20
ValidRuleValidation RulenVarChar
127

Table relationship map

SELECT statement

SELECT CUFD.TableID AS 'Table', CUFD.FieldID AS 'Field', CUFD.AliasID AS 'Title', CUFD.Descr AS 'Description', CUFD.TypeID AS 'Type', CUFD.EditType AS 'Edit Type', CUFD.SizeID AS 'Size', CUFD.EditSize AS 'Edit Size', CUFD.Dflt AS 'Default', CUFD.NotNull AS 'Required Entry Field', CUFD.IndexID AS 'Create Index', CUFD.RTable AS 'Linked Table', CUFD.RField AS 'Linked Field', CUFD.Action AS 'Action', CUFD.Sys AS 'System Defined?', CUFD.DfltDate AS 'Default Date', CUFD.RelUDO AS 'Related UDO', CUFD.ValidRule AS 'Validation Rule' FROM CUFD AS CUFD

Related information


User Fields MD UserFieldsMD Object· Table: CUFD
UserFieldsMD is a business object that enables you to manage user-defined fields in user and system tables. This object enables you to: Add a user-defined field. Retrieve a user-defined field from the database by its key. Remove a...

CUFD SQL Table

User Tables OUTB SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates