| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | TermCode | Dunning Term Code | nvarchar | 25 | 0 | | | | Allow NULL? |
| 2 | TermName | Dunning Term Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | GrpMethod | Grouping Method | char | 1 | 0 | | B | B=One Letter per BP, I=One Letter per Invoice, L=One Letter per Dunning Level | Allow NULL? |
| 4 | YearDays | Days in Year | int | 6 | 0 | | 360 | | Allow NULL? |
| 5 | MonthDays | Days in Month | int | 6 | 0 | | 30 | | Allow NULL? |
| 6 | RemIntrst | Calc. Interest Rem/Orig Sum | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 7 | XchgOrig | Exchange Rate Orig/Current | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 8 | YearlyRate | Yearly Interest Rate | num | 19 | 6 | | | | Allow NULL? |
| 9 | MaxLevel | Max Dunning Level | int | 6 | 0 | | 0 | | Allow NULL? |
| 10 | TotalFee | All Total Fee | num | 19 | 6 | | | | Allow NULL? |
| 11 | FeeCurr | All Fee Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | MinBalance | All Min. Balance | num | 19 | 6 | | | | Allow NULL? |
| 13 | BalCurr | All Balance Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | CalcIntr | All Calc. Interest | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 15 | LetterFrmt | All Letter Format | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | HiLtrFrmt | Apply Highest Letter Template | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 17 | DateCalInt | Base Date for Interest Calc. | char | 1 | 0 | | Y | N=From Last Dunning Run, Y=From Due Date | Allow NULL? |
| 18 | AutoPost | Automatic Posting | char | 1 | 0 | | N | B=Interest and Fee, F=Fee Only, I=Interest Only, N=No | Allow NULL? |
| 19 | IntrAcc | Interest Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 20 | FeeAcc | Fee Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
