biuan SAP® BUSINESS ONE SDK
SQL Finance / Shareholder's Rights and Interests Report History - Rows
API SHR1
SHR1 - Shareholder's Rights and Interests Report History - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ShrId KEY UNIQUESHR IdentityInt
11OSHR
Shareholder's Rights and Interests Report History		PRIMARYYes
RowIdRow NumberInt
11
CatIdCategory IdentityInt
6
LineNumLine NumbernVarChar
6
ItemNameItem NamenVarChar
127
LevelLevel NumberInt
6
IndentCharNumber of Characters to IndentnVarChar
6
FormulaFormula?VarChar
1
CurAmountCurrent Period AmountNum
20
PreAmountPrevious Period AmountNum
20

SELECT statement

SELECT SHR1.ShrId AS 'SHR Identity', SHR1.RowId AS 'Row Number', SHR1.CatId AS 'Category Identity', SHR1.LineNum AS 'Line Number', SHR1.ItemName AS 'Item Name', SHR1.Level AS 'Level Number', SHR1.IndentChar AS 'Number of Characters to Indent', SHR1.Formula AS 'Formula?', SHR1.CurAmount AS 'Current Period Amount', SHR1.PreAmount AS 'Previous Period Amount' FROM SHR1 AS SHR1

Related information


Shareholder's Rights and Interests Report History OSHR SQL Table
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