Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    z601 Transfers

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    I am trying to create a report that lists all transfers from monograph funds to serials funds. I can see how the transfers relate by date, amount, credit/debit, but I don't see a unique identifier for the transfer (for example, if the transfer was from fund A to fund B, they would share a common field with a unique identifier for the transfer). If there are several transfers with the same date and the same amount, how would you know how the transfers relate (transfer to/transfer from)? The only thing I can figure out is the sequence part of the rec key is a counter. Transactions that relate should be consecutive numbers. Is this correct?

    Resolution:
    It should be safe to make the assumption that the numbers representing the two sides of the transfer transaction are sequential. Perhaps if two staff members made a budget transfer at precisely the same moment, these might interleave, but that would be very, very coincidental. The Note field in each of the Z601 records indicates the budget that the amount was transfered to or from, so you could use this as a double-check. Here, for example, are the two Z601's that were created when I transfered $10.00 from BUDGET-A to BUDGET-B:

    01 z601 \
    02 z601_rec_key \
    03 budget_number .......BUDGET-A
    03 sequence ............200803190060098
    02 z601_rec_key_2 \
    03 vendor_code .........
    03 invoice_number ......
    03 line_number .........00000
    02 z601_rec_key_3 \
    03 doc_number ..........000000000
    03 doc_sequence ........00000
    02 z601_object_code ......
    02 z601_user_name ........MASTER
    02 z601_open_date ........20080319
    02 z601_type .............TRN
    02 z601_note .............Transfered to BUDGET-B
    02 z601_credit_debit .....D
    02 z601_currency .........USD
    02 z601_currency_date ....20080319
    02 z601_currency_ratio ...000000000000
    02 z601_original_sum .....00000000001000
    02 z601_active_sum .......00000000001000
    02 z601_local_sum ........00000000001000
    02 z601_vat_sum ..........00000000000000
    02 z601_paid .............


    01 z601 \
    02 z601_rec_key \
    03 budget_number .......BUDGET-B
    03 sequence ............200803190060099
    02 z601_rec_key_2 \
    03 vendor_code .........
    03 invoice_number ......
    03 line_number .........00000
    02 z601_rec_key_3 \
    03 doc_number ..........000000000
    03 doc_sequence ........00000
    02 z601_object_code ......
    02 z601_user_name ........MASTER
    02 z601_open_date ........20080319
    02 z601_type .............TRN
    02 z601_note .............Transfered from BUDGET-A
    02 z601_credit_debit .....C
    02 z601_currency .........USD
    02 z601_currency_date ....20080319
    02 z601_currency_ratio ...000000000000
    02 z601_original_sum .....00000000001000
    02 z601_active_sum .......00000000001000
    02 z601_local_sum ........00000000001000
    02 z601_vat_sum ..........00000000000000
    02 z601_paid .............

    Randy

    • Article last edited: 10/8/2013