📚 SAP Business One SDK Help

Table Name: PWZ3

Table Description: Payment Wizard - Rows 3

Field Description Type Size Related Default Value Constraints
IdEntry ID Entry Int 11 OPWZ      
PymNum Payment Number Int 11 OCRN      
CardCode Vendor Code nVarChar 15 OCRD      
CardName Vendor Name nVarChar 200 -      
PymMeth Payment Method nVarChar 15 OPYM      
GLAccCode G/L Account Code nVarChar 15 OACT      
GLAccName G/L Account Name nVarChar 200 -      
PymAmount Total Payment Num 19.6 -      
PymAmntFC Total Payment (FC) Num 19.6 -      
PymAmnSyst Total Payment (SC) Num 19.6 -      
InvKey Invoice Key Int 11 -      
DocNum Document Number Int 11 -      
PostDate Posting Date Date 8 -      
ValDate Due Date Date 8 -      
TotalLoc Total (LC) Num 19.6 -      
TotalFC Total (FC) Num 19.6 -      
TotalSys Total (SC) Num 19.6 -      
DueBal Balance Due Num 19.6 -      
DueBalFC Balance Due (FC) Num 19.6 -      
DueBalSys Balance Due (SC) Num 19.6 -      
DiscPrcnt Discount % Num 19.6 -      
DiscSum Total Discount Num 19.6 -      
DiscSumFC Total Discount (FC) Num 19.6 -      
DiscSumSy Total Discount (SC) Num 19.6 -      
PayAmount Payment Amount Num 19.6 -      
PayAmntFC Payment Amount (FC) Num 19.6 -      
PayAmntSys Payment Amount (SC) Num 19.6 -      
InvPayAmnt Total Invoice for Payment Num 19.6 -      
InvPayAmFC Total Invoice for Payment (FC) Num 19.6 -      
InvPayAmSy Total Invoice for Payment (SC) Num 19.6 -      
CardType BP Type VarChar 1 - C C Customer
            S Vendor
            L Lead
Country Bank Country/Region nVarChar 3 OCRY      
ObjType Object Type nVarChar 20 ADP1 13    
PymBnkTrns Payment Means VarChar 1 - C C Check
            T Bank Transfer
            B Bill Of Exchange
ActFrmtCod Account Format Code nVarChar 210 -      
Checked Checked VarChar 1 -      
FatherLine Father Line VarChar 1 - N    
InvCurr Document Currency nVarChar 3 -      
LineRate Row Rate Num 19.6 -      
BfDcntSum Amount Before Discount Num 19.6 -      
BfNetDcnt Net Amount Before Discount Num 19.6 -      
vatApplied VAT Applied Num 19.6 -      
IsTax Is Tax VarChar 1 - Y    
IsFreight Is Freight VarChar 1 - Y    
IsOrigMeth Original Payment Method VarChar 1 - N    
FreightSum Freight Sum Num 19.6 -      
IsrRef ISR Ref. No. nVarChar 27 -      
RoundSum Rounding Amount Num 19.6 -      
Agent Agent Code nVarChar 32 OAGP      
InstId Installment ID Int 6 - 1    
WtSum Withholding Tax Amount Num 19.6 -      
BoeNum Bill of Exchange No. Int 11 -      
NumAtCard BP Reference No. nVarChar 200 -      
DeductPer Deduction Percent Num 19.6 -      
DpmPosted Down Payment Posted VarChar 1 -      
Status Inv Status VarChar 1 -      
NumOfCheck Number of Checks Int 11 - 1    
SumFrstChk Sum of First Check Num 19.6 -      
SumNxtChk Sum of Next Check Num 19.6 -      
PayToCode Pay To nVarChar 50 -      
PayToCntr Pay to Bank Country/Region nVarChar 3 OCRY      
PayToBank Pay to Bank Code nVarChar 30 -      
PayToAct Pay to Bank Account No. nVarChar 50 -      
PymCurr Payment Currency nVarChar 3 -      
TaxOnExpSu Tax on Freight Amount Num 19.6 -      
TransId Transaction Internal ID Int 11 OJDT      
OcrCode Distribution Rule nVarChar 8 OOCR      
Line_ID JE Row Number Int 11 - 0    
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
PymDate Payment Date Date 8 -      
BcgSum Bank Charges Amount Num 19.6 -      
BcgSumFC Bank Charges Amount (FC) Num 19.6 -      
BcgSumSy Bank Charges Amount (SC) Num 19.6 -      
BcgTaxSum Bank Charge Tax Amount Num 19.6 -      
BcgTaxSumF Bank Charge Tax Amount (FC) Num 19.6 -      
BcgTaxSumS Bank Charge Tax Amount (SC) Num 19.6 -      
PrjCode Project nVarChar 20 OPRJ      
BcgVatGrp Bank Charge Tax Group nVarChar 8 OVTG      
LinePrjCod Line Project nVarChar 20 OPRJ      
BcgPmnt Payment Amount (BCG) Num 19.6 -      
BcgPmntFc Payment Amount FC (BCG) Num 19.6 -      
BcgPmntSc Payment Amount SC (BCG) Num 19.6 -      
PayOrderNo Payment Order Number Int 11 OIPO      
LineType Line Type VarChar 1 - G G General
            O Pay on Account
            T Pay to Account
ManualNum Manual Entry No. Int 11 - 0    
Ref1 Reference 1 nVarChar 254 -      
Ref2 Reference 2 nVarChar 254 -      
Ref3 Reference 3 nVarChar 254 -      
OrdrStatus Payment Order Status VarChar 1 -      
BnkCode Bank Code nVarChar 30 -      
BnkAccNo Bank Account Number nVarChar 50 -      
Branch Branch nVarChar 50 -      
BnkCountr Manual Line Bank Country/Region nVarChar 3 -      
TBankCode Target Default Bank nVarChar 30 - -1    
TDflAccoun Target Default Account nVarChar 50 -      
TBankCount Target Bank Country/Region nVarChar 3 OCRY      
TargetBran Target Bank Branch nVarChar 50 -      
DscDueDate Discount Due Date Date 8 -      
CIG Contract Code Identification Int 11 OCIG      
CUP Unique Code of Project Int 11 OCUP      
BoeCurrSta BoE Current Status VarChar 1 -      
BoeKey Bill of Exchange Key Int 11 OBOE      
BoeDate BoE Date Date 8 -      
BoeDueDate Bill of Exchange Due Date Date 8 -      
Instruct1 BoE Instruction 1 nVarChar 2 -      
Instruct2 BoE Instruction 2 nVarChar 2 -      
BoeCancIns BoE Cancel Instruction nVarChar 2 -      
BoeOccCode BoE Occurrence Code nVarChar 2 -      
BoePtfID BoE Internal Portfolio ID nVarChar 3 -      
BoeOurNum Our Number in Next BoE Int 11 -      
BoeIntrAm BoE Interest Amount Num 19.6 -      
BoeDiscD BoE Discount Date Date 8 -      
BoeDisAmnt BoE Discount Amount Num 19.6 -      
BoeFineD BoE Fine Date Date 8 -      
BoeFineAmt BoE Fine Amount Num 19.6 -      
BoeIntrstD BoE Interest Date Date 8 -      
BoeIOFAmt BoE IOF Amount Num 19.6 -      
BoeMovCode BoE Movement Code nVarChar 10 -      
BarcodeRep Barcode Representation nVarChar 100 -      
BPLId Branch Int 11 OBPL      
PONumber External Payment Order Number Int 11 -      
POSeries External Payment Order Series Int 11 -      
PaPriority Payment Priority VarChar 1 - 5 1  
            2  
            3  
            4  
            5  
            6  
PaymType Payment Type VarChar 1 - N N  
            E Electronic
            P Mail
            T Telegraph
            X Express
OriPymMeth Original Payment Method Code nVarChar 15 -      
PymMethTyp Payment Method Type VarChar 1 -   I Incoming
            O Outgoing
SinglePym Single Payment VarChar 1 - N N No
            Y Yes
MandateID Mandate ID nVarChar 35 -      
SeqType Sequence Type nVarChar 4 -   OOFF OOFF
            FRST FRST
            RCUR RCUR
            FNAL FNAL
BaseDocDat Base Document Date Date 8 -      
OKATO OKATO nVarChar 11 -      
PostPeriod Posting Period Code nVarChar 10 -      
RecipStatu Recipient Status nVarChar 2 -      
BudgetId VAT Budget Classification Code nVarChar 100 -      
PymReason Payment Reason nVarChar 2 -      
BaseDocTyp Base Document Type nVarChar 2 -      
TaxPymType Tax Payment Type nVarChar 2 -      
OKTMO OKTMO nVarChar 12 -      
PymIsUpdat Payment method is updated nVarChar 30 -      
OriPymCode Original Payment Method Code nVarChar 15 -      
OriPymType Original Payment Method Type VarChar 1 -      
ReasonCode Reason Code Int 11 -      
OriActCode Original Account Code nVarChar 15 -      
OriActName Original Account Name nVarChar 200 -      
ReasonLine Reason Line Int 11 -      
OriFormat Original Format Code nVarChar 210 -      
WtIsPym Withholding Tax is Payment Type VarChar 1 - N N No
            Y Yes
IBAN IBAN nVarChar 50 -      
SwiftNum BIC/SWIFT Code nVarChar 50 -      
UIPCode UIP Code nVarChar 25 -      
AgrNo Agreement No. Int 11 OOAT      
ExeByServ Executed by Server VarChar 1 -      
SpltPmtVAT Split Payment VarChar 1 - N Y Yes
            N No
VatAmount VAT Amount Num 19.6 -      
EnPayToAct Encryption of Pay to Bank Acct Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
SelOrder Select Order Int 11 -      
Key Unique Field
PRIMARY Yes IdEntry
    PymNum
DOCUMENT No InvKey
    ObjType
    InstId