|
|
SQL Banking / Payment Results Table
API OPEX / Payment Run Export
OPEX - Payment Results Table Table
Payment Run Export PaymentRunExport Object· Table: OPEX
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| 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 | nVarChar | 3 | |||||
| CompTaxNum | Company Tax Number | nVarChar | 32 | |||||
| PayeeName | Payee Name | nVarChar | 100 | |||||
| PayeeZip | Payee Zip Code | nVarChar | 20 | |||||
| PayeeCity | Payee City | nVarChar | 100 | |||||
| PayeeStree | Payee Street | nVarChar | 100 | |||||
| PayCountry | Payee Country | nVarChar | 3 | |||||
| PayeeState | Payee State | nVarChar | 3 | |||||
| PayBnkName | Payee Bank Name | nVarChar | 127 | |||||
| PayBankZip | Payee Bank Zip Code | nVarChar | 20 | |||||
| PayBnkCity | Payee Bank City | nVarChar | 100 | |||||
| PayBnkStr | Payee Bank Street | nVarChar | 100 | |||||
| PayBnkCntr | Payee Bank Country | 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 | 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 | 20 | |||||
| PymDocCurr | Payment Document Currency | nVarChar | 3 | |||||
| PymDcAmtFC | Payment Document Amount (FC) | Num | 20 | |||||
| PymCshDsct | Cash Discount in Payment Doc | Num | 20 | |||||
| PyCshDscFC | Cash Discount in Payment Doc | Num | 20 | |||||
| PymNumOfPa | Number of Items Paid | Int | 11 | |||||
| PymDocRate | Payment Document Exchange Rate | Num | 20 | |||||
| Status | Status | VarChar | O) Open C) Closed | 1 | O | |||
| PaymWizCod | Payment Wizard Code | Int | 11 | OPWZ Payment Wizard | ||||
| 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 | N) No Y) Yes | 1 | N | |||
| PayBnkBlck | Payee Bank Block | nVarChar | 100 | |||||
| PayBnkCnty | Payee Bank County | nVarChar | 100 | |||||
| PayBnkStat | Payee Bank State | nVarChar | 3 | |||||
| PayBnkBISR | Payee Bank BISR | VarChar | N) No Y) Yes | 1 | N | |||
| 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 | 100 | |||||
| CompAddres | Company Address | nVarChar | 127 | |||||
| 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 | 50 | |||||
| PayBnkBrnc | Payee Bank Branch | nVarChar | 50 | |||||
| PymBnkBrnc | Payment Bank Branch | nVarChar | 50 | |||||
| UserName | User Name | nVarChar | 127 | |||||
| UserEmail | User E-Mail | nVarChar | 100 | |||||
| UserPortNo | User Mobile Phone No. | nVarChar | 50 | |||||
| UserFax | User Fax No. | nVarChar | 20 | |||||
| Department | User Department | Int | 6 | |||||
| DebitMemo | Debit Memo | VarChar | N) No Y) Yes | 1 | N | |||
| EuInTrnsfr | EU Internal Transfer | VarChar | N) No Y) Yes | 1 | N | |||
| 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 | N) No Y) Yes | 1 | N | |||
| 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 States | ||||
| PymBCACode | Payment Bank Charges | nVarChar | 3 | OBCA Bank Charges Allocation Codes | ||||
| PaymDocTyp | Payment Document Object Type | nVarChar | 20 | |||||
| PayOrderNo | Payment Order Number | Int | 11 | OIPO Internal Payment Order Number | ||||
| FreeText1 | Free Text 1 | nVarChar | 100 | |||||
| FreeText2 | Free Text 2 | nVarChar | 100 | |||||
| FreeText3 | Free Text 3 | nVarChar | 100 | |||||
| PymBnkSwif | Payment Bank Swift Code | nVarChar | 50 | |||||
| PayBnkUIC | Payee Bank UIC Code | nVarChar | 3 | |||||
| LineType | Line Type | VarChar | G) General O) Pay on Account T) Pay to Account | 1 | G | |||
| BoeKey | Bill of Exchange Key | Int | 11 | OBOE Bill of Exchange for Payment | ||||
| 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 | 20 | |||||
| BoeDiscD | BoE Discount Date | Date | 8 | |||||
| BoeDisAmnt | BoE Discount Amount | Num | 20 | |||||
| BoeFineD | BoE Fine Date | Date | 8 | |||||
| BoeFineAmt | BoE Fine Amount | Num | 20 | |||||
| BoeIntrstD | BoE Interest Date | Date | 8 | |||||
| BoeIOFAmt | BoE IOF Amount | Num | 20 | |||||
| BoeMovCode | BoE Movement Code | nVarChar | 10 | |||||
| BarcodeRep | Barcode Representation | nVarChar | 100 | |||||
| PONumber | External Payment Order Number | Int | 11 | |||||
| POSeries | External Payment Order Series | Int | 6 | |||||
| PaPriority | Payment Priority | VarChar | 1) 2) 3) 4) 5) 6) | 1 | 6 | |||
| PaymType | Payment Type | VarChar | N) E) Electronic P) Mail T) Telegraph X) Express | 1 | N | |||
| RecipStatu | Recipient Status | nVarChar | 2 | |||||
| BudegetId | Budget ID | 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 | OOFF) OOFF FRST) FRST RCUR) RCUR FNAL) FNAL | 4 | ||||
| PymDate | Payment Date | Date | 8 | |||||
| PymBnkName | Payment Bank Name | nVarChar | 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
PaymentRunExport
Enumeration
Method
Object
Property
BankAccount
DB
BankCode
DB
BankCountry
DB
BankIBAN
DB
CompanyBlock
DB
CompanyCity
DB
CompanyState
DB
Countery
DB
Currency
DB
CustomerNum
DB
DebitMemo
DB
DocCurrnecy
DB
DocNum
DB
DocRate
DB
FilePath
DB
FiscalYear
DB
FormatName
DB
GLAccount
DB
PayeeBankZip
DB
PayeeCity
DB
PayeeCountry
DB
PayeeName
DB
PayeeState
DB
PayeeStreet
DB
PostingDate
DB
RunDate
DB
Status
DB
UserEMail
DB
UserName
DB
VendorNum
DB
WizCode
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
