📚 SAP Business One SDK Help

Table Name: ODWZ

Table Description: Dunning Wizard

Field Description Type Size Related Default Value Constraints
WizardId Wizard ID Int 11 -      
WizardName Wizard Name nVarChar 100 -      
ToPayDate To be paid by Date 8 -      
CreateDate Creation Date Date 8 -      
Status Wizard Status VarChar 1 - S 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
DunLevel Dunning Level nVarChar 3 ODUN 0 0 All
            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
CreditZero Include BP with Credit VarChar 1 - N Y Yes
            N No
PayNoBased Payment on Account VarChar 1 - Y Y Yes
            N No
CrdtNBased Include Credit Not Based VarChar 1 - Y Y Yes
            N No
DunTime Dunning Time nVarChar 6 -      
UserSign User Signature Int 6 OUSR      
FromDate From Date Filter Date 8 -      
ToDate Date To Filter Date 8 -      
ManualJEs Include Manual JEs VarChar 1 - N N No
            Y Yes
DspOpnItms Display Open Items VarChar 1 - N Y Yes
            N No
AllowNegLt Allow Negative Dunning Letter VarChar 1 - N Y Yes
            N No
DunTerm Dunning Term nVarChar 25 ODUT -1    
FrmDueDate From Due Date Filter Date 8 -      
ToDueDate To Due Date Filter Date 8 -      
UpToDate Include Payments Up To Date 8 -      
InvPostDat Invc. Posting Date Date 8 -      
InvDueDate Invc. Due Date Date 8 -      
InvDocDate Invc. Doc. Date Date 8 -      
Project Project nVarChar 20 -      
OcrCode Costing Code nVarChar 8 -      
OcrCode2 Costing Code 2 nVarChar 8 -      
OcrCode3 Costing Code 3 nVarChar 8 -      
OcrCode4 Costing Code 4 nVarChar 8 -      
OcrCode5 Costing Code 5 nVarChar 8 -      
InVatGroup Interest VAT Group nVarChar 8 -      
InTaxCode Interest Tax Code nVarChar 8 -      
FeVatGroup Fee VAT Group nVarChar 8 -      
FeTaxCode Fee Tax Code nVarChar 8 -      
VatPrcnt VAT Percent Num 19.6 -      
AutoRmk Auto Remark VarChar 1 - Y    
Remarks Remarks nVarChar 254 -      
Series Series Int 11 NNM1 0    
BPLId BPL ID Assigned to Invoice Int 11 -      
LocCode Location Code Int 11 -      
VersionNum Version Number nVarChar 13 -      
OvrDueOnly BPs with Overdue Item Only VarChar 1 - N Y Yes
            N No
QuickDisp Quick Display VarChar 1 - N Y Yes
            N No
OPNoBased Include Outgoing Payments VarChar 1 - N Y Yes
            N No
CnsdVendor Consider Connected Vendor VarChar 1 - N Y Yes
            N No
SACIntrst SAC for Interest nVarChar 8 -      
SACFee SAC for Fee nVarChar 8 -      
Key Unique Field
PRIMARY Yes WizardId
SECONDARY No WizardName