|
|
DTW Administration / Setup / Banking / Payment Methods
API OPYM / Wizard Payment Methods
OPYM - Payment Methods for Payment Wizard Table
Wizard Payment Methods WizardPaymentMethods Object· 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | PayMethCod KEY UNIQUE | Payment Method Code | nVarChar | 15 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Descript | Description | nVarChar | 100 | |||||
| Type | Type | VarChar | O) Outgoing I) Incoming | 1 | ||||
| BankTransf | Payment Means | VarChar | C) Check T) Bank Transfer B) Bill of Exchange | 1 | ||||
| Address | Check Address | VarChar | Y) Yes N) No | 1 | N | |||
| BankDet | Check Bank Details | VarChar | Y) Yes N) No | 1 | N | |||
| CllctAutor | Collection Authorization Check | VarChar | Y) Yes N) No | 1 | N | |||
| FrgnPmntBl | Block Foreign Payment | VarChar | Y) Yes N) No | 1 | N | |||
| FrgnBnkBl | Block Foreign Bank | VarChar | Y) Yes N) No | 1 | N | |||
| CurrRestr | Currency Restriction | VarChar | Y) Yes N) No | 1 | N | |||
| PostOffBnk | Post Office Bank | VarChar | Y) Yes N) No | 1 | N | |||
| MinAmount | Minimum Amount | Num | 20 | |||||
| MaxAmount | Maximum Amount | Num | 20 | |||||
| BnkDflt | Default Bank | nVarChar | 30 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DataSource | Data Source | VarChar | 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 | |||
| CreateDate | Creation Date | Date | 8 | |||||
| BankCountr | Bank Country | nVarChar | 3 | OCRY Countries | ||||
| DflAccount | Default Account | nVarChar | 50 | |||||
| GLAccount | G/L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Branch | Branch | nVarChar | 50 | |||||
| KeyCode | Key Code | nVarChar | 6 | |||||
| TrnsType | Transaction Type | nVarChar | 2 | |||||
| Format | Format | nVarChar | 11 | OFRM File Format | ||||
| AgtCollect | Agent Collection | VarChar | Y) Yes N) No | 1 | N | |||
| SendAccept | Send for Acceptance | VarChar | Y) Yes N) No | 1 | N | |||
| GrpByDate | Group By Date | VarChar | Y) Yes N) No | 1 | N | |||
| DepNorm | Deposit Norm | nVarChar | 8 | |||||
| DebitMemo | Debit Memo | VarChar | N) No Y) Yes | 1 | N | |||
| GroupPmRef | Group by Payment Reference No. | VarChar | Y) Yes N) No | 1 | N | |||
| GroupInv | Group Invoices by Pay | VarChar | N) No Y) Yes | 1 | N | |||
| ValDateSel | Due Date Selection | VarChar | P) Date of Payment Run I) Due Date of Invoice T) Payment Terms | 1 | P | |||
| PaymTerms | Payment Terms Code | Int | 6 | OCTG Payment Terms | ||||
| IntrimAcct | Post to G/L Interim Account | VarChar | N) No Y) Yes | 1 | N | |||
| BnkActKey | Bank Account Key | Int | 11 | DSC1 House Bank Accounts | ||||
| DocType | BoE Document Type | nVarChar | 2 | |||||
| Accepted | BoE Status - Accepted | VarChar | 1 | |||||
| PtfID | BoE Internal Portfolio ID | nVarChar | 3 | |||||
| PtfCode | BoE Portfolio Code | nVarChar | 2 | |||||
| PtfNum | BoE Portfolio Number | nVarChar | 4 | |||||
| CurCode | BoE Currency Code | nVarChar | 2 | |||||
| Instruct1 | BoE Instruction 1 | nVarChar | 2 | |||||
| Instruct2 | BoE Instruction 2 | nVarChar | 2 | |||||
| PaymntPlc | BoE Payment Place | nVarChar | 127 | |||||
| BoeDll | Bar Code DLL | nVarChar | 50 | |||||
| BankCtlKey | Bank Control Key | nVarChar | 2 | |||||
| Active | Status of the Payment Method | VarChar | Y) Active N) Inactive | 1 | Y | |||
| BcgPcnt | Bank Charge Rate (%) | Num | 20 | |||||
| GrpByCur | Group Invoices by Currency | VarChar | N) No Y) Yes | 1 | N | |||
| GrpByBank | Group Invoices by Pay-To Bank | VarChar | Y) Yes N) No | 1 | N | |||
| DflIBAN | Bank IBAN | nVarChar | 50 | |||||
| DflSwift | Bank BIC/SWIFT | nVarChar | 50 | |||||
| BoeReport | BoE Report Code | nVarChar | 8 | |||||
| CancInstr | Cancellation Instruction | nVarChar | 2 | |||||
| OccurCode | Occurrence Code | nVarChar | 2 | |||||
| MovmntCode | Movement Code | nVarChar | 10 | |||||
| NegPymCode | Negative Payment Method Code | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | ||||
| DirectDbt | Direct Debit | nVarChar | 5 | |||||
| IssueIndic | Issue Indicator | VarChar | 3) R) | 1 | R | |||
| PrintSEPA | Print SEPA Prenotification | VarChar | 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
WizardPaymentMethods
Enumeration
Method
Object
CurrencyRestrictions PYM1
Property
Accepted
DTW DB
AgentCollection
DTW DB
BankCountry
DTW DB
BarcodeDll
DTW DB
BlockForeignBank
DTW DB
BlockForeignPayment
DTW DB
Branch
DB
CheckAddress
DTW DB
CheckBankDetails
DTW DB
CollectionAuthorizationCheck
DTW DB
CreationDate
DB
CurCode
DTW DB
CurrencyRestriction
DTW DB
DebitMemo
DTW DB
DefaultAccount
DTW DB
DefaultBank
DTW DB
DepositNorm
DTW DB
Description
DTW DB
DocType
DTW DB
DueDateSelection
DTW DB
Format
DTW DB
GLAccount
DB
GroupByDate
DTW DB
GroupByPaymentReference
DTW DB
GroupInvoicesbyPay
DTW DB
Instruction1
DTW DB
Instruction2
DTW DB
KeyCode
DTW DB
MaximumAmount
DTW DB
MinimumAmount
DTW DB
PaymentMeans
DTW DB
PaymentMethodCode
DTW DB
PaymentPlace
DTW DB
PaymentTermsCode
DTW DB
PortfolioID
DTW DB
PostOfficeBank
DTW DB
PosttoGLInterimAccount
DTW DB
SendforAcceptance
DTW DB
TransactionType
DTW DB
Type
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
