/
7.5.5.3 Fields used in Columns and Rows in PDF table

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
3 min read

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 No

Value

Comment

Type

Column No

Value

Comment

Type

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

3

Placement__r.External_Name__c
OR
Placement__r.Name

static

4

Ad_Type__r.External_Name__c
OR
Ad_Type__r.Name

static

4.1

Ad_Price__r.RateCriterion__c



additional

5

from_Date__c



static

6

until_Date__c



static

7

Sales_Price__c



static

7.1

SurchargeSalesPrice__c



additional

8

Billing_category__c



static

9

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



additional

10

Quantity__c



static

10.1

Guaranteed_AI__c



additional

11

Amount__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

16

Amount_net__c

N1

static

17

Agency_Commission__c



additional

18

Amount_net_net__c

N2

additional

19

eCPM__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.



20

Third_party_commission__c

TPC

additional

21

Amount_net3__c

N3

additional



* 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

Row

Field

Value

#1

Values

Item Table Columns (see above)

#2

Standard description from AdSpec

Ad_Price__r.Ad_Spec__r.DescriptionOnPDF__c

#3

Line Item description

Line_Description__c / LineDescription__c

#4

Frequency Capping

Label.FC + ":" + FC_Quantity__c + "/" + FC_Ad_served_every__c + " " + FC_Period__c

#5

Operating System Targeting

Label.AdOperatingSystems + ": " + AdOperatingSystems__c + "; " + Label.AdWebBrowsers + ": " + AdWebBrowsers__c

#6

Time Targeting

Label.AdDayOfWeek + ": " + AdDayOfWeek__c + "; " + Label.AdHourOfDay + ": " + AdHourOfDay__c

#7

Geo Targeting

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

#8

Key Value Targeting

Label.KeyValueTargeting + ": " + AdKeyValues__c

#9

Content

Label.Content + ": " + SelectedContentInformation__c

#10

Publication Dates

Label.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)





Related content