Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. List of invoice lines with blank order numbers

    List of invoice lines with blank order numbers

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

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

     

    Description

    We need a list of invoice lines that have blank order numbers. 

    Resolution

    > s+ xxx50;
    SQL> select z601_rec_key_2 from z601 where substr (z601_rec_key_3,1,9) = '000000000' and (substr (z601_rec_key_2,21,15) is not null and substr (z601_rec_key_2,21,3) ^= '   ');

     


    • Article last edited: 8-Dec-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • List of filterable fields in def file for p-file-96
      • List of items with status nn checked out since yyyy-mm-dd
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved