| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CpnNo | Campaign No. | int | 11 | 0 | | | | Allow NULL? |
| 2 | Name | Campaign Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | Type | Campaign Type | char | 1 | 0 | | E | E=E-Mail, F=Fax, M=Mail, O=Other, P=Phone Call, S=SMS, T=Meeting, W=Web | Allow NULL? |
| 4 | TargetGrp | Target Group | nvarchar | 20 | 0 | OTGG | | | Allow NULL? |
| 5 | Owner | Campaign Owner | int | 11 | 0 | OHEM | | | Allow NULL? |
| 6 | Status | Campaign Status | char | 1 | 0 | | O | C=Canceled, F=Finished, O=Open | Allow NULL? |
| 7 | StartDate | Campaign Start Date | date | 8 | 0 | | | | |
| 8 | FinishDate | Campaign Finish Date | date | 8 | 0 | | | | |
| 9 | Remarks | Campaign Remarks | text | 16 | 0 | | | | |
| 10 | WizardGen | Generated by Wizard | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 11 | Template | Campaign Template | text | 16 | 0 | | | | |
| 12 | AtcEntry | Attachment Entry | int | 11 | 0 | OATC | | | Allow NULL? |
| 13 | Attachment | Attachments | text | 16 | 0 | | | | |
| 14 | LogIns | Log Instance - History | int | 11 | 0 | | | | Allow NULL? |
| 15 | UserSign2 | Updating User - History | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | UpdateDate | Date of Update - History | date | 8 | 0 | | | | |
| 17 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 18 | CreateDate | Create Date | date | 8 | 0 | | | | |
| 19 | DataSource | Data Source | char | 1 | 0 | | N | A=Auto Summary, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year of Transfer, U=Upgrade | Allow NULL? |
| 20 | Transfered | Year Transfer | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | Instance | Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 22 | Url | Web Link | text | 16 | 0 | | | | |
| 23 | TmplPath | Template Path | nvarchar | 254 | 0 | | | | Allow NULL? |
| 24 | TargetType | Target Group Type | char | 1 | 0 | | C | C=Customer, S=Vendor | Allow NULL? |
| 25 | ExeOption | Execute Option | char | 1 | 0 | | O | B=Send E-Mail Using SAP Business One Mail, F=Send Fax, L=Generate External List, O=Send E-Mail Using Microsoft Office Outlook, U=Generate URL | Allow NULL? |
| 26 | Executed | Executed | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 27 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
