biuan SAP® BUSINESS ONE SDK
API OUDO / / User Objects MD
OUDO - User-Defined Object Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20
PRIMARYYes
NameNamenVarChar
100
TableName KEY UNIQUETable NamenVarChar
19OUTB
User Tables
TABLEYes
LogTableLog Table NamenVarChar
19
TYPEObject TypeVarChar
1) Master Data
3) Document
1
1
MngSeriesManage SeriesVarChar
Y) Yes
N) No
1
N
CanDeleteDeleteVarChar
Y) Yes
N) No
1
Y
CanCloseCloseVarChar
Y) Yes
N) No
1
N
CanCancelCancelVarChar
Y) Yes
N) No
1
N
ExtNameExtension NamenVarChar
127
CanFindFindVarChar
Y) Yes
N) No
1
N
CanYrTrnsfYear TransferVarChar
Y) Yes
N) No
1
N
CanDefFormCreate Default FormVarChar
Y) Yes
N) No
1
N
CanLogLogVarChar
Y) Yes
N) No
1
N
OvrWrtDllOverwrite DLL FileVarChar
Y) Yes
N) No
1
Y
UIDFormatUnique Form ID FormatVarChar
Y) Yes
N) No
1
Y
CanArchiveArchiveVarChar
1
N
MenuItemSpecify Menu ItemVarChar
Y) Yes
N) No
1
N
MenuCaptMenu CaptionnVarChar
127
FatherMenuParent Menu IDInt
11
PositionMenu PositionInt
6
CanNewFormCreate Enhanced FormVarChar
1
Y
IsRebuildIf Needed, Rebuild New FormVarChar
1
Y
NewFormSrfEnhanced Form: SRF FileText
16
MenuUidMenu UIDnVarChar
32
LstUpdDateLast Update DateDate
8
LstUpdTimeLast Update TimeInt
11
CanApproveApproveVarChar
Y) Yes
N) No
1
N
TemplateIDWorkflow Template IDInt
11OWMG
Workflow Manager

Table relationship map

SELECT statement

SELECT OUDO.Code AS 'Code', OUDO.Name AS 'Name', OUDO.TableName AS 'Table Name', OUDO.LogTable AS 'Log Table Name', OUDO.TYPE AS 'Object Type', OUDO.MngSeries AS 'Manage Series', OUDO.CanDelete AS 'Delete', OUDO.CanClose AS 'Close', OUDO.CanCancel AS 'Cancel', OUDO.ExtName AS 'Extension Name', OUDO.CanFind AS 'Find', OUDO.CanYrTrnsf AS 'Year Transfer', OUDO.CanDefForm AS 'Create Default Form', OUDO.CanLog AS 'Log', OUDO.OvrWrtDll AS 'Overwrite DLL File', OUDO.UIDFormat AS 'Unique Form ID Format', OUDO.CanArchive AS 'Archive', OUDO.MenuItem AS 'Specify Menu Item', OUDO.MenuCapt AS 'Menu Caption', OUDO.FatherMenu AS 'Parent Menu ID', OUDO.Position AS 'Menu Position', OUDO.CanNewForm AS 'Create Enhanced Form', OUDO.IsRebuild AS 'If Needed, Rebuild New Form', OUDO.NewFormSrf AS 'Enhanced Form: SRF File', OUDO.MenuUid AS 'Menu UID', OUDO.LstUpdDate AS 'Last Update Date', OUDO.LstUpdTime AS 'Last Update Time', OUDO.CanApprove AS 'Approve', OUDO.TemplateID AS 'Workflow Template ID' FROM OUDO AS OUDO

Related information


User Objects MD UserObjectsMD Object· Table: OUDO
The UserObjectsMD object represents the registration data settings, such as table name and supported services, of a user defined object. This object enables you to: Add a user define object. Retrieve a user define object by its key. Update...

User Tables OUTB SQL Table

Workflow Manager OWMG 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