| 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 or Sent by E-Mail, O=Executed, Not Yet Printed or Sent by E-Mail, P=Partially Executed and Printed, R=Saved Recommendations, S=Saved Parameters, T=Partially Executed, Not Yet Printed or Sent by E-Mail | 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 | | | | |
| 21 | InvPostDat | Invc. Posting Date | date | 8 | 0 | | | | |
| 22 | InvDueDate | Invc. Due Date | date | 8 | 0 | | | | |
| 23 | InvDocDate | Invc. Doc. Date | date | 8 | 0 | | | | |
| 24 | Project | Project | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | OcrCode | Costing Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | OcrCode2 | Costing Code 2 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | OcrCode3 | Costing Code 3 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | OcrCode4 | Costing Code 4 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | OcrCode5 | Costing Code 5 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | InVatGroup | Interest VAT Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | InTaxCode | Interest Tax Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | FeVatGroup | Fee VAT Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | FeTaxCode | Fee Tax Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | VatPrcnt | VAT Percent | num | 19 | 6 | | | | Allow NULL? |
| 35 | AutoRmk | Auto Remark | char | 1 | 0 | | Y | | Allow NULL? |
| 36 | Remarks | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 37 | Series | Series | int | 11 | 0 | NNM1 | 0 | | Allow NULL? |
| 38 | BPLId | BPL ID Assigned to Invoice | int | 11 | 0 | | | | Allow NULL? |
| 39 | LocCode | Location Code | int | 11 | 0 | | | | Allow NULL? |
| 40 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 41 | OvrDueOnly | BPs with Overdue Item Only | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 42 | QuickDisp | Quick Display | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 43 | OPNoBased | Include Outgoing Payments | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 44 | CnsdVendor | Consider Connected Vendor | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
