biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Banking / Payment Methods
API OPYM / / Wizard Payment Methods
OPYM - Payment Methods for Payment Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PayMethCod KEY UNIQUEPayment Method CodenVarChar
15
PRIMARYYes
DescriptDescriptionnVarChar
100
TypeTypeVarChar
O) Outgoing
I) Incoming
1
BankTransfPayment MeansVarChar
C) Check
T) Bank Transfer
B) Bill of Exchange
1
AddressCheck AddressVarChar
Y) Yes
N) No
1
N
BankDetCheck Bank DetailsVarChar
Y) Yes
N) No
1
N
CllctAutorCollection Authorization CheckVarChar
Y) Yes
N) No
1
N
FrgnPmntBlBlock Foreign PaymentVarChar
Y) Yes
N) No
1
N
FrgnBnkBlBlock Foreign BankVarChar
Y) Yes
N) No
1
N
CurrRestrCurrency RestrictionVarChar
Y) Yes
N) No
1
N
PostOffBnkPost Office BankVarChar
Y) Yes
N) No
1
N
MinAmountMinimum AmountNum
20
MaxAmountMaximum AmountNum
20
BnkDfltDefault BanknVarChar
30
UserSignUser SignatureInt
6OUSR
Users
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
CreateDateCreation DateDate
8
BankCountrBank CountrynVarChar
3OCRY
Countries
DflAccountDefault AccountnVarChar
50
GLAccountG/L AccountnVarChar
15OACT
G/L Accounts
BranchBranchnVarChar
50
KeyCodeKey CodenVarChar
6
TrnsTypeTransaction TypenVarChar
2
FormatFormatnVarChar
11OFRM
File Format
AgtCollectAgent CollectionVarChar
Y) Yes
N) No
1
N
SendAcceptSend for AcceptanceVarChar
Y) Yes
N) No
1
N
GrpByDateGroup By DateVarChar
Y) Yes
N) No
1
N
DepNormDeposit NormnVarChar
8
DebitMemoDebit MemoVarChar
N) No
Y) Yes
1
N
GroupPmRefGroup by Payment Reference No.VarChar
Y) Yes
N) No
1
N
GroupInvGroup Invoices by PayVarChar
N) No
Y) Yes
1
N
ValDateSelDue Date SelectionVarChar
P) Date of Payment Run
I) Due Date of Invoice
T) Payment Terms
1
P
PaymTermsPayment Terms CodeInt
6OCTG
Payment Terms
IntrimAcctPost to G/L Interim AccountVarChar
N) No
Y) Yes
1
N
BnkActKeyBank Account KeyInt
11DSC1
House Bank Accounts
DocTypeBoE Document TypenVarChar
2
AcceptedBoE Status - AcceptedVarChar
1
PtfIDBoE Internal Portfolio IDnVarChar
3
PtfCodeBoE Portfolio CodenVarChar
2
PtfNumBoE Portfolio NumbernVarChar
4
CurCodeBoE Currency CodenVarChar
2
Instruct1BoE Instruction 1nVarChar
2
Instruct2BoE Instruction 2nVarChar
2
PaymntPlcBoE Payment PlacenVarChar
127
BoeDllBar Code DLLnVarChar
50
BankCtlKeyBank Control KeynVarChar
2
ActiveStatus of the Payment MethodVarChar
Y) Active
N) Inactive
1
Y
BcgPcntBank Charge Rate (%)Num
20
GrpByCurGroup Invoices by CurrencyVarChar
N) No
Y) Yes
1
N
GrpByBankGroup Invoices by Pay-To BankVarChar
Y) Yes
N) No
1
N
DflIBANBank IBANnVarChar
50
DflSwiftBank BIC/SWIFTnVarChar
50
BoeReportBoE Report CodenVarChar
8
CancInstrCancellation InstructionnVarChar
2
OccurCodeOccurrence CodenVarChar
2
MovmntCodeMovement CodenVarChar
10
NegPymCodeNegative Payment Method CodenVarChar
15OPYM
Payment Methods for Payment Wizard
DirectDbtDirect DebitnVarChar
5
IssueIndicIssue IndicatorVarChar
3)
R)
1
R
PrintSEPAPrint SEPA PrenotificationVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OPYM.PayMethCod AS 'Payment Method Code', OPYM.Descript AS 'Description', OPYM.Type AS 'Type', OPYM.BankTransf AS 'Payment Means', OPYM.Address AS 'Check Address', OPYM.BankDet AS 'Check Bank Details', OPYM.CllctAutor AS 'Collection Authorization Check', OPYM.FrgnPmntBl AS 'Block Foreign Payment', OPYM.FrgnBnkBl AS 'Block Foreign Bank', OPYM.CurrRestr AS 'Currency Restriction', OPYM.PostOffBnk AS 'Post Office Bank', OPYM.MinAmount AS 'Minimum Amount', OPYM.MaxAmount AS 'Maximum Amount', OPYM.BnkDflt AS 'Default Bank', OPYM.UserSign AS 'User Signature', OPYM.DataSource AS 'Data Source', OPYM.CreateDate AS 'Creation Date', OPYM.BankCountr AS 'Bank Country', OPYM.DflAccount AS 'Default Account', OPYM.GLAccount AS 'G/L Account', OPYM.Branch AS 'Branch', OPYM.KeyCode AS 'Key Code', OPYM.TrnsType AS 'Transaction Type', OPYM.Format AS 'Format', OPYM.AgtCollect AS 'Agent Collection', OPYM.SendAccept AS 'Send for Acceptance', OPYM.GrpByDate AS 'Group By Date', OPYM.DepNorm AS 'Deposit Norm', OPYM.DebitMemo AS 'Debit Memo', OPYM.GroupPmRef AS 'Group by Payment Reference No.', OPYM.GroupInv AS 'Group Invoices by Pay', OPYM.ValDateSel AS 'Due Date Selection', OPYM.PaymTerms AS 'Payment Terms Code', OPYM.IntrimAcct AS 'Post to G/L Interim Account', OPYM.BnkActKey AS 'Bank Account Key', OPYM.DocType AS 'BoE Document Type', OPYM.Accepted AS 'BoE Status - Accepted', OPYM.PtfID AS 'BoE Internal Portfolio ID', OPYM.PtfCode AS 'BoE Portfolio Code', OPYM.PtfNum AS 'BoE Portfolio Number', OPYM.CurCode AS 'BoE Currency Code', OPYM.Instruct1 AS 'BoE Instruction 1', OPYM.Instruct2 AS 'BoE Instruction 2', OPYM.PaymntPlc AS 'BoE Payment Place', OPYM.BoeDll AS 'Bar Code DLL', OPYM.BankCtlKey AS 'Bank Control Key', OPYM.Active AS 'Status of the Payment Method', OPYM.BcgPcnt AS 'Bank Charge Rate (%)', OPYM.GrpByCur AS 'Group Invoices by Currency', OPYM.GrpByBank AS 'Group Invoices by Pay-To Bank', OPYM.DflIBAN AS 'Bank IBAN', OPYM.DflSwift AS 'Bank BIC/SWIFT', OPYM.BoeReport AS 'BoE Report Code', OPYM.CancInstr AS 'Cancellation Instruction', OPYM.OccurCode AS 'Occurrence Code', OPYM.MovmntCode AS 'Movement Code', OPYM.NegPymCode AS 'Negative Payment Method Code', OPYM.DirectDbt AS 'Direct Debit', OPYM.IssueIndic AS 'Issue Indicator', OPYM.PrintSEPA AS 'Print SEPA Prenotification' FROM OPYM AS OPYM

Related information


Wizard Payment Methods WizardPaymentMethods Object· Table: OPYM
The WizardPaymentMethods object enables to define payment methods, such as check, bank transfer, or bill-of-exchange. Source table: OPYM.

Payment Methods for Payment Wizard OPYM SQL Table

Countries OCRY SQL Table

House Bank Accounts DSC1 SQL Table

File Format OFRM SQL Table

G/L Accounts OACT SQL Table

Payment Terms OCTG SQL Table

Users OUSR 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