LIBRARY ORDER STATUS Table
Includes order, arrival and invoice statuses (e.g., Sent to Vendor, Closed, Library Cancelled, Partial or Complete). Note that only descriptions are includes and not the Aleph codes (e.g., SV). Use this table to limit the query by statuses.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_ORDER_STATUS |
Describes the status of the order (e.g., New, Sent to Vendor, Closed, Cancelled, etc.) (Z68-ORDER-STATUS) |
VARCHAR2 |
30 |
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 |
ORDER_ARRIVAL_STATUS |
Use this to limit a query to orders Partially or Completely received, for Monographs only (Z68-ARRIVAL-STATUS) |
VARCHAR2 |
30 |
ORDER_INVOICE_STATUS |
Use this to limit a query to orders Partially or Completely invoiced, most useful for Monographs (Serials doesn't really use this field) (Z68-INVOICE-STATUS) |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |