LIBRARY INVOICE DETAIL Table
Includes information from the Invoice Line Items (e.g., Invoice Line Item Note, Line Item Amounts) as well as information from the General Invoice (e.g., Currency and Total Amount). Data in this table is taken from Z75, Z77, and Z601 tables in Aleph.
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 |
CURRENCY_RATIO |
Conversion, or exchange, rate on the date the transaction occurred; sometimes referred to as Explicit Ratio. Probably best not to use this field for calculations, since almost all of the amounts in the Warehouse are in USD. (Z601-CURRENCY-RATIO, not Z82-R) |
NUMBER |
22 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
INVOICE_LINE_ITEM_NOTE |
Note associated with the detail line of an invoice. (Z75-I-NOTE) |
VARCHAR2 |
200 |
INVOICE_NUMBER_OF_UNITS |
Total number of units from the detail lines. (Sum of Z75-I-NO-UNITS; individually referred to as ""Number of Units"" in the detail lines, but you can't see the total itself in the client.) |
NUMBER |
22 |
LIBRARY_FUND_KEY |
Key used to join to the LIBRARY_FUND table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_INVOICE_DATE |
Date printed on the invoice from the vendor. (Z77-I-DATE) |
DATE |
8 |
LIBRARY_INVOICE_LINE_ITEM |
Line number from the invoice for transactions of the type INV. (Z601-LINE-NUMBER or Z75-LINE-NUMBER)) |
NUMBER |
22 |
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_ORDER_KEY |
Key used to join to the LIBRARY_ORDER table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
14 |
LIBRARY_ORDER_STATUS_KEY |
Key used to join to the LIBRARY_ORDER_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_ORDER_TYPE_KEY |
Key used to join to the LIBRARY _ORDER_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
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 |
TRANSACTION_AMOUNT |
The dollar amount (USD) associated with an invoice line. This value equates to the 'actual amounts' seen in the Financial Detail table. (Z601-LOCAL-SUM) |
NUMBER |
22 |
TRANSACTION_AMOUNT_ORIG_CURR |
Invoice amount in the original currency; DO NOT use this field for calculations. (Z601-ORIGINAL-SUM) |
NUMBER |
22 |
TRANSACTION_DATE |
Original date of the transaction. (Z601-OPEN-DATE or just Date in the client) |
DATE |
8 |
TRANSACTION_NOTE |
Invoice note. Corresponds to Aleph Z75 Note field. (Invoice Line or Order Encumbrance) |
VARCHAR2 |
200 |
TRANSACTION_SORT_SEQUENCE |
A unique sequence number, usually a time and date stamp, assigned by Aleph. Not sure if there is an accurate time and date stamp associated with migrated data, but it should be accurate for all Aleph-born data. (Z601-SEQUENCE) |
VARCHAR2 |
15 |
TRANSACTION_USER |
Original user (person) who created the transaction. (Z601-USER-NAME) |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |