biuan SAP® BUSINESS ONE SDK
API UIVE
UIVE - FIFO Based Sales Return Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TreeID KEYTree IDInt
11
0TreeIDNo
ParentIDParent IDInt
11
-1
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
TransSeq KEYTransaction Sequence No.Int
11UIVL
Whse Journal
TRANS_SEQNo
LayerIDLayer IDInt
11
LayerInQtyLayer In QuantityNum
20
LayerOutQLayer Out QuantityNum
20
LayerValLayer ValueNum
20
ItemCodeItem CodenVarChar
20UITM
Items
EntryTreeIEntry Tree IDInt
11
LayerCogsLayer - Cost of Goods SoldNum
20

Table relationship map

SELECT statement

SELECT UIVE.TreeID AS 'Tree ID', UIVE.ParentID AS 'Parent ID', UIVE.AbsEntry AS 'Internal Number', UIVE.LocType AS 'Location Type', UIVE.LocCode AS 'Location Code', UIVE.TransSeq AS 'Transaction Sequence No.', UIVE.LayerID AS 'Layer ID', UIVE.LayerInQty AS 'Layer In Quantity', UIVE.LayerOutQ AS 'Layer Out Quantity', UIVE.LayerVal AS 'Layer Value', UIVE.ItemCode AS 'Item Code', UIVE.EntryTreeI AS 'Entry Tree ID', UIVE.LayerCogs AS 'Layer - Cost of Goods Sold' FROM UIVE AS UIVE

Related information


Items UITM SQL Table

Whse Journal UIVL 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