|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Dunning Terms
Table Name: ODUT
Table Description: Dunning Terms
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TermCode | Dunning Term Code | nVarChar | 25 | - | Â | Â | Â |
| TermName | Dunning Term Name | nVarChar | 100 | - | Â | Â | Â |
| GrpMethod | Grouping Method | VarChar | 1 | - | B | I | One Letter per Invoice |
| Â | Â | Â | Â | Â | Â | L | One Letter per Dunning Level |
| Â | Â | Â | Â | Â | Â | B | One Letter per BP |
| YearDays | Days in Year | Int | 6 | - | 360 | Â | Â |
| MonthDays | Days in Month | Int | 6 | - | 30 | Â | Â |
| RemIntrst | Calc. Interest Rem/Orig Sum | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| XchgOrig | Exchange Rate Orig/Current | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| YearlyRate | Yearly Interest Rate | Num | 19.6 | - | Â | Â | Â |
| MaxLevel | Max Dunning Level | Int | 6 | - | 0 | Â | Â |
| TotalFee | All Total Fee | Num | 19.6 | - | Â | Â | Â |
| FeeCurr | All Fee Currency | nVarChar | 3 | - | Â | Â | Â |
| MinBalance | All Min. Balance | Num | 19.6 | - | Â | Â | Â |
| BalCurr | All Balance Currency | nVarChar | 3 | - | Â | Â | Â |
| CalcIntr | All Calc. Interest | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LetterFrmt | All Letter Format | nVarChar | 8 | - | Â | Â | Â |
| HiLtrFrmt | Apply Highest Letter Template | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DateCalInt | Base Date for Interest Calc. | VarChar | 1 | - | Y | Y | From Due Date |
| Â | Â | Â | Â | Â | Â | N | From Last Dunning Run |
| AutoPost | Automatic Posting | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | B | Interest and Fee |
| Â | Â | Â | Â | Â | Â | I | Interest Only |
| Â | Â | Â | Â | Â | Â | F | Fee Only |
| IntrAcc | Interest Account | nVarChar | 15 | OACT | Â | Â | Â |
| FeeAcc | Fee Account | nVarChar | 15 | OACT | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TermCode |