biuan SAP® BUSINESS ONE SDK
API PWZ4
PWZ4 - Payment Wizard - Rows 4 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdEntry KEY UNIQUEID EntryInt
11OPWZ
Payment Wizard
PRIMARYYes
PymNumPayment NumberInt
11
CardCodeVendor's Card codenVarChar
15OCRD
Business Partner
CardNameVendor's Card NamenVarChar
100
PymMethPayment MethodnVarChar
15OPYM
Payment Methods for Payment Wizard
GLAccCodeG/L Account CodenVarChar
15OACT
G/L Accounts
PymAmountSum of payment amountNum
20
PymAmntFCTotal Payment Amount (FC)Num
20
ObjTypeObject TypenVarChar
24) Incoming Payment
46) Outgoing Payment
20
RctIdDocument IDInt
11
DocCurrDocument CurrencynVarChar
3
BankAccouAcct No.nVarChar
50OACT
G/L Accounts
BnkDfltDefault BanknVarChar
30
BankCountrBank CountrynVarChar
3OCRY
Countries
BankActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
LineTypeLine TypeVarChar
1
G
ManualNumManual Entry No.Int
11
0
TBankCodeTarget Default BanknVarChar
30
-1
TDflAccounTarget Default AccountnVarChar
50
TBankCountTarget Bank CountrynVarChar
3OCRY
Countries
TargetBranTarget Bank BranchnVarChar
50
BcgPmntPayment Amount (BCG)Num
20
BcgPmntFcPayment Amount FC (BCG)Num
20
RecipStatuRecipient StatusnVarChar
2
BudgetIdBudget IDnVarChar
100
OKATOOKATOnVarChar
11
PymReasonPayment ReasonnVarChar
2
PostPeriodPosting Period CodenVarChar
10
BaseDocTypBase Document TypenVarChar
2
BaseDocDatBase Docoument DateDate
8
TaxPymTypeTax Payment TypenVarChar
2
OKTMOOKTMOnVarChar
12
IBANIBANnVarChar
50
SwiftNumBIC/SWIFT CodenVarChar
50

Table relationship map

SELECT statement

SELECT PWZ4.IdEntry AS 'ID Entry', PWZ4.PymNum AS 'Payment Number', PWZ4.CardCode AS 'Vendor's Card code', PWZ4.CardName AS 'Vendor's Card Name', PWZ4.PymMeth AS 'Payment Method', PWZ4.GLAccCode AS 'G/L Account Code', PWZ4.PymAmount AS 'Sum of payment amount', PWZ4.PymAmntFC AS 'Total Payment Amount (FC)', PWZ4.ObjType AS 'Object Type', PWZ4.RctId AS 'Document ID', PWZ4.DocCurr AS 'Document Currency', PWZ4.BankAccou AS 'Acct No.', PWZ4.BnkDflt AS 'Default Bank', PWZ4.BankCountr AS 'Bank Country', PWZ4.BankActKey AS 'Bank Account Internal ID', PWZ4.LineType AS 'Line Type', PWZ4.ManualNum AS 'Manual Entry No.', PWZ4.TBankCode AS 'Target Default Bank', PWZ4.TDflAccoun AS 'Target Default Account', PWZ4.TBankCount AS 'Target Bank Country', PWZ4.TargetBran AS 'Target Bank Branch', PWZ4.BcgPmnt AS 'Payment Amount (BCG)', PWZ4.BcgPmntFc AS 'Payment Amount FC (BCG)', PWZ4.RecipStatu AS 'Recipient Status', PWZ4.BudgetId AS 'Budget ID', PWZ4.OKATO AS 'OKATO', PWZ4.PymReason AS 'Payment Reason', PWZ4.PostPeriod AS 'Posting Period Code', PWZ4.BaseDocTyp AS 'Base Document Type', PWZ4.BaseDocDat AS 'Base Docoument Date', PWZ4.TaxPymType AS 'Tax Payment Type', PWZ4.OKTMO AS 'OKTMO', PWZ4.IBAN AS 'IBAN', PWZ4.SwiftNum AS 'BIC/SWIFT Code' FROM PWZ4 AS PWZ4

Related information


G/L Accounts OACT SQL Table

House Bank Accounts DSC1 SQL Table

Countries OCRY SQL Table

Business Partner OCRD 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