Added in Version 7.0
The MKTGSVC_RECIPIENT table stores the recipient (Lead/Contact) data targeted for a specific marketing service campaign.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
MKTGSVC_RECIPIENTID (PK) |
char(12) |
NOT NULL |
MKTGSVC_RECIPIENT_ID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
MGTSVC_UNDELIVERABLE.MKTGSVC_RECIPIENTID
|
||||
|
MKTGSVC_CAMPAIGNID (FK) |
char(12) |
NOT NULL |
MKTGSVC_RECIPIENT_CAMPID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
CAMPAIGNTARGETID(FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SKIPPED |
char(1) |
NULLS |
|
|
|
|
TARGETRESPONSEID (FK) |
char(12) |
NULLS |
MKTGSVC_RECIPIENT_TARGETRESPID (IE) |
(Many) to (One)
|