biuan SAP® BUSINESS ONE SDK
API SIVL1
SIVL1 - IVL Layer Level Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransSeq KEY UNIQUETransaction Sequence No.Int
11OIVL
Whse Journal
PRIMARYYes
LayerIDLayer IDInt
11
CalcPriceCalculated PriceNum
20
BalanceStock BalanceNum
20
TransValueTransaction ValueNum
20
LayerInQtyReceipt QuantityNum
20
LayerOutQIssue QuantityNum
20
RevalTotalInventory Revaluation TotalNum
20

SELECT statement

SELECT SIVL1.TransSeq AS 'Transaction Sequence No.', SIVL1.LayerID AS 'Layer ID', SIVL1.CalcPrice AS 'Calculated Price', SIVL1.Balance AS 'Stock Balance', SIVL1.TransValue AS 'Transaction Value', SIVL1.LayerInQty AS 'Receipt Quantity', SIVL1.LayerOutQ AS 'Issue Quantity', SIVL1.RevalTotal AS 'Inventory Revaluation Total' FROM SIVL1 AS SIVL1

Related information


Whse Journal OIVL SQL Table



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