Table "Currency Amount"
ID 264
Namespace: Microsoft.Finance.Currency
Represents currency-specific amounts for a given date. This table is used to store historical or calculated amounts in different currencies, typically for reporting, analysis, or currency conversion purposes.
Properties
| Name | Value |
|---|---|
| Caption | Currency Amount |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Currency Code" | Code[10] | Currency code identifying the currency for this amount entry. Must reference a valid currency record in the Currency table. |
| Date | Date | Date associated with this currency amount entry. Used to track when the amount was recorded or is effective from. |
| Amount | Decimal | Monetary amount in the specified currency. Automatically formatted according to the currency's display settings. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |