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

SBO SQL database table details

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

SELECT statement

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

Related information


User Object MD Form Columns UserObjectMD_FormColumns Object· Table: UDO3
UserObjectMD_FormColumns is child object of the UserObjectsMD object that represents the default fields (columns) to display in the default form (UDO form with the matrix style). Source table: UDO3.
   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