ABLETM

 

Advanced Bindery Library Exchange

 

 

 

 

 

 

 

Reference Guide

 

 

 

 

 

Volume 6

 

Reports

 

 

 

 

 

 

 

 

 

 

Version 6.6.1

June 9, 2003

     

 

 

 

 

ABLEä Ventures, LLC

     

 

 

 


Copyright by ABLEä Ventures, LLC

 

This reference guide is copyrighted and all rights are reserved.  This document may not, in whole or in part, be copied, photocopied, reproduced translated, reduced to any electronic medium or machine readable form without prior consent, in writing, from the ABLEä Ventures, LLC.

 

The information in this document is subject to change without notice. The ABLEä Ventures, LLC assumes no responsibility for errors that may appear in this document.

 

For more information visit the ABLEä web site:  http://www.programmingconcepts.com/able/

Or contact,

ABLEä Ventures, LLC

c/o Paul Parisi

ACME Bookbinding

100 Cambridge Street

Charlestown, MA  02129

 (800) 242-1821

 

For technical support contact:

 

Programming Concepts, Inc.

                                                                 

web site:               http://www.programmingconcepts.com/able/  

e-mail:                   able_support@programmingconcepts.com

telephone:              631-563-3800 x230

fax:                       631-563-3898

                                                                 

 

ABLEä Ventures, LLC

Acme Bookbinding

Information Conservation, Inc.

Kater-Crafts Bookbinders

Lehmann Bookbinding

Mekatronics Inc.

National Library Binding of Georgia

Ocker & Trapp Library Bindery Inc.

Programming Concepts, Inc.

 

 

 

ABLEä is a trademark of Mekatronics, Inc. / Bendror International Inc. 1987-2001

 


 

Table of Contents

 

1.  Introduction.......................................................................................................................................... 6

2.  Common Report Screen Services.......................................................................................................... 7

3.  Report Descriptions............................................................................................................................. 10

3.1  Binding (UBS) Slips............................................................................................................................. 10

3.2  Title Reports (Full, Brief, Extend History, Slips)...................................................................................... 13

3.3  Lot Summary...................................................................................................................................... 15

3.4  Lot Item Report................................................................................................................................... 15

3.4.1  Lot Summary................................................................................................................................ 16

3.4.2  Lot Items..................................................................................................................................... 16

3.4.3  Summary/Totals............................................................................................................................ 17

3.5  Lot Slips Report.................................................................................................................................. 17

3.6  Format Reports (Full and Brief)............................................................................................................. 18

3.7  Job Piece Report................................................................................................................................. 18

3.7.1  Job (Piece) Header....................................................................................................................... 18

3.7.2  Piece Detail................................................................................................................................. 18

3.8  Job Measurement Report (ABLE Bindery).............................................................................................. 19

3.8.1  Job (MSR) Header........................................................................................................................ 19

3.8.2  Piece Detail................................................................................................................................. 20

3.9  Job Summary Report........................................................................................................................... 21

3.10  Job Slips Report................................................................................................................................ 21

3.11  Cloth Pulling Report (CPR)................................................................................................................. 22

3.12  Lot (Billing) Detail Report................................................................................................................... 23

3.12.1  Lot Billing Header...................................................................................................................... 23

3.12.2  Lot Billing Detail....................................................................................................................... 24

3.13  Lot Billing Summary........................................................................................................................... 27

3.14  Lot (Detail/Summary) Costing............................................................................................................. 32

3.15  Lot Binding Statistics.......................................................................................................................... 32

3.16  Monthly (Detail/Summary) Binding Statistics........................................................................................ 32

3. 17  File Maintenance Tables..................................................................................................................... 32

 


 

Release Notes

 

 

V6.0                  Preliminary release for review.

V6.01                Changes for ABLEä release 6.01.

V6.02                Changes for ABLEä release 6.02.

V6.4                  Changed copyright.

                        

 


 

Volumes

 

The ABLEä Reference Guide is comprised of multiple volumes.  The collection of volumes describes the functional and operational characteristics of ABLEä.  The volumes are:                     

 

 

Volume

Reference Guide

File Name

1

Introduction

r6-intro.htm

2

Library User

r6-library-user.htm

3

User Interface

r6-user.htm

4

Title Composition

r6-title.htm

5

Text Fit Style Guide

R6-style.htm

6

Reports

r6-report.htm

7

Bindery Control Services

r6-control.doc

9

File Maintenance

r6-maint.htm

10

Bindery Transfer

r6-transfer.htm

12

Embosser Control

R6-emboss.htm

13

Help

r6-help.htm

15

Billing Statistics

r6-bill.htm

16

Preventive Maintenance

r6-pm.htm

19

System 3 Services

R6-s3.htm

20

Library Installation

r6-linstall.htm

21

Bindery Installation

r6-binstall.htm

22

EZ-Cut

r6-ezcut.htm

23

FTP

r6-ftp.htm

24

A-Link

r6-alink.htm

25

Z-Link

r6-zlink.htm

27

File Import Service

r6-file-import.htm

 

 

                                                                                                                 

                                                 

 

 

 


 1.  Introduction

 

The Report program provides comprehensive ABLEä reports.  The ABLEä Bindery system reports are a superset of the ABLEä Library reports.

 

The ABLEä reports consist of the reports that the library and bindery are expected to use on a frequent basis.  The ABLEä reports are easy to use and comprehensive for most libraries & binderies.

 

The reports are available using Window: Reports service selected from the Title Composition screen. The operator selects the Reports to start the process.  The Reports window is displayed.

 

The ABLEä Bindery reports can optionally be directed to a specific printer based on the report type. This means, for example, that binding slips will print on one printer and CPR reports could be directed to a different printer.

 

Reports may be:

 

·       Printed

·       Sent to a file for importing into a program such as Excel

·       Displayed on the screen

 

 

ABLEä Library

 

Title - Brief

Title - Full

Title - History                     

Title - Slips

Lot - Item

Lot - Summary

Lot - Slips

Format - Brief

Format - Full

Lot Costing - Detail                        

Lot Costing - Summary                   

Lot Binding - Statistics                   

Monthly Binding - Detail                

Monthly Binding – Summary

File Maintenance Tables   

 

 

ABLEä Bindery Reports

 

ABLEä Bindery Reports include all the ABLEä Library reports and the following additions:

 

Job - Piece

Job - MSR                          

Job - Summary

Job - Slips              

Cloth Pulling

Lot Billing - Detail             

Lot Billing - Summary        

 

 

2.  Common Report Screen Services

 

The Report program is invoked from the Title Composition screen using the Window: Reports menu selection.  The Report Screen is displayed.

 

 

First Report Screen

 

Report Type                        Each report is listed.

 

Sort Criteria                        The available sort fields for the Report selected are listed.

 

 

There are three action buttons on this first Report screen,

 

Next                                    The second report screen is displayed

 

Cancel                                 The Report program is closed

 

Help                                    Help information is displayed for using the Report program

 

            


Second Report Screen

 

Report Type                        Selected on first Report screen

Sort Criteria                        Selected on first Report screen

 

 

The following fields are available depending on the Report Type and Sort Criteria.  The fields not available are grayed to indicate they can not be used.

 

Department & Collection   Secondary selection criteria. These fields can be optionally specified to limit the report to only the Department and/or Collection specified.

 

Lot Status                            A secondary selection criteria.  The field can be used to optionally limit the report to only the Lot Status specified (e.g. COC, COS, CIC, CIS).

 

Item Status                          A secondary selection criteria. The field can be used to optionally limit a Lot Item or Lot report to only the Lot Item Status specified (e.g. CO, CI).

 

Start Title                            The Title ID of the first UBS to print.  The Title ID of the starting UBS to print.  If this field is empty, the report prints from the first Title ID.

 

Stop Title                            The Title ID of the last UBS to print. The Title ID of the last UBS to print.  If this field is empty, the report prints to the last Title ID.

 

Quantity                              The number of binding slips to print for each title. The number of binding slips to print for each title.  If this field is empty, the binding frequency specified in the title determines the number of slips to print.

 

Include Variables                Select if title text variables are to be included in the report. Determines if title text variables are to be included in the report.  The entry of YES indicates to include variables in the report.  The entry of No indicates to NOT include variables in the report.

 

Extra/specials are omitted when binding slips are printed without variable data.

 

Account ID                          The Account to generate the report for  The field can be used to optionally generate the Monthly Binding Statistics report for a selected Account.

 

Binder ID                            The field can be used to optionally generate the Monthly Binding Statistics report for a selected Binder.

 

Month                                 The field can be used to optionally generate the Monthly Binding Statistics report for a selected month.  NOTE: If the field is blank, the report will be generated for the current month.

 

Year                                     The field can be used to optionally generate the Monthly Binding Statistics report for a selected year.  NOTE: If the field is blank, the report will be generated for the current year.

 

 

There are three action buttons on this second Report screen,

 

To Printer                           The report is printed on the default printer.

 

To Screen                            The report is displayed on the screen.

 

To File                                 The report is sent to a specified file in as Comma Delimited text file.

 

Cancel                                 The first Report screen is displayed.

 

Help                                    Help information is displayed for using the Report program.

 

 

Note that alignment of the UBS form in the printer (printing a dummy UBS form so that the forms can be lined up) may be performed by choosing Setup: Print: Align UBS.

 

 

Note:    Printer Selection

 

The reports may be printed to a local workstation or, if available, a network printer.  For ABLEä Library, the default Windows printer is used unless changed before printing.

 

For ABLEä Bindery, each report can be assigned to a different printer.  In reality, a group of reports will be assigned to the same printer.  The user is provided complete flexibility of the use of printers for ABLEä reports. 

 

The printer assignments are allocated from Setup: System Parameters: Printer Queues.

 

Refer to the File Maintenance Reference Guide for further description of the Printer Queues.

 


 

3.  Report Descriptions

 

The ABLEä Library and ABLEä Bindery reports are described in the following sections.

 

 

3.1  Binding (UBS) Slips

 

Note:  The terms Binding Slips and UBS are used interchangeably.

 

Binding slips can be printed in two formats:

 

·       with variable data

·       without variable data.

 

A binding slip is printed with variable data for the following cases:

 

  • UBS slips printed from the Title Composition Utility

 

  • Lot Slip report selected from the Report Utility with the Include Variable field set to 'Y'

 

  • Job Slip report selected from the Report Utility with the Include Variable field set to 'Y'

 

 

A binding slip is printed without variable data for the following cases:

 

  • Title Slip report selected from the Report Utility

 

  • Lot Slip report selected from the Report Utility with the Include Variable field set to 'N'

 

  • Job Slip report selected from the Report Utility with the Include Variable field set to 'N'

 

 

If a UBS slip is printed with variable data, the following rules apply:

 

1.    ALL variable prompts are removed.

 

2.    Text is centered on the slip.

 

 


For example, if the volume appeared as follows,

 

                 F       S           P           Lvl       Text                                                       

    B      1           C          108        BOOK\AUCTION\RECORDS

 

    E                                 63        <VOL>VOL 3

                                        48        <YR>1990

 

                                       45        PAGES <PG>100

 

    A                                 32        <CALL>REF\Z\1000\B71

    J                                    9        <IMP>GETTY

 

 

             the text on the UBS slip would appear as below:

 

BOOK

AUCTION

RECORDS

 

VOL 3

1990

 

PAGES 100

 

REF

Z

1000

B71

 

GETTY

 

 


If a UBS slip is printed without variable data, the contents of the title record is printed.  The following rules are applied to the title:

 

1.    All characters NOT associated with a variable are printed.

 

2.    All characters associated with a special variable (i.e., title, call, or imprint) are printed.  Note, the variable prompt for these variables is not printed on the binding slip. 

 

3.    All characters following a variable other than title, call, or imprint, that are on the same screen line as the variable are NOT printed.  (EXCEPTION: Other variable prompts on the same line will be printed).  For succeeding screen lines, all characters preceding a new line character, an explicit level, or another variable are NOT printed. Note, the variable prompt is printed on the binding slip.

 

4.    Variable prompts are left-justified on the binding slip.

 

5.    Text is centered on the binding slip.

 

NOTE

 

For example, if the volume shown above was to be printed without variable data, the UBS slip would appear as follows:

 

BOOK

AUCTION

RECORDS

 

<VOL>

<YR>

 

PAGES <PG>

 

REF

Z

1000

B71

 

GETTY

 

 


3.2  Title Reports (Full, Brief, Extend History, Slips)

 

The "Full" report type prints complete Title record information for an account, including up to the six history records for each title.

 

The "Brief" report provides one line per Title record.  NOTE: the brief report displays the cloth color.

 

The "Extended History" report provides brief information of Title record along with the complete title's history data.  A start and stop title ID are available to select only a subset of the title database.

 

The "Slips" report prints UBS slips for the entire account.  The Title Slip report allows for restarting the report by entering into the Start Title field the Title ID to restart printing.  The Title ID is used even if sort key selected is not Title ID.  The starting Title ID can be obtained from the slip last successfully printed.

 

If the starting Title ID field is left blank then the report is started sorted (if text key is selected) and then started from the beginning. If the field is entered AND there is no report to be restarted, the report is sorted and starts printing at the specific Title ID.

 

The Title Slips report allows for stopping the report by entering into the Stop Title field the Title ID of the last UBS to print.

 

The variable data is not printed EXCEPT for the title, imprint and call variable data.  Text that precedes a variable on the same text line is printed.

 


The number of slips printed for a title depends on the binding frequency set for the title.  The rules for printing slips are:

 

  • If the first characters are numbers then the number is used as the count of slips to print.  E.g. 4 = 4 slips.

 

  • Specific values (upper or lower case) have designated printing counts:

 

Value

Count

Description

Weekly

52

Weekly

Bi-Weekly

26

Bi-weekly

Monthly

12

Monthly

Bi-Monthly

6

Bi-monthly

Quarterly

4

Quarterly

Yearly

1

Yearly

 

 

·       If the binding frequency is not filled in (i.e. blank) or is not a valid entry then one slip is printed.

 

 

The number of Title Slips to print for each title can be specified in the Quantity field.  If this field is empty, the binding frequency specified in the title determines the number of slips to print.

 

NOTE: the Title Slip report is printed directly to the printer and does not use the print spooler.  If the spooler is active then DO NOT print this report since the consequences would be unknown.

 

All selections allow the following options: Sort Key, Department, and Collection.

 

The sort keys allowed are:

 

·       Title ID

·       Text                        (68 characters of the text excluding spaces and exclusion words)

·       Call Number

·       ISSN/ISBN

·       Private ID

 


3.3  Lot Summary Report

 

The Lot Summary report provides a summary of all Lots that are currently active.  One line of status information is printed per Lot.  The Lot Status field is optional.

 

The Lot Summary section of the report provides header information about the lot, such as Lot Number, Binder, Lot Header Status (i.e. Produce, Restore), the number of works/cartons sent to the binder, works/cartons returned from the binder, Return Date, Return Operator.

 

 

3.4  Lot Item Report

 

The Lot Item report lists the items for Lot(s) (specified by Lot ID) that match the Lot Item Status criteria (if entered). This has to report enough information to identify the title file record associated with each item in the Lot.

 

There are four subsections: Lot Summary, Lot Items, Department Totals, and Lot Totals.

 

The Lot Item report lists the items in the lot specified in the Lot ID field.  If a Lot ID is not specified, a report is printed for the combination of all lots in the Account.  However, reports are printed for only those lots that match the Lot Status criteria (if entered).  Moreover, only those items that match the Item Status criteria (if entered) are listed in the report.

 

The Lot Item report can be sorted by:

 

  • Title ID
  • Text                                                       68 characters of the text excluding spaces and exclusion words
  • Call Number                                         
  • ISSN/ISBN                                             prints Private ID and not ISSN/ISBN
  • ISSN/ISBN - No Priv ID                        prints ISSN/ISBN and not Private ID
  • Private ID

 

 

If the Account's Department Sort field is set, the items will first be sorted by department and then by the selected sort key.  There is a summary printed for each department after the items in that department have been printed.

 

Extras/Specials that are manually entered for the item or obtained from the Title record and Special Instructions are now printed on the Lot Item Report.

 


3.4.1  Lot Summary

 

The Lot Summary section of the report provides header information about the lot, such as Lot Number, Binder, Lot Header Status (i.e. Produce, Restore), the number of works/cartons sent to the binder, works/cartons returned from the binder, Return Date, Return Operator.

 

Lot Summary appears after Lot Item and provides summary information about all the lots selected for the report. The information displayed is the same as above.

 

 

3.4.2  Lot Items

 

For a particular lot (or lots) of an account selected, the lot items section of the report lists the following fields sorted in ascending order by title text AFTER the exclusion words have been stripped:

 

  1)  Title                              Title record the item was created from.  The item is a monograph       if this field is blank.   (For example, 000009 = Title # 9)

 

  2)  Call Number                 Call number KEY (not call number text).  Up to 15 characters long.  None if blank.

 

  3)  Private ID                    Private ID.  Up to 13 characters long.  If the sort is IS

 

  4)  Lot                                Lot ID number. 8-digit code.

 

  5)  Items                            Item number.   4-digit code.  (For example, 0012 = Item 12 of the lot)

 

  6)  Set                                "Set Of" value (number of copies).  A blank indicates a single copy.

 

  7)  Depart                          Department in the library.  6-digit code.

 

  8)  Collect                          Collection in the library.  6-digit code.

 

  9)  Ct                                 Category. Two-digit category code.  (For example, 04  = Category code of 04)

 

 10)  Cl                                 Binding Classification. Two-digit class code.  (For example, 03  = Class code of 03)


 

 11)  Color                           Cloth Color.

 

 12)  Title Text                    Title text, variables and comments.  Sorted in ascending order (not counting exclusion words).  One or more lines long.

 

 

3.4.3  Summary/Totals

 

The Lot Items Summary reports the totals for the selected lot (or lots) in an account.  This summary is shown in two forms.  After each department, it is printed on a department basis.  All classes and categories listed are only for the previous department. This is shown as Department Totals.  This is only printed if the report is sorted by department.  At the end of the report is a section called Lot Totals.  This lists categories and classes for all departments.

 

1)  Class                              The types of class, the number and percentages of items in each class type, the total number of class types, and total number of items in the lot.

 

2)  Category                        The category types, the number and percentages of items in each category type, the total number of category types, and the total number of items in the lot.

 

 

3.5  Lot Slips Report

 

The Lot Slips Report allows for UBS forms to be printed for each item selected by the Lot Item Status within the Lot.

 

There is an option for selecting "Include Variables".  If yes or blank, then the report is generated from the Lot Items that were generated from Title Records.  If no, then the report is generated from the associated Title record (only if one exists).

 

The variable data is not printed EXCEPT for the title, imprint and call variable data.

 

For the ABLEäBindery, the "Include Variables" defaults to No.  The operator may change the value.

 

For the ABLEä Library, the "Include Variables" defaults to Yes.  The operator may change the value

The sort keys allowed are:

 

·       Title ID

·       Text                        (68 characters of the text excluding spaces and exclusion words)

·       Call Number

·       ISSN/ISBN

·       Private ID

 

3.6  Format Reports (Full and Brief)

 

The Full report prints complete Format record information and the Brief report prints one line Format record information.  Note: the Default Format record is NOT printed.

 

 

3.7  Job Piece Report

 

The Job (Piece) Report provides job and piece information for ABLEä Binders. The report prints a report heading, followed by detail lines for each piece in the job, and then shows a summary of statistics for the job.

 

 

3.7.1  Job (Piece) Header

 

The report heading includes the date and name of the report, and the job number of the data being printed, for example:

 

22-Apr-1988                                             Job (Piece) Report                                                             Page 1

Job ID : 600

 

 

 

3.7.2  Piece Detail

 

For a particular job that is selected, the piece detail section of the report lists the following fields, in order of ascending piece number (one line for every piece in the job):

 

  1)  Piece                            Piece number for selected job, in ascending order. 4 digits. (For example, 0001 = Piece # 1)

 

  2)  Accnt                            Account code of library owning the piece.  (For example, ABLE = account ABLE)

 

  3)  Title                              Numeric title ID of the volume.  The piece is a monograph if this field is blank.   (For example, 000009 = Title # 9)

 

  4)  Lot                                Library's lot in which the volume arrived.

 

  5)  Call Number                 Call number KEY (not call number text) of volume.  Up to 15 characters long.  None if blank.

 

  6)  Items                            Associated library's lot item number. 4 digits.           (For example, 0012 = Item 12)

 

  7)  Set                                N number of copies.  A blank indicates a single copy.

 

  8)  Cat                                Category or type of volume. Two-digit code.. (For example, 04  = Category code of 04)

 

  9)  Cls                                Binding classification. Two-digit class code.  (For example, 03  = Class code of 03)

 

 10)  Leaf                             Leaf Attachment. Two-character code, the first character indicates the leaf attachment method and the second character indicates the backing.

                                            (For example, HF = Hand-sewn, Flat-backed AR =  Adhesive,  Round-backed)

 

 11)  Color                           Cover color.  4 digits.

 

 12)  Sts                                Station. Four characters (i.e. MSR1, ORD2).

 

 13)  Text                             Title text, variables and comments.  One or more lines.

 

 

3.8  Job Measurement Report (ABLE Bindery)

 

The Job (MSR) Report provides job and piece information for ABLEä Binders.  The report prints a report heading, followed by detail lines for each piece in the job, and then shows a summary of statistics for the job.

 

 

3.8.1  Job (MSR) Header

 

The report heading includes the date and name of the report, and the job number of the data being printed, for example:

 

22-Apr-1988                                            Job (Msr) Report                                                          Page 1

Job ID : 600

 


3.8.2  Piece Detail

 

For a particular job that is selected, the piece detail section of the report lists the following fields, in order of ascending piece number (one line for every piece in the job):

 

1)  Piece                              Piece number for selected job, in ascending order.  4 digits. (For example, 0001 = Piece # 1)

 

2)  Accnt                              Account code of library owning the piece. (For example, ABLE = account ABLE)

 

 

3)  Lot                                  Library's lot in which the volume arrived.

 

4) Call Number                    Call number KEY (not call number text) of volume. Up to 15 characters long.  None if blank.

                                                         

5)  Items                              Associated library's lot item number. 4 digits.  (For example, 0012 = Item 12)

                                           

6)  Set                                  "Set Of" value (number of copies).  A blank indicates a single copy.

                                           

7)  Ct                                   Category or type of volume. Two-digit code. (For example, 04  = Category code of 04)

                                           

8)  Cl                                    Binding classification. Two-digit class code.  (For example, 03  = Class code of 03)

                                           

9)  Lf                                    Leaf Attachment. Two-character code, the first character indicates the leaf attachment method and the second character indicates the backing.

                                             (For example, HF = Hand-sewn, Flat-backed, AR = Adhesive,  Round-backed)

 

10)  Color                            Cover color, 4 digits.

 

11)  Sts                                 Station. Four characters (i.e. MSR1, ORD2).

 

12)  Ht                                 The height of the volume (in default units).

 

13)  Width                            The width of the volume (in default units).


 

 14)  Spine                            The thickness of the spine (in default units).

 

 15)  Text                             Title text, variables and comments.  One or more lines.

                                            

 

3.9  Job Summary Report

 

The job summary section of the Job (Piece) report provides header information about the binder's job ID, station, embosser type and unit, job header comment, last piece, total pieces in job, job creation date, target date for completion of job, expected date of return of job to customer.

 

The report also prints out the following statistics:

 

  1)   Attachment                 Each leaf attachment method listed in the piece detail section, including the backing types (such as FLAT, ROUND), and TRIM, NOTRIM.

                                                

2)   Count                            The number of pieces for each of the attachments (FLAT and ROUND pieces add up to the piece total, as do NOTRIM and TRIM).

                                  

                                  

3.10  Job Slips Report

 

The Job Slips Report allows for UBS forms to be printed for each piece within the Job.  Slips will only be printed if the piece's account has the Print Binding Slips field set to Yes.  Slips will only be printed if the piece's account has the Print Binding Slips field set to Call Sort or Text Sort.

 

There is an option for selecting "Include Variables".  If Yes, then the report is generated from the Job Pieces that were generated from Title Records.  If no, then the report is generated from the associated Title record (only if one exists).

 

The variable data is not printed EXCEPT for the title, imprint and call variable data.

 

For the ABLEä Bindery, the "Include Variables" defaults to No.   The operator may change the No if required. 

 

The Release service automatically initiates the report.  Refer to the Embossing Control volume for further details.

 

The report is printed BEFORE the Automatic Account Processing or Diskette Production phase.  This means that the titles have not yet been updated or created (if needed).  The Job Slips may not be "perfect" depending on the circumstances.

 

The Job Slip report is printed directly to the printer and does not use the Spooler.  If the Spooler is active then DO NOT print this report.  The consequences would be unknown.

 

The Job Slip report can be sorted by account/department/text or by account/department/call.  The piece's account record "print binding slip" field is used to determine the sort criteria.  If it is set to:

 

     T                                     sorted by account/department/text

     C                                     sorted by account/department/call

 

 

NOTE: if a Job has multiple accounts and the accounts have different sort criteria (i.e. Call Sort or Text Sort), then the Job sort selected is either Call Sort or Text Sort depending on the first Job encountered in the program logic (i.e., it is non-deterministic).

 

 

The Job Slip report provides a way to start and stop the report at specified pieces.  Two edit fields are provided for this purpose: Start Piece and Stop Piece.  These fields are used to specify the start and end piece to print from. If they are not entered then the full report is printed.  Note that the original sort order (text or call) is used for the pieces defined by the start and stop fields.

 

 

3.11  Cloth Pulling Report (CPR)

 

NOTE:  Avery #5162 labels are required for proper alignment of CPR labels.

 

This report prints cloth pulling labels in the order the job pieces are to be embossed.  Normally, the report is not needed since it is generated automatically.  The report is printed after all the pieces of a job are measured.

 

When "Copies" function is used.  If a piece requires multiple copies, then multiple CPR labels are also printed.

 

Different formats are supported.  

 

A File Maintenance, Bindery System Parameter, CPR Format (cpr_bmsr), indicates which CPR format is printed

 

CPR Format is No                      then the format #1 is printed. 

CPR Format is Yes                    then format #2 is printed.

 

 

     RB7/11 Header                             SII Header                       

     Job ID                                  Font Name (actual)

                                                   Foil Name (actual)

 

 

Format #1

                                     

        Job                                                  Piece

        Title Text (Partial)                         Seq#

        Variables                                         SII Placement

   ** Cloth Height x Width                     Emb.Type

        Color                                               Cloth Bin

 

 

**  The cloth height and width are the calculated cloth measurements derived MD-17 MSR program.  They are NOT the measurements of the pre-cut cloth referenced by the Cloth Bin number. 

 

 

Format #2

 

        Job                                                  Piece

        Title Text (Partial)                         Seq#

        Variables                                         SII Placement

        Cloth Height x Width                     Vol height x spine

        Color       Foil                                 Cloth Bin

 

 

A CPR label is printed for pieces that have a "no CPR/Emboss" or "no CPR" category.  (Refer to File Maintenance, Bindery System Parameters, No Emboss/CPR Class (nocpr emb) and No CPR Category (nocpr).)

 

A CPR label is printed for pieces that have a "no touch" class. (Refer to File Maintenance, Bindery System Parameter, No Touch Classes (notouch.)

 

 

3.12  Lot (Billing) Detail Report

 

The Lot (Billing) Detail Report provides billing information and statistics for the lot selected.  The report prints a report heading, followed by detail lines for each item within the lot, and then puts out a summary of the calculated statistics for the lot. Note that the summary page is the same as the Lot (Billing) Summary Report.

 

 

3.12.1  Lot Billing Header

 

The report heading includes the date and name of the report, the library account ID, and the lot number of the data being printed, for example:

 

22-Apr-1988                                             Lot (Billing) Detail                                                              Page 1

Accnt: ABLE    Lot ID: 22APR88

 

3.12.2  Lot Billing Detail

 

The lot billing detail section of the report prints one or more line(s) per item in the lot showing the statistics calculated for each item, showing the following fields in ascending item number order:

 

1)  Items                              Item number within the lot, sorted in ascending order.  4 digits.                         (For example, 0002 = Item 2 of the lot)

 

2)  Set                                  "Set Of" value (number of copies). A blank indicates a single copy.                              

3)  Ttl ID                             Title record the item was created from.  The item is a monograph if this field is blank.   (For example, 000009 = Title # 9)

 

  4)  Job ID                          Number of the bindery job in which the item was processed.  8 digits, with no leading zeros.  (For example, 600 = Job # 600)

 

  5)  Piece                            Bindery piece number within the job in which the item was processed.  4 digits.  A question mark appearing after the piece number is a warning that the printed figures might not be accurate because the piece has either not been text-fitted and released, or the piece has been modified after being text-fitted. (For example, 0001  = Piece # 1 0003? = Piece # 3, textfit warning)

 

  6)                                       To be defined or renumbered.


 

7)  Height                            Height.  Board height measurement of the volume. An '*' will precede the measurement, if the board height is beyond the contract height in the Binder Record.

 

8)  Width                              Width.  Board width measurement of the volume. An '*' will recede the measurement, if the board width is beyond the contract width in the Binder record.                                                                                                                 

9)  Spine                              Spine Width. Spine width measurement of the volume. An '*' will precede the measurement, if the spine width is beyond the contract spine width in the Binder record.                                                                                                 

10)  T                                   Trim.  One-character code.  An 'N' prints in this field if any of the trim top, trim bottom or trim front fields in the Collation screen have a value of zero (no trim specified) or if it is defined by its class, leaf attachment. or extra specials to be a no-trim piece.                                           

                                                                                                            

11)  Ex                                 Extra Call or Imprint Lines: Since call and CEx imprint lines are mutually exclusive this one field is used for two purposes.  The heading is CEx and only counts extra call lines.  A blank entry means there were

                                            Call Lines Extra, where 'c' is a one character flag denoting the presence of call line(s), with a two digit number after the 'c' indicating the number of call lines over the contract call lines.                                      

(For example, c = Call line(s) present c05 = 5 Call lines over contract)                         

                                            Imprint Lines Extra, where 'i' is a one character flag denoting the presence of imprint line(s), with a two digit number after the 'i' indicating the number of imprint lines over the contract imprint lines.  (For example, i =  Imprint line(s) present; i05 = 5 Imprint lines over contract)

 

12) Tx                                  Text Lines Extra. A two digit number indicating the number of text lines exceeding the contract amount.  A blank entry means there were no extra text lines over the contracted amount for the item.   (For example, 02 = Two text lines over contract)                                                                                                                                                                    

Text lines are all the text lines except the call lines and imprint lines.                            

                                            This field is labeled "Hx" and it represents the number of horizontal title lines exceeding the contract amount                                         .

 

13) Vx                                  Vertical Title Lines Extra. A two digit number indicating the number of vertical title lines exceeding the contract amount.  A blank entry means there were no extra vertical title  lines over the contracted amount for the item.     (For example, 02 = Two lines over contract)                                                   

                                            

 

14) Ct                                   Category. Two-digit category code. (For example, 04  = Category code of 04)

 

15) Cl                                   Binding Class. Two-digit class code. (For example, 03  = Class code of 03)

                                           

16) Lf                                   Leaf Attachment processing. Two-character code, the first character indicates the leaf attachment method and the second character indicates the backing. (For example, HR = Hand-sewn, Round-backed AF = Adhesive,  Flat-backed )                                                       

 

17) Cvr                                Cover color.  The first three characters of the cover color will be printed.  An '*' will follow if the piece's cover color differs from          the class's cover color.                                                       

 

  18) Text                             Title text, variables and comments. Can be more than one line long.

 

  19) Extras/

        Specials   -                   Additional line(s) printed under the item line giving the number of minutes for each extra/special listed.  The minutes field can be blank for a listed special. One line is printed for each extra/special that was coded as chargeable (code of 1 or 2).       No extras/specials lines are printed if there were no extras/specials recorded at the MD-17 workstation. (For example,  12 TL-Tattletape 15 ST-Stubbing)                                                                                                                              

                                                                                                                                      .

                                            

 


 

3.13  Lot Billing Summary

 

The lot billing summary section of the report shows the calculated totals for the selected lot of the account.  Items that are in the Hold Job; i.e., not processed, are not included in the counts.

 

1)  Volumes                         Total number of volumes in the Hold Job. in Hold Job.

 

2)  Volumes                         Total number of volumes in the selected Lot.  The heading is Volumes Processed, the total number of volumes           processed in the selected Lot; i.e., the number of volumes not in the Hold Job.                                        

 

3)  Vertical Lines                Total number of vertical lines in the volumes listed.  This field is replaced by "Extra Vert. Title Lines", which is described below.                    

 

4)  NOTRIM                       Total number of volumes with no trim.

 

5)  RND backed                  Total number of volumes with round-backing.

 

6)  FLT backed                   Total number of volumes with flat-backing.  (The numbers for RND and FLT add up to the total number of volumes.)                                       

                                                

7)  Volumes

        with CALL                  The total number of volumes with call numbers.

 

8)  Extra CALL

        Lines                           The total number of call lines over the contract amount of call lines for all the volumes listed                                                    .

 

9)  Volumes with

        Imprints                      The total number of volumes with imprint lines.

 

10)  Extra Imprint

        Lines                           The total number of imprint lines over the contract amount of imprint lines for all the volumes listed.                                                        

 

11)  Volumes with

         Extra Text                  The total number of volumes with extra text lines.

 

12)  Extra TEXT

         Lines                          The total number of text lines over the contracted amount for all         the volumes listed.

                               

                                            This field is labeled "Extra Horz. Title Lines" and it represents the total number of horizontal title lines over the contracted amount for all the volumes listed.                                                                                                       

 

13)  Extra Vert.

         Title Lines                 The total number of vertical title lines over the contracted amount for all the volumes listed.

                                  

 

14)  Non Standard

        Cvr Color                    The number of volumes which had a cover color that differed from the class's cover color.  If a class is not specified for the volume or the class specified does not indicate a color, then the volume's cover will be considered a match.                                                                        

 

15)  Leaf

        Attachments                The number of volumes in each different leaf attachment listed in the report.  An asterisk * printed after the leaf attachment method indicates that the this is a charged attachment which will cost extra.                                             

 

16)  Class Items                  The number of items for each particular binding class code listed in the report.                                          


 

 17)  Board Height              The number of volumes with board heights over the contract height, grouped by ascending ranges of extra board height values inclusive.                                                                                                                  

For example:       Board Height (  5-0/8)  6-1/8 to   7-0/8    1

 

                                             This means that there was 1 volume with a height that exceeded                     the contracted amount of 5-0/8 by an amount between 1-1/8                        and 2-0/8, i.e. an item with a board height of 6-1/8 to 7-0/8.)

 

 18)  Board Width                The number of volumes with board widths over the contract width, grouped by ascending ranges of extra board width values inclusive.                                                                           

                                            For example: Board Width  4-0/8) 5-1/8 to 6-0/8 1 

 

                                                         This means that there was 1 volume with a width that exceeded the contracted amount of 4-0/8 by an amount between 1-1/8 and 2-0/8, i.e. an item with a board width of 5-1/8 to 6-0/8.

 

 19)  Spine Width                 The number of volumes with spine widths over the contract width, grouped by ascending ranges of extra spine width values inclusive.  (For example: Spine Width (     12P) 13P to 14P   2

                                  

                                                                      This means that there were 2 volumes with widths that exceeded the contracted amount of 12P by amounts between 1P and 2P, i.e. a volume with a spine width of 13 picas to 14 picas.)                                                

20)  Extra Charges              The number of volumes for each special note, and the amount of time spent on each special, followed by the total time spent on all extras.  (For example, Extra Charges,                                                                                  

                                                                             12 TL-Tattletape   (2)

                                                                             12 Minutes extra time )

 


 

SAMPLE REPORT PRINTOUT FOR LOT BILLING

 

22-Apr-1988                                                          Lot (Billing) Detail                                     page 1

Accnt: ABLE                 Lot ID: 22APR88

ITEM

SET

Tlt ID

Job ID

Piece

NV

OHeight

OWdt

T

Ex

Tx

Ct

Cl

Lf

Cv

T

0001

1

000009

600

00001

02

 

1P

 

c

 

01

02

HF

 

 

0002

3

000010

600

00002

 

2-0/8

2P

N

 

02

04

03

CR

 

 

 

12 TL-Tattletape

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0003

5

000011

600

00003?

01

0-1/8

4P

N

c05

 

01

02

AR

 

 

 

                                                                             SUMMARY

                                                       Leaf Attachments              Class Items

                           Item     Set                     Item      Set                          Item              Set

Totals                             Total      Total                  Total     Total         Total             Total

Volumes                         00003    00009       H       00001    00001    02 00002            00006

Vertical Lines                  00003    00003       C*      00001  00003      03 00001            00003

NOTRIM                        00002 00008        A         00001  00005

RND backed                   00002 00008

FLT backed                    00001 00001

Volumes with Call           00002 00006

Extra Call Lines  00005 00025

Volumes with Imprints     00000 00000

Extra Imprint Lines          00000 00000

Volumes w/ Extra Text    00001 00003

Extra Text Lines 00002 00006

Non-Standard Cvr           00000 00000

Color

                            Item   Set                                                                          Item     Set

Board Height ( 5-0/8)  Total  Total                                       Spine Width  (12P)     Total    Total

0-1/8 to   1-0/8 Over   00001 00005                         1P to       2P Over           00002  00004

1-1/8 to   2-0/8 Over   00001 00003                         3P to       4P Over           00001  00005

 

                          Item                   Set

Extra Charges                 Total                  Total

 12 TL-Tattletape            (00001)  (00003)

 12 Minutes extra time

 


SAMPLE REPORT PRINTOUT FOR LOT BILLING

 

06-Mar-1990                                             Lot (Billing) Detail                        page 1

Accnt: ABLE    Lot ID: 06MAR90

ITEM

SET

Tlt ID

Job ID

Piece

Hght

Width

Spine

T

Ex

Hx

Vx

Ct

Cl

Lf

C

T

0001

1

000009

690

0001

*7-0

4-0

*13P

 

i

01

 

01

02

HF

 

 

0002

3

000010

HOLD

0100

 

 

 

 

 

 

 

 

 

 

 

 

0003

5

000011

690

0002?

*5-1

*4-1

 

N

c05

 

01

01

02

AR

 

 

 

12 TL-Tattletape

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                                                                                                   SUMMARY

                                                                Leaf Attachments                  Class Items

                          Item      Set                                  Item      Set                     Item      Set

Totals                             Total     Total                               Total     Total                  Total     Total

Volumes in Hold Job           1          3

Volumes Processed            2          6                      H           1          1                  02     2        6

NOTRIM                           1          5                      A           1          5

RND backed                      1          5

FLT backed                       1          1

Volumes with Call              1          5

Extra Call Lines     5          25

Volumes with Imprints        1          1

Extra Imprint Lines             0          0

Volumes w/Extra Text        2          6

Extra Horz. Title Lines        1          1

Extra Vert. Title Lines        1          5

Non-Standard Cvr              0          0

Color

 

                          Item  Set                                      Item  Set                              Item   Set

Hght ( 5-0/8)   Tot    Tot               Width ( 4-0/8) Tot    Tot  Spine (12P) Tot    Tot

5-1/8 to 6-0/8    1             5           4-1/8 to 5-0/8   1              5           13P to 14P   1            1

6-1/8 to 7-0/8    1             1

 

                          Item      Set

Extra Charges                 Total     Total

 12 TL-Tattletape            (    1)     (    3)

 12 Minutes extra time

 

 


3.14  Lot (Detail/Summary) Costing

 

The Lot Costing Report generates and displays calculated binding statistics for a selected Lot.  See the ABLEä Billing Statistics volume of the ABLEä/Reference Guide.

 

 

3.15  Lot Binding Statistics

 

The Lot Binding Statistics displays the "actual" billing costs for a selected Lot.  See the ABLEä Billing Statistics volume of the ABLEä Reference Guide.

 

 

3.16  Monthly (Detail/Summary) Binding Statistics

 

The Monthly Binding Statistics displays "actual" billing costs for a selected month and year.  If a month or year is NOT selected, the report will be generated for the current month or year.  Note, year-to-date binding statistics are also displayed.  They are calculated based on the fiscal-year.

 

At the Library, the report may be generated for a selected Binder. If a Binder is NOT selected, the report will include all billing statistics, regardless of the Binder.

 

At the Bindery, the report may be generated for a selected Account. If an Account is NOT selected, the report will include all billing statistics, regardless of the Account.

 

See the ABLEä Billing Statistics volume of the ABLEä Reference Guide.

 

 

3. 17  File Maintenance Tables

 

A selected File Maintenance table is reported.  Refer to the File Maintenance volume for details.