1. Home
  2. /
  3. V7.9 Documentation
  4. /
  5. IP1 Product Documentation
  6. /
  7. User Guides
  8. /
  9. Database Title
  10. /
  11. About Database Title

About Database Title

The Title masterfile  covers the following.

  • Entry of Title details including ISBN, Title, classification, discount, and unit cost.
  • Definition of a Title’s pricing details, with the facility to store multiple prices and currencies per Title, plus variable and flexible discounts.
  • Title substitution and stock can be based on the company to which the customer belongs
  • Nominating a title’s Link Title and Previous Title.
  • Facility to sell Titles to specific customers with or without management approval. Titles can be excluded from being purchased by selected customers, based on the user defined customer hierarchy.
  • Multiple user defined Title classifications, summarising products into specific categories.
  • Optional Automatic Barcode generation controlled via TMSDS/IM-IBCD.
  • Individual Titles can be grouped together and sold as a single product. The components together with the number of units required are recorded. The price is calculated by the addition of all individual component prices.
  • Extra Processing facilities are available, designed to automatically update certain programs. When additions are made to the Title Masterfile, certain programs can be automatically updated, validations can take place, or reports can be generated, that specifically relate to this Title. This is an optional facility controlled by a Y/N flag on TMSDS/IM-XTRP. If it is to be used, program modifications are required. External programs are only called if the Classification type and code are a match or blank.
  • Buying Price definitions by supplier, shipping method and buying method.
  • Minimum profit margins.
  • Title applicability by Region or Country.
  • New Title/Price approval and subsequent transfer to masterfile.
  • Functionality to nominate a title’s substitute and stock status, based on the customer’s company code. This provides your company with the facility to nominate different substitute ISBNs and stock status codes, dependant on the company to which the customer belongs. This facility determined in the following control files.
    • TMSDS/ICG IFCC Customer Group – Item Fields default CC type
    • TMSDS/ICG-IFLD Customer Group – Item Fields
    • TMSDS/ICG-SICC Customer Group – Item Substitution default CC type
    • TMSDS/ICG-SUBI Customer Group – Item Substitution.
  • There is a facility to generate notes on fields that have been changed on the Title Masterfile and Price File. These notes display on the Title Text Inquiry (DSI540) and show the date the change was made, the user who made the change as well as the old and new value of the field. TMSDS/IM-NTYP has the Title Masterfile field names and descriptions as well as a flag that determines whether or not the system is to automatically generate notes on field changes to the Title Text Inquiry.
  • For efficient sales order entry a Title Mask Character can be nominated in TMSDS/IM-MASK. This Mask character becomes the last character of a non-stocked Item Number where the leading characters are the common characters in the range of Titles. During order entry, the nonstocked Mask Title is entered on the first line with no quantity. The other Titles are then added to the order by entering only the last part of the ISBN that differs. Once the lines are confirmed the system retrieves the prefix of each Title.
  • Users can be setup to have limited access to the Title Masterfile. TMSDS/LA-IMMU determines by User ID which of the Front Screen Options the user can access. Those options for which access is denied do not display on the screen when that user accesses the Title Masterfile.
  • Another limited access facility is the use of Templates. Users listed in TMSDS/LA-IMMUT must enter a Type or template number when adding new Titles to the Title Masterfile. If the user is not listed then Type is optional.
  • Customers can be setup as eligible for Bonus Titles. Bonus Titles are listed by Customer Hierarchy, along with the corresponding Bonus Quantity. The Type of Sale is an optional parameter when defining whether a customer can have bonus Titles. A time limit can be placed on the availability of Bonus Titles by using Effective and Expiry Dates. Sequence for Bonus Item is defined in Bonus Item Definition Header database.
  • After a Bonus Item has been setup and customers have been setup to purchase the selected items, orders for the selected items are entered through the Order Processing Module. When entering the original item in the detail screen and the minimum quantity, you will see the next line item display the Bonus Item and the quantity that is to be given away with the purchase of the previous line item.
  • A Control File determines whether to generate the Bonus Item with the original item ordered even though there is no stock of the original item or to only supply a Bonus Item where there is sufficient stock of the original Item. The original item can be flagged as a firm sale, therefore the Bonus Item and the original item cannot be returned. This is defined in control file TMSDS/OE-BI.
  • The Title/Catalogue Maintenance option has the facility to call new catalogue program (DSM570) as well as old (DSW130). The program called is determined by a switch in TMSDS/IM/CTLOG.
  • Contacts in IP1 system can be linked to a title as contributors such as authors, illustrators, editors etc. When titles are purged with the use of DSO905 and DSP020 programs, the relevant contributor links are removed.

Special Price File

TMSDS/PR-AUTH can register authorized users for price maintenance. If this control file does not exist or there is no entry, then the program will work as per existing logic – all users are allowed price maintenance. If there are entries in the control file, but the user is not registered in it, then all prices will be locked except expiry date in the last entry is allowed to be changed. But the user can still create a new price. If the user is registered in the control file, then a new toggle function key ‘F8=Lock Price’ & ‘F8=Unlock Price’ is displayed to allow lock/unlock the prices for maintenance.

Sales rep can be added to the special price file. This will override a sales rep on the order if a specific sales rep is defined for special price that is retrieved for the order.

Bins/Packs/Systems/Assortments/Mixtures/Varieties

Bin/Pack/System component pricing works as follows.

  • If a record is not found nor has an expired date less than today’s date then a new record is created. If the expired date is equal to today’s date and the price is different then the price is updated. If the expired date is greater than today’s date and the price is different:
  • If the Effective date is less than today’s date then change the expired date to today’s date1 day can create a new record.
  • If the Effective date is equal to today’s date then change the price.
  • TMSDS/IM-PACK contains system defined pack identifier codes.
  • Pack = an Item that is brought into stock as individual pieces, physically bound together and becomes another Item that is then sold.
  • System = an Item that is brought into stock in component form and stored as such, but is sold as one whole unit. Each code has a flag which determines whether mass component maintenance is allowed.
  • Allow maintenance of comp = Indicate by Pack Type if maintenance of components is allowed bearing in mind that components of packs, systems and bins cannot be maintained once stock is available.
  • %Breakdown = Indicate by Pack Type whether a percentage breakdown is applicable.

Promotional Discounts

Promotional discounts in IP1 are handled through promotional packages and discount definitions.

Promotional Packages are created to encourage customers to buy titles which are part of a promotional deal. This is often used to create a sizeable initial order as well as a continuity purchase over a period of time. This Promotion Package maintenance program is used to maintain Promotion Package header and title information as well as budget information. Promotional packages can be linked to sales orders through Order Entry. 

Discount definitions determine what price and discount the customers receive when purchasing a Title. For Example a debtor class could receive a specified discount on items belonging to a specified item level. Discount definitions are created by setting up rules combining multiple customer and item attributes. It is also possible to include Promotion IDs of existing promotion packages, in a discount definition rule.

Print Friendly, PDF & Email