Activity Column Codes Explained

Code

Prints As on Report

Explanation

1BL10

Blank column, 10 spaces wide

1BL15

Blank column, 15 spaces wide

2BL10

Blank column, 10 spaces wide

2BL15

Blank column, 15 spaces wide

3BL10

Blank column, 10 spaces wide

3BL15

Blank column, 15 spaces wide

ABBL

Asgn Billable

Assigned Billable Charges. Sums the values in the Assigned Cost and Integration columns that are billable charges for the unit.

ADS

Actual Data Stream

Displays a code for the Act Dta Strm used for posting.

APM

Post By

Shows the method used for Posting

ASGN

Assigned

Assigned Cost

BB

BB

Billboard. If a unit has a billboard, the letters BB appear in this column.

BBL

Billable

Billable Charges. Sums the values in the Actual Cost and Integration columns that are billable charges for the unit. (Ordered - Billed = Billable) Reference: Units Available for Billing.

BLD

Billed

Billed Charges. Sums the values in the Actual Cost or Assigned Cost column and the Integration columns which are charges billed to the client

C

Cost

Actual Cost

CDT

Cm Date

Commercial Date

CL

Cl

Client Code

CLEAR

Cleared

Cleared Charges. Sums the values in the Actual Cost and Integration columns that are cleared charges.

CLNTN

Client Name

Client Name

CMPY

Company Name

Company Name

CP

CP

Commercial Position: may be added in Buy Module or specified in Schedule ISCIs traffic option.

CT

Cm Time

Commercial Time: Unit may be updated from Matching option if Matching Profile indicates to update.

DAY

Day

Unit Day

DC

Dp

Daypart Code

DP

Daypart Descrip

Daypart Description

DT

Date

Unit Date

E

Est

Estimate Code

EDS

Estimated Data Stream

Displays a code for the estimated data stream used in posting.

ESTN

Estimate Code

Estimate Name

FEED

Feed %

Feed Percent. If a unit has a feed % of 100%, no value appears in this column

IC

ISCI

ISCI code assigned to the first product allocated to a unit, 12 character field.

IC2

ISCI

ISCI codes assigned for up to two products allocated to a unit, 25-character field.

IC3

ISCI

ISCI codes for up to three products allocated to a unit, 38-character field.

IC4

ISCI

ISCI codes for up to four products allocated to a unit, 51-character field.

IC9

ISCI Codes

ISCI code for the first product allocated to a unit, uses a 9-character field. If a 12 character ISCI is used, truncates the code after 9 characters.

IC9B

ISCI Codes

ISCI codes for up to two products allocated to a unit, uses  9-characters for the ISCI. If one or more 12 character ISCIs are used, truncates the codes after 18 characters, 9 per code.

IC9C

ISCI Codes

ISCI codes for up to three products allocated to a unit, uses a 29-character field. If one or more 12 character ISCIs are used, truncates each code after 9 characters.

IC9D

ISCI Codes

ISCI codes for up to four products allocated to a unit, uses a 39-character field.  If one or more 12 character ISCIs are used, truncates each code after 9 characters.

ID

ISCI Description

ISCI description for the first product allocated to a unit.

ID2

ISCI Descriptions

ISCI descriptions for up to two products allocated to a unit.

ID3

ISCI Descriptions

ISCI descriptions for up to three products allocated to a unit

ID4

ISCI Descriptions

ISCI descriptions for up to four products allocated to a unit.

INT

Integration

Integration Cost

L

Len

Unit Length

M

M

Media Code

MATCH

Matched

Matched Charges. Sums the values in the Actual Cost and Integration columns that are matched charges.

MO

Month

Month, based upon your calendar selection on the Unit Detail Screen.

N

N/Syn

Network/Syndicator Code

NETN

Network Name

Network Name

NTIC

NTI Code

NTI Code

OFFC

Office

Office

P

P

Posting Indicator. When the setting for the Schedule field on the Unit Detail Screen is A or P and the Actuals=Estimates? setting is Y in the Client Buying Profile, indicates if the audience figures are posted actuals. Valid codes for this column are Y, N, or *.

Y = Unit has actuals from tapes.

N = Unit does not have actuals loaded from the tapes.

* = Unit has mixed data (estimates and actuals) due to user overrides.

When the setting for Schedule is E, no codes display in this column.

PAID

Paid

Paid charges. Sums the values in the Actual Cost and Integration columns that are paid charges.

PAY

Payable

Payable charges. Sums the values in the Actual Cost and Integration columns that are unit charges that have not been paid.

(Billed - Cleared = Payable) charges. Sums the values in the Actual Cost and Integration columns that are unit charges that have not been paid.

(Billed - Cleared = Payable)

PC

Prog

Program Code 10 characters in length

PC6

Prog

Program Code six characters in length

PKG

Pkg

Package Number six digits, leading zeroes

PKG3

Pkg

Package Number only three digits, leading zeroes

PKGN

Package Name

Package Name

APM

Post By

Shows the method used for posting

PN

Program Name

Program Name

PN25

Program Name (25)

Program Name up to 25 characters

PROD

Product Code

Product code for the first product allocated to a unit.

PROD2

Prod

Product codes for up to two products allocated to a unit

PROD3

Prod

Product codes for up to three products allocated to a unit.

PROD4

Prod

Product codes for up to four products allocated to a unit.

PRODN

Product Name

Product Name. If a unit has more than one product allocated, the name of the first allocated product appears in this column.

PROT

Pgm Rot

Rotation days for program

PT

Time

Program Time. The assigned program start/end times in the Buy Module.

QTR

Qtr

Indicates the quarter    as 1Q, 2Q, etc.

SP

Split %

Split Percent. Percentage of impressions allocated to the first product in a split.

ST

ST

Split Type

TASGN

Total Assgnd

Total Assigned Cost. Sums the values in the Assigned Cost and Integration columns.

TC

Total Cost

Total Cost. Sums the values in the Actual Cost and Integration columns.

U

Units

Unit Count. Number of units reported for a line item. This value is always 1 if the setting for the Combine Units? field is N.

UID

ID

Unit ID Number

UN

Uncleared

Uncleared Charges. Sums the values in the Actual Cost and Integration columns that are uncleared charges. Uncleared charges are calculated by adding the actual cost and integration cost and then subtracting the cleared charges.

UST

Sts

Unit Status

WK

Week of

Week of