biuan SAP® BUSINESS ONE SDK
API PWZ2
PWZ2 - Payment Wizard - Rows 2 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdEntry KEY UNIQUEID EntryInt
11OPWZ
Payment Wizard
PRIMARYYes
PymCodePayment Method CodenVarChar
15OPYM
Payment Methods for Payment Wizard
BnkAccountBank AccountnVarChar
15OACT
G/L Accounts
MaxIncomMax. Incoming AmountNum
20
MaxOutgoMax. Outgoing AmountNum
20
BalanceG/L BalanceNum
20
ExpectBalExpected G/L BalanceNum
20
CheckedCheckedVarChar
1
PymDiscPayment discriptionnVarChar
100
PymTypePayment TypeVarChar
1
IntBalanceG/L Interim BalanceNum
20
ExpIntBalExpected G/L Interim BalanceNum
20
InterimActInterim AccountnVarChar
15OACT
G/L Accounts
BnkCountryBank CountrynVarChar
3
BnkCodeBank CodenVarChar
30
BnkAccNoBank Account NumbernVarChar
50
FatherLnParent LineVarChar
Y) Yes
N) No
1
N
NegativPymNegative Payment Method CodenVarChar
15
NegPymBnkNegative Payment Bank CodenVarChar
30
NegCountryNegative Payment Bank CountrynVarChar
3
NegPymAcctNegative Payment Bank AccountnVarChar
50
PaymenMeanPayment MeansVarChar
1
IBANIBANnVarChar
50
SwiftNumBIC/SWIFT CodenVarChar
50

Table relationship map

SELECT statement

SELECT PWZ2.IdEntry AS 'ID Entry', PWZ2.PymCode AS 'Payment Method Code', PWZ2.BnkAccount AS 'Bank Account', PWZ2.MaxIncom AS 'Max. Incoming Amount', PWZ2.MaxOutgo AS 'Max. Outgoing Amount', PWZ2.Balance AS 'G/L Balance', PWZ2.ExpectBal AS 'Expected G/L Balance', PWZ2.Checked AS 'Checked', PWZ2.PymDisc AS 'Payment discription', PWZ2.PymType AS 'Payment Type', PWZ2.IntBalance AS 'G/L Interim Balance', PWZ2.ExpIntBal AS 'Expected G/L Interim Balance', PWZ2.InterimAct AS 'Interim Account', PWZ2.BnkCountry AS 'Bank Country', PWZ2.BnkCode AS 'Bank Code', PWZ2.BnkAccNo AS 'Bank Account Number', PWZ2.FatherLn AS 'Parent Line', PWZ2.NegativPym AS 'Negative Payment Method Code', PWZ2.NegPymBnk AS 'Negative Payment Bank Code', PWZ2.NegCountry AS 'Negative Payment Bank Country', PWZ2.NegPymAcct AS 'Negative Payment Bank Account', PWZ2.PaymenMean AS 'Payment Means', PWZ2.IBAN AS 'IBAN', PWZ2.SwiftNum AS 'BIC/SWIFT Code' FROM PWZ2 AS PWZ2

Related information


G/L Accounts OACT SQL Table

Payment Wizard OPWZ SQL Table

Payment Methods for Payment Wizard OPYM 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