SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: CPN2
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 |