biuan SAP® BUSINESS ONE SDK
API IWZ1
IWZ1 - Accounts Revaluation History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OIWZ
Inflation Wizard
PRIMARYYes
AcctCodeAccount CodenVarChar
15OACT
G/L Accounts
ActNameAccount NamenVarChar
100
ActFrmBlncAccount From BalanceNum
20
ExecutLineExecuted RowVarChar
Y) Executed Row
N) Filter Line
1
Y
ActRevCnclAccount Revaluation CancelVarChar
N) No
Y) Yes
1
N
RevToActRevaluate To AccountnVarChar
15
ActDiffBalAccount Difference BalanceNum
20
RvCaclDateReval. Acct Cancellation DateDate
8
ErrReasonError ReasonInt
11
ActLastBalAccount Last Reval BalanceNum
20

Table relationship map

SELECT statement

SELECT IWZ1.AbsEntry AS 'Internal Number', IWZ1.AcctCode AS 'Account Code', IWZ1.ActName AS 'Account Name', IWZ1.ActFrmBlnc AS 'Account From Balance', IWZ1.ExecutLine AS 'Executed Row', IWZ1.ActRevCncl AS 'Account Revaluation Cancel', IWZ1.RevToAct AS 'Revaluate To Account', IWZ1.ActDiffBal AS 'Account Difference Balance', IWZ1.RvCaclDate AS 'Reval. Acct Cancellation Date', IWZ1.ErrReason AS 'Error Reason', IWZ1.ActLastBal AS 'Account Last Reval Balance' FROM IWZ1 AS IWZ1

Related information


Inflation Wizard OIWZ SQL Table

G/L Accounts OACT 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