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

SQL Others / Connection Map for CR Templates

API RCON

RCON - Connection Map for CR Templates Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
DocCode ^KEY ^UNIQUE	Internal Template Key	nVarChar	8	PRIMARY	Yes
ConnID	Connection ID	Int	11
OldServer	Old Server Name	nVarChar	64
OldDbName	Old Database Name	nVarChar	64
NewServer	Mapped Server Name	nVarChar	64
NewDbName	Mapped Database Name	nVarChar	64
UserCode	User Code	nVarChar	32
SubIndex	Subreport Index	Int	6
SubName	Subreport Name	nVarChar	64

SELECT statement

SELECT
   RCON.DocCode AS 'Internal Template Key', 
   RCON.ConnID AS 'Connection ID', 
   RCON.OldServer AS 'Old Server Name', 
   RCON.OldDbName AS 'Old Database Name', 
   RCON.NewServer AS 'Mapped Server Name', 
   RCON.NewDbName AS 'Mapped Database Name', 
   RCON.UserCode AS 'User Code', 
   RCON.SubIndex AS 'Subreport Index', 
   RCON.SubName AS 'Subreport Name'
FROM RCON AS RCON

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