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

API RAMI

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
ErrUID ^KEY ^UNIQUE	Error Message Unique ID	nVarChar		11		PRIMARY	Yes
StrlNum ^KEY ^UNIQUE	String List Number	Int		11		String	Yes
StrIdx	String Index	Int		11
GuidStr ^KEY	GUID String	nVarChar		32	3A51AF1A405C41479530D05FF95A3FBA	GUID	No
MsgDef ^KEY ^UNIQUE	Message Define	nVarChar		100		CodeDefine	Yes
MsgType	Message Type	VarChar	E) Error W) Warning N) Info S) Success O) None	1	E
MsgArea	Message Area	nVarChar	-1) AP_AR) Sales and Purchurse orders RPT) Reports PROD) Production LGST) ItemMasterData INVT) Inventory FIN) Financial BANK) Banking CARD) BP Master Data AUTH) Authorization ADMIN) Administration SDK) SDK UI LCNS) License ADDON) Add-On manager FORM) Form Infrastructure DB) DB Infrastructure CORE) Core Layer INST) Installation and Upgrade	20	-1
ScnExp	Scenarion Explanation	Text		16
ObjName ^KEY	Object Name	nVarChar		20		ObjectId	No
SonTable	Son Table	nVarChar		20
Alias	Alias	nVarChar		10
FormID	Form ID	Int		11
PaneID	Pane Id	Int		6	0
ItemID	Item ID	Int		11	-1
CreateDate	Creation date	Date		8
CreateTime	Creation Time	Int		6
UpdateDate	Update Date	Date		8
UpdateTime	Update Time	Int		6
UserSign	User Sign	Int		11
SolExp	Solution Explanation	Text		16
CsnId	CSN Note Id	nVarChar		30
DispType	Display Type	nVarChar	SBAR) Sbar NOTE) Note DIALOG_OKCancelType) Dialog OK Cancel DIALOG_YesNoCancelType) Dialog Yes No Cancel DIALOG_YesNoType) Dialog Yes No DIALOG_YesAllNoAllCancelType) Dialog Yes All No All Cancel DIALOG_ErrorOkType) Dialog Error Ok DIALOG_ContinueSaveType) Dialog Continue Save DIALOG_RemoveCancelType) Dialog Remove Cancel DIALOG_ContinueCancelType) Dialog Continue Cancel DIALOG_ContinueCancelNoType) Dialog Continue Cancel No DIALOG_AddCancelType) Dialog Add Cancel DIALOG_ContinueStopType) Dialog Continue Stop DIALOG_YesCancelType) Dialog Yes Cancel DIALOG_ContinueOpenType) Dialog Continue Open DIALOG_OpenContinueCancelType) Dialog Open Continue Cancel DIALOG_YesYesAllNoType) Dialog Yes Yes All No DIALOG_YesYesAllNoAllType) Dialog Yes Yes All No All	30	SBAR
ColmID	Column ID	Int		11	-1
IsDeleted	Is Deleted	VarChar	N) No Y) Yes	1	N

SELECT statement

SELECT
   RAMI.ErrUID AS 'Error Message Unique ID', 
   RAMI.StrlNum AS 'String List Number', 
   RAMI.StrIdx AS 'String Index', 
   RAMI.GuidStr AS 'GUID String', 
   RAMI.MsgDef AS 'Message Define', 
   RAMI.MsgType AS 'Message Type', 
   RAMI.MsgArea AS 'Message Area', 
   RAMI.ScnExp AS 'Scenarion Explanation', 
   RAMI.ObjName AS 'Object Name', 
   RAMI.SonTable AS 'Son Table', 
   RAMI.Alias AS 'Alias', 
   RAMI.FormID AS 'Form ID', 
   RAMI.PaneID AS 'Pane Id', 
   RAMI.ItemID AS 'Item ID', 
   RAMI.CreateDate AS 'Creation date', 
   RAMI.CreateTime AS 'Creation Time', 
   RAMI.UpdateDate AS 'Update Date', 
   RAMI.UpdateTime AS 'Update Time', 
   RAMI.UserSign AS 'User Sign', 
   RAMI.SolExp AS 'Solution Explanation', 
   RAMI.CsnId AS 'CSN Note Id', 
   RAMI.DispType AS 'Display Type', 
   RAMI.ColmID AS 'Column ID', 
   RAMI.IsDeleted AS 'Is Deleted'
FROM RAMI AS RAMI

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