biuan SAP® BUSINESS ONE SDK
API TABL
TABL - Table resource Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreatedCreation dateDate
8
UpdatedUpdate dateDate
8
Name KEY UNIQUETable namenVarChar
64
PRIMARYYes
Num KEY UNIQUETable numberInt
11
NUMYes
DoColorUse color tableVarChar
0
1) Yes
1
0
BorderRedBorder redInt
11
BorderGrnBorder greenInt
11
BorderBlueBorder blueInt
11
BgRedBackground redInt
11
65535
BgGreenBackground greenInt
11
65535
BgBlueBackground blueInt
11
65535
CellHeightCell heightInt
11
TitleHeigtTitle heightInt
11
WidthWidthInt
11
MaxUniqueMax UniqueInt
11
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
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




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