biuan SAP® BUSINESS ONE SDK
API UIVQ
UIVQ - FIFO Queue Working Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TreeID KEYTree IDInt
11
0TreeOpenQtNo
ParentIDParent IDInt
11
-1
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
TransSeq KEY UNIQUETransaction Sequence No.Int
11UIVL
Whse Journal
TRANS_SEQYes
LayerIDLayer IDInt
11
OpenQtyOpen QuantityNum
20
OpenValueOpen ValueNum
20
ItemCodeItem CodenVarChar
20UITM
Items
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
StockActioStock Action TypeInt
15) Delivery
16) Returns
13) A/R Invoice
14) A/R Credit Memo
132) Correction Invoice
(-0) (-
20) Goods Receipt
21) Goods Return
18) A/P Invoice
19) A/P Credit Memo
(-1) (-
-2) Opening Balance
58) Inventory Update
59) Goods Receipt
60) Goods Issue
67) Inventory Transfer
68) Work Instructions
(-2) (-
-1) All Transactions
162) Inventory Revaluation
69) Landed Costs
11
-1
RemMethodQuantity Removal MethodVarChar
U) Unspecified
I) Issue
R) Revaluation
1
U

Table relationship map

SELECT statement

SELECT UIVQ.TreeID AS 'Tree ID', UIVQ.ParentID AS 'Parent ID', UIVQ.LocType AS 'Location Type', UIVQ.LocCode AS 'Location Code', UIVQ.TransSeq AS 'Transaction Sequence No.', UIVQ.LayerID AS 'Layer ID', UIVQ.OpenQty AS 'Open Quantity', UIVQ.OpenValue AS 'Open Value', UIVQ.ItemCode AS 'Item Code', UIVQ.AbsEntry AS 'Internal Number', UIVQ.StockActio AS 'Stock Action Type', UIVQ.RemMethod AS 'Quantity Removal Method' FROM UIVQ AS UIVQ

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