biuan SAP® BUSINESS ONE SDK
SQL Administration / User-Defined Object / User-Defined Objects - Child Table Columns
DTW User-Defined Objects - Child Table Columns
API User Objects MD / User Object MD Enhanced Form Columns
UDO4 - User-Defined Objects - Child Table Columns Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20
PRIMARYYes
ColumnNumForm Column NumberInt
11
SonNumChild No.Int
11
ColAliasForm Column AliasnVarChar
20
ColDescForm Column DescriptionnVarChar
30
ColIsUsedForm Column Used or NotVarChar
1
N
ColEditForm Column Actived or NotVarChar
1
N

SELECT statement

SELECT UDO4.Code AS 'Code', UDO4.ColumnNum AS 'Form Column Number', UDO4.SonNum AS 'Child No.', UDO4.ColAlias AS 'Form Column Alias', UDO4.ColDesc AS 'Form Column Description', UDO4.ColIsUsed AS 'Form Column Used or Not', UDO4.ColEdit AS 'Form Column Actived or Not' FROM UDO4 AS UDO4

Related information


User Object MD Enhanced Form Columns UserObjectMD_EnhancedFormColumns Object· Table: UDO4
UserObjectMD_EnhancedFormColumns is a child object of the UserObjectsMD object that represents the default fields (columns) to display in the UDO enhanced default form (UDO form with the header-line style). Source table: UDO4.
   Parent: User Objects MD UserObjectsMD Object· Table: OUDO


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