biuan SAP® BUSINESS ONE SDK
API PWZ3
PWZ3 - Payment Wizard - Rows 3 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdEntry KEY UNIQUEID EntryInt
11OPWZ
Payment Wizard
PRIMARYYes
PymNumPayment NumberInt
11OCRN
Currency Codes
CardCodeVendor CodenVarChar
15OCRD
Business Partner
CardNameVendor NamenVarChar
100
PymMethPayment MethodnVarChar
15OPYM
Payment Methods for Payment Wizard
GLAccCodeG/L Account CodenVarChar
15OACT
G/L Accounts
GLAccNameG/L Account NamenVarChar
100
PymAmountTotal PaymentNum
20
PymAmntFCTotal Payment (FC)Num
20
PymAmnSystTotal Payment (SC)Num
20
InvKeyInvoice KeyInt
11
DocNumDocument NumberInt
11
PostDatePosting DateDate
8
ValDateDue DateDate
8
TotalLocTotal (LC)Num
20
TotalFCTotal (FC)Num
20
TotalSysTotal (SC)Num
20
DueBalBalance DueNum
20
DueBalFCBalance Due (FC)Num
20
DueBalSysBalance Due (SC)Num
20
DiscPrcntDiscount %Num
20
DiscSumTotal DiscountNum
20
DiscSumFCTotal Discount (FC)Num
20
DiscSumSyTotal Discount (SC)Num
20
PayAmountPayment AmountNum
20
PayAmntFCPayment Amount (FC)Num
20
PayAmntSysPayment Amount (SC)Num
20
InvPayAmntTotal Invoice for PaymentNum
20
InvPayAmFCTotal Invoice for Payment (FC)Num
20
InvPayAmSyTotal Invoice for Payment (SC)Num
20
CardTypeBP TypeVarChar
C) Customer
S) Vendor
L) Lead
1
C
CountryBank CountrynVarChar
3OCRY
Countries
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
13
PymBnkTrnsPayment MeansVarChar
C) Check
T) Bank Transfer
B) Bill Of Exchange
1
C
ActFrmtCodAccount Format CodenVarChar
127
CheckedCheckedVarChar
1
FatherLineFather LineVarChar
1
N
InvCurrDocument CurrencynVarChar
3
LineRateRow RateNum
20
BfDcntSumAmount Before DiscountNum
20
BfNetDcntNet Amount Before DiscountNum
20
vatAppliedTax DefinitionNum
20
IsTaxIs TaxVarChar
1
Y
IsFreightIs FreightVarChar
1
Y
IsOrigMethOriginal Payment MethodVarChar
1
N
FreightSumFreight SumNum
20
IsrRefISR Ref. No.nVarChar
27
RoundSumRounding AmountNum
20
AgentAgent CodenVarChar
32OAGP
Agent Name
InstIdInstallment IDInt
6
1
WtSumWithholding Tax AmountNum
20
BoeNumBill of Exchange No.Int
11
NumAtCardBP Reference No.nVarChar
100
DeductPerDeduction PercentNum
20
DpmPostedDown Payment PostedVarChar
1
StatusInv StatusVarChar
1
NumOfCheckNumber of ChecksInt
11
1
SumFrstChkSum of First CheckNum
20
SumNxtChkSum of Next CheckNum
20
PayToCodePay tonVarChar
50
PayToCntrPay to Bank CountrynVarChar
3OCRY
Countries
PayToBankPay to Bank CodenVarChar
30
PayToActPay to Bank Account No.nVarChar
50
PymCurrPayment CurrencynVarChar
3
TaxOnExpSuTax on Freight AmountNum
20
TransIdTransaction Internal IDInt
11OJDT
Journal Entry
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
Line_IDJE Row NumberInt
11
0
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
PymDatePayment DateDate
8
BcgSumBank Charges AmountNum
20
BcgSumFCBank Charges Amount (FC)Num
20
BcgSumSyBank Charges Amount (SC)Num
20
BcgTaxSumBank Charge Tax AmountNum
20
BcgTaxSumFBank Charge Tax Amount (FC)Num
20
BcgTaxSumSBank Charge Tax Amount (SC)Num
20
PrjCodeProjectnVarChar
20OPRJ
Project Codes
BcgVatGrpBank Charge Tax GroupnVarChar
8OVTG
Tax Definition
LinePrjCodLine ProjectnVarChar
20OPRJ
Project Codes
BcgPmntPayment Amount (BCG)Num
20
BcgPmntFcPayment Amount FC (BCG)Num
20
BcgPmntScPayment Amount SC (BCG)Num
20
PayOrderNoPayment Order NumberInt
11OIPO
Internal Payment Order Number
LineTypeLine TypeVarChar
G) General
O) Pay on Account
T) Pay to Account
1
G
ManualNumManual Entry No.Int
11
0
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
Ref3Reference 3nVarChar
100
OrdrStatusPayment Order StatusVarChar
1
BnkCodeBank CodenVarChar
30
BnkAccNoBank Account NumbernVarChar
50
BranchBranchnVarChar
50
BnkCountrManual Line Bank CountrynVarChar
3
TBankCodeTarget Default BanknVarChar
30
-1
TDflAccounTarget Default AccountnVarChar
50
TBankCountTarget Bank CountrynVarChar
3OCRY
Countries
TargetBranTarget Bank BranchnVarChar
50
DscDueDateDiscount Due DateDate
8
CIGContract Code IdentificationInt
11OCIG
CIG Codes
CUPUnique Code of ProjectInt
11OCUP
CUP Codes
BoeCurrStaBoE Current StatusVarChar
1
BoeKeyBill of Exchange KeyInt
11OBOE
Bill of Exchange for Payment
BoeDateBoE DateDate
8
BoeDueDateBill of Exchange Due DateDate
8
Instruct1BoE Instruction 1nVarChar
2
Instruct2BoE Instruction 2nVarChar
2
BoeCancInsBoE Cancel InstructionnVarChar
2
BoeOccCodeBoE Occurrence CodenVarChar
2
BoePtfIDBoE Internal Portfolio IDnVarChar
3
BoeOurNumOur Number in Next BoEInt
11
BoeIntrAmBoE Interest AmountNum
20
BoeDiscDBoE Discount DateDate
8
BoeDisAmntBoE Discount AmountNum
20
BoeFineDBoE Fine DateDate
8
BoeFineAmtBoE Fine AmountNum
20
BoeIntrstDBoE Interest DateDate
8
BoeIOFAmtBoE IOF AmountNum
20
BoeMovCodeBoE Movement CodenVarChar
10
BarcodeRepBarcode RepresentationnVarChar
100
BPLIdBranchInt
11OBPL
Business Place
PONumberExternal Payment Order NumberInt
11
POSeriesExternal Payment Order SeriesInt
6
PaPriorityPayment PriorityVarChar
1)
2)
3)
4)
5)
6)
1
6
PaymTypePayment TypeVarChar
N)
E) Electronic
P) Mail
T) Telegraph
X) Express
1
N
OriPymMethOriginal Payment Method CodenVarChar
15
PymMethTypPayment Method TypeVarChar
I) Incoming
O) Outgoing
1
SinglePymSingle PaymentVarChar
N) No
Y) Yes
1
N
MandateIDMandate IDnVarChar
35
SeqTypeSequence TypenVarChar
OOFF) OOFF
FRST) FRST
RCUR) RCUR
FNAL) FNAL
4
BaseDocDatBase Document DateDate
8
OKATOOKATOnVarChar
11
PostPeriodPosting Period CodenVarChar
10
RecipStatuRecipient StatusnVarChar
2
BudgetIdBudget IDnVarChar
100
PymReasonPayment ReasonnVarChar
2
BaseDocTypBase Document TypenVarChar
2
TaxPymTypeTax Payment TypenVarChar
2
OKTMOOKTMOnVarChar
12
PymIsUpdatPayment method is updatednVarChar
30
OriPymCodeOriginal Payment Method CodenVarChar
15
OriPymTypeOriginal Payment Method TypeVarChar
1
ReasonCodeReason CodeInt
11
OriActCodeOriginal Account CodenVarChar
15
OriActNameOriginal Account NamenVarChar
100
ReasonLineReason LineInt
11
OriFormatOriginal Format CodenVarChar
127
WtIsPymWithholding Tax is Payment TypeVarChar
N) No
Y) Yes
1
N
IBANIBANnVarChar
50
SwiftNumBIC/SWIFT CodenVarChar
50

Table relationship map

SELECT statement

SELECT PWZ3.IdEntry AS 'ID Entry', PWZ3.PymNum AS 'Payment Number', PWZ3.CardCode AS 'Vendor Code', PWZ3.CardName AS 'Vendor Name', PWZ3.PymMeth AS 'Payment Method', PWZ3.GLAccCode AS 'G/L Account Code', PWZ3.GLAccName AS 'G/L Account Name', PWZ3.PymAmount AS 'Total Payment', PWZ3.PymAmntFC AS 'Total Payment (FC)', PWZ3.PymAmnSyst AS 'Total Payment (SC)', PWZ3.InvKey AS 'Invoice Key', PWZ3.DocNum AS 'Document Number', PWZ3.PostDate AS 'Posting Date', PWZ3.ValDate AS 'Due Date', PWZ3.TotalLoc AS 'Total (LC)', PWZ3.TotalFC AS 'Total (FC)', PWZ3.TotalSys AS 'Total (SC)', PWZ3.DueBal AS 'Balance Due', PWZ3.DueBalFC AS 'Balance Due (FC)', PWZ3.DueBalSys AS 'Balance Due (SC)', PWZ3.DiscPrcnt AS 'Discount %', PWZ3.DiscSum AS 'Total Discount', PWZ3.DiscSumFC AS 'Total Discount (FC)', PWZ3.DiscSumSy AS 'Total Discount (SC)', PWZ3.PayAmount AS 'Payment Amount', PWZ3.PayAmntFC AS 'Payment Amount (FC)', PWZ3.PayAmntSys AS 'Payment Amount (SC)', PWZ3.InvPayAmnt AS 'Total Invoice for Payment', PWZ3.InvPayAmFC AS 'Total Invoice for Payment (FC)', PWZ3.InvPayAmSy AS 'Total Invoice for Payment (SC)', PWZ3.CardType AS 'BP Type', PWZ3.Country AS 'Bank Country', PWZ3.ObjType AS 'Object Type', PWZ3.PymBnkTrns AS 'Payment Means', PWZ3.ActFrmtCod AS 'Account Format Code', PWZ3.Checked AS 'Checked', PWZ3.FatherLine AS 'Father Line', PWZ3.InvCurr AS 'Document Currency', PWZ3.LineRate AS 'Row Rate', PWZ3.BfDcntSum AS 'Amount Before Discount', PWZ3.BfNetDcnt AS 'Net Amount Before Discount', PWZ3.vatApplied AS 'Tax Definition', PWZ3.IsTax AS 'Is Tax', PWZ3.IsFreight AS 'Is Freight', PWZ3.IsOrigMeth AS 'Original Payment Method', PWZ3.FreightSum AS 'Freight Sum', PWZ3.IsrRef AS 'ISR Ref. No.', PWZ3.RoundSum AS 'Rounding Amount', PWZ3.Agent AS 'Agent Code', PWZ3.InstId AS 'Installment ID', PWZ3.WtSum AS 'Withholding Tax Amount', PWZ3.BoeNum AS 'Bill of Exchange No.', PWZ3.NumAtCard AS 'BP Reference No.', PWZ3.DeductPer AS 'Deduction Percent', PWZ3.DpmPosted AS 'Down Payment Posted', PWZ3.Status AS 'Inv Status', PWZ3.NumOfCheck AS 'Number of Checks', PWZ3.SumFrstChk AS 'Sum of First Check', PWZ3.SumNxtChk AS 'Sum of Next Check', PWZ3.PayToCode AS 'Pay to', PWZ3.PayToCntr AS 'Pay to Bank Country', PWZ3.PayToBank AS 'Pay to Bank Code', PWZ3.PayToAct AS 'Pay to Bank Account No.', PWZ3.PymCurr AS 'Payment Currency', PWZ3.TaxOnExpSu AS 'Tax on Freight Amount', PWZ3.TransId AS 'Transaction Internal ID', PWZ3.OcrCode AS 'Distribution Rule', PWZ3.Line_ID AS 'JE Row Number', PWZ3.OcrCode2 AS 'Distribution Rule2', PWZ3.OcrCode3 AS 'Distribution Rule3', PWZ3.OcrCode4 AS 'Distribution Rule4', PWZ3.OcrCode5 AS 'Distribution Rule5', PWZ3.PymDate AS 'Payment Date', PWZ3.BcgSum AS 'Bank Charges Amount', PWZ3.BcgSumFC AS 'Bank Charges Amount (FC)', PWZ3.BcgSumSy AS 'Bank Charges Amount (SC)', PWZ3.BcgTaxSum AS 'Bank Charge Tax Amount', PWZ3.BcgTaxSumF AS 'Bank Charge Tax Amount (FC)', PWZ3.BcgTaxSumS AS 'Bank Charge Tax Amount (SC)', PWZ3.PrjCode AS 'Project', PWZ3.BcgVatGrp AS 'Bank Charge Tax Group', PWZ3.LinePrjCod AS 'Line Project', PWZ3.BcgPmnt AS 'Payment Amount (BCG)', PWZ3.BcgPmntFc AS 'Payment Amount FC (BCG)', PWZ3.BcgPmntSc AS 'Payment Amount SC (BCG)', PWZ3.PayOrderNo AS 'Payment Order Number', PWZ3.LineType AS 'Line Type', PWZ3.ManualNum AS 'Manual Entry No.', PWZ3.Ref1 AS 'Reference 1', PWZ3.Ref2 AS 'Reference 2', PWZ3.Ref3 AS 'Reference 3', PWZ3.OrdrStatus AS 'Payment Order Status', PWZ3.BnkCode AS 'Bank Code', PWZ3.BnkAccNo AS 'Bank Account Number', PWZ3.Branch AS 'Branch', PWZ3.BnkCountr AS 'Manual Line Bank Country', PWZ3.TBankCode AS 'Target Default Bank', PWZ3.TDflAccoun AS 'Target Default Account', PWZ3.TBankCount AS 'Target Bank Country', PWZ3.TargetBran AS 'Target Bank Branch', PWZ3.DscDueDate AS 'Discount Due Date', PWZ3.CIG AS 'Contract Code Identification', PWZ3.CUP AS 'Unique Code of Project', PWZ3.BoeCurrSta AS 'BoE Current Status', PWZ3.BoeKey AS 'Bill of Exchange Key', PWZ3.BoeDate AS 'BoE Date', PWZ3.BoeDueDate AS 'Bill of Exchange Due Date', PWZ3.Instruct1 AS 'BoE Instruction 1', PWZ3.Instruct2 AS 'BoE Instruction 2', PWZ3.BoeCancIns AS 'BoE Cancel Instruction', PWZ3.BoeOccCode AS 'BoE Occurrence Code', PWZ3.BoePtfID AS 'BoE Internal Portfolio ID', PWZ3.BoeOurNum AS 'Our Number in Next BoE', PWZ3.BoeIntrAm AS 'BoE Interest Amount', PWZ3.BoeDiscD AS 'BoE Discount Date', PWZ3.BoeDisAmnt AS 'BoE Discount Amount', PWZ3.BoeFineD AS 'BoE Fine Date', PWZ3.BoeFineAmt AS 'BoE Fine Amount', PWZ3.BoeIntrstD AS 'BoE Interest Date', PWZ3.BoeIOFAmt AS 'BoE IOF Amount', PWZ3.BoeMovCode AS 'BoE Movement Code', PWZ3.BarcodeRep AS 'Barcode Representation', PWZ3.BPLId AS 'Branch', PWZ3.PONumber AS 'External Payment Order Number', PWZ3.POSeries AS 'External Payment Order Series', PWZ3.PaPriority AS 'Payment Priority', PWZ3.PaymType AS 'Payment Type', PWZ3.OriPymMeth AS 'Original Payment Method Code', PWZ3.PymMethTyp AS 'Payment Method Type', PWZ3.SinglePym AS 'Single Payment', PWZ3.MandateID AS 'Mandate ID', PWZ3.SeqType AS 'Sequence Type', PWZ3.BaseDocDat AS 'Base Document Date', PWZ3.OKATO AS 'OKATO', PWZ3.PostPeriod AS 'Posting Period Code', PWZ3.RecipStatu AS 'Recipient Status', PWZ3.BudgetId AS 'Budget ID', PWZ3.PymReason AS 'Payment Reason', PWZ3.BaseDocTyp AS 'Base Document Type', PWZ3.TaxPymType AS 'Tax Payment Type', PWZ3.OKTMO AS 'OKTMO', PWZ3.PymIsUpdat AS 'Payment method is updated', PWZ3.OriPymCode AS 'Original Payment Method Code', PWZ3.OriPymType AS 'Original Payment Method Type', PWZ3.ReasonCode AS 'Reason Code', PWZ3.OriActCode AS 'Original Account Code', PWZ3.OriActName AS 'Original Account Name', PWZ3.ReasonLine AS 'Reason Line', PWZ3.OriFormat AS 'Original Format Code', PWZ3.WtIsPym AS 'Withholding Tax is Payment Type', PWZ3.IBAN AS 'IBAN', PWZ3.SwiftNum AS 'BIC/SWIFT Code' FROM PWZ3 AS PWZ3

Related information


Agent Name OAGP SQL Table

Tax Definition OVTG SQL Table

Bill of Exchange for Payment OBOE SQL Table

Business Place OBPL SQL Table

Business Partner OCRD SQL Table

CIG Codes OCIG SQL Table

Countries OCRY SQL Table

CUP Codes OCUP SQL Table

G/L Accounts OACT SQL Table

Payment Wizard OPWZ SQL Table

Project Codes OPRJ SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Internal Payment Order Number OIPO SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Currency Codes OCRN SQL Table

Journal Entry OJDT 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