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

SQL Banking / Payment Wizard - Rows 5

API PWZ5

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
IdEntry ^KEY ^UNIQUE	ID Entry	Int	11	OPWZ Payment Wizard		PRIMARY	Yes
InvID	Inv ID	Int	11
Amount	Invoice Amount	Num	20
CardCode	Card Code	nVarChar	15	OCRD Business Partner
CardName	Card Name	nVarChar	100
PostDate	Posting Date	Date	8
ErrDisc	Error Discription	nVarChar	127
ErrorLine	ErrorLine	Int	11
WriteErr	WriteErr	VarChar	1		Y
Object	Object Type	nVarChar	20		0
InstlmntID	Installment ID	Int	6		1
invNum	Invoice No.	Int	11
Currency	Currency	nVarChar	3
LineType	Line Type	VarChar	1		G
DueBal	Balance Due	Num	20
DueBalFC	Balance Due (FC)	Num	20
DueBalSys	Balance Due (SC)	Num	20
ValDate	Due Date	Date	8
BPLId	Branch	Int	11	OBPL Business Place

Table relationship map

SELECT statement

SELECT
   PWZ5.IdEntry AS 'ID Entry', 
   PWZ5.InvID AS 'Inv ID', 
   PWZ5.Amount AS 'Invoice Amount', 
   PWZ5.CardCode AS 'Card Code', 
   PWZ5.CardName AS 'Card Name', 
   PWZ5.PostDate AS 'Posting Date', 
   PWZ5.ErrDisc AS 'Error Discription', 
   PWZ5.ErrorLine AS 'ErrorLine', 
   PWZ5.WriteErr AS 'WriteErr', 
   PWZ5.Object AS 'Object Type', 
   PWZ5.InstlmntID AS 'Installment ID', 
   PWZ5.invNum AS 'Invoice No.', 
   PWZ5.Currency AS 'Currency', 
   PWZ5.LineType AS 'Line Type', 
   PWZ5.DueBal AS 'Balance Due', 
   PWZ5.DueBalFC AS 'Balance Due (FC)', 
   PWZ5.DueBalSys AS 'Balance Due (SC)', 
   PWZ5.ValDate AS 'Due Date', 
   PWZ5.BPLId AS 'Branch'
FROM PWZ5 AS PWZ5

Related information

OBPL SQL Table

OCRD SQL Table

OPWZ 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates