From the Contract Insertion Orders tab on the Advertising Contracts screen, you can view all insertion orders associated with a specific contract. Double-click any record on this screen to open the Insertion Orders screen. Additionally, from this screen, click View Contract Pricing Summary to open the Order Pricing Summary screen. For more information, please see Viewing Contract Pricing Summary.
The first grid (highlighted below) displays records from Order_Master where Order_Master.ADV_CONTRACT_ID = CONTRACT_ID of the contract open in the Advertising Contracts screen.
The second grid (highlighted below) is for the Order_Master record selected in the first grid (discussed above). This grid displays records from Order_Detail where Order_Detail.ORDER_NO = selected Order_Master.ORDER_NO and Order_Detail.PRODUCT_ID = Product.PRODUCT_ID and Product. MASTER_PRODUCT_FLAG = Y.
The third grid (highlighted) below is for the Order_Detail record selected in the second grid (discussed above). This grid displays records from Order_Detaill where Order_Detail.ORDER_NO = selected Order_Detail.ORDER_NO and Order_Detail.ORDER_LINE_NO = selected Order_Detail.ORDER_LINE_NO and Order_Detail.PRODUCT_ID = Product.PRODUCT_ID and Product. MASTER_PRODUCT_FLAG = N.
See Also:
· Overview: Advertising Contracts
· Accessing Advertising Contract Maintenance
· Creating a New Advertising Contract
· Maintaining Frequency Information
· Adding Sales Representatives
· Adding a Primary Contract to a Group
· Viewing Contract Pricing Summary
· Copying an Advertising Contract