| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CpnNo | Campaign No. | Int | 11 | - | |||
| Name | Campaign Name | nVarChar | 100 | - | |||
| Type | Campaign Type | VarChar | 1 | - | E | E | |
| M | |||||||
| F | Fax | ||||||
| P | Phone Call | ||||||
| T | Meeting | ||||||
| S | SMS | ||||||
| W | Web | ||||||
| O | Other | ||||||
| TargetGrp | Target Group | nVarChar | 20 | OTGG | |||
| Owner | Campaign Owner | Int | 11 | OHEM | |||
| Status | Campaign Status | VarChar | 1 | - | O | O | Open |
| F | Finished | ||||||
| C | Canceled | ||||||
| StartDate | Campaign Start Date | Date | 8 | - | |||
| FinishDate | Campaign Finish Date | Date | 8 | - | |||
| Remarks | Campaign Remarks | Text | 16 | - | |||
| WizardGen | Generated by Wizard | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| Template | Campaign Template | Text | 16 | - | |||
| AtcEntry | Attachment Entry | Int | 11 | OATC | |||
| Attachment | Attachments | Text | 16 | - | |||
| LogIns | Log Instance - History | Int | 11 | - | |||
| UserSign2 | Updating User - History | Int | 6 | OUSR | |||
| UpdateDate | Date of Update - History | Date | 8 | - | |||
| UserSign | User Signature | Int | 6 | OUSR | |||
| CreateDate | Create Date | Date | 8 | - | |||
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| I | Interface | ||||||
| U | Upgrade | ||||||
| M | Import | ||||||
| O | DI API | ||||||
| S | Service Layer | ||||||
| W | Web Client | ||||||
| A | Auto Summary | ||||||
| P | Partner Implementation | ||||||
| T | Year of Transfer | ||||||
| Transfered | Year Transfer | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| Instance | Instance | Int | 6 | - | 0 | ||
| Url | Web Link | Text | 16 | - | |||
| TmplPath | Template Path | nVarChar | 254 | - | |||
| TargetType | Target Group Type | VarChar | 1 | - | C | C | Customer |
| S | Vendor | ||||||
| ExeOption | Execute Option | VarChar | 1 | - | O | L | Generate External List |
| O | Send E-Mail Using Microsoft Office Outlook | ||||||
| B | Send E-Mail Using SAP Business One Mail | ||||||
| F | Send Fax | ||||||
| U | Generate URL | ||||||
| Executed | Executed | VarChar | 1 | - | Y | Yes | |
| N | No | ||||||
| VersionNum | Version Number | nVarChar | 13 | - | |||
| Key | Unique | Field |
| PRIMARY | Yes | CpnNo |