| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | WizardId | Wizard ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | WizardName | Wizard Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | ToPayDate | To be paid by | date | 8 | 0 | | | | |
| 4 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 5 | Status | Wizard Status | char | 1 | 0 | | S | E=Executed and Printed Wizard, O=Executed, Not Yet Printed Wizard, R=Recommended Wizard, S=Saved Parameters | Allow NULL? |
| 6 | DunLevel | Dunning Level | nvarchar | 3 | 0 | ODUN | 0 | 0=All, 10=Level 10, 1=Level 1, 2=Level 2, 3=Level 3, 4=Level 4, 5=Level 5, 6=Level 6, 7=Level 7, 8=Level 8, 9=Level 9 | Allow NULL? |
| 7 | CreditZero | Include BP with Credit | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | PayNoBased | Payment on Account | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 9 | CrdtNBased | Include Credit Not Based | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 10 | DunTime | Dunning Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 12 | FromDate | From Date Filter | date | 8 | 0 | | | | |
| 13 | ToDate | Date To Filter | date | 8 | 0 | | | | |
| 14 | ManualJEs | Include Manual JEs | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 15 | DspOpnItms | Display Open Items | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | AllowNegLt | Allow Negative Dunning Letter | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 17 | DunTerm | Dunning Term | nvarchar | 25 | 0 | ODUT | -1 | | Allow NULL? |
| 18 | FrmDueDate | From Due Date Filter | date | 8 | 0 | | | | |
| 19 | ToDueDate | To Due Date Filter | date | 8 | 0 | | | | |
| 20 | UpToDate | Include Payments Up To | date | 8 | 0 | | | | |
