biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Campaign / Campaign
API Campaigns Service / Campaign
OCPN - Campaign Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CpnNo KEY UNIQUECampaign No.Int
11
PRIMARYYes
NameCampaign NamenVarChar
100
TypeCampaign TypeVarChar
E) E-Mail
M) Mail
F) Fax
P) Phone Call
T) Meeting
S) SMS
W) Web
O) Other
1
E
TargetGrpTarget GroupnVarChar
20OTGG
Target Group
OwnerCampaign OwnerInt
11OHEM
Employees
StatusCampaign StatusVarChar
O) Open
F) Finished
C) Canceled
1
O
StartDateCampaign Start DateDate
8
FinishDateCampaign Finish DateDate
8
RemarksCampaign RemarksText
16
WizardGenGenerated by WizardVarChar
Y) Yes
N) No
1
N
TemplateCampaign TemplateText
16
AtcEntryAttachment EntryInt
11OATC
Attachments
AttachmentAttachmentsText
16
LogInsLog Instance - HistoryInt
11
UserSign2Updating User - HistoryInt
6OUSR
Users
UpdateDateDate of Update - HistoryDate
8
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreate DateDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
P) Partner Implementation
T) Year of Transfer
1
N
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
UrlWeb LinkText
16
TmplPathTemplate PathnVarChar
127

Table relationship map

SELECT statement

SELECT OCPN.CpnNo AS 'Campaign No.', OCPN.Name AS 'Campaign Name', OCPN.Type AS 'Campaign Type', OCPN.TargetGrp AS 'Target Group', OCPN.Owner AS 'Campaign Owner', OCPN.Status AS 'Campaign Status', OCPN.StartDate AS 'Campaign Start Date', OCPN.FinishDate AS 'Campaign Finish Date', OCPN.Remarks AS 'Campaign Remarks', OCPN.WizardGen AS 'Generated by Wizard', OCPN.Template AS 'Campaign Template', OCPN.AtcEntry AS 'Attachment Entry', OCPN.Attachment AS 'Attachments', OCPN.LogIns AS 'Log Instance - History', OCPN.UserSign2 AS 'Updating User - History', OCPN.UpdateDate AS 'Date of Update - History', OCPN.UserSign AS 'User Signature', OCPN.CreateDate AS 'Create Date', OCPN.DataSource AS 'Data Source', OCPN.Transfered AS 'Year Transfer', OCPN.Instance AS 'Instance', OCPN.Url AS 'Web Link', OCPN.TmplPath AS 'Template Path' FROM OCPN AS OCPN

Related information


Campaign Campaign Object· Table: OCPN
You can create, maintain, and analyze your marketing event information using the campaign management feature. Source table: OCPN.
   Parent: Campaigns Service CampaignsService Service· Table: OCPN

Campaigns Service CampaignsService Service· Table: OCPN
The CampaignsService service enables you to add, look up, update, cancel, and remove campaigns. Source table: OCPN.

OCPN SQL Table

Attachments OATC SQL Table

Employees OHEM SQL Table

Target Group OTGG SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates