|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Campaign - Items
Table Name: ACP2
Table Description: Campaign - Items
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CpnNo | Campaign No. | Int | 11 | OCPN | Â | Â | Â |
| CpnLineNum | Campaign Line Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| ItemName | Item Description | nVarChar | 200 | - | Â | Â | Â |
| ItemType | Item Type | VarChar | 1 | - | Â | I | Items |
| Â | Â | Â | Â | Â | Â | L | Labor |
| Â | Â | Â | Â | Â | Â | T | Travel |
| ItemGrp | Item Group | nVarChar | 100 | - | Â | Â | Â |
| LogIns | Log Instance - History | Int | 11 | - | Â | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CpnNo |
| Â | Â | CpnLineNum |
| Â | Â | LogIns |