biuan SAP® BUSINESS ONE SDK
API OPWZ
OPWZ - Payment Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdNumber KEY UNIQUEID NumberInt
11
PRIMARYYes
PmntDateDate of Payment RunDate
8
NextDateA/P Due Date ToDate
8
OutgoTypeOutgoing TypeVarChar
Y) Yes
N) No
1
N
IncomTypeIncoming TypeVarChar
Y) Yes
N) No
1
N
CheckPmntMCheck Payment TermsVarChar
Y) Yes
N) No
1
N
BnkTrnsPmMBank Transfer Payment TermsVarChar
Y) Yes
N) No
1
N
FilePathFile PathText
16
PostDtFromPosting Date FromDate
8
PostDtToPosting Date ToDate
8
ValDteFromDue Date FromDate
8
ValDateToDue Date ToDate
8
ApInvAmntFA/P Invoice Amount FromNum
20
ApInvAmntTA/P Invoice Amount ToNum
20
PchNoFromA/P Invoice No. FromInt
11
PchNoToA/P Invoice No. ToInt
11
InvNoFromA/R Invoice No. FromInt
11
InvNoToA/R Invoice No. ToInt
11
SelPrioritSelection PriorityInt
11
StatusObject StatusVarChar
S) Saved Wizard
R) Recommended Wizard
E) Executed Wizard
1
S
WizardName KEY UNIQUEWizard NamenVarChar
100
NAMEYes
StatusDiscStatusnVarChar
100
CanceledCanceledVarChar
1
N
BoePmnMnBill of Exchange Paymt MethodVarChar
Y) Yes
N) No
1
N
SeriesOutOutgoing SeriesInt
6NNM1
Documents Numbering - Series
0
SeriesInIncoming SeriesInt
6NNM1
Documents Numbering - Series
0
TotalOutTotal OutgoingNum
20
TotalInTotal IncomingNum
20
ViewIntBalInclude Interim Acct BalanceVarChar
Y) Yes
N) No
1
N
SelMthdSelection MethodVarChar
M) By Monthly Invoice
D) By Document Property
1
D
MINumFromMonthly Invoice No. FromInt
11
MINumToMonthly Invoice No. ToInt
11
MIDateFromMonthly Invoice Issued Date FromDate
8
MIDateToMonthly Invoice Issued Date ToDate
8
MIVNumFromA/P Monthly Invoice No. FromInt
11
MIVNumToA/P Monthly Invoice No. ToInt
11
MIVDateFroA/P Monthly Invoice Date FromDate
8
MIVDateToA/P Monthly Invoice Date ToDate
8
APDocDtFrmA/P Document Date FromDate
8
APDocDtToA/P Document Date ToDate
8
APDueDtFrmA/P Due Date FromDate
8
NxtPmntDatNext Payment Run DateDate
8
MinPayARMinimum Incoming PaymentNum
20
MinPayAPMinimum Outgoing PaymentNum
20
ShowAtCardDisplay BP Ref. No.VarChar
Y) Yes
N) No
1
N
TolerDaysTolerance DaysInt
6
MinCashDisMin. Cash DiscountNum
20
NegBalBPInclude Negative Balance BPVarChar
Y) Yes
N) No
1
N
ManualJEInclude Manual JEsVarChar
Y) Yes
N) No
1
Y
NegTransInclude Negative TransactionsVarChar
Y) Yes
N) No
1
Y
CDTransAppApply to Cash Discount Trans.VarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
CigToContract Code ID ToInt
11OCIG
CIG Codes
CupFromUnique Code of Project FromInt
11OCUP
CUP Codes
CupToUnique Code of Project ToInt
11OCUP
CUP Codes
CigFromContract Code ID FromInt
11OCIG
CIG Codes
BPLIdActive BranchInt
11OBPL
Business Place
BoeDDFromBoE Due Date FromDate
8
BoeDDToBoE Due Date ToDate
8
BoeNumFromBoE No. FromInt
11OBOE
Bill of Exchange for Payment
BoeNumToBoE No. ToInt
11OBOE
Bill of Exchange for Payment
BoeStatusBill of Exchange StatusnVarChar
32
HaExistBoeHandle Existing BoEVarChar
Y) Yes
N) No
1
N
SeriesPOOOutgoing Payment Order SeriesInt
6NNM1
Documents Numbering - Series
0
SeriesPOIIncoming Payment Order SeriesInt
6NNM1
Documents Numbering - Series
0
SeqTypeSequence TypenVarChar
4
PayDueDatePayment Due Date DeterminationVarChar
R) Run Date
D) Document Due Date
1
R

Table relationship map

SELECT statement

