biuan SAP® BUSINESS ONE SDK
SQL Finance / Items Last Revaluation Data
API IWZ3
IWZ3 - Items Last Revaluation Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEYInternal NumberInt
11OIWZ
Inflation Wizard		ABSNo
ItemCodeItem NumbernVarChar
20OITM
Items
WhCodeWarehouse CodenVarChar
8OWHS
Warehouses
RevalPriceRevaluated PriceNum
20
BaseCurrItem Base CurrencynVarChar
3
RevalDateRevaluation DateDate
8
RevalSumRevaluation SumNum
20
BasePriceBase PriceNum
20
RealAcctRevaluation AccountnVarChar
15OACT
G/L Accounts
RevalOfsacReval. Offset AccountnVarChar
15OACT
G/L Accounts
RevalTypeRevaluation TypeVarChar
S) Inventory Reval. Type
C) COGS Revaluation Type
1
S
ExeLineExecuted RowVarChar
Y) Yes
N) No
1
Y
RevCancelRevaluation CancelVarChar
N) No
Y) Yes
1
N
RvCaclDateReval. Acct Cancellation DateDate
8
QuantityQuantityNum
20
BalanceBefBalance Before RevaluationNum
20

Table relationship map

SELECT statement

SELECT IWZ3.AbsEntry AS 'Internal Number', IWZ3.ItemCode AS 'Item Number', IWZ3.WhCode AS 'Warehouse Code', IWZ3.RevalPrice AS 'Revaluated Price', IWZ3.BaseCurr AS 'Item Base Currency', IWZ3.RevalDate AS 'Revaluation Date', IWZ3.RevalSum AS 'Revaluation Sum', IWZ3.BasePrice AS 'Base Price', IWZ3.RealAcct AS 'Revaluation Account', IWZ3.RevalOfsac AS 'Reval. Offset Account', IWZ3.RevalType AS 'Revaluation Type', IWZ3.ExeLine AS 'Executed Row', IWZ3.RevCancel AS 'Revaluation Cancel', IWZ3.RvCaclDate AS 'Reval. Acct Cancellation Date', IWZ3.Quantity AS 'Quantity', IWZ3.BalanceBef AS 'Balance Before Revaluation' FROM IWZ3 AS IWZ3

Related information


Inflation Wizard OIWZ SQL Table

Items OITM SQL Table

G/L Accounts OACT SQL Table

Warehouses OWHS SQL Table
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