biuan SAP® BUSINESS ONE SDK
DTW Dunning Terms
API Dunning Terms Service / Dunning Term
ODUT - Dunning Terms Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TermCode KEY UNIQUEDunning Term CodenVarChar
25
PRIMARYYes
TermNameDunning Term NamenVarChar
100
GrpMethodGrouping MethodVarChar
I) One Letter per Invoice
L) One Letter per Dunning Level
B) One Letter per BP
1
B
YearDaysDays in YearInt
6
360
MonthDaysDays in MonthInt
6
30
RemIntrstCalc. Interest Rem/Orig SumVarChar
Y) Yes
N) No
1
Y
XchgOrigExchange Rate Orig/CurrentVarChar
Y) Yes
N) No
1
Y
YearlyRateYearly Interest RateNum
20
MaxLevelMax Dunning LevelInt
6
0
TotalFeeAll Total FeeNum
20
FeeCurrAll Fee CurrencynVarChar
3
MinBalanceAll Min. BalanceNum
20
BalCurrAll Balance CurrencynVarChar
3
CalcIntrAll Calc. InterestVarChar
Y) Yes
N) No
1
Y
LetterFrmtAll Letter FormatnVarChar
8
HiLtrFrmtApply Highest Letter TemplateVarChar
Y) Yes
N) No
1
N
DateCalIntBase Date for Interest Calc.VarChar
Y) From Due Date
N) From Last Dunning Run
1
Y
AutoPostAutomatic PostingVarChar
N) No
B) Interest and Fee
I) Interest Only
F) Fee Only
1
N
IntrAccInterest AccountnVarChar
15OACT
G/L Accounts
FeeAccFee AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT ODUT.TermCode AS 'Dunning Term Code', ODUT.TermName AS 'Dunning Term Name', ODUT.GrpMethod AS 'Grouping Method', ODUT.YearDays AS 'Days in Year', ODUT.MonthDays AS 'Days in Month', ODUT.RemIntrst AS 'Calc. Interest Rem/Orig Sum', ODUT.XchgOrig AS 'Exchange Rate Orig/Current', ODUT.YearlyRate AS 'Yearly Interest Rate', ODUT.MaxLevel AS 'Max Dunning Level', ODUT.TotalFee AS 'All Total Fee', ODUT.FeeCurr AS 'All Fee Currency', ODUT.MinBalance AS 'All Min. Balance', ODUT.BalCurr AS 'All Balance Currency', ODUT.CalcIntr AS 'All Calc. Interest', ODUT.LetterFrmt AS 'All Letter Format', ODUT.HiLtrFrmt AS 'Apply Highest Letter Template', ODUT.DateCalInt AS 'Base Date for Interest Calc.', ODUT.AutoPost AS 'Automatic Posting', ODUT.IntrAcc AS 'Interest Account', ODUT.FeeAcc AS 'Fee Account' FROM ODUT AS ODUT

Related information


Dunning Term DunningTerm Object· Table: ODUT
Represents a dunning term, which defines a set of dunning levels that determine when to send dunning letters for past-due balances. A dunning term can be assigned to a business partner. Source table: ODUT Mandatory properties: Code, Name;    Parent: Dunning Terms Service DunningTermsService Service· Table: ODUT

Dunning Terms Service DunningTermsService Service· Table: ODUT
The DunningTermsService service enables you to add, look up and remove dunning terms for defining when to send out dunning terms for delinquent balances. Each business partner can be assigned to one dunning term, which defines when to send...

ODUT SQL Table

G/L Accounts OACT 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