title: "ExchangeRate" category: reference tags: [entity, exchange-rate, datamodel] source: Entities.xml date: 2026-04-17 status: published
ExchangeRate
Type: Entity Properties: 19 Contexts: 1 Statussen: 4
DB-schema:
lookup_table_schema("ExchangeRate")· ../tables/ExchangeRate
Contextsbewerken
- 0: Standaard (
ExchangeRateContext.None)
Statussenbewerken
- -1: Trash (
ExchangeRateStatus.Trash) - 0: None (
ExchangeRateStatus.None) - 1: Aangemaakt (
ExchangeRateStatus.Concept) - 2: Goedgekeurd (
ExchangeRateStatus.Approved)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id.ExchangeCurrency | ExchangeCurrency | EXRABASECURID, EXRACOUNTERCURID | false | , | |
| Id.LineId | UltimoString | EXRALINEID | 9 | false | |
| Context | Context | EXRACONTEXT | false | 0 | |
| ConversionFactor | Int16 | EXRACONVFACTOR | false | 1 | |
| DataProvider | UltimoString | EXRADATAPROVIDER | 50 | true | |
| Date | DateTime | EXRADATE | false | ||
| Exported | Boolean | EXRAEXPORTED | false | 0 | |
| ExternalId | UltimoString | EXRAEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | EXRAEXTERNALSTATUS | 50 | true | |
| IsCurrentExchangeRate | Boolean | EXRAISCURRENT | false | 0 | |
| ProviderMutationDate | DateTime? | EXRAPROVIDERMUTDATE | true | ||
| Rate | Decimal | EXRARATE | false | 1 | |
| RecordCreateDate | DateTime | EXRARECCREATEDATE | false | SYSDATETIME | |
| Status | Status | EXRARECSTATUS | false | 1 | |
| StatusApprovedDate | DateTime? | EXRAAPPROVEDDATE | true | ||
| StatusApprovedEmployee | Employee | EXRAAPPROVEDEMPID | true | ||
| StatusConceptDate | DateTime? | EXRACONCEPTDATE | true | SYSDATETIME | |
| StatusConceptEmployee | Employee | EXRACONCEPTEMPID | true | USERID | |
| TransferNextTime | Boolean | EXRATRANSFERNEXTTIME | false | 0 |
Brondatabewerken
- Entity-definitie —
lookup_entity("ExchangeRate")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("ExchangeRate")· ../tables/ExchangeRate DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="ExchangeRate")Before/After Save events voor ExchangeRate. Bron:workflows.xml.