|
|
DTW Dunning Terms
API Dunning Terms Service / Dunning Term
ODUT - Dunning Terms Table
Dunning Term DunningTerm Object· Table: ODUT
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TermCode KEY UNIQUE | Dunning Term Code | nVarChar | 25 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TermName | Dunning Term Name | nVarChar | 100 | |||||
| GrpMethod | Grouping Method | VarChar | I) One Letter per Invoice L) One Letter per Dunning Level B) One Letter per BP | 1 | B | |||
| YearDays | Days in Year | Int | 6 | 360 | ||||
| MonthDays | Days in Month | Int | 6 | 30 | ||||
| RemIntrst | Calc. Interest Rem/Orig Sum | VarChar | Y) Yes N) No | 1 | Y | |||
| XchgOrig | Exchange Rate Orig/Current | VarChar | Y) Yes N) No | 1 | Y | |||
| YearlyRate | Yearly Interest Rate | Num | 20 | |||||
| MaxLevel | Max Dunning Level | Int | 6 | 0 | ||||
| TotalFee | All Total Fee | Num | 20 | |||||
| FeeCurr | All Fee Currency | nVarChar | 3 | |||||
| MinBalance | All Min. Balance | Num | 20 | |||||
| BalCurr | All Balance Currency | nVarChar | 3 | |||||
| CalcIntr | All Calc. Interest | VarChar | Y) Yes N) No | 1 | Y | |||
| LetterFrmt | All Letter Format | nVarChar | 8 | |||||
| HiLtrFrmt | Apply Highest Letter Template | VarChar | Y) Yes N) No | 1 | N | |||
| DateCalInt | Base Date for Interest Calc. | VarChar | Y) From Due Date N) From Last Dunning Run | 1 | Y | |||
| AutoPost | Automatic Posting | VarChar | N) No B) Interest and Fee I) Interest Only F) Fee Only | 1 | N | |||
| IntrAcc | Interest Account | nVarChar | 15 | OACT G/L Accounts | ||||
| FeeAcc | Fee Account | nVarChar | 15 | OACT 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
ODUT SQL Table
G/L Accounts OACT SQL Table
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
DunningTermsService
Object
DunningTerm
Collection
Enumeration
Method
Property
Code
DB
DaysInMonth
DB
DaysInYear
DB
LetterFee
DB
Name
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
