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

SQL

Administration /

Property Object

DTW Sales / Return

API OPRO

OPRO - Property Object Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Property ID	Int		11			PRIMARY	Yes
MapID ^KEY ^UNIQUE	Mapping ID	Int		11	OMAP Mapping Elements		CODE_NAME	Yes
Code	Input/Output Code	Int		11
Type	Property Type	nVarChar	Strin) String XML) XML String)	6		Strin
Name	Property Name	nVarChar		50
IsBlob	Is BLOB Type	VarChar	Y) N)	1
TValue	Text Value	nVarChar		127
BValue	BLOB Value	Text		16
Encoding	Encoding	nVarChar	base64)	20

SELECT statement

SELECT
   OPRO.AbsEntry AS 'Property ID', 
   OPRO.MapID AS 'Mapping ID', 
   OPRO.Code AS 'Input/Output Code', 
   OPRO.Type AS 'Property Type', 
   OPRO.Name AS 'Property Name', 
   OPRO.IsBlob AS 'Is BLOB Type', 
   OPRO.TValue AS 'Text Value', 
   OPRO.BValue AS 'BLOB Value', 
   OPRO.Encoding AS 'Encoding'
FROM OPRO AS OPRO

Related information

OMAP 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