📚 SAP Business One SDK Help

Table Name: OPWZ

Table Description: Payment Wizard

Field Description Type Size Related Default Value Constraints
IdNumber ID Number Int 11 -      
PmntDate Date of Payment Run Date 8 -      
NextDate A/P Due Date To Date 8 -      
OutgoType Outgoing Type VarChar 1 - N Y Yes
            N No
IncomType Incoming Type VarChar 1 - N Y Yes
            N No
CheckPmntM Check Payment Terms VarChar 1 - N Y Yes
            N No
BnkTrnsPmM Bank Transfer Payment Terms VarChar 1 - N Y Yes
            N No
FilePath File Path Text 16 -      
PostDtFrom Posting Date From Date 8 -      
PostDtTo Posting Date To Date 8 -      
ValDteFrom Due Date From Date 8 -      
ValDateTo Due Date To Date 8 -      
ApInvAmntF A/P Invoice Amount From Num 19.6 -      
ApInvAmntT A/P Invoice Amount To Num 19.6 -      
PchNoFrom A/P Invoice No. From Int 11 -      
PchNoTo A/P Invoice No. To Int 11 -      
InvNoFrom A/R Invoice No. From Int 11 -      
InvNoTo A/R Invoice No. To Int 11 -      
SelPriorit Selection Priority Int 11 -      
Status Object Status VarChar 1 - S S Saved Wizard
            R Recommended Wizard
            E Executed Wizard
            H Scheduled Wizard
            L Scheduled Executing Wizard
WizardName Wizard Name nVarChar 100 -      
StatusDisc Status nVarChar 100 -      
Canceled Canceled VarChar 1 - N    
BoePmnMn Bill of Exchange Paymt Method VarChar 1 - N Y Yes
            N No
SeriesOut Outgoing Series Int 11 NNM1 0    
SeriesIn Incoming Series Int 11 NNM1 0    
TotalOut Total Outgoing Num 19.6 -      
TotalIn Total Incoming Num 19.6 -      
ViewIntBal Include Interim Acct Balance VarChar 1 - N Y Yes
            N No
SelMthd Selection Method VarChar 1 - D M By Monthly Invoice
            D By Document Property
MINumFrom Monthly Invoice No. From Int 11 -      
MINumTo Monthly Invoice No. To Int 11 -      
MIDateFrom Monthly Invoice Issued Date From Date 8 -      
MIDateTo Monthly Invoice Issued Date To Date 8 -      
MIVNumFrom A/P Monthly Invoice No. From Int 11 -      
MIVNumTo A/P Monthly Invoice No. To Int 11 -      
MIVDateFro A/P Monthly Invoice Date From Date 8 -      
MIVDateTo A/P Monthly Invoice Date To Date 8 -      
APDocDtFrm A/P Document Date From Date 8 -      
APDocDtTo A/P Document Date To Date 8 -      
APDueDtFrm A/P Due Date From Date 8 -      
NxtPmntDat Next Payment Run Date Date 8 -      
MinPayAR Minimum Incoming Payment Num 19.6 -      
MinPayAP Minimum Outgoing Payment Num 19.6 -      
ShowAtCard Display BP Ref. No. VarChar 1 - N Y Yes
            N No
TolerDays Tolerance Days Int 6 -      
MinCashDis Min. Cash Discount Num 19.6 -      
NegBalBP Include Negative Balance BP VarChar 1 - N Y Yes
            N No
ManualJE Include Manual JEs VarChar 1 - Y Y Yes
            N No
NegTrans Include Negative Transactions VarChar 1 - Y Y Yes
            N No
CDTransApp Apply to Cash Discount Trans. VarChar 1 - N Y Yes
            N No
UserSign User Signature Int 6 OUSR      
CigTo Contract Code ID To Int 11 OCIG      
CupFrom Unique Code of Project From Int 11 OCUP      
CupTo Unique Code of Project To Int 11 OCUP      
CigFrom Contract Code ID From Int 11 OCIG      
BPLId Active Branch Int 11 OBPL      
BoeDDFrom BoE Due Date From Date 8 -      
BoeDDTo BoE Due Date To Date 8 -      
BoeNumFrom BoE No. From Int 11 OBOE      
BoeNumTo BoE No. To Int 11 OBOE      
BoeStatus Bill of Exchange Status nVarChar 32 -      
HaExistBoe Handle Existing BoE VarChar 1 - N Y Yes
            N No
SeriesPOO Outgoing Payment Order Series Int 11 NNM1 0    
SeriesPOI Incoming Payment Order Series Int 11 NNM1 0    
SeqType Sequence Type nVarChar 4 -      
            OOFF OOFF
            FRST FRST
            RCUR RCUR
            FNAL FNAL
PayDueDate Payment Due Date Determination VarChar 1 - R R Run Date
            D Document Due Date
CentrPay Centralized Payment VarChar 1 - N Y Yes
            N No
BA_AP_From A/P Blanket Agreement From Int 11 -      
BA_AP_To A/P Blanket Agreement To Int 11 -      
BA_AR_From A/R Blanket Agreement From Int 11 -      
BA_AR_To A/R Blanket Agreement To Int 11 -      
JobId Job ID Number Int 11 -      
ZeroBalBP Include Zero Balance BP VarChar 1 - Y Y Yes
            N No
ZeroBalDoc Zero Balance Document Types nVarChar 50 - YNNNNYNNNNN    
VersionNum Version Number nVarChar 13 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
Key Unique Field
PRIMARY Yes IdNumber
NAME Yes WizardName