biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment Run
API OPYD
OPYD - Payment Run Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEPayment Run CodenVarChar
20
PRIMARYYes
NamePayment Run NamenVarChar
50
TolerDaysTolerance DaysInt
6
MinCashDisMin. Cash DiscountNum
20
UseMinPayUse Minimum PaymentVarChar
Y) Yes
N) No
1
N
MinPayARMinimum Incoming PaymentNum
20
MinPayAPMinimum Outgoing PaymentNum
20
ArePayMethPayment TermsVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT OPYD.Code AS 'Payment Run Code', OPYD.Name AS 'Payment Run Name', OPYD.TolerDays AS 'Tolerance Days', OPYD.MinCashDis AS 'Min. Cash Discount', OPYD.UseMinPay AS 'Use Minimum Payment', OPYD.MinPayAR AS 'Minimum Incoming Payment', OPYD.MinPayAP AS 'Minimum Outgoing Payment', OPYD.ArePayMeth AS 'Payment Terms' FROM OPYD AS OPYD

Related information


OPYD 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