7.5.5.3 Fields used in Columns and Rows in PDF table

Owned by Former user (Deleted)
Last updated: 2020-04-22 by Nicole Jünger

Table Columns

The table can show up to 23 columns.

  1. Notice that static columns will always be shown. 
  2. Additional columns will only appear on the document if you have a value other than ZERO in your records. 
  3. Also if AC is false for all Campaign Items, we don't display the AC and Agency Net columns.
Column NoValueCommentType
1

PositionNumber__c + PositionNumberAppendix__c
OR
counted from 1 upwards


static
2

Site__r.External_Name__c
OR
Site__r.Name

Alternatively the

OR

  • Ad_Spec__r.Name

OR 

can be used. 

static
3Placement__r.External_Name__c
OR
Placement__r.Name		static
4Ad_Type__r.External_Name__c
OR
Ad_Type__r.Name		static
4.1Ad_Price__r.RateCriterion__c
additional
5from_Date__c
static
6until_Date__c
static
7Sales_Price__c
static
7.1SurchargeSalesPrice__c
additional
8Billing_category__c
static
9

Amount__c - Amount_B3__c
OR
(Amount__c - Amount_B3__c) / Quantity__c * 1000 (CPM)


additional
10Quantity__c
static
10.1Guaranteed_AI__c
additional
11Amount__c
static
12*Rate_Discount_1__c
additional
13*Rate_Discount_2__c
additional
14*Rate_Discount_3__c
additional
15*Rate_Discount_4__c
additional
12 + 13 + 14 + 15

TotalDiscountAbs__c


additional instead of line 13, 14 ,15, 16
16Amount_net__cN1static
17Agency_Commission__c
additional
18Amount_net_net__cN2additional
19eCPM__c

This column will only show where sales price per item ≠ CPM

CPM (N2) You can change the label if needed.

additional
-eCPC__c

This column will only show where sales price per item ≠ CPC

CPC (N2) You can change the label if needed.


20Third_party_commission__cTPCadditional
21Amount_net3__cN3additional

* can be overwritten using custom labels and a definition in you quote or invoice preferences.


Item Table Rows

The rows will list a maximum of 10 if all of the following data is filled:

Row

Field

Value

#1ValuesItem Table Columns (see above)
#2Standard description from AdSpecAd_Price__r.Ad_Spec__r.DescriptionOnPDF__c
#3Line Item descriptionLine_Description__c / LineDescription__c
#4Frequency CappingLabel.FC + ":" + FC_Quantity__c + "/" + FC_Ad_served_every__c + " " + FC_Period__c
#5Operating System TargetingLabel.AdOperatingSystems + ": " + AdOperatingSystems__c + "; " + Label.AdWebBrowsers + ": " + AdWebBrowsers__c
#6Time TargetingLabel.AdDayOfWeek + ": " + AdDayOfWeek__c + "; " + Label.AdHourOfDay + ": " + AdHourOfDay__c
#7Geo Targeting

Label.Countries + ": " + SelectedCountryInformation__c + "; " + Label.Regions + ": " + SelectedRegionInformation__c + "; " + Label.Cities + ": " + SelectedCityInformation__c

#8Key Value TargetingLabel.KeyValueTargeting + ": " + AdKeyValues__c
#9ContentLabel.Content + ": " + SelectedContentInformation__c
#10Publication DatesLabel.PublicationDates + ": " + SelectedPublicationDateInformation__c



Summary Row

The last row underneath all of your other items is a summary row which will show the total of all rows for each column.

* Only CPM relevant values included means: That the Total for the Booked Quantity is displaying the sum of all CPM items.

The Total of the eCPM / CPM (N2) is calculated like this:

  • if there are only CPM items the values from the column are summed up
  • if there are CPM items mixed with other Billing Categories that have Guaranteed AIs the calculation will be:
    (N2 amounts of the CPM + N2 amounts of the Guaranteed AI items) / (quantity of CPM items + Guaranteed AIs of other items)