biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment Terms / Dunning Interest Rate
DTW Business Partners / Payment Terms Types / Dunning Interest Rate
API Payment Terms Types / Dunning Code
ORIT - Dunning Interest Rate Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEInterest CodenVarChar
20
PRIMARYYes
NameInterest NamenVarChar
50
IncPartPayInclude Partially Paid Inv.VarChar
Y) Yes
N) No
1
Y
DayInMonthNumber of Days in MonthInt
11
OrigRateUse Original Exchange RateVarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT ORIT.Code AS 'Interest Code', ORIT.Name AS 'Interest Name', ORIT.IncPartPay AS 'Include Partially Paid Inv.', ORIT.DayInMonth AS 'Number of Days in Month', ORIT.OrigRate AS 'Use Original Exchange Rate' FROM ORIT AS ORIT

Related information


Dunning Code DunningCode Property· Table: ORIT
Sets or returns the dunning code as defined in the Dunning System. The dunning code sets the type of interest calculation for late payments.Field name: DunningCod.Length: 20 characters.This is a foreign key to the Dunning Interest Rate table...
· Table: OCTG    Parent: Payment Terms Types PaymentTermsTypes Object· Table: OCTG
ORIT 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