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

SQL Administration / User-Defined Object / User-Defined Objects - Find Columns

DTW User-Defined Objects - Find Columns

API User Objects MD / User Object MD Find Columns

UDO2 - User-Defined Objects - Find Columns Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
Code ^KEY ^UNIQUE	Code	nVarChar	20	PRIMARY	Yes
ColumnNum	Column Number	Int	11
ColAlias	Column Alias	nVarChar	20
ColumnDesc	Column Description	nVarChar	30

SELECT statement

SELECT
   UDO2.Code AS 'Code', 
   UDO2.ColumnNum AS 'Column Number', 
   UDO2.ColAlias AS 'Column Alias', 
   UDO2.ColumnDesc AS 'Column Description'
FROM UDO2 AS UDO2

Related information

UserObjectMD_FindColumns Object· Table: UDO2

UserObjectMD_FindColumns is a child object of the UserObjectsMD object that represents the fields (columns) to display in the Find Form (Choose From List form). Source table: UDO2.

Parent: User Objects MD UserObjectsMD Object· Table: OUDO

biuan SAP® BUSINESS ONE

Object
UserObjectsMD

Object
UserObjectMD_FindColumns

Method

Add

SetCurrentLine

Property

Code

ColumnAlias

ColumnDescription

ColumnNumber

Count

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