📚 SAP Business One SDK Help

Table Name: OPEX

Table Description: Payment Results Table

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
PayRunDate Date of Payment Run Date 8 -      
VendorNum Vendor Code nVarChar 15 -      
CustNum Customer Code nVarChar 15 -      
PaymMethod Payment Means nVarChar 15 -      
PaymDocNum Payment Document No. Int 11 -      
FiscalYear Fiscal Year Date 8 -      
Country Company Country/Region nVarChar 3 -      
CompTaxNum Company Tax Number nVarChar 32 -      
PayeeName Payee Name nVarChar 200 -      
PayeeZip Payee Zip Code nVarChar 20 -      
PayeeCity Payee City nVarChar 100 -      
PayeeStree Payee Street nVarChar 100 -      
PayCountry Payee Country/Region nVarChar 3 -      
PayeeState Payee State nVarChar 3 -      
PayBnkName Payee Bank Name nVarChar 250 -      
PayBankZip Payee Bank Zip Code nVarChar 20 -      
PayBnkCity Payee Bank City nVarChar 100 -      
PayBnkStr Payee Bank Street nVarChar 100 -      
PayBnkCntr Payee Bank Country/Region nVarChar 3 -      
PayBankAct Payee Bank Account nVarChar 50 -      
PayBnkCode Payee Bank Code nVarChar 30 -      
PayBnkCtrl Payee Bank Control Number nVarChar 2 -      
PayBnkSwif Payee Bank BIC/SWIFT Code nVarChar 50 -      
PayBnkIBAN Payee Bank IBAN nVarChar 50 -      
PymPostDat Payment Posting Date Date 8 -      
PymBnkAcct Payment Bank Account nVarChar 50 -      
PymBnkCntr Payment Bank Country/Region nVarChar 3 -      
PymBnkCode Payment Bank Code nVarChar 30 -      
PymBnkIBAN Payment Bank IBAN nVarChar 50 -      
PymGLAcct Payment G/L Account nVarChar 15 -      
Currency Main Currency nVarChar 3 -      
PymDocAmnt Payment Document Amount (LC) Num 19.6 -      
PymDocCurr Payment Document Currency nVarChar 3 -      
PymDcAmtFC Payment Document Amount (FC) Num 19.6 -      
PymCshDsct Cash Discount in Payment Doc Num 19.6 -      
PyCshDscFC Cash Discount in Payment Doc Num 19.6 -      
PymNumOfPa Number of Items Paid Int 11 -      
PymDocRate Payment Document Exchange Rate Num 19.6 -      
Status Status VarChar 1 - O O Open
            C Closed
PaymWizCod Payment Wizard Code Int 11 OPWZ      
InstrucKey Instruction Key nVarChar 30 -      
CllctAutho Collection Authorization VarChar 1 -      
PayBnkPost Payee Bank Post Office VarChar 1 -      
PayBnkChNo Payee Bank Next Check No. Int 11 -      
PayBnkHsBk Payee Bank House Bank VarChar 1 - N N No
            Y Yes
PayBnkBlck Payee Bank Block nVarChar 100 -      
PayBnkCnty Payee Bank County nVarChar 100 -      
PayBnkStat Payee Bank State nVarChar 3 -      
PayBnkBISR Payee Bank BISR VarChar 1 - N N No
            Y Yes
PayBnkUsr1 Payee Bank User No. 1 nVarChar 25 -      
PayBnkUsr2 Payee Bank User No. 2 nVarChar 25 -      
PayBnkUsr3 Payee Bank User No. 3 nVarChar 25 -      
PayBnkUsr4 Payee Bank User No. 4 nVarChar 25 -      
PaymFormat Payment Format nVarChar 20 -      
CompName Company Name nVarChar 200 -      
CompAddres Company Address nVarChar 254 -      
CompISRBil Company ISR Biller ID nVarChar 9 -      
VendISRBil Vendor ISR Biller ID nVarChar 9 -      
AddIdNum Additional ID No. nVarChar 32 -      
CompOrgNum Company Organization No. nVarChar 100 -      
PayBnkBrnc Payee Bank Branch nVarChar 50 -      
PymBnkBrnc Payment Bank Branch nVarChar 50 -      
UserName User Name nVarChar 155 -      
UserEmail User E-Mail nVarChar 100 -      
UserPortNo User Mobile Phone No. nVarChar 50 -      
UserFax User Fax No. nVarChar 50 -      
Department User Department Int 6 -      
DebitMemo Debit Memo VarChar 1 - N N No
            Y Yes
EuInTrnsfr EU Internal Transfer VarChar 1 - N N No
            Y Yes
FilePath File Path Text 16 -      
OrderParty Ordering Party nVarChar 30 -      
PymCtrlKey Payment Bank Control Number nVarChar 2 -      
PayeeTaxNo Payee Tax Number nVarChar 32 -      
PymKeyCode Payment Key Code nVarChar 6 -      
PayRefDtls Payee Reference Details nVarChar 20 -      
FormatName Format Name nVarChar 100 -      
CheckPmnt Payment Done with Check VarChar 1 - N N No
            Y Yes
PymBnkUsr1 Payment Bank User No. 1 nVarChar 25 -      
PymBnkUsr2 Payment Bank User No. 2 nVarChar 25 -      
PymBnkUsr3 Payment Bank User No. 3 nVarChar 25 -      
PymBnkUsr4 Payment Bank User No. 4 nVarChar 25 -      
CompStreet Company Street nVarChar 100 -      
CompBlock Company Block nVarChar 100 -      
CompCity Company City nVarChar 100 -      
CompZip Company Zip Code nVarChar 20 -      
CompCounty Company County nVarChar 100 -      
CompState Company State nVarChar 3 OCST      
PymBCACode Payment Bank Charges nVarChar 3 OBCA      
PaymDocTyp Payment Document Object Type nVarChar 20 -      
PayOrderNo Payment Order Number Int 11 OIPO      
FreeText1 Free Text 1 nVarChar 254 -      
FreeText2 Free Text 2 nVarChar 254 -      
FreeText3 Free Text 3 nVarChar 254 -      
PymBnkSwif Payment Bank Swift Code nVarChar 50 -      
PayBnkUIC Payee Bank UIC Code nVarChar 3 -      
LineType Line Type VarChar 1 - G G General
            O Pay on Account
            T Pay to Account
BoeKey Bill of Exchange Key Int 11 OBOE      
BoeCurrSta BoE Current Status VarChar 1 -      
BoeDate Bill of Exchange Date Date 8 -      
BoeDueDate BoE 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 -      
PONumber External Payment Order Number Int 11 -      
POSeries External Payment Order Series Int 11 -      
PaPriority Payment Priority VarChar 1 - 6 1  
            2  
            3  
            4  
            5  
            6  
PaymType Payment Type VarChar 1 - N N  
            E Electronic
            P Mail
            T Telegraph
            X Express
RecipStatu Recipient Status nVarChar 2 -      
BudegetId VAT Budget Classification Code nVarChar 100 -      
OKATO OKATO nVarChar 11 -      
PymReason Payment Reason nVarChar 2 -      
PostPeriod Posting Period Code nVarChar 10 -      
BaseDocTyp Base Document Type nVarChar 2 -      
BaseDocDat Base Document Date Date 8 -      
TaxPymType Tax Payment Type nVarChar 2 -      
OKTMO OKTMO nVarChar 12 -      
SeqType Sequence Type nVarChar 4 -   OOFF OOFF
            FRST FRST
            RCUR RCUR
            FNAL FNAL
PymDate Payment Date Date 8 -      
PymBnkName Payment Bank Name nVarChar 250 -      
UIPCode UIP Code nVarChar 25 -      
UserId User ID Int 6 OUSR      
SpltPmtVAT Split Payment VarChar 1 - N Y Yes
            N No
EnBnkAct Encryption of Payee Bank Acct Text 16 -      
EnBnkIBan Encryption of Payee Bank IBAN Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
EnPmBnkAct Encryption of Payment Bank Account Text 16 -      
Key Unique Field
PRIMARY Yes AbsEntry