SELECT OPWZ.IdNumber AS 'ID Number', OPWZ.PmntDate AS 'Date of Payment Run', OPWZ.NextDate AS 'A/P Due Date To', OPWZ.OutgoType AS 'Outgoing Type', OPWZ.IncomType AS 'Incoming Type', OPWZ.CheckPmntM AS 'Check Payment Terms', OPWZ.BnkTrnsPmM AS 'Bank Transfer Payment Terms', OPWZ.FilePath AS 'File Path', OPWZ.PostDtFrom AS 'Posting Date From', OPWZ.PostDtTo AS 'Posting Date To', OPWZ.ValDteFrom AS 'Due Date From', OPWZ.ValDateTo AS 'Due Date To', OPWZ.ApInvAmntF AS 'A/P Invoice Amount From', OPWZ.ApInvAmntT AS 'A/P Invoice Amount To', OPWZ.PchNoFrom AS 'A/P Invoice No. From', OPWZ.PchNoTo AS 'A/P Invoice No. To', OPWZ.InvNoFrom AS 'A/R Invoice No. From', OPWZ.InvNoTo AS 'A/R Invoice No. To', OPWZ.SelPriorit AS 'Selection Priority', OPWZ.Status AS 'Object Status', OPWZ.WizardName AS 'Wizard Name', OPWZ.StatusDisc AS 'Status', OPWZ.Canceled AS 'Canceled', OPWZ.BoePmnMn AS 'Bill of Exchange Paymt Method', OPWZ.SeriesOut AS 'Outgoing Series', OPWZ.SeriesIn AS 'Incoming Series', OPWZ.TotalOut AS 'Total Outgoing', OPWZ.TotalIn AS 'Total Incoming', OPWZ.ViewIntBal AS 'Include Interim Acct Balance', OPWZ.SelMthd AS 'Selection Method', OPWZ.MINumFrom AS 'Monthly Invoice No. From', OPWZ.MINumTo AS 'Monthly Invoice No. To', OPWZ.MIDateFrom AS 'Monthly Invoice Issued Date From', OPWZ.MIDateTo AS 'Monthly Invoice Issued Date To', OPWZ.MIVNumFrom AS 'A/P Monthly Invoice No. From', OPWZ.MIVNumTo AS 'A/P Monthly Invoice No. To', OPWZ.MIVDateFro AS 'A/P Monthly Invoice Date From', OPWZ.MIVDateTo AS 'A/P Monthly Invoice Date To', OPWZ.APDocDtFrm AS 'A/P Document Date From', OPWZ.APDocDtTo AS 'A/P Document Date To', OPWZ.APDueDtFrm AS 'A/P Due Date From', OPWZ.NxtPmntDat AS 'Next Payment Run Date', OPWZ.MinPayAR AS 'Minimum Incoming Payment', OPWZ.MinPayAP AS 'Minimum Outgoing Payment', OPWZ.ShowAtCard AS 'Display BP Ref. No.', OPWZ.TolerDays AS 'Tolerance Days', OPWZ.MinCashDis AS 'Min. Cash Discount', OPWZ.NegBalBP AS 'Include Negative Balance BP', OPWZ.ManualJE AS 'Include Manual JEs', OPWZ.NegTrans AS 'Include Negative Transactions', OPWZ.CDTransApp AS 'Apply to Cash Discount Trans.', OPWZ.UserSign AS 'User Signature', OPWZ.CigTo AS 'Contract Code ID To', OPWZ.CupFrom AS 'Unique Code of Project From', OPWZ.CupTo AS 'Unique Code of Project To', OPWZ.CigFrom AS 'Contract Code ID From', OPWZ.BPLId AS 'Active Branch', OPWZ.BoeDDFrom AS 'BoE Due Date From', OPWZ.BoeDDTo AS 'BoE Due Date To', OPWZ.BoeNumFrom AS 'BoE No. From', OPWZ.BoeNumTo AS 'BoE No. To', OPWZ.BoeStatus AS 'Bill of Exchange Status', OPWZ.HaExistBoe AS 'Handle Existing BoE', OPWZ.SeriesPOO AS 'Outgoing Payment Order Series', OPWZ.SeriesPOI AS 'Incoming Payment Order Series', OPWZ.SeqType AS 'Sequence Type', OPWZ.PayDueDate AS 'Payment Due Date Determination' FROM OPWZ AS OPWZ

Related information


OPWZ SQL Table

Bill of Exchange for Payment OBOE SQL Table

Business Place OBPL SQL Table

CIG Codes OCIG SQL Table

CUP Codes OCUP SQL Table

Documents Numbering - Series NNM1 SQL Table

Users OUSR 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