biuan SAP® BUSINESS ONE SDK
SQL Finance / Inflation Wizard
API OIWZ
OIWZ - Inflation Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
WizNameWizard NamenVarChar
100
PostDateToPosting Date ToDate
8
WizTypeWizard TypeVarChar
1) G\L Account Revaluation Wizard
2) Inventory Revaluation Wizard
3) COGS Revaluation Wizard
1
IndexCodeIndex CodenVarChar
3
IndexRateIndex RateNum
20
CashAcctCash AccountVarChar
N) No
Y) Yes
1
N
CashFrmBlCash from BalanceNum
20
CashCancelCash CancelVarChar
N) No
Y) Yes
1
N
FromItemItem Number TonVarChar
20
ToItemItem Number TonVarChar
20
ItemGroupItem GroupInt
6
PropertiesItem PropertiesnVarChar
127
RvalMethodInventory Revaluation MethodVarChar
P) Price Source
I) Inflation Only
1
P
PriceSourPrice SourceInt
6
TransAbsJournal Entry Absolute EntryInt
11
UseDLNUse Delivery NotesVarChar
Y) Yes
N) No
1
Y
UsePCHUse Invoices with Stock Trans.VarChar
Y) Yes
N) No
1
Y
UsePCHNoStUse Invoices without Trans.VarChar
Y) Yes
N) No
1
Y
UseImportUse Import DataVarChar
Y) Yes
N) No
1
N
CashDifBalCash Acct Difference BalanceNum
20
CashExecutCash ExecutedVarChar
Y) Yes
N) No
1
Y
ActTypeAccount TypeVarChar
A) Post amount to adjustment account
S) Post amount to inventory account
1
A
VarRatePrice Variance RateNum
20
FilterExeFilter ExecutedVarChar
Y) Yes
N) No
1
Y
CashErrResCash Account Error ReasonInt
11
CshRvToActCash Revaluate to AccountnVarChar
15
MarkVarMark Items with Varient PriceVarChar
Y) Yes
N) No
1
N
ChngPriceChange PriceVarChar
Y) Yes
N) No
1
N
UseSemestrRevaluate by Semesters IndexVarChar
Y) Yes
N) No
1
N
CreateDateCreate DateDate
8
CshLstRvBlCash Last Revaluation BalanceNum
20
userSignCreating UserInt
6OUSR
Users
userSign2Updating UserInt
6OUSR
Users
CshCanclDCash Acct Cancellation DateDate
8

Table relationship map

SELECT statement

SELECT OIWZ.AbsEntry AS 'Internal Number', OIWZ.WizName AS 'Wizard Name', OIWZ.PostDateTo AS 'Posting Date To', OIWZ.WizType AS 'Wizard Type', OIWZ.IndexCode AS 'Index Code', OIWZ.IndexRate AS 'Index Rate', OIWZ.CashAcct AS 'Cash Account', OIWZ.CashFrmBl AS 'Cash from Balance', OIWZ.CashCancel AS 'Cash Cancel', OIWZ.FromItem AS 'Item Number To', OIWZ.ToItem AS 'Item Number To', OIWZ.ItemGroup AS 'Item Group', OIWZ.Properties AS 'Item Properties', OIWZ.RvalMethod AS 'Inventory Revaluation Method', OIWZ.PriceSour AS 'Price Source', OIWZ.TransAbs AS 'Journal Entry Absolute Entry', OIWZ.UseDLN AS 'Use Delivery Notes', OIWZ.UsePCH AS 'Use Invoices with Stock Trans.', OIWZ.UsePCHNoSt AS 'Use Invoices without Trans.', OIWZ.UseImport AS 'Use Import Data', OIWZ.CashDifBal AS 'Cash Acct Difference Balance', OIWZ.CashExecut AS 'Cash Executed', OIWZ.ActType AS 'Account Type', OIWZ.VarRate AS 'Price Variance Rate', OIWZ.FilterExe AS 'Filter Executed', OIWZ.CashErrRes AS 'Cash Account Error Reason', OIWZ.CshRvToAct AS 'Cash Revaluate to Account', OIWZ.MarkVar AS 'Mark Items with Varient Price', OIWZ.ChngPrice AS 'Change Price', OIWZ.UseSemestr AS 'Revaluate by Semesters Index', OIWZ.CreateDate AS 'Create Date', OIWZ.CshLstRvBl AS 'Cash Last Revaluation Balance', OIWZ.userSign AS 'Creating User', OIWZ.userSign2 AS 'Updating User', OIWZ.CshCanclD AS 'Cash Acct Cancellation Date' FROM OIWZ AS OIWZ

Related information


OIWZ SQL Table

Users OUSR 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