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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransSeq KEY UNIQUETransaction Sequence No.Int
11
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 UIVL1.TransSeq AS 'Transaction Sequence No.', UIVL1.LayerID AS 'Layer ID', UIVL1.CalcPrice AS 'Calculated Price', UIVL1.Balance AS 'Stock Balance', UIVL1.TransValue AS 'Transaction Value', UIVL1.LayerInQty AS 'Receipt Quantity', UIVL1.LayerOutQ AS 'Issue Quantity', UIVL1.RevalTotal AS 'Inventory Revaluation Total' FROM UIVL1 AS UIVL1

Related information




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