6.4.4 Cancellation Campaign Item, Invoice and Invoice Item Creation

Important note: A cancellation wizard should not be used. We highly recommend using the Optimization wizard (Optimizer) to cancel invoices and campaign items.

When canceling items through the Cancellation Wizard, the Optimizer or individually, the cancellation items are cloned from the original items. When creating new records, certain fields are cloned, reset or changed/set by certain logic. An overview of this per field, per Object, can be found i the tables below:

Invoice Item

Label	Changed to	Reset	Clone

Label	Changed to	Reset	Clone
AC			x
AdDayOfWeek			x
AdHourOfDay			x
AdKeyValues			x
AdOperatingSystems			x
Ad Type External			x
Ad Type			x
Ad Spec Description on PDF			x
Ad Spec Distribution			x
Ad Spec External Name			x
Ad Spec			x
Placement External			x
Placement			x
Site External			x
Site			x
Ad Spec Use External Name on PDF			x
Sales Representative Country Code			x
AdWebBrowsers			x
Agency Earnings			x
Agency Earnings Amount			x
Amount Net			x
Billing Category			x
Billing Period End Date			x
Billing Period Start Date			x
Booked Quantity			x
Campaign Item			x
Quantity Discount Abs. Custom			x
Customer Discount Abs. Custom			x
Agency Discount Abs. Custom			x
Special Discount Abs. Custom			x
Connected Item	Lookup to cancelled item
Days This InvoiceItem			x
Days This Item			x
Day Time Targeting			x
Delivery AutoImport			x
Description (deprecated)			x
Distribution (Note)			x
Distribution (Period)			x
Distribution (Ratio)			x
Distribution (Unit)			x
eCPM			x
FC AdServed Every			x
FC Period			x
FC Quantity			x
Flexible Payment Amount			x
Frequency			x
Frequency Capping			x
Start Date			x
Gross Amount B1			x
Gross Amount B2			x
Gross Amount B3			x
Guaranteed AI			x
Hide Brands/Products On PDF			x
Hide Content Targeting On PDF			x
Hide FC On PDF			x
Hide Geo/Device Targeting on PDF			x
Hide Geo Targeting On PDF			x
Hide Key Value Targeting On PDF			x
Hide Package Header Details on PDF			x
Hide Publication Date Targeting On PDF			x
Hide Technical Targeting On PDF			x
Hide Time Targeting On PDF			x
Installment			x
Interval End Date			x
Interval Start Date			x
Invoice	Lookup to new pre-invoice
Invoice Accounting Date			x
Invoice Accounting End Date			x
Invoice Amount			x
Invoice Creation Type	Merge per period: Cancellation Invoice Merge all: Cancellation and Merge all Invoice		x Cloned for standard cancellation (value of zero)
Invoiced Amount N1			x
Invoiced Amount N2			x
Invoiced Amount N3			x
Invoice Date	Set by logic
InvoicedQuantity			x
Invoiced Quantity Multiplier			x
Invoice Item End Date			x
Invoice Item Start Date			x
Invoice Surcharge B2 (Abs.)			x
Invoice Surcharge B3 (Abs.)			x
Is CPM Price			x
Item Id			x
Item Record Type			x
Linear Distribution			x
Line Description			x
Non-Media			x
Package			x
Packet Item Id			x
Packet Item Package			x
Payment Status			x
Position Number			x
Position Number Appendix	Set by logic
Prorated			x
Delivered Quantity			x
Quantity Delivered Sum			x
Rate Criterion			x
Quantity Discount			x
Quantity Discount Abs.			x
Invoice Quantity Discount Abs. Custom			x
Customer Discount			x
Customer Discount Abs.			x
Invoice Customer Discount Abs. Custom			x
Customer Discount (Name)			x
Agency Discount			x
Agency Discount Abs.			x
Invoice Agency Discount Abs. Custom			x
Special Discount			x
Special Discount Abs.			x
Invoice Special Discount Abs. Custom			x
Special Discount (Name)			x
Salesprice			x
Selected AdServer ID Information			x
Selected Brands/Products Information			x
Selected City Information			x
Selected Content Information			x
Selected Country Information			x
Selected Publication Date Information			x
Selected Region Information			x
Show on PDF			x
Show Packet Component On PDF			x
Show Third Party Commission (deprecated)			x
Sort Order			x
Status		x Both Merge Cancellations	x Cloned for standard cancellation (value of zero)
Surcharge B2 (%)			x
Surcharge B2 (Abs.)			x
Surcharge B3 (%)			x
Surcharge B3 (Abs.)			x
Surcharge Sales Price			x
Surcharge Sales Price %			x
Taxable Amount Type			x
Third Party Commission			x
Third Party Commission Abs.			x
Total Discount (abs.)			x
TPC Campaign Item		x
Unique Key	Set by logic Merge: zero in original invoice item
End Date			x
VAT Amount			x
VAT-Exempt			x
VAT External Name			x
VAT Rate %			x
VAT Total			x
VAT Type			x
Created By ID			x
Created Date			x
Currency ISO Code			x
Record ID			x
Deleted			x
Last Activity Date			x
Last Modified By ID			x
Last Modified Date			x
Invoice Item			x
System Modstamp			x

Invoice

Label	Changed to	Reset	Clone

Label	Changed to	Reset	Clone
Accounting Date			x
Accounting End Date			x
Accounting Period		x Both Merge Cancellations	x Cloned for standard cancellation (value of zero)
Advertised Brand Name			x
Advertiser Billing City			x
Advertiser Billing Country			x
Advertiser Billing Postal Code			x
Advertiser Billing State			x
Advertiser Billing Street			x
Advertiser Billing Streets			x
Advertiser Contact Name			x
Advertiser Contact Email			x
Advertiser Contact Fax			x
Advertiser Contact Phone			x
Advertiser Debtor Id			x
Advertiser Id			x
Advertiser Name			x
Advertiser Number			x
Advertiser VAT Id			x
Agency Billing City			x
Agency Billing Country			x
Agency Billing Postal Code			x
Agency Billing State			x
Agency Billing Street			x
Agency Billing Streets			x
Agency Contact Name			x
Agency Contact Email			x
Agency Contact Fax			x
Agency Contact Phone			x
Agency Debtor Id			x
Agency Id
Agency Name			x
Agency Number			x
Agency VAT Id			x
Beneficiary Billing City			x
Beneficiary Billing Country			x
Beneficiary Billing Postal Code			x
Beneficiary Billing State			x
Beneficiary Billing Street			x
Beneficiary Billing Streets			x
Beneficiary Debtor Id			x
Beneficiary Id			x
Beneficiary Name			x
Beneficiary Number			x
Beneficiary VAT Id			x
Billing Period End Date			x
Billing Period Start Date			x
Billing Run		x
Campaign Name			x
Creation Type	Merge per period: Cancellation invoice Merge all: Cancellation and Merge all Invoice		x Cloned for standard cancellation (value of zero)
Payment Due Date			x
Days Early Payment Discount			x
Description			x
Invoice Dispatch Type	When no value: changed to Print	x When there is a value
Early Payment Discount			x
Early Payment Discount abs.			x
eCPM			x
End Date			x
ESR Amount			x
ESR Code			x
ESR Id			x
ESR Number			x
ESR Reference Number			x
ESR Type			x
External Media Campaign Name			x
Gross Amount B1			x
Gross Amount B2			x
Gross Amount B3			x
Hide components of adhoc packages on PDF			x
Intermediary Billing City			x
Intermediary Billing Country			x
Intermediary Billing Postal Code			x
Intermediary Billing State			x
Intermediary Billing Street			x
Intermediary Billing Streets			x
Intermediary Debtor Id			x
Intermediary Id			x
Intermediary Name			x
Intermediary Number			x
Intermediary VAT Id			x
Invoice			x
Invoiced Amount Gross (deprecated)			x
Invoiced Amount Gross (incl. EPD)			x
Invoiced Amount Gross (N2)(deprecated)			x
Invoiced Amount gross normal(deprecated)			x
Invoiced Amount Gross reduced deprecated			x
Invoiced Amount N1			x
Invoiced Amount N2			x
Invoiced Amount N3			x
Invoiced Amount Gross (Total)			x
Invoiced Amount Gross (VAT Type 1)			x
Invoiced Amount Gross (VAT Type 2)			x
Invoice Date	recalculated
Invoice Date (Manual)		x
Invoice Email			x
Invoice Full Number	Set by logic
Invoice Generation Setting			x
Invoice Legal Entity Number		x
Invoice Number		x
Invoice Number Prefix			x
Invoice Number Suffix			x
Invoice Type	Standard Cancellation: Credit note cancellation Cancellation wizard merge periods and merge all: Invoice Cancellation optimizer merge periods and merge all: Credit note With version 2.167 “Merge All Cancelation” type Invoice and invoice items can be canceled unless those are cancelation invoice items. So even when you try to cancel full Merge All Cancelation type invoice only invoice items that have no connected items as a reference (Cancelation items) will be canceled.
Debtor			x
Invoiced?			x
Items on PDF			x
KeyExtension			x
Legal Entity			x
Legal Entity Country			x
Media Campaign			x
N3			x
New VAT Calculation			x
Non-Media Amount			x
Nontaxable Amount (Total)			x
External Order No.			x
Order No.			x
Payment Due to			x
Payment Interval			x
Payment Start			x
Payment Status			x
Payment Terms			x
Postal-Recipient Billing City			x
Postal-Recipient Billing Country			x
Postal-Recipient Billing Postal Code			x
Postal-Recipient Billing State			x
Postal-Recipient Billing Street			x
Postal Recipient Billing Streets			x
Postal-Recipient Debtor Id			x
Postal-Recipient Id			x
Postal-Recipient Name			x
Postal-Recipient Number			x
Postal-Recipient VAT Id			x
Pre-Invoice Number			x
QuoteLanguage			x
QuoteLocale			x
Quantity Discount			x
Quantity Discount Abs.			x
Customer Discount			x
Customer Discount Abs.			x
Agency Discount			x
Agency Discount Abs.			x
Special Discount Abs.			x
Debtor Billing City			x
Debtor Billing Country			x
Debtor Billing Postal Code			x
Debtor Billing State			x
Debtor Billing Street			x
Debtor Billing Streets			x
Debtor Contact Name			x
Debtor Contact Email			x
Debtor Contact Fax			x
Debtor Contact Phone			x
Debtor Debtor Id			x
Debtor Id			x
Debtor Name			x
Debtor Number			x
Debtor VAT Id			x
Reverse-Charge Mechanism			x
Sales Representative			x
Sales Tax Id			x
Show Third Party Commission			x
Start Date			x
Status	Created		x
Sum of Agency Commission			x
Taxable Amount (Total)			x
Taxable Amount (VAT Type 1)			x
Taxable Amount (VAT Type 2)			x
Terms of Payment Days Net			x
Terms of Payment Text			x
Third Party Commission			x
Third Party Commission Abs.			x
Total Amount Due (deprecated)			x
Total Discount Abs.			x
Transaction Type			x
Unique Key			x
VAT Amount (Type 1)			x
VAT Amount (Type 2)			x
VAT Exempt			x
VAT External Name (Type 1)			x
VAT External Name (Type 2)			x
VAT External Name (VAT Exempt)			x
VAT Rate % (Type 1)			x
VAT Rate % (Type 2)			x
VAT Total			x
Reference Number			x
Created By ID			x
Created Date			x
Currency ISO Code			x
Record ID			x
Deleted			x
Last Activity Date			x
Last Modified By ID			x
Last Modified Date			x
Invoice			x
Owner ID			x
System Modstamp			x

Campaign Item

Label	Changed to	Reset	Clone

Label	Changed to	Clone
AC		x
Ad Id		x
Ad Price		x
Ad Spec		x
AdAreaCodes		x
AdBrowsersMajor Version		x
AdBrowsersMinor Version		x
AdDayOfWeek		x
Additional Ad Ids		x
AdHourOfDay		x
Internet Service Providers		x
AdKeyValues		x
AdKeyWords		x
Ad Manager Status		x
AdOperatingSystems		x
AdPostalCodes		x
Adserver Adv. (Advertiser ID)		x
Adserver ID Order ID		x
Adserver Name		x
Adserver Price		x
AdServer Proposal ID		x
AdServer Proposal Line Item ID		x
Adserver Status		x
AdServer Targeting		x
AdStatesRegions		x
Ad Type		x
AdWebBrowsers		x
Agency Commission (%)		x
Agency Earnings		x
Agency Earnings Condition
Alternate ID		x
Amount		x
Amount (B2)		x
Amount (B2) (apex)		x
Amount (B3)		x
Amount (B3) (apex)		x
Amount net3		x
Amount net3 (apex)		x
Amount net		x
Amount net/net		x
Amount_net_net (apex)		x
Amount net (apex)		x
Amount (apex)		x
Availability (planned)		x
Availability (running)		x
Available		x
AV AS Eligible AI		x
AV AS Measurable AI		x
AV AS Measurable AI Rate		x
AV AS Viewable AI		x
AV AS Viewable AI (Manual)		x
AV AS Viewable AI Rate		x
AV Total Eligible AI		x
AV Total Measurable AI		x
AV Total Measurable AI Rate		x
AV Total Viewable AI		x
AV Total Viewable AI Rate		x
Bandwidth		x
Billing Category		x
Billing Status	Changed to Created
Bill me?		x
Bleed Amount		x
Booked Page Equivalency		x
Booking Calendar Date Assignment		x
Booking Quantity		x
Budget N2		x
Business Type		x
Calendar Week (due to)		x
Calendar Week (from)		x
Count Default CiAP		x
Click Rate		x
Commitment Relevant		x
Component Optional		x
Condition Applied		x
Connected Item	Links to cancelled item
Connected Item ID		x
Contending Campaign Items		x
Creative Rotation Type		x
Creative Source		x
Creative Targeting		x
Creative Uploaded		x
Current AdServer Status		x
Days		x
Day & Time Targeting		x
Delivered Clicks		x
Delivered Impressions		x
Delivered AIs (manual)		x
Delivered Clicks (manual)		x
Delivery Rate Type		x
Delivery Type		x
Device Capability		x
Device Category		x
Distribution (Period)		x
Distribution (Unit)		x
Do not Show on Proposal PDF		xx
eCPC		x
eCPM		x
Effective Agency Earnings		x
Exclude Bandwidths		x
Exclude Browsers		x
Exclude Cities		x
Exclude Countries		x
Exclude Device Capabilities		x
Exclude Device Categories		x
Exclude Operating Systems		x
Exclude Regions		x
Exclusive		x
Exclusivity Check Status		x
External ID		x
FC Ad served every		x
FC Period		x
FC Quantity		x
Flat Plan Status		x
Frequency		x
Frequency Capping		x
From (Date)		x
From (Hour)		x
From (Minute)		x
Goal Percent		x
Guaranteed AI		x
Height		x
Hide Brands/Products On PDF		x
Hide Content Targeting On Quote		x
Hide FC On Quote		x
Hide Geo/Device Targeting on PDF		x
Hide Geo Targeting On Quote		x
Hide Key Value Targeting On Quote		x
Hide Package Header Details on PDF		x
Hide Publication Date Targeting On Quote		x
Hide Technical Targeting On Quote		x
Hide Time Targeting On Quote		x
Include Users Without Cookies		x
Internal comment		x
Invoice at end of runtime		x
Invoice Generation Setting		x
Invoice Interval Setting		x
Invoice Quantity (manual)		x
Is CPM Price		x
Is Recommended		x
Last Delivery Data Update		x
Last Availability Forecast		x
Last Booking Process		x
Last Exclusivity Check		x
Last Manual Delivery Data Update		x
Level Of Exclusivity		x
Line Description (deprecated)		x
Linear Distribution		x
Line Description		x
List Price		x
Manual Date Range		x
Matched Impressions (planned)		x
Matched Impressions (running)		x
Media Campaign		x
Non-Media		x
Not Relevant For Turnover		x
Number Of Columns		x
One Imp Per Page		x
Optimization Exclusion		x
OSI		x
Overbooking Factor		x
Package		x
Packet Item		x
Pay Factor		x
Payment Status		x
Payment Type (deprecated)		x
Performance Indicator		x
Period		x
Placement Type		x
Planned Receipt Date Setting		x
Position Number		x
Position Number Appendix	Set by logic
Position Reference		x
Preferred Placement		x
Priority		x
Proposal ID		x
Proposal Line Item ID		x
Prorated		x
Publisher Payout Condition		x
Quantity		x
Quantity Discount custom		x
Query Inventory		x
Quantity Discount		x
Customer Discount		x
Customer Discount custom		x
Agency Discount		x
Agency Discount custom		x
Special Discount		x
Special Discount (Name)		x
Rate Calculation Quantity		x
Quantity Discount Abs.		x
Quantity Discount Abs. Custom		x
Customer Discount Abs.		x
Customer Discount Abs. Custom		x
Customer Discount (Name)		x
Agency Discount Abs.		x
Agency Discount Abs. Custom		x
Special Discount Abs.		x
Special Discount Abs. Custom		x
Rebate In Kind Condition		x
Reserved Impressions (planned)		x
Reserved Impressions (running)		x
RTB Competition		x
Sales Price		x
Scaled Discount Condition		x
Scope of Exclusivity		x
Secondary Goal Quantity		x
Selected Cities		x
Selected Countries		x
Selected AdServer ID Information		x
Selected Brands/Products Information		x
Selected City Information		x
Selected Content Information		x
Selected Country Information		x
Selected Publication Date Information		x
Selected Region Information		x
Set Bleed		x
Share of Voice (%)		x
Shiftable		x
Show on Invoice PDF		x
Show Packet Components On Quote		x
Sort Order	Set by logic	x
Special Discount Condition		x
Status message submitted to AdServer		x
Status submitted to AdServer		x
Submit to AdServer		x
Sum Of Taxes (deprecated)		x
Suppress Crosssell Warnings		x
Surcharge B2 (%)		x
Surcharge B2 (Abs.)		x
Surcharge B3 (%)		x
Surcharge B3 (Abs.)		x
Surcharge Sales Price		x
Surcharge Sales Price %		x
Targeting		x
Targeting fee (deprecated)		x
Targeting Surcharge (deprecated)		x
Targeting type		x
Targetingabbrevation		x
Target Net		x
Target Platform		x
Tax (deprecated)		x
Taxable Amount Type		x
Third party commission		x
Third Party Commission Abs.		x
Third Party Commission Custom		x
Tile Category		x
Time Zone		x
Total Impressions		x
Total Discount (abs.)		x
Third Party Commission Condition		x
Turnover actual (by delivery) oli		x
Label Unit		x
Until (Date)		x
Until (Hour)		x
Until (Minute)		x
User Domains		x
User Domains Matched		x
VAT Amount		x
VAT Exempt		x
VAT External Name		x
VAT Rate %		x
Video Metric		x
Video Metric (manual)		x
Width		x
Created By ID		x
Created Date		x
Currency ISO Code		x
Record ID		x
Deleted		x
Last Modified By ID		x
Last Modified Date		x
Campaign Item Name		x
Record Type ID		x
System Modstamp		x