biuan SAP® BUSINESS ONE SDK
API DAL1
DAL1 - Mapping between form item and dashboard column Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
LinkEntryInternal KeyInt
11
ItemIDItem IDnVarChar
127
ObjNameObject NamenVarChar
127
PropNameProperty NamenVarChar
127
QueryColQuery ColumnnVarChar
127
MobDescMobile DescriptionnVarChar
127
IsUDFIs UDF or NotVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT DAL1.AbsEntry AS 'Internal Key', DAL1.LinkEntry AS 'Internal Key', DAL1.ItemID AS 'Item ID', DAL1.ObjName AS 'Object Name', DAL1.PropName AS 'Property Name', DAL1.QueryCol AS 'Query Column', DAL1.MobDesc AS 'Mobile Description', DAL1.IsUDF AS 'Is UDF or Not' FROM DAL1 AS DAL1

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