Currency
Lookup table for currencies.
erDiagram
Currency ||--o{ AnnotationProperty : "CurrencyID"
Currency ||--o{ LicenseComplianceHistory : "InitialCostCurrencyID"
Currency ||--o{ LicenseComplianceHistory : "RecurringCostCurrencyID"
Currency ||--o{ SoftwareItem : "InitialCostCurrencyID"
Currency ||--o{ SoftwareItem : "RecurringCostCurrencyID"
Fields
| Field |
Type |
Description |
| ID |
numeric |
Internal ID for the Currency entity (Primary Key) |
| Name |
string |
International currency name |
Referenced by
| Table |
Column Name |
Description |
| AnnotationProperty |
CurrencyID |
Keeps per instance storage of annotation |
| LicenseComplianceHistory |
InitialCostCurrencyID |
History of license compliance changes |
| LicenseComplianceHistory |
RecurringCostCurrencyID |
History of license compliance changes |
| SoftwareItem |
InitialCostCurrencyID |
Software items hold customer specific information about software objects |
| SoftwareItem |
RecurringCostCurrencyID |
Software items hold customer specific information about software objects |