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

SQL Reports / Transformation Documents

API OTRX

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Identity		11		PRIMARY	Yes
Code ^KEY ^UNIQUE	Code	nVarChar		20		CODE	Yes
Descr	Description	nVarChar		127
Type	Type	nVarChar	XSLT) XSLT Document	8	XSLT
Data	Data	Text		16

SELECT statement

SELECT
   OTRX.AbsEntry AS 'Internal Number', 
   OTRX.Code AS 'Code', 
   OTRX.Descr AS 'Description', 
   OTRX.Type AS 'Type', 
   OTRX.Data AS 'Data'
FROM OTRX AS OTRX

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