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

API TABL

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	Table name	nVarChar		64		PRIMARY	Yes
Num ^KEY ^UNIQUE	Table number	Int		11		NUM	Yes
DoColor	Use color table	VarChar	0 1) Yes	1	0
BorderRed	Border red	Int		11
BorderGrn	Border green	Int		11
BorderBlue	Border blue	Int		11
BgRed	Background red	Int		11	65535
BgGreen	Background green	Int		11	65535
BgBlue	Background blue	Int		11	65535
CellHeight	Cell height	Int		11
TitleHeigt	Title height	Int		11
Width	Width	Int		11
MaxUnique	Max Unique	Int		11
UsrSgnAttr	User Sign For Attribs Change	Int		11	-1
ResCode	Resource Code from RSBD	Int		11	-1
RevCode	Revision Code	Int		11	-1

SELECT statement

SELECT
   TABL.Created AS 'Creation date', 
   TABL.Updated AS 'Update date', 
   TABL.Name AS 'Table name', 
   TABL.Num AS 'Table number', 
   TABL.DoColor AS 'Use color table', 
   TABL.BorderRed AS 'Border red', 
   TABL.BorderGrn AS 'Border green', 
   TABL.BorderBlue AS 'Border blue', 
   TABL.BgRed AS 'Background red', 
   TABL.BgGreen AS 'Background green', 
   TABL.BgBlue AS 'Background blue', 
   TABL.CellHeight AS 'Cell height', 
   TABL.TitleHeigt AS 'Title height', 
   TABL.Width AS 'Width', 
   TABL.MaxUnique AS 'Max Unique', 
   TABL.UsrSgnAttr AS 'User Sign For Attribs Change', 
   TABL.ResCode AS 'Resource Code from RSBD', 
   TABL.RevCode AS 'Revision Code'
FROM TABL AS TABL

Related information

biuan SAP® BUSINESS ONE

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