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

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

FORM - FORM resource Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
Created	Creation date	Date		8
Updated	Update date	Date		8
Name ^KEY ^UNIQUE	Form name	nVarChar		64		PRIMARY	Yes
Num ^KEY ^UNIQUE	Form number	Int		11		NUM	Yes
Type	Form type	Int	0 1) Dialog Box 3) No Title Document 4) Fixed Document 5) Resize No Title Document 6) Toolbar 7) Fixed No Minimize	11	0
CloseBox	Close box	VarChar	0 1) Yes	1	1
DfltButton	Default button	Int		11	0
_Top	Top	Int		11
_Bottom	Bottom	Int		11
_Left	Left	Int		11
_Right	Right	Int		11
MaxUnique	Max Unique	Int		11
RobjCode	ImpExp Obj Code	Int		11	0
HelpCntxt	Help Context	nVarChar		32
UsrSgnAttr	User Sign For Attribs Change	Int		11	-1
ResCode	Resource Code from RSBD	Int		11	-1
RevCode	Revision Code	Int		11	-1
UseBoBind	Use BO Binding	VarChar	Y) Yes N) No	1	N

SELECT statement

SELECT
   FORM.Created AS 'Creation date', 
   FORM.Updated AS 'Update date', 
   FORM.Name AS 'Form name', 
   FORM.Num AS 'Form number', 
   FORM.Type AS 'Form type', 
   FORM.CloseBox AS 'Close box', 
   FORM.DfltButton AS 'Default button', 
   FORM._Top AS 'Top', 
   FORM._Bottom AS 'Bottom', 
   FORM._Left AS 'Left', 
   FORM._Right AS 'Right', 
   FORM.MaxUnique AS 'Max Unique', 
   FORM.RobjCode AS 'ImpExp Obj Code', 
   FORM.HelpCntxt AS 'Help Context', 
   FORM.UsrSgnAttr AS 'User Sign For Attribs Change', 
   FORM.ResCode AS 'Resource Code from RSBD', 
   FORM.RevCode AS 'Revision Code', 
   FORM.UseBoBind AS 'Use BO Binding'
FROM FORM AS FORM

Related information

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

biuan SAP® BUSINESS ONE

Object
UserObjectsMD

Object
UserObjectMD_FormColumns

Method

Add

SetCurrentLine

Property

Code

Count

Editable

FormColumnAlias

FormColumnDescription

FormColumnNumber

SonNumber

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