LIBRARY CURRENCY Table
Includes codes and definitions of ISO defined currencies used in Aleph (USD for United States dollar, EUR for Euro, GBP for British pounds, etc.) Usually not needed to link to other tables, the Currency Code is in the LIBRARY_FINANCIAL_DETAIL, LIBRARY_INVOICE_DETAIL and LIBRARY_INVOICE_SUMMARY tables.
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_KEY |
Key used to join to the LIBRARY_CURRENCY table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
CURRENCY_NAME |
Full name for the currency (e.g., U.S. Dollar, Euro) (Z82) |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |