Skip to main content
ExLibris
ExLibris Dev

Can barcodes or other record IDs be duplicated in Aleph?

  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct,Direct,Local,Total Care

Question

Can the following values be duplicated in Aleph?

 

* Patron barcodes

* Other patron IDs

* Item barcodes

* Invoice numbers

* Order numbers   

Answer

*  Patron barcodes

<<  No.  The Z308_REC_KEY is defined as UNIQUE in Oracle, so there could only be one “01nnnnnnnnnnnnnnnnnn” record.  (“01” is the Z308-KEY-TYPE for the patron barcode.)

 

*  Other patron IDs

<<  No.  Same as above.  The Z308_REC_KEY is defined as UNIQUE in Oracle.  See also, article "Duplicate patron ID's *MASTER RECORD*"  :  https://knowledge.exlibrisgroup.com/...MASTER_RECORD*

 

*  Item barcodes

<<  Yes.  The Z30_BARCODE is usually defined as NONUNIQUE, but, as described in the article “Duplicate item barcodes” , the  tab100 CHECK-BARCODE=Y parameter usually prevents this.

 

*  Invoice numbers

<<  The Z77_REC_KEY is defined as UNIQUE.  The  Z77_REC_KEY consists of:

            03 Z77-VENDOR-CODE          PICTURE X(20).

            03 Z77-INVOICE-NUMBER       PICTURE X(15).

   So, though one *could* have a duplicate Z77-INVOICE-NUMBER, since Aleph uses that number only in conjunction with the Z77-VENDOR-CODE, the invoice number is effectively unique.   

 

*  Order numbers   

<<  Yes.  The Z68_ORDER_NUMBER is defined as NONUNIQUE.   {The z68_rec_key (the Aleph order record key) is UNIQUE.}

    

But uniqueness is normally enforced via the "last-order-number" util g/2 counter.  See article "Duplicate Order Numbers" : https://knowledge.exlibrisgroup.com/..._Order_Numbers .

 

 

 

 

  • Was this article helpful?
//doorbell.io feedback widged