📚 SAP Business One SDK Help

Table Name: OIWZ

Table Description: Inflation Wizard

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
WizName Wizard Name nVarChar 100 -      
PostDateTo Posting Date To Date 8 -      
WizType Wizard Type VarChar 1 -   1 G\L Account Revaluation Wizard
            2 Inventory Revaluation Wizard
            3 COGS Revaluation Wizard
IndexCode Index Code nVarChar 3 -      
IndexRate Index Rate Num 19.6 -      
CashAcct Cash Account VarChar 1 - N N No
            Y Yes
CashFrmBl Cash from Balance Num 19.6 -      
CashCancel Cash Cancel VarChar 1 - N N No
            Y Yes
FromItem Item Number To nVarChar 50 -      
ToItem Item Number To nVarChar 50 -      
ItemGroup Item Group Int 6 -      
Properties Item Properties nVarChar 250 -      
RvalMethod Inventory Revaluation Method VarChar 1 - P P Price Source
            I Inflation Only
PriceSour Price Source Int 6 -      
TransAbs Journal Entry Absolute Entry Int 11 -      
UseDLN Use Delivery Notes VarChar 1 - Y Y Yes
            N No
UsePCH Use Invoices with Stock Trans. VarChar 1 - Y Y Yes
            N No
UsePCHNoSt Use Invoices without Trans. VarChar 1 - Y Y Yes
            N No
UseImport Use Import Data VarChar 1 - N Y Yes
            N No
CashDifBal Cash Acct Difference Balance Num 19.6 -      
CashExecut Cash Executed VarChar 1 - Y Y Yes
            N No
ActType Account Type VarChar 1 - A A Post amount to adjustment account
            S Post amount to inventory account
VarRate Price Variance Rate Num 19.6 -      
FilterExe Filter Executed VarChar 1 - Y Y Yes
            N No
CashErrRes Cash Account Error Reason Int 11 -      
CshRvToAct Cash Revaluate to Account nVarChar 15 -      
MarkVar Mark Items with Varient Price VarChar 1 - N Y Yes
            N No
ChngPrice Change Price VarChar 1 - N Y Yes
            N No
UseSemestr Revaluate by Semesters Index VarChar 1 - N Y Yes
            N No
CreateDate Create Date Date 8 -      
CshLstRvBl Cash Last Revaluation Balance Num 19.6 -      
userSign Creating User Int 6 OUSR      
userSign2 Updating User Int 6 OUSR      
CshCanclD Cash Acct Cancellation Date Date 8 -      
BPLId Active Branch Int 11 OBPL      
Key Unique Field
PRIMARY Yes AbsEntry