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

SQL

Others /

String list item resource

API STRI

STRI - String list item resource Table

SBO SQL database table details

Field	Description	Type	Size	Default	Primary_Key	Unique
Created	Creation date	Date	8
Updated	Update date	Date	8
Name ^KEY ^UNIQUE	STRL name	nVarChar	64		UNIQUE_ID	Yes
Num	String number	Int	11
StrIndex	String Index	Int	11	0
ItemString	Item string	nVarChar	127
UniqueID	Unique ID	nVarChar	10
UsrSgnStr	User Sign For Strings Change	Int	11	-1
UsrSgnAttr	User Sign For Attribs Change	Int	11	-1
ResCode	Resource Code from RSBD	Int	11	-1
RevCode	Revision Code	Int	11	-1

SELECT statement

SELECT
   STRI.Created AS 'Creation date', 
   STRI.Updated AS 'Update date', 
   STRI.Name AS 'STRL name', 
   STRI.Num AS 'String number', 
   STRI.StrIndex AS 'String Index', 
   STRI.ItemString AS 'Item string', 
   STRI.UniqueID AS 'Unique ID', 
   STRI.UsrSgnStr AS 'User Sign For Strings Change', 
   STRI.UsrSgnAttr AS 'User Sign For Attribs Change', 
   STRI.ResCode AS 'Resource Code from RSBD', 
   STRI.RevCode AS 'Revision Code'
FROM STRI AS STRI

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates