Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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