📚 SAP Business One SDK Help

Table Name: ACPN

Table Description: Campaign

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 E-Mail
            M Mail
            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    
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
    LogIns