📚 SAP Business One SDK Help

Table Name: UIVQ

Table Description: FIFO Queue Working Table

Field Description Type Size Related Default Value Constraints
TreeID Tree ID Int 11 - 0    
ParentID Parent ID Int 11 - -1    
LocType Location Type Int 6 -      
LocCode Location Code nVarChar 8 -      
TransSeq Transaction Sequence No. Int 11 UIVL      
LayerID Layer ID Int 11 -      
OpenQty Open Quantity Num 19.6 -      
OpenValue Open Value Num 19.6 -      
ItemCode Item Code nVarChar 50 UITM      
AbsEntry Internal Number Int 11 -      
StockActio Stock Action Type Int 11 - -1 15 Delivery
            16 Returns
            13 A/R Invoice
            14 A/R Credit Memo
            132 Correction Invoice
            20 Goods Receipt
            21 Goods Return
            18 A/P Invoice
            19 A/P Credit Memo
            -2 Opening Balance
            58 Inventory Update
            59 Goods Receipt
            60 Goods Issue
            67 Inventory Transfer
            68 Work Instructions
            -1 All Transactions
            162 Inventory Revaluation
            69 Landed Costs
RemMethod Quantity Removal Method VarChar 1 - U U Unspecified
            I Issue
            R Revaluation
Key Unique Field
PRIMARY Yes AbsEntry
TRANS_SEQ Yes TransSeq
    LayerID
TreeOpenQt No TreeID
    OpenQty