📚 SAP Business One SDK Help

Table Name: DWZ2

Table Description: Dunning Wizard Array 2-Invoice Filter

Field Description Type Size Related Default Value Constraints
WizardId Wizard ID Int 11 ODWZ      
CardCode BP Card Code nVarChar 15 OCRD      
LetterNum Letter Number Int 11 -      
TotalFee Total Fee Num 19.6 -      
FeeCurr Total Fee Currency nVarChar 3 OCRN      
TtlopnIntr Sum of Open Sum+Interest Num 19.6 -      
EDunLevel Edited Dunning Level nVarChar 3 -      
OpnIntrCrr Total Open + Interest Currency nVarChar 3 -      
DocAbs Document Internal Number Int 11 -      
DocNum Doc. No. Int 11 -      
InstlmntID Installment ID Int 6 -      
IntrstPC Interest Percent Num 19.6 -      
IntrstAmnt Interest Amount Num 19.6 -      
IntrstCurr Interest Currency nVarChar 3 OCRN      
ChckLine Checked Row VarChar 1 - N Y Yes
            N No
IntrstDays Interest Days Int 11 -      
DocType Source Table Int 11 -   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
DueDate Due Date Date 8 -      
LetterLvl Letter Level nVarChar 3 - 0    
OpenSum Open Sum Num 19.6 -      
OpenCurr Open Sum Currency nVarChar 3 -      
sumIntrClc Sum for Interest Calculation Num 19.6 -      
folioNum Folio Number nVarChar 14 -      
LvlUpdated Level Updated Flag VarChar 1 - N Y Yes
            N No
TotalFeeFC Total Fee in Document Currency Num 19.6 -      
TotalFeeLC Total Fee in Local Currency Num 19.6 -      
TotalFeeSC Total Fee in System Currency Num 19.6 -      
TtlopnInFC Sum of Open Sum+Interest FC Num 19.6 -      
TtlopnInSC Sum of Open Sum+Interest SC Num 19.6 -      
IntrAmtFC Interest Amount (FC) Num 19.6 -      
IntrAmtSC Interest Amount (SC) Num 19.6 -      
OpenSumFC Open Sum (FC) Num 19.6 -      
OpenSumSC Open Sum (SC) Num 19.6 -      
ExeChkLine Executed Checked Row VarChar 1 - N Y Yes
            N No
AutoPost Automatic Posting VarChar 1 - N N No
            B Interest and Fee
            I Interest Only
            F Fee Only
DocRate Document Rate Num 19.6 -      
UnpaidBoEV Unpaid BoE Value Num 19.6 -      
BoENumber BoE Number Int 11 -      
BoEStatus BoE Status VarChar 1 -      
BoEDate BoE Date Date 8 -      
BoEKey BoE Key Int 11 -      
BPType Business Partner Type VarChar 1 - C C Customer
            S Vendor
BPLId Assigned Branch Int 11 OBPL      
Key Unique Field
PRIMARY Yes WizardId
    LetterNum
    DocAbs
    InstlmntID
    DocType