Viewing Advertising Product Order Details from Order Entry

Most organizations will use the Insertion Orders screen to enter advertising orders into the system. Advertising orders are very complex particularly in relation to a typical inventoried product or meeting. At the same time, the Order Entry screen may be used to view all orders including advertising related orders.

It is recommended that you only create simple advertising orders using Order Entry. For complex orders, please use the Insertion Orders screen.

From the Order Entry screen, if you right-click an advertising product order line, you have the option to Open in ADV Insertion Order Screen. This option will open the current order in the Insertion Orders screen.

To view advertising product order details from Order Entry:

1. From the Order Entry screen, right-click an advertising product order line and select Show Advertising Line Details.
The Advertising Product Order Details screen displays, as shown below.

2. The following information displays on this screen:

Screen Element	Description
Insertion Details
Contract	Read-only. Order_Master.ADV_CONTRACT_ID For more information, please see Advertising Contracts.
Media	Read-only. Order_Detail.PARENT_PRODUCT For more information, please see Advertising Media.
Issue	Link. Order_Adv_Detail.ISSUE_DATE
Product Code	Read-only. Order_ Detail.PRODUCT_CODE For more information, please see Defining General Advertising Product Information.
Rate Structure	Drop-down. Order_ Detail.RATE_STRUCTURE
Rate Code	Drop-down. Order_Detail.RATE_CODE
Rate Card Yr	Drop-down. Order_Adv_Detail.RATE_CARD_YEAR_CODE If Order_Master.ADV_CONTRACT_ID is not null, this is set to Adv_Contract. RATE_CARD_YEAR_CODE where Order_Master.ADV_CONTRACT_ID = Adv_Contract.CONTRACT_ID.
Ad Type	Read-only. Order_Adv_Detail. AD_TYPE_CODE This is set to Adv_Product.AD_TYPE_CODE where Order_Detail.PRODUCT_ID = Adv_Product.PRODUCT_ID.
Ad Size	Read-only. Order_Adv_Detail. AD_SIZE_CODE This is set to Adv_Product.AD_SIZE_CODE where Order_Detail.PRODUCT_ID = Adv_Product.PRODUCT_ID. When this is set, EARNED_PAGE_PCT is set to Adv_Ad_Size. AD_SIZE_PCT if FULFILLS_FREQUENCY_FLAG = Y.
Color/Webmedia	Read-only. Order_Adv_Detail. AD_COLOR_WEBMEDIA_CODE This is set to Adv_Product. AD_COLOR_WEBMEDIA_CODE where Order_Detail.PRODUCT_ID = Adv_Product.PRODUCT_ID.
Prem. Position	Read-only. Order_Adv_Detail. AD_PREMIUM_POSITION_CODE This is set to Adv_Product. AD_ PREMIUM_POSITION CODE where Order_Detail.PRODUCT_ID = Adv_Product.PRODUCT_ID.
Earned Page	Read-only. Order_Adv_Detail. EARNED_PAGE_PCT Set to Adv_Ad_Size. AD_SIZE_PCT where Adv_Ad_Size.AD_SIZE_CODE = AD_SIZE_CODE if FULFILLS_FREQUENCY_FLAG = Y.
Invoice Number	Read-only. Order_ Detail.INVOICE_NO
Invoice Date	Read-only. Order_ Detail.INVOICE_DATE
Insertion No	Read-only. Order_Adv_Detail. INSERTION_ORDER_NO This number is a combination of order_no + order_line_no of the primary advertising order line.
Line Status	Drop-down. Order_Detail.LINE_STATUS_CODE
Fulfill Status	Drop-down. Order_Detail.FULFILL_STATUS_CODE
Line Status Change Reason	Drop-down. Order_Detail.LINE_STATUS_REASON_CODE
Order Quantity	Text box. Order_Detail.ORDER_QTY
Web Date Range
Begin Date (not labeled)	Drop-down. Order_Detail.CYCLE_BEGIN_DATE The web date range fields are only enabled when Order_Detail.SUBSYSTEM = ‘ADV’ and Order_Detail.PRODUCT_TYPE_CODE = ‘WEB_DISPLAY’.
End Date (not labeled)	Drop-down. Order_Detail.CYCLE_END_DATE The web date range fields are only enabled when Order_Detail.SUBSYSTEM = ‘ADV’ and Order_Detail.PRODUCT_TYPE_CODE = ‘WEB_DISPLAY’.
Ad Detail
Section	Drop-down. Order_Adv_Detail. SECTION_CODE
Ad ID	Link. Order_Adv_Detail.ADVERTISEMENT_ID
Description	Read-only. Adv_Advertisement.DESCR where Order_Adv_Detail.ADVERTISEMENT_ID = Adv_Advertisement.ADVERTISEMENT_ID
Reader Service No	Text box. Order_Adv_Detail. READER_SERVICE_CARD_NO
House	Checkbox. Order_Adv_Detail.HOUSE_AD_FLAG If Order_Adv_Detail.ADVERTISEMENT_ID is not null, set to Adv_Advertisement. HOUSE_AD_FLAG where ADVERTISEMENT_ID = Adv_Advertisement. ADVERTISEMENT_ID.
PSA	Checkbox. Order_Adv_Detail.PSA_AD_FLAG If Order_Adv_Detail.ADVERTISEMENT_ID is not null, set to Adv_Advertisement. PSA_AD_FLAG where ADVERTISEMENT_ID = Adv_Advertisement. ADVERTISEMENT_ID.
Exhibition Code	Link. Order_Adv_Detail.EXHIBITION_CODE
Booth Number	Text box. Order_Adv_Detail.BOOTH_NO
Bleed Instructions	Text box. Order_Adv_Detail.BLEED_INSTRUCTIONS If Order_Adv_Detail.ADVERTISEMENT_ID is not null, set to Adv_Advertisement. BLEED_INSTRUCTIONS where ADVERTISEMENT_ID = Adv_Advertisement. ADVERTISEMENT_ID.
Position Requested	Text box. Order_Adv_Detail.POSITION_REQUEST
Special Instructions	Text box. Order_Adv_Detail.SPECIAL_INSTRUCTIONS
Linked Product	Order_Adv_Detail. LINKED_PRODUCT_ID
Ad Date	Date drop-down. Order_Adv_Detail.AD_DATE Identifies the ad date of the ad; this is set by the system based on the type of ad. If Adv_Media.MEDIA_TYPE_CODE = ‘ISSUE_BASED’, this set to Order_Adv_Detail. ISSUE_DATE ‘EXHIBITION_BASED’, Xbt_Product.START_DATE of exhibition product linked to media ‘MEETING_BASED’, Mtg_Product.START_DATE of meeting product linked to media ‘PRODUCT_BASED’ then Product.AVAILABLE_DATE of product linked to media ‘STANDALONE_ADV’ then Adv_Media. AVAILABLE_TO_INVOICE_DATE
Page Information
Page Range	Text box. Order_Adv_Detail.START_PAGE Order_Adv_Detail.END_PAGE
Page Position	Drop-down. Order_Adv_Detail. PAGE_POSITION_CODE
Orientation	Drop-down. Order_Adv_Detail. PAGE_ORIENTATION_CODE
Fulfills Frequency	Checkbox. Order_Adv_Detail. CREDITS_FULFILL_FREQ_FLAG
Classified Text	Text box. Order_Adv_Detail. ADVERTISEMENT_TEXT Displayed and enabled for editing when Order_Detail.SUBSYSTEM = ‘ADV’ and Order_Detail.PRODUCT_TYPE_CODE = ‘CLASSIFIED’.
Word Count	Text box. Order_Adv_Detail. WORD_COUNT Displayed and enabled for editing when Order_Detail.SUBSYSTEM = ‘ADV’ and Order_Detail.PRODUCT_TYPE_CODE = ‘CLASSIFIED’.