biuan SAP® BUSINESS ONE SDK
API OPEX / Payment Run Export
OPEX - Payment Results Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
PayRunDateDate of Payment RunDate
8
VendorNumVendor CodenVarChar
15
CustNumCustomer CodenVarChar
15
PaymMethodPayment MeansnVarChar
15
PaymDocNumPayment Document No.Int
11
FiscalYearFiscal YearDate
8
CountryCompany CountrynVarChar
3
CompTaxNumCompany Tax NumbernVarChar
32
PayeeNamePayee NamenVarChar
100
PayeeZipPayee Zip CodenVarChar
20
PayeeCityPayee CitynVarChar
100
PayeeStreePayee StreetnVarChar
100
PayCountryPayee CountrynVarChar
3
PayeeStatePayee StatenVarChar
3
PayBnkNamePayee Bank NamenVarChar
127
PayBankZipPayee Bank Zip CodenVarChar
20
PayBnkCityPayee Bank CitynVarChar
100
PayBnkStrPayee Bank StreetnVarChar
100
PayBnkCntrPayee Bank CountrynVarChar
3
PayBankActPayee Bank AccountnVarChar
50
PayBnkCodePayee Bank CodenVarChar
30
PayBnkCtrlPayee Bank Control NumbernVarChar
2
PayBnkSwifPayee Bank BIC/SWIFT CodenVarChar
50
PayBnkIBANPayee Bank IBANnVarChar
50
PymPostDatPayment Posting DateDate
8
PymBnkAcctPayment Bank AccountnVarChar
50
PymBnkCntrPayment Bank CountrynVarChar
3
PymBnkCodePayment Bank CodenVarChar
30
PymBnkIBANPayment Bank IBANnVarChar
50
PymGLAcctPayment G/L AccountnVarChar
15
CurrencyMain CurrencynVarChar
3
PymDocAmntPayment Document Amount (LC)Num
20
PymDocCurrPayment Document CurrencynVarChar
3
PymDcAmtFCPayment Document Amount (FC)Num
20
PymCshDsctCash Discount in Payment DocNum
20
PyCshDscFCCash Discount in Payment DocNum
20
PymNumOfPaNumber of Items PaidInt
11
PymDocRatePayment Document Exchange RateNum
20
StatusStatusVarChar
O) Open
C) Closed
1
O
PaymWizCodPayment Wizard CodeInt
11OPWZ
Payment Wizard
InstrucKeyInstruction KeynVarChar
30
CllctAuthoCollection AuthorizationVarChar
1
PayBnkPostPayee Bank Post OfficeVarChar
1
PayBnkChNoPayee Bank Next Check No.Int
11
PayBnkHsBkPayee Bank House BankVarChar
N) No
Y) Yes
1
N
PayBnkBlckPayee Bank BlocknVarChar
100
PayBnkCntyPayee Bank CountynVarChar
100
PayBnkStatPayee Bank StatenVarChar
3
PayBnkBISRPayee Bank BISRVarChar
N) No
Y) Yes
1
N
PayBnkUsr1Payee Bank User No. 1nVarChar
25
PayBnkUsr2Payee Bank User No. 2nVarChar
25
PayBnkUsr3Payee Bank User No. 3nVarChar
25
PayBnkUsr4Payee Bank User No. 4nVarChar
25
PaymFormatPayment FormatnVarChar
20
CompNameCompany NamenVarChar
100
CompAddresCompany AddressnVarChar
127
CompISRBilCompany ISR Biller IDnVarChar
9
VendISRBilVendor ISR Biller IDnVarChar
9
AddIdNumAdditional ID No.nVarChar
32
CompOrgNumCompany Organization No.nVarChar
50
PayBnkBrncPayee Bank BranchnVarChar
50
PymBnkBrncPayment Bank BranchnVarChar
50
UserNameUser NamenVarChar
127
UserEmailUser E-MailnVarChar
100
UserPortNoUser Mobile Phone No.nVarChar
50
UserFaxUser Fax No.nVarChar
20
DepartmentUser DepartmentInt
6
DebitMemoDebit MemoVarChar
N) No
Y) Yes
1
N
EuInTrnsfrEU Internal TransferVarChar
N) No
Y) Yes
1
N
FilePathFile PathText
16
OrderPartyOrdering PartynVarChar
30
PymCtrlKeyPayment Bank Control NumbernVarChar
2
PayeeTaxNoPayee Tax NumbernVarChar
32
PymKeyCodePayment Key CodenVarChar
6
PayRefDtlsPayee Reference DetailsnVarChar
20
FormatNameFormat NamenVarChar
100
CheckPmntPayment Done with CheckVarChar
N) No
Y) Yes
1
N
PymBnkUsr1Payment Bank User No. 1nVarChar
25
PymBnkUsr2Payment Bank User No. 2nVarChar
25
PymBnkUsr3Payment Bank User No. 3nVarChar
25
PymBnkUsr4Payment Bank User No. 4nVarChar
25
CompStreetCompany StreetnVarChar
100
CompBlockCompany BlocknVarChar
100
CompCityCompany CitynVarChar
100
CompZipCompany Zip CodenVarChar
20
CompCountyCompany CountynVarChar
100
CompStateCompany StatenVarChar
3OCST
States
PymBCACodePayment Bank ChargesnVarChar
3OBCA
Bank Charges Allocation Codes
PaymDocTypPayment Document Object TypenVarChar
20
PayOrderNoPayment Order NumberInt
11OIPO
Internal Payment Order Number
FreeText1Free Text 1nVarChar
100
FreeText2Free Text 2nVarChar
100
FreeText3Free Text 3nVarChar
100
PymBnkSwifPayment Bank Swift CodenVarChar
50
PayBnkUICPayee Bank UIC CodenVarChar
3
LineTypeLine TypeVarChar
G) General
O) Pay on Account
T) Pay to Account
1
G
BoeKeyBill of Exchange KeyInt
11OBOE
Bill of Exchange for Payment
BoeCurrStaBoE Current StatusVarChar
1
BoeDateBill of Exchange DateDate
8
BoeDueDateBoE 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
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
RecipStatuRecipient StatusnVarChar
2
BudegetIdBudget IDnVarChar
100
OKATOOKATOnVarChar
11
PymReasonPayment ReasonnVarChar
2
PostPeriodPosting Period CodenVarChar
10
BaseDocTypBase Document TypenVarChar
2
BaseDocDatBase Document DateDate
8
TaxPymTypeTax Payment TypenVarChar
2
OKTMOOKTMOnVarChar
12
SeqTypeSequence TypenVarChar
OOFF) OOFF
FRST) FRST
RCUR) RCUR
FNAL) FNAL
4
PymDatePayment DateDate
8
PymBnkNamePayment Bank NamenVarChar
127

Table relationship map

SELECT statement

SELECT OPEX.AbsEntry AS 'Internal Number', OPEX.PayRunDate AS 'Date of Payment Run', OPEX.VendorNum AS 'Vendor Code', OPEX.CustNum AS 'Customer Code', OPEX.PaymMethod AS 'Payment Means', OPEX.PaymDocNum AS 'Payment Document No.', OPEX.FiscalYear AS 'Fiscal Year', OPEX.Country AS 'Company Country', OPEX.CompTaxNum AS 'Company Tax Number', OPEX.PayeeName AS 'Payee Name', OPEX.PayeeZip AS 'Payee Zip Code', OPEX.PayeeCity AS 'Payee City', OPEX.PayeeStree AS 'Payee Street', OPEX.PayCountry AS 'Payee Country', OPEX.PayeeState AS 'Payee State', OPEX.PayBnkName AS 'Payee Bank Name', OPEX.PayBankZip AS 'Payee Bank Zip Code', OPEX.PayBnkCity AS 'Payee Bank City', OPEX.PayBnkStr AS 'Payee Bank Street', OPEX.PayBnkCntr AS 'Payee Bank Country', OPEX.PayBankAct AS 'Payee Bank Account', OPEX.PayBnkCode AS 'Payee Bank Code', OPEX.PayBnkCtrl AS 'Payee Bank Control Number', OPEX.PayBnkSwif AS 'Payee Bank BIC/SWIFT Code', OPEX.PayBnkIBAN AS 'Payee Bank IBAN', OPEX.PymPostDat AS 'Payment Posting Date', OPEX.PymBnkAcct AS 'Payment Bank Account', OPEX.PymBnkCntr AS 'Payment Bank Country', OPEX.PymBnkCode AS 'Payment Bank Code', OPEX.PymBnkIBAN AS 'Payment Bank IBAN', OPEX.PymGLAcct AS 'Payment G/L Account', OPEX.Currency AS 'Main Currency', OPEX.PymDocAmnt AS 'Payment Document Amount (LC)', OPEX.PymDocCurr AS 'Payment Document Currency', OPEX.PymDcAmtFC AS 'Payment Document Amount (FC)', OPEX.PymCshDsct AS 'Cash Discount in Payment Doc', OPEX.PyCshDscFC AS 'Cash Discount in Payment Doc', OPEX.PymNumOfPa AS 'Number of Items Paid', OPEX.PymDocRate AS 'Payment Document Exchange Rate', OPEX.Status AS 'Status', OPEX.PaymWizCod AS 'Payment Wizard Code', OPEX.InstrucKey AS 'Instruction Key', OPEX.CllctAutho AS 'Collection Authorization', OPEX.PayBnkPost AS 'Payee Bank Post Office', OPEX.PayBnkChNo AS 'Payee Bank Next Check No.', OPEX.PayBnkHsBk AS 'Payee Bank House Bank', OPEX.PayBnkBlck AS 'Payee Bank Block', OPEX.PayBnkCnty AS 'Payee Bank County', OPEX.PayBnkStat AS 'Payee Bank State', OPEX.PayBnkBISR AS 'Payee Bank BISR', OPEX.PayBnkUsr1 AS 'Payee Bank User No. 1', OPEX.PayBnkUsr2 AS 'Payee Bank User No. 2', OPEX.PayBnkUsr3 AS 'Payee Bank User No. 3', OPEX.PayBnkUsr4 AS 'Payee Bank User No. 4', OPEX.PaymFormat AS 'Payment Format', OPEX.CompName AS 'Company Name', OPEX.CompAddres AS 'Company Address', OPEX.CompISRBil AS 'Company ISR Biller ID', OPEX.VendISRBil AS 'Vendor ISR Biller ID', OPEX.AddIdNum AS 'Additional ID No.', OPEX.CompOrgNum AS 'Company Organization No.', OPEX.PayBnkBrnc AS 'Payee Bank Branch', OPEX.PymBnkBrnc AS 'Payment Bank Branch', OPEX.UserName AS 'User Name', OPEX.UserEmail AS 'User E-Mail', OPEX.UserPortNo AS 'User Mobile Phone No.', OPEX.UserFax AS 'User Fax No.', OPEX.Department AS 'User Department', OPEX.DebitMemo AS 'Debit Memo', OPEX.EuInTrnsfr AS 'EU Internal Transfer', OPEX.FilePath AS 'File Path', OPEX.OrderParty AS 'Ordering Party', OPEX.PymCtrlKey AS 'Payment Bank Control Number', OPEX.PayeeTaxNo AS 'Payee Tax Number', OPEX.PymKeyCode AS 'Payment Key Code', OPEX.PayRefDtls AS 'Payee Reference Details', OPEX.FormatName AS 'Format Name', OPEX.CheckPmnt AS 'Payment Done with Check', OPEX.PymBnkUsr1 AS 'Payment Bank User No. 1', OPEX.PymBnkUsr2 AS 'Payment Bank User No. 2', OPEX.PymBnkUsr3 AS 'Payment Bank User No. 3', OPEX.PymBnkUsr4 AS 'Payment Bank User No. 4', OPEX.CompStreet AS 'Company Street', OPEX.CompBlock AS 'Company Block', OPEX.CompCity AS 'Company City', OPEX.CompZip AS 'Company Zip Code', OPEX.CompCounty AS 'Company County', OPEX.CompState AS 'Company State', OPEX.PymBCACode AS 'Payment Bank Charges', OPEX.PaymDocTyp AS 'Payment Document Object Type', OPEX.PayOrderNo AS 'Payment Order Number', OPEX.FreeText1 AS 'Free Text 1', OPEX.FreeText2 AS 'Free Text 2', OPEX.FreeText3 AS 'Free Text 3', OPEX.PymBnkSwif AS 'Payment Bank Swift Code', OPEX.PayBnkUIC AS 'Payee Bank UIC Code', OPEX.LineType AS 'Line Type', OPEX.BoeKey AS 'Bill of Exchange Key', OPEX.BoeCurrSta AS 'BoE Current Status', OPEX.BoeDate AS 'Bill of Exchange Date', OPEX.BoeDueDate AS 'BoE Due Date', OPEX.Instruct1 AS 'BoE Instruction 1', OPEX.Instruct2 AS 'BoE Instruction 2', OPEX.BoeCancIns AS 'BoE Cancel Instruction', OPEX.BoeOccCode AS 'BoE Occurrence Code', OPEX.BoePtfID AS 'BoE Internal Portfolio ID', OPEX.BoeOurNum AS 'Our Number in Next BoE', OPEX.BoeIntrAm AS 'BoE Interest Amount', OPEX.BoeDiscD AS 'BoE Discount Date', OPEX.BoeDisAmnt AS 'BoE Discount Amount', OPEX.BoeFineD AS 'BoE Fine Date', OPEX.BoeFineAmt AS 'BoE Fine Amount', OPEX.BoeIntrstD AS 'BoE Interest Date', OPEX.BoeIOFAmt AS 'BoE IOF Amount', OPEX.BoeMovCode AS 'BoE Movement Code', OPEX.BarcodeRep AS 'Barcode Representation', OPEX.PONumber AS 'External Payment Order Number', OPEX.POSeries AS 'External Payment Order Series', OPEX.PaPriority AS 'Payment Priority', OPEX.PaymType AS 'Payment Type', OPEX.RecipStatu AS 'Recipient Status', OPEX.BudegetId AS 'Budget ID', OPEX.OKATO AS 'OKATO', OPEX.PymReason AS 'Payment Reason', OPEX.PostPeriod AS 'Posting Period Code', OPEX.BaseDocTyp AS 'Base Document Type', OPEX.BaseDocDat AS 'Base Document Date', OPEX.TaxPymType AS 'Tax Payment Type', OPEX.OKTMO AS 'OKTMO', OPEX.SeqType AS 'Sequence Type', OPEX.PymDate AS 'Payment Date', OPEX.PymBnkName AS 'Payment Bank Name' FROM OPEX AS OPEX

Related information


Payment Run Export PaymentRunExport Object· Table: OPEX
PaymentRunExport is a business object that enables you to export data of automatic payments for both incoming payments and outgoing payments to vendors. The automatic payments data is generated by running the Payment Wizard in SAP Business One....

Bill of Exchange for Payment OBOE SQL Table

States OCST SQL Table

Payment Wizard OPWZ SQL Table

Internal Payment Order Number OIPO SQL Table

Bank Charges Allocation Codes OBCA 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