📚 SAP Business One SDK Help

Table Name: IWZ3

Table Description: Items Last Revaluation Data

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 OIWZ      
ItemCode Item Number nVarChar 50 OITM      
WhCode Warehouse Code nVarChar 8 OWHS      
RevalPrice Revaluated Price Num 19.6 -      
BaseCurr Item Base Currency nVarChar 3 -      
RevalDate Revaluation Date Date 8 -      
RevalSum Revaluation Sum Num 19.6 -      
BasePrice Base Price Num 19.6 -      
RealAcct Revaluation Account nVarChar 15 OACT      
RevalOfsac Reval. Offset Account nVarChar 15 OACT      
RevalType Revaluation Type VarChar 1 - S S Inventory Reval. Type
            C COGS Revaluation Type
ExeLine Executed Row VarChar 1 - Y Y Yes
            N No
RevCancel Revaluation Cancel VarChar 1 - N N No
            Y Yes
RvCaclDate Reval. Acct Cancellation Date Date 8 -      
Quantity Quantity Num 19.6 -      
BalanceBef Balance Before Revaluation Num 19.6 -      
Key Unique Field
PRIMARY Yes AbsEntry
    ItemCode
    WhCode
ABS No AbsEntry