biuan SAP® BUSINESS ONE SDK
API ODWZ
ODWZ - Dunning Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11
PRIMARYYes
WizardName KEYWizard NamenVarChar
100
SECONDARYNo
ToPayDateTo be paid byDate
8
CreateDateCreation DateDate
8
StatusWizard StatusVarChar
S) Saved Parameters
R) Saved Recommendations
E) Executed and Printed or Sent by E-Mail
O) Executed, Not Yet Printed or Sent by E-Mail
P) Partially Executed and Printed
T) Partially Executed, Not Yet Printed or Sent by E-Mail
1
S
DunLevelDunning LevelnVarChar
0
1) Level 1
2) Level 2
3) Level 3
4) Level 4
5) Level 5
6) Level 6
7) Level 7
8) Level 8
9) Level 9
10) Level 10
3ODUN
Dunning Letters
0
CreditZeroInclude BP with CreditVarChar
Y) Yes
N) No
1
N
PayNoBasedPayment on AccountVarChar
Y) Yes
N) No
1
Y
CrdtNBasedInclude Credit Not BasedVarChar
Y) Yes
N) No
1
Y
DunTimeDunning TimenVarChar
6
UserSignUser SignatureInt
6OUSR
Users
FromDateFrom Date FilterDate
8
ToDateDate To FilterDate
8
ManualJEsInclude Manual JEsVarChar
N) No
Y) Yes
1
N
DspOpnItmsDisplay Open ItemsVarChar
Y) Yes
N) No
1
N
AllowNegLtAllow Negative Dunning LetterVarChar
Y) Yes
N) No
1
N
DunTermDunning TermnVarChar
25ODUT
Dunning Terms
-1
FrmDueDateFrom Due Date FilterDate
8
ToDueDateTo Due Date FilterDate
8
UpToDateInclude Payments Up ToDate
8
InvPostDatInvc. Posting DateDate
8
InvDueDateInvc. Due DateDate
8
InvDocDateInvc. Doc. DateDate
8
ProjectProjectnVarChar
20
OcrCodeCosting CodenVarChar
8
OcrCode2Costing Code 2nVarChar
8
OcrCode3Costing Code 3nVarChar
8
OcrCode4Costing Code 4nVarChar
8
OcrCode5Costing Code 5nVarChar
8
InVatGroupInterest VAT GroupnVarChar
8
InTaxCodeInterest Tax CodenVarChar
8
FeVatGroupFee VAT GroupnVarChar
8
FeTaxCodeFee Tax CodenVarChar
8
VatPrcntVAT PercentNum
20
AutoRmkAuto RemarkVarChar
1
Y
RemarksRemarksnVarChar
127
SeriesSeriesInt
6NNM1
Documents Numbering - Series
0
BPLIdBPL ID Assigned to InvoiceInt
11
LocCodeLocation CodeInt
11
VersionNumVersion NumbernVarChar
11
OvrDueOnlyBPs with Overdue Item OnlyVarChar
Y) Yes
N) No
1
N
QuickDispQuick DisplayVarChar
Y) Yes
N) No
1
N
OPNoBasedInclude Outgoing PaymentsVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ODWZ.WizardId AS 'Wizard ID', ODWZ.WizardName AS 'Wizard Name', ODWZ.ToPayDate AS 'To be paid by', ODWZ.CreateDate AS 'Creation Date', ODWZ.Status AS 'Wizard Status', ODWZ.DunLevel AS 'Dunning Level', ODWZ.CreditZero AS 'Include BP with Credit', ODWZ.PayNoBased AS 'Payment on Account', ODWZ.CrdtNBased AS 'Include Credit Not Based', ODWZ.DunTime AS 'Dunning Time', ODWZ.UserSign AS 'User Signature', ODWZ.FromDate AS 'From Date Filter', ODWZ.ToDate AS 'Date To Filter', ODWZ.ManualJEs AS 'Include Manual JEs', ODWZ.DspOpnItms AS 'Display Open Items', ODWZ.AllowNegLt AS 'Allow Negative Dunning Letter', ODWZ.DunTerm AS 'Dunning Term', ODWZ.FrmDueDate AS 'From Due Date Filter', ODWZ.ToDueDate AS 'To Due Date Filter', ODWZ.UpToDate AS 'Include Payments Up To', ODWZ.InvPostDat AS 'Invc. Posting Date', ODWZ.InvDueDate AS 'Invc. Due Date', ODWZ.InvDocDate AS 'Invc. Doc. Date', ODWZ.Project AS 'Project', ODWZ.OcrCode AS 'Costing Code', ODWZ.OcrCode2 AS 'Costing Code 2', ODWZ.OcrCode3 AS 'Costing Code 3', ODWZ.OcrCode4 AS 'Costing Code 4', ODWZ.OcrCode5 AS 'Costing Code 5', ODWZ.InVatGroup AS 'Interest VAT Group', ODWZ.InTaxCode AS 'Interest Tax Code', ODWZ.FeVatGroup AS 'Fee VAT Group', ODWZ.FeTaxCode AS 'Fee Tax Code', ODWZ.VatPrcnt AS 'VAT Percent', ODWZ.AutoRmk AS 'Auto Remark', ODWZ.Remarks AS 'Remarks', ODWZ.Series AS 'Series', ODWZ.BPLId AS 'BPL ID Assigned to Invoice', ODWZ.LocCode AS 'Location Code', ODWZ.VersionNum AS 'Version Number', ODWZ.OvrDueOnly AS 'BPs with Overdue Item Only', ODWZ.QuickDisp AS 'Quick Display', ODWZ.OPNoBased AS 'Include Outgoing Payments' FROM ODWZ AS ODWZ

Related information


ODWZ SQL Table

Dunning Letters ODUN SQL Table

Dunning Terms ODUT SQL Table

Documents Numbering - Series NNM1 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