LIBRARY VENDOR Table
Lists codes and names of all vendors used in Aleph. All Monograph vendor codes end in -M and all Serial vendor codes end in -S. Data is taken from the Z70 table in Aleph.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_VENDOR_CODE |
Code associated with a vendor (all MonoAcq vendors end in -M and all SerAcq vendors end in -S) (Z70-VENDOR-CODE) |
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 |
LIBRARY_VENDOR_NAME |
Name of the vendor (Z70-VENDOR-NAME) |
VARCHAR2 |
150 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |