Ad List column definitions

This table includes all the possible columns your system administrator may choose to include in each of the Ad List dialog box panels.

A=Adlist H=Hold List S=Standby List F=Fillers List

	Description	A	H	S	F
Ad ID	See the row “ID” below.
Ad Sub Type	Ad Sub Type in Plan is the “ID” of the Ad Type from Naviga Ad
Agency	If the ad is being billed to an agency, this will be the agency name. If it is billed direct to the advertiser, this will be blank.
Agency ID	ID from the Agency Name record. Will be blank if no agency was billed on the campaign.
Billing	The alternate contact name (not used in Naviga Ad Implementations).
Bleed	Ad Material in Naviga Ad is flagged as Bleed
Brand Name	Advertiser Brand Name (only used in Naviga Ad implementations)
Campaign	Campaign ID (only used in Naviga Ad implementations)
Campaign Description	Campaign Description field from the Campaign Header in Naviga Ad
Campaign Entered By (ID)	User's ID who entered the Campaign in Naviga Ad
Campaign Entered By (Name)	User's Name who entered the Campaign in Naviga Ad
Clash	The clash code will display if there is a conflict between advertisers. In Naviga Ad the Position Code can be set up with Conflicting positions. For example, you might not allow advertisers in the same industry code to be in positions near each other. If they are booked as such, the industry code (ID) will be displayed in this field.
Class Code	The classification code assigned to the ad.
Client	The client assigned to the ad (if an agency/client booked the ad). (Not used in Naviga Ad Implementations…use Customer instead with Naviga Ad)
Color	The colors assigned to the ad.
Cols	See the row “Columns” below.
Columns	The ad’s column width (the number of columns).
Copyline	The copy line of the ad. For Naviga Ad users, this will be called the Ad Headline in Naviga Ad.
Customer	The name of the customer.
Customer Reference	Customer Reference ID from the Campaign Header in Naviga Ad
Depth	The depth of the ad.
Double Truck	Flag to indicate Double Truck Ad
Edition (Zone)	The ID of the Edition in Naviga Ad
External ID	This is the External ID from the Material Record in Naviga Ad.
Hold	The reason the ad is on hold. (Not supported in Naviga Ad Implementations)
ID	The ID of the ad. May be used for troubleshooting with Naviga Support but will not be overly useful to most end users.
MaterialID	Naviga Ad Material ID
Material Description	Material Description field from the Material record in Naviga Ad
Material Notes	Note from the Material line on the order in Naviga Ad. It is this note here:
Material Status	The ID of the Material Status. (Numeric ID in Naviga Ad, so the more useful option here would be for the Material Status Description)
Material Status Description	Material Status from the order line in Naviga Ad.
Merged	Product Code where the order was booked. (Only populated if you use merge products feature in Naviga Plan)
Name	The classification and name of the ad. In Naviga Ad implementation it will be the “OrderID.Issue Number” For example 1234.1, meaning the first insertion of order id 1234.
New	Displays a check mark if the ad has been booked since the plan was last refreshed. As soon as the ad is placed, the check mark is removed.
Notes	Displays both the placement and the production notes for the ad (it concatenates them into a single field.
Order ID	This is the internal order id in the Plan database. May be used for troubleshooting with Naviga Support but won’t be overly useful to most end users.
Order Name	Name of the Ad. In Naviga Ad implementation it will be the “OrderID.Issue Number” For example 1234.1, meaning the first insertion of order id 1234.
Page	The page in the plan on which the ad is placed.
Placed	Displays a check mark if the ad has been placed on the plan.
Placement Notes	The placement notes. In Naviga Ad, this is the “Internal Comment” field from the “Other options” tab in order entry.
Plan	Displays a check mark if the ad can be automatically planned. If you remove an ad from the page, in the Ad List menu you can choose the option Set Planable > Disable, which unchecks this box. You can recheck the box by choosing the option Set Planable > Enable or by dragging the ad back onto the plan.
Preferred	Displays info on the preferred position of the ad. This is a code that is set based on the position settings of the ad. Here is the code meanings:
Preflight Status Code	Status Code from Preflight on the material
Preflight Status Description	Status Description from Preflight on the material
Production Notes	The text from the Production Notes. In Naviga Ad there can be multiple production notes on an order (it comes from the “Production Notes” tab). The Production notes will all be concatenated together in this field.
Required	Displays whether the standby ad must be placed. (Not currently supported in Naviga Ad Implementations)
Sales Rep	The Name and ID of the sales rep assigned to the ad.
Size Description	Size Description from the Campaign
Sort	The sort information for the ad from the Sort text field.
Split	This box is checked if the ad is a split‐run ad. (Not currently supported in Naviga Ad Implementations)
Standby Type	The standby type code from the booking file. (Not currently supported in Naviga Ad Implementations)
Start Date	The first date on which the standby ad can be inserted. (Not currently supported in Naviga Ad Implementations)
Status	The status of the ad. (displays as a colored flag using the color codes set up in Naviga Plan Setup
Stop Date	The last date on which the standby ad can be inserted. (Not currently supported in Naviga Ad Implementations)
Type	Not functional in this version.
Usage	The number of insertions to date and the number of insertions originally ordered. For example, 6/10. (Not currently supported in Naviga Ad Implementations)
User‐defined fields (4)	Your system administrator can design these fields to display data from the database tables.
Width	Physical width of filler.