LIBRARY INVOICE SUMMARY Table
Includes information from the General Invoice (Invoice Header) in Aleph (e.g., Invoice Number, Invoice Date, Vendor, Total Price)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENCY_CODE |
Three-letter codes for the currency (follows ISO code structure) (e.g., USD, EUR) (Z82-CURRENCY) |
VARCHAR2 |
3 |
LIBRARY_INVOICE_DATE |
Date printed on the invoice from the vendor. (Z77-I-DATE) |
DATE |
8 |
LIBRARY_INVOICE_NOTE |
A note referring to the entire invoice. (Z77-I-NOTE, this is a note in the General Invoice, not any notes in the Detail Lines) |
VARCHAR2 |
60 |
LIBRARY_INVOICE_NUMBER |
Invoice number for transactions of the type INV. (Z601-INVOICE-NUMBER, Z77-INVOICE-NUMBER, or Z75-INVOICE-NUMBER; they are all the same) |
VARCHAR2 |
15 |
LIBRARY_INVOICE_PAYMENT_DATE |
Date the Payment Status was changed to P (paid). (Z77-P-DATE) |
DATE |
8 |
LIBRARY_INVOICE_RECEIVED_DATE |
Date the invoice was entered into Aleph, assigned by Aleph as today's date if nothing is entered manually. (Z77-REC-DATE) |
DATE |
8 |
LIBRARY_INVOICE_STATUS_KEY |
Key used to join to the LIBRARY_INVOICE_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
LIBRARY_INVOICE_TYPE_KEY |
Key used to join to the LIBRARY_INVOICE_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
LIBRARY_VENDOR_KEY |
Key used to join to the LIBRARY_VENDOR table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
MATERIAL_SHIPPED_DATE |
Date the material was shipped by the vendor. Usually matches invoice date and is assigned by Aleph as the same as the Invoice Date if nothing is entered manually. (Z77-SHIP-DATE) |
DATE |
8 |
ORIGINAL_INVOICE_NUMBER |
Used when the Libraries changed the vendor-assigned invoice number (alternate invoice number) in order to maintain a uniquie number. (Z77-ORIG-INVOICE-NUMBER, in the client General Invoice Form it is called ""Refers to Invoice"") |
VARCHAR2 |
15 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
TOTAL_INVOICE_AMOUNT |
Sum of all detail lines and other charges, in USD. (Z77-I-TOTAL-AMOUNT converted to USD, in the client General Invoice Form it is called ""Local Amount."") |
NUMBER |
13 |
TOTAL_INVOICE_AMOUNT_ORIG_CURR |
Sum of all detail lines and other charges, in the original currency of the invoice. (Z77-I-TOTAL-AMOUNT, in the client General Invoice Form it is called ""Total Amount."") |
NUMBER |
13 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |