biuan SAP® BUSINESS ONE SDK
API Dunning Term Lines / Dunning Term Line
DUT1 - Dunning Term Array1 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TermCode KEY UNIQUEDunning Term CodenVarChar
25ODUT
Dunning Terms
PRIMARYYes
LevelNumLevel No.Int
11
LetterFrmtLetter FormatnVarChar
8
EffctAftrEffective afternVarChar
3
LetterFeeFee per LetterNum
20
FeeCurrFee CurrencynVarChar
3
MinBalanceMininum BalanceNum
20
MinBlnCurrMin Balance CurrencynVarChar
3
CalcIntrstCalc. InterestVarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT DUT1.TermCode AS 'Dunning Term Code', DUT1.LevelNum AS 'Level No.', DUT1.LetterFrmt AS 'Letter Format', DUT1.EffctAftr AS 'Effective after', DUT1.LetterFee AS 'Fee per Letter', DUT1.FeeCurr AS 'Fee Currency', DUT1.MinBalance AS 'Mininum Balance', DUT1.MinBlnCurr AS 'Min Balance Currency', DUT1.CalcIntrst AS 'Calc. Interest' FROM DUT1 AS DUT1

Related information


Dunning Term Line DunningTermLine Object· Table: DUT1
Represents a criterion for sending out a dunning letter. For example, a dunning term can define dunning letters for 30, 60, and 90-day delinquent balances. The term would, therefore, contain three lines, one for each dunning letter. Source...
   Parent: Dunning Term Lines DunningTermLines Collection
Dunning Terms ODUT 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