CPN3 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Business Partners / Campaign - Partners

DTW Business Partners / Campaign

API Campaign Partners / Campaign Partner

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
CpnNo ^KEY ^UNIQUE	Campaign No.	Int	11	OCPN Campaign	PRIMARY	Yes
CpnLineNum	Campaign Line Number	Int	11
ParterId	Partners	Int	11	OPRT Partners
OrlCode	Relationship Code	Int	11	OORL Relationships
RelatCard	Related BP	nVarChar	15	OCRD Business Partner
Memo	Details	nVarChar	50
LogIns	Log Instance - History	Int	11
VisOrder	Visual Order	Int	11

Table relationship map

SELECT statement

SELECT
   CPN3.CpnNo AS 'Campaign No.', 
   CPN3.CpnLineNum AS 'Campaign Line Number', 
   CPN3.ParterId AS 'Partners', 
   CPN3.OrlCode AS 'Relationship Code', 
   CPN3.RelatCard AS 'Related BP', 
   CPN3.Memo AS 'Details', 
   CPN3.LogIns AS 'Log Instance - History', 
   CPN3.VisOrder AS 'Visual Order'
FROM CPN3 AS CPN3

Related information

CampaignPartner Object· Table: CPN3

The relevant partners for the campaign. Source table: CPN3.

Parent: Campaign Partners CampaignPartners Collection
OCPN SQL Table

OORL SQL Table

OPRT SQL Table

OCRD SQL Table

biuan SAP® BUSINESS ONE

Collection
CampaignPartners

Object
CampaignPartner

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

Details

UserFields

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