| 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 |
|
|
|