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

SQL Others / XLR Property Definitions

API SXRPD

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
propdefid ^KEY ^UNIQUE	propdefid	Int		11		PRIMARY	Yes
classid	classid	Int		11
seqno	seqno	Int		11	0
name	name	nVarChar		50
category	category	nVarChar		50	'General'
descriptio	description	nVarChar		127
type	type	Int		11	0
minoccurs	minoccurs	Int		11	0
maxoccurs	maxoccurs	Int		11	999999
classrefid	classrefid	Int		11	0
enumid	enumid	Int	0	11	0

SELECT statement

SELECT
   SXRPD.propdefid AS 'propdefid', 
   SXRPD.classid AS 'classid', 
   SXRPD.seqno AS 'seqno', 
   SXRPD.name AS 'name', 
   SXRPD.category AS 'category', 
   SXRPD.descriptio AS 'description', 
   SXRPD.type AS 'type', 
   SXRPD.minoccurs AS 'minoccurs', 
   SXRPD.maxoccurs AS 'maxoccurs', 
   SXRPD.classrefid AS 'classrefid', 
   SXRPD.enumid AS 'enumid'
FROM SXRPD AS SXRPD

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