biuan SAP® BUSINESS ONE SDK
SQL Others / Object Wizard Related Files
API WORF
WORF - Object Wizard Related Files Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjName KEY UNIQUEParent Object CodeInt
11
TABLEYes
SonNumSon NumberInt
11
ObjTableSon TablenVarChar
20
RelObjObjectnVarChar
20
RelTypeRelationship TypeVarChar
L) Line
O) Odd
A) Another object contained
1
L
LogSonSon's Log tablenVarChar
20
FthrLineIdFather's Line IdInt
11
0
UniqueId KEY UNIQUESon Unique IdInt
11
UNIQUE_IDYes
LnObjCodeLine object codenVarChar
20
SonDescSon DescriptionnVarChar
30
CreateDateCreation dateDate
8
CreateTimeCreation TimeInt
6
UpdateDateUpdate DateDate
8
UpdateTimeUpdate TimeInt
6
UserSignUser SignInt
11
FieldIndexField IndexInt
6

SELECT statement

SELECT WORF.ObjName AS 'Parent Object Code', WORF.SonNum AS 'Son Number', WORF.ObjTable AS 'Son Table', WORF.RelObj AS 'Object', WORF.RelType AS 'Relationship Type', WORF.LogSon AS 'Son's Log table', WORF.FthrLineId AS 'Father's Line Id', WORF.UniqueId AS 'Son Unique Id', WORF.LnObjCode AS 'Line object code', WORF.SonDesc AS 'Son Description', WORF.CreateDate AS 'Creation date', WORF.CreateTime AS 'Creation Time', WORF.UpdateDate AS 'Update Date', WORF.UpdateTime AS 'Update Time', WORF.UserSign AS 'User Sign', WORF.FieldIndex AS 'Field Index' FROM WORF AS WORF

Related information
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