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

SQL

Administration /

Dynamic Extensions

DTW Business Partners / Business Partner Master Data

API SDEX

SDEX - Dynamic Extensions Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
FormId ^KEY ^UNIQUE	Form ID	Int		11			PRIMARY	Yes
ItemId	Item ID	Int		11		0
ColumnId	Column ID	Int		11		0
BefAppl	Application Before	Text		16
AftAppl	Application After	Text		16
BefScript	Is Script Before	VarChar	Y) Yes N) No	1		Y
AftScript	Is Script After	VarChar	Y) Yes N) No	1		Y
UserSign	User Signature	Int		6	OUSR Users	-1

SELECT statement

SELECT
   SDEX.FormId AS 'Form ID', 
   SDEX.ItemId AS 'Item ID', 
   SDEX.ColumnId AS 'Column ID', 
   SDEX.BefAppl AS 'Application Before', 
   SDEX.AftAppl AS 'Application After', 
   SDEX.BefScript AS 'Is Script Before', 
   SDEX.AftScript AS 'Is Script After', 
   SDEX.UserSign AS 'User Signature'
FROM SDEX AS SDEX

Related information

OUSR SQL Table

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