6.4.4 Cancellation Campaign Item, Invoice and Invoice Item Creation

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

Invoice Item

LabelChanged toResetClone
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 ItemLookup 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
InvoiceLookup 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 DateSet 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 AppendixSet 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

LabelChanged 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 Daterecalculated

Invoice Date (Manual)
x
Invoice Email

x
Invoice Full NumberSet 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




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
StatusCreated
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

LabelChanged toResetClone
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
ADTECH Campaign type

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 StatusChanged 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 ItemLinks 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
OVK Billing Category

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 AppendixSet 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 OrderSet 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