biuan SAP® BUSINESS ONE SDK
API DWZ4
DWZ4 - Dunning Wizard Array 4-Paging Grid Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11ODWZ
Dunning Wizard
PRIMARYYes
CheckLineChecked RowVarChar
1
Y
ExeChkLineExecuted Checked RowVarChar
1
Y
RowIdRow NumInt
11
CardCodeBP Card CodenVarChar
15OCRD
Business Partner
LetterNumLetter NumberInt
11
DunnLevelDunning LevelInt
11
CardNameBP NamenVarChar
100
DocCurDoc. CurrencynVarChar
3
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
11
DocNumDoc. No.Int
11
InstlmntIDInstallment IDInt
6
DueDateDue DateDate
8
LastLvlDteLast Update DateDate
8
LastDunDteLast Dunning DateDate
8
NewLvlDateNew Level Update DateDate
8
DocAmntLCDOC. AMOUNT (LC)nVarChar
100
DocAmntFCDOC. AMOUNT (FC)nVarChar
100
OpenAmtLCOpen Amount (LC)nVarChar
100
OpenAmtFCOpen Amount (FC)nVarChar
100
IntrstDaysInterest DaysInt
11
IntrstPCInterest PercentNum
20
IntAmntLCInterest Amount (LC)nVarChar
100
IntAmntFCInterest Amount (FC)nVarChar
100
InclAmntLCTotal Incl. Amount (LC)nVarChar
100
InclAmntFCTotal Incl. Amount (FC)nVarChar
100
FeeLCFee (LC)nVarChar
100
FeeFCFee (FC)nVarChar
100
AllTotalLCOverall Total (LC)nVarChar
100
AllTotalFCOverall Total (FC)nVarChar
100
AutoPostAutomatic PostingVarChar
N) No
B) Interest and Fee
I) Interest Only
F) Fee Only
1
N
LinePropLine PropertyInt
11
YearDaysYear DaysInt
11
YearlyRateYearly RateNum
20
LetterFrmtLetter FormantnVarChar
8
MinBlanMin. BalanceNum
20
GrpMethodGroup MethodVarChar
1
DocEntryDocEntryInt
11
DocRateExchange Rate on DocumentnVarChar
100
FeeCurrFee CurrencynVarChar
3
OrigFeeOriginal Fee on Dunning TermNum
20
MinBalCurrMinimum Balance CurrencynVarChar
3
LvlUpdatedLevel UpdatednVarChar
3
DunAddrDunning AddressnVarChar
127
DocTextDoc. TextnVarChar
127
ParentIdParent IdInt
11

Table relationship map

SELECT statement

SELECT DWZ4.WizardId AS 'Wizard ID', DWZ4.CheckLine AS 'Checked Row', DWZ4.ExeChkLine AS 'Executed Checked Row', DWZ4.RowId AS 'Row Num', DWZ4.CardCode AS 'BP Card Code', DWZ4.LetterNum AS 'Letter Number', DWZ4.DunnLevel AS 'Dunning Level', DWZ4.CardName AS 'BP Name', DWZ4.DocCur AS 'Doc. Currency', DWZ4.DocType AS 'Source Table', DWZ4.DocNum AS 'Doc. No.', DWZ4.InstlmntID AS 'Installment ID', DWZ4.DueDate AS 'Due Date', DWZ4.LastLvlDte AS 'Last Update Date', DWZ4.LastDunDte AS 'Last Dunning Date', DWZ4.NewLvlDate AS 'New Level Update Date', DWZ4.DocAmntLC AS 'DOC. AMOUNT (LC)', DWZ4.DocAmntFC AS 'DOC. AMOUNT (FC)', DWZ4.OpenAmtLC AS 'Open Amount (LC)', DWZ4.OpenAmtFC AS 'Open Amount (FC)', DWZ4.IntrstDays AS 'Interest Days', DWZ4.IntrstPC AS 'Interest Percent', DWZ4.IntAmntLC AS 'Interest Amount (LC)', DWZ4.IntAmntFC AS 'Interest Amount (FC)', DWZ4.InclAmntLC AS 'Total Incl. Amount (LC)', DWZ4.InclAmntFC AS 'Total Incl. Amount (FC)', DWZ4.FeeLC AS 'Fee (LC)', DWZ4.FeeFC AS 'Fee (FC)', DWZ4.AllTotalLC AS 'Overall Total (LC)', DWZ4.AllTotalFC AS 'Overall Total (FC)', DWZ4.AutoPost AS 'Automatic Posting', DWZ4.LineProp AS 'Line Property', DWZ4.YearDays AS 'Year Days', DWZ4.YearlyRate AS 'Yearly Rate', DWZ4.LetterFrmt AS 'Letter Formant', DWZ4.MinBlan AS 'Min. Balance', DWZ4.GrpMethod AS 'Group Method', DWZ4.DocEntry AS 'DocEntry', DWZ4.DocRate AS 'Exchange Rate on Document', DWZ4.FeeCurr AS 'Fee Currency', DWZ4.OrigFee AS 'Original Fee on Dunning Term', DWZ4.MinBalCurr AS 'Minimum Balance Currency', DWZ4.LvlUpdated AS 'Level Updated', DWZ4.DunAddr AS 'Dunning Address', DWZ4.DocText AS 'Doc. Text', DWZ4.ParentId AS 'Parent Id' FROM DWZ4 AS DWZ4

Related information


Business Partner OCRD 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates