DWZ1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Marketing Documents and Receipts /

Dunning Wizard Array1 - BP Filter

API DWZ1

DWZ1 - Dunning Wizard Array1 - BP Filter Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
WizardId ^KEY ^UNIQUE	Wizard ID	Int		11	ODWZ Dunning Wizard		PRIMARY	Yes
CardCode	BP Card Code	nVarChar		15	OCRD Business Partner
DunAddr	Dunning Address	nVarChar		127
CheckedBP	Checked BP	VarChar	Y) Yes N) No	1		Y
FaxNum	Fax Number	nVarChar		20
Email	E-Mail Address	nVarChar		100

Table relationship map

SELECT statement

SELECT
   DWZ1.WizardId AS 'Wizard ID', 
   DWZ1.CardCode AS 'BP Card Code', 
   DWZ1.DunAddr AS 'Dunning Address', 
   DWZ1.CheckedBP AS 'Checked BP', 
   DWZ1.FaxNum AS 'Fax Number', 
   DWZ1.Email AS 'E-Mail Address'
FROM DWZ1 AS DWZ1

Related information

OCRD SQL Table

ODWZ SQL Table

biuan SAP® BUSINESS ONE

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates