biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment Results Table / Payment Results Table - Rows
DTW Payment Results Table - Rows
API Payment Run Export / Payment Run Export Lines
PEX1 - Payment Results Table - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
LineIdRow NumberInt
11
PayRunDateDate of Payment RunDate
8
PaymWizCodPayment Wizard CodeInt
11
VendorNumVendor CodenVarChar
15OCRD
Business Partner
CustNumCustomer CodenVarChar
15OCRD
Business Partner
PaymMethodPayment MeansnVarChar
15OPYM
Payment Methods for Payment Wizard
PaymDocNumPayment Document No.Int
11
FiscalYearFiscal YearDate
8
VendRefNumVendor Ref. No.nVarChar
100
ObjTypeDocument Object TypenVarChar
20
DocDateDocument Posting DateDate
8
TaxDateDocument DateDate
8
CrdGLAcctBP Accounts Receivable/PayablenVarChar
15OACT
G/L Accounts
DocCurrDocument CurrencynVarChar
3
DocRateDocument RateNum
20
DocTotalDocument Total (LC)Num
20
DocTotalFCDocument Total (FC)Num
20
DocTaxAmntTax Amount per Document AmountNum
20
DoxTxAmtFCTax Amount per Document AmountNum
20
DocRemarksDocument RemarksnVarChar
127
DocPrmTermDocument Payment TermsInt
6OCTG
Payment Terms
DocPymRefPayment Document ReferencenVarChar
27
DocLocCurrDocument Local CurrencynVarChar
3
PymTermPerPayment Terms PeriodInt
11
DocNumDocument NumberInt
11
PymNumPayment Number (PWZ3 - PymNum)Int
11
PayOrderNoPayment Order NumberInt
11OIPO
Internal Payment Order Number
FreeText1Free Text 1nVarChar
100
FreeText2Free Text 2nVarChar
100
FreeText3Free Text 3nVarChar
100

Table relationship map

SELECT statement

SELECT PEX1.AbsEntry AS 'Internal Number', PEX1.LineId AS 'Row Number', PEX1.PayRunDate AS 'Date of Payment Run', PEX1.PaymWizCod AS 'Payment Wizard Code', PEX1.VendorNum AS 'Vendor Code', PEX1.CustNum AS 'Customer Code', PEX1.PaymMethod AS 'Payment Means', PEX1.PaymDocNum AS 'Payment Document No.', PEX1.FiscalYear AS 'Fiscal Year', PEX1.VendRefNum AS 'Vendor Ref. No.', PEX1.ObjType AS 'Document Object Type', PEX1.DocDate AS 'Document Posting Date', PEX1.TaxDate AS 'Document Date', PEX1.CrdGLAcct AS 'BP Accounts Receivable/Payable', PEX1.DocCurr AS 'Document Currency', PEX1.DocRate AS 'Document Rate', PEX1.DocTotal AS 'Document Total (LC)', PEX1.DocTotalFC AS 'Document Total (FC)', PEX1.DocTaxAmnt AS 'Tax Amount per Document Amount', PEX1.DoxTxAmtFC AS 'Tax Amount per Document Amount', PEX1.DocRemarks AS 'Document Remarks', PEX1.DocPrmTerm AS 'Document Payment Terms', PEX1.DocPymRef AS 'Payment Document Reference', PEX1.DocLocCurr AS 'Document Local Currency', PEX1.PymTermPer AS 'Payment Terms Period', PEX1.DocNum AS 'Document Number', PEX1.PymNum AS 'Payment Number (PWZ3 - PymNum)', PEX1.PayOrderNo AS 'Payment Order Number', PEX1.FreeText1 AS 'Free Text 1', PEX1.FreeText2 AS 'Free Text 2', PEX1.FreeText3 AS 'Free Text 3' FROM PEX1 AS PEX1

Related information


Payment Run Export Lines PaymentRunExport_Lines Object· Table: PEX1
PaymentRunExport_Lines is a child object of the PaymentRunExport object and represents the line entries of each payment. Source table: PEX1.
   Parent: Payment Run Export PaymentRunExport Object· Table: OPEX
G/L Accounts OACT SQL Table

Business Partner OCRD SQL Table

Payment Terms OCTG SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Internal Payment Order Number OIPO SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates