Ad Hoc Open Orders Template

This report is focused on Direct Customer Info.  Ingram Wholesale Customer information will be rolled up to Ingram Wholesale.

Fixed Filters

• Order Date Range
• Direct Fulfillment
• DC
• EAN
• Title
• Imprint
• Pub Date Range
• Publisher Status
• Release Date Range
• Headquarter
• Shipping Location
• Customer PO
• Territory
• Market Segment

Dynamic Filters

The Dynamic Filters must be part of the Report in order to appear as a filter

• IPS Sale
• Brand Category
• Author
• BISAC Category
• Format
• Ship To
• SL State
• Promo Code
• Publisher

Customer

• Bill To:  Bill To Number within a Headquarter
• HQ Account Number: Headquarter Account Number.
• Headquarter: The customer's headquarter name.
• Market Segment: Customer Grouping at the Market level
• Market Segment Types (Not all Market Segments are listed)
  • • Retail
    • Library International Wholesaler
    • Gift Retailer
    • Book Club
    • Catalog and Direct Response
    • Canadian Merchandising Wholesaler
    • Corporate Account, Retail Internet
    • Specialty Distribution Center
    • Wholesaler
• SL Account Number: An Ingram account number assigned to a customer’s shipping address, (Shipping Location).
• SL City: Shipping Location city.
• SL ST:  Shipping Location state.
• Shipping Location:  Where product is shipped.
• Territory 
• Territory Types:
  • National
  • Publisher Account
  • Field Sales
  • Gift
  • Canada
  • Retailer
  • Wholesale
  • Trade
  • Library
  • International
  • Special
  • Wholesale Exports
  • Ext Digital
  • Mass Merch
  • Home
  • Global Export
  • Europe Export
  • Consignment Agent

DC - Distribution Centers

• DC
• DC Warehouses
  • BB - Allentown
  • CB - IPS UK
  • CG - GBS UK
  • CI - Chambersburg
  • CN - New South-Australia
  • CP - PGC-Canada
  • DD - FT Wayne
  • EE - Roseburg
  • FF - Fairfield
  • HH - Jackson
  • JJ - Fresno
  • LL - Chambersburg Returns
  • NV - Nashville
• In Process: Units that are currently In Process
• Units on Hand: Units on Hand at all domestic  Ingram Warehouses not just the DC listed

Direct Fulfillment

• Direct Fulfillment:  Direct Fulfillment or Not Direct Fulfillment.

IPS Sale

• IPS Sale:  Values Y=Yes (Direct Sale) and N=No (Ingram Wholesale)

Item

• Author: Author
• BISAC Category: Book Industry Standards and Communications. These are industry approved subject descriptors.
• Brand Category:  Publisher defined category set up through the client manager and maintained in CoreSource.
• Canadian Price: The price the book is sold in Canada.
• Client Cost: The cost assigned to the book in the title management system.
• EAN: 13-digit code used to identify the product (ISBN).
• Format
• Format Types (Not all Formats are listed)
  • • Paperback / Softback
    • Hardback
    • Multiple Copy Pack
    • Spiral Bound
    • CD-Audio
    • Digital (Delivered Electronically)
    • Mobipocket
    • Digital Download
    • Epub
    • Ebook
    • PDF
• Front List: Front list are titles with a pub date in the last six months from the day the report is pulled.
• IBC Status:  The status of product at Ingram Book Company.
• IBC Status Types (Not all IBC Status Types are listed)
  • • Available
    • Out of Stock
    • Out of Stock Indefinitely
    • Out of Print
    • Not Available
    • Cancelled
    • Not Yet Received – Past Pub Date
    • Not Yet Received – Future Pub Date
• Imprint: Imprint
• Last Receipt Date: Date book was last received into an Ingram warehouse.
• List Amount: The current list price of the title in USD.
• Print to Order: Identifies if an item is available from Lightening Source on a print-to-order basis. Values are Y=Yes or N=No.
• Product Type: Print, Audio, Other, etc.
• Pub Date: Publisher defined expected date for product to be available.
• Publisher Status: Publisher status of titles at Ingram, pulled in from CoreSource.
• Publisher Status Types (Not all Publisher Status Types are listed)
  • Active
  • Forthcoming
  • Postponed Indefinitely
  • Cancelled
  • No longer our product
  • Out of stock indefinitely
  • Out of print
  • Inactive
  • Unknown
  • Remaindered
  • Withdrawn from sale
  • Recalled
  • Active, but not sold separately
  • Recalled
  • Temporarily withdrawn from sale
  • Permanently withdrawn from sale
• Release Date: The date initial new title backorders are released to the warehouse for fulfillment.
• Series: Series
• Title: Title
• Total On Hand Units: This is the TOTAL On Hand not dependent of the DC.  

Open Retailer PO

• Bindery Shipment: Y=Yes and N=No
• Cancel Date: The date an order will be cancelled.
• Customer Discount: The discount percentage the customer receives for an item.
• Customer PO: The purchase order number created by the customer when placing an order to Ingram.
• Order Date: The date the order was placed by the customer.
• Order Type Code
• Order Type Code (Not all Order Types Codes are listed)
  • EO Electronic Combining
  • CO Consolidated Orders
  • DB IPS Bindery Orders
  • DH Direct to Home Dropship
  • DS Dropship Orders
  • EF Future Ship
  • EH Electronic Order Combine Shipment / Separate Invoice
  • TH Trade Holding
  • TN Trade Normal
  • XX Publisher Returns Overstock
  • XY Publisher Returns Damaged
• Promo Code: Promotion Code at Ingram.

Publisher

• Partner Publisher: Specific to IPS Jackson.  Values are: Two Rivers, Consortium, PGW and Ingram Academic.
• Publisher:  Publisher name.

Publisher Sales Rep

• Sales Rep: Sales Rep at the Publisher.

Open Retailer PO Measures

• Backorder Expected Invoice Amount: The expected invoice amount when an Open Backorder ships.
• Committed Backorder Expected Invoice Amount: The expected invoice amount when a Committed Backorder ships.
• Committed Backorder Units: Inventory has been allocated to the order and will ship when the order is released.
• Open Backorders: Open backorders where no inventory is available at this time and the order will ship when inventory is allocated.
• Total Backorder Expected Invoice Amount: The expected invoice amount when Open Backorders and Committed Backorders ship.
• Total Backorder Units: The total units of Open Backorders and Committed Backorders.