biuan SAP® BUSINESS ONE SDK
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates