biuan SAP® BUSINESS ONE SDK
API UIC2
UIC2 - Customized Forms in Template Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TPLId KEY UNIQUETemplate IDInt
6UICU
Customized Template
PRIMARYYes
FormIdForm IDnVarChar
20
ItemIdItem IDnVarChar
20
VisibleVisibleVarChar
1
VisibleCtlVisible ControlVarChar
1
EditableEditableVarChar
1
EditbleCtlEditable ControlVarChar
1
LeftLeftInt
6
TopTopInt
6
RightRightInt
6
BottomBottomInt
6
FromPaneFrom PaneInt
6
ToPaneTo PaneInt
6
UDFUDFVarChar
1
N

SELECT statement

SELECT UIC2.TPLId AS 'Template ID', UIC2.FormId AS 'Form ID', UIC2.ItemId AS 'Item ID', UIC2.Visible AS 'Visible', UIC2.VisibleCtl AS 'Visible Control', UIC2.Editable AS 'Editable', UIC2.EditbleCtl AS 'Editable Control', UIC2.Left AS 'Left', UIC2.Top AS 'Top', UIC2.Right AS 'Right', UIC2.Bottom AS 'Bottom', UIC2.FromPane AS 'From Pane', UIC2.ToPane AS 'To Pane', UIC2.UDF AS 'UDF' FROM UIC2 AS UIC2

Related information


Customized Template UICU 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