biuan SAP® BUSINESS ONE SDK
API PWZ5
PWZ5 - Payment Wizard - Rows 5 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdEntry KEY UNIQUEID EntryInt
11OPWZ
Payment Wizard
PRIMARYYes
InvIDInv IDInt
11
AmountInvoice AmountNum
20
CardCodeCard CodenVarChar
15OCRD
Business Partner
CardNameCard NamenVarChar
100
PostDatePosting DateDate
8
ErrDiscError DiscriptionnVarChar
127
ErrorLineErrorLineInt
11
WriteErrWriteErrVarChar
1
Y
ObjectObject TypenVarChar
20
0
InstlmntIDInstallment IDInt
6
1
invNumInvoice No.Int
11
CurrencyCurrencynVarChar
3
LineTypeLine TypeVarChar
1
G
DueBalBalance DueNum
20
DueBalFCBalance Due (FC)Num
20
DueBalSysBalance Due (SC)Num
20
ValDateDue DateDate
8
BPLIdBranchInt
11OBPL
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


Business Place OBPL SQL Table

Business Partner OCRD SQL Table

Payment Wizard OPWZ SQL Table



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