biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Dunning Wizard Array 3 - Recommended Service Invoice
API DWZ3
DWZ3 - Dunning Wizard Array 3 - Recommended Service Invoice Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11
PRIMARYYes
CardCodeBP Card CodenVarChar
15
LetterNumLetter NumberInt
11
AddCheckedAdd CheckedVarChar
1
Y
DocAbsInternal Document NumberInt
11
IntrAmtInterest Amount (LC)Num
20
IntrAmtFCInterest Amount (FC)Num
20
IntrAmtSCInterest Amount (SC)Num
20
FeeAmtFee Amount (LC)Num
20
FeeAmtFCFee Amount (FC)Num
20
FeeAmtSCFee Amount (SC)Num
20
InVatGroupInterest VAT GroupnVarChar
8
InTaxCodeInterest Tax CodenVarChar
8
FeVatGroupFee VAT GroupnVarChar
8
FeTaxCodeFee Tax CodenVarChar
8
VatPrcntVAT PercentNum
20
ExecutedExecutedVarChar
Y) Yes
N) No
1
N
MessageMessagenVarChar
127
DocCurDocument CurrencynVarChar
3OCRN
Currency Codes
DocNumDocument NumberInt
11
BPLIdBPL ID Assigned to InvoiceInt
11
LocCodeLocation CodeInt
11

SELECT statement

SELECT DWZ3.WizardId AS 'Wizard ID', DWZ3.CardCode AS 'BP Card Code', DWZ3.LetterNum AS 'Letter Number', DWZ3.AddChecked AS 'Add Checked', DWZ3.DocAbs AS 'Internal Document Number', DWZ3.IntrAmt AS 'Interest Amount (LC)', DWZ3.IntrAmtFC AS 'Interest Amount (FC)', DWZ3.IntrAmtSC AS 'Interest Amount (SC)', DWZ3.FeeAmt AS 'Fee Amount (LC)', DWZ3.FeeAmtFC AS 'Fee Amount (FC)', DWZ3.FeeAmtSC AS 'Fee Amount (SC)', DWZ3.InVatGroup AS 'Interest VAT Group', DWZ3.InTaxCode AS 'Interest Tax Code', DWZ3.FeVatGroup AS 'Fee VAT Group', DWZ3.FeTaxCode AS 'Fee Tax Code', DWZ3.VatPrcnt AS 'VAT Percent', DWZ3.Executed AS 'Executed', DWZ3.Message AS 'Message', DWZ3.DocCur AS 'Document Currency', DWZ3.DocNum AS 'Document Number', DWZ3.BPLId AS 'BPL ID Assigned to Invoice', DWZ3.LocCode AS 'Location Code' FROM DWZ3 AS DWZ3

Related information


Currency Codes OCRN 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