biuan SAP® BUSINESS ONE SDK
API DWZ2
DWZ2 - Dunning Wizard Array 2-Invoice Filter Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11ODWZ
Dunning Wizard
PRIMARYYes
CardCodeBP Card CodenVarChar
15OCRD
Business Partner
LetterNumLetter NumberInt
11
TotalFeeTotal FeeNum
20
FeeCurrTotal Fee CurrencynVarChar
3OCRN
Currency Codes
TtlopnIntrSum of Open Sum+InterestNum
20
EDunLevelEdited Dunning LevelnVarChar
3
OpnIntrCrrTotal Open + Interest CurrencynVarChar
3
DocAbsDocument Internal NumberInt
11
DocNumDoc. No.Int
11
InstlmntIDInstallment IDInt
6
IntrstPCInterest PercentNum
20
IntrstAmntInterest AmountNum
20
IntrstCurrInterest CurrencynVarChar
3OCRN
Currency Codes
ChckLineChecked RowVarChar
Y) Yes
N) No
1
N
IntrstDaysInterest DaysInt
11
DocTypeSource TableInt
13) A/R Invoice
203) Down Payment Incoming
165) Correction A/R Invoice
14) A/R Credit Memo
24) Incoming Payment
30) Journal Transactions
-2) Open Balance
-3) Close Balance
46) Outgoing Payments
11
DueDateDue DateDate
8
LetterLvlLetter LevelnVarChar
3
0
OpenSumOpen SumNum
20
OpenCurrOpen Sum CurrencynVarChar
3
sumIntrClcSum for Interest CalculationNum
20
folioNumFolio NumbernVarChar
14
LvlUpdatedLevel Updated FlagVarChar
Y) Yes
N) No
1
N
TotalFeeFCTotal Fee in Document CurrencyNum
20
TotalFeeLCTotal Fee in Local CurrencyNum
20
TotalFeeSCTotal Fee in System CurrencyNum
20
TtlopnInFCSum of Open Sum+Interest FCNum
20
TtlopnInSCSum of Open Sum+Interest SCNum
20
IntrAmtFCInterest Amount (FC)Num
20
IntrAmtSCInterest Amount (SC)Num
20
OpenSumFCOpen Sum (FC)Num
20
OpenSumSCOpen Sum (SC)Num
20
ExeChkLineExecuted Checked RowVarChar
Y) Yes
N) No
1
N
AutoPostAutomatic PostingVarChar
N) No
B) Interest and Fee
I) Interest Only
F) Fee Only
1
N
DocRateDocument RateNum
20
UnpaidBoEVUnpaid BoE ValueNum
20
BoENumberBoE NumberInt
11
BoEStatusBoE StatusVarChar
1
BoEDateBoE DateDate
8
BoEKeyBoE KeyInt
11

Table relationship map

SELECT statement

SELECT DWZ2.WizardId AS 'Wizard ID', DWZ2.CardCode AS 'BP Card Code', DWZ2.LetterNum AS 'Letter Number', DWZ2.TotalFee AS 'Total Fee', DWZ2.FeeCurr AS 'Total Fee Currency', DWZ2.TtlopnIntr AS 'Sum of Open Sum+Interest', DWZ2.EDunLevel AS 'Edited Dunning Level', DWZ2.OpnIntrCrr AS 'Total Open + Interest Currency', DWZ2.DocAbs AS 'Document Internal Number', DWZ2.DocNum AS 'Doc. No.', DWZ2.InstlmntID AS 'Installment ID', DWZ2.IntrstPC AS 'Interest Percent', DWZ2.IntrstAmnt AS 'Interest Amount', DWZ2.IntrstCurr AS 'Interest Currency', DWZ2.ChckLine AS 'Checked Row', DWZ2.IntrstDays AS 'Interest Days', DWZ2.DocType AS 'Source Table', DWZ2.DueDate AS 'Due Date', DWZ2.LetterLvl AS 'Letter Level', DWZ2.OpenSum AS 'Open Sum', DWZ2.OpenCurr AS 'Open Sum Currency', DWZ2.sumIntrClc AS 'Sum for Interest Calculation', DWZ2.folioNum AS 'Folio Number', DWZ2.LvlUpdated AS 'Level Updated Flag', DWZ2.TotalFeeFC AS 'Total Fee in Document Currency', DWZ2.TotalFeeLC AS 'Total Fee in Local Currency', DWZ2.TotalFeeSC AS 'Total Fee in System Currency', DWZ2.TtlopnInFC AS 'Sum of Open Sum+Interest FC', DWZ2.TtlopnInSC AS 'Sum of Open Sum+Interest SC', DWZ2.IntrAmtFC AS 'Interest Amount (FC)', DWZ2.IntrAmtSC AS 'Interest Amount (SC)', DWZ2.OpenSumFC AS 'Open Sum (FC)', DWZ2.OpenSumSC AS 'Open Sum (SC)', DWZ2.ExeChkLine AS 'Executed Checked Row', DWZ2.AutoPost AS 'Automatic Posting', DWZ2.DocRate AS 'Document Rate', DWZ2.UnpaidBoEV AS 'Unpaid BoE Value', DWZ2.BoENumber AS 'BoE Number', DWZ2.BoEStatus AS 'BoE Status', DWZ2.BoEDate AS 'BoE Date', DWZ2.BoEKey AS 'BoE Key' FROM DWZ2 AS DWZ2

Related information


Business Partner OCRD SQL Table

Currency Codes OCRN SQL Table

Dunning Wizard ODWZ 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