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

SQL

Others /

Mapping between form item and dashboard column

API DAL1

DAL1 - Mapping between form item and dashboard column Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int		11		PRIMARY	Yes
LinkEntry	Internal Key	Int		11
ItemID	Item ID	nVarChar		127
ObjName	Object Name	nVarChar		127
PropName	Property Name	nVarChar		127
QueryCol	Query Column	nVarChar		127
MobDesc	Mobile Description	nVarChar		127
IsUDF	Is UDF or Not	VarChar	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

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates