Table 5345 "CRM Transactioncurrency"

Base Application · Microsoft.Integration.D365Sales · captioned “Dataverse Transactioncurrency” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Dataverse Transactioncurrency
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	StatusCode	Option	Status Reason caption	OptionCaption: ,Active,Inactive
2	ModifiedOn	DateTime	Modified On caption
3	StateCode	Option	Status caption	OptionCaption: Active,Inactive
4	VersionNumber	BigInteger	Version Number caption
5	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6	ImportSequenceNumber	Integer	Import Sequence Number caption
7	OverriddenCreatedOn	Date	Record Created On caption
8	CreatedOn	DateTime	Created On caption
9	TransactionCurrencyId	Guid	Transaction Currency caption
10	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
11	CurrencySymbol	Text[10]	Currency Symbol caption
12	CurrencyName Δ BC28	Text[100]	Specifies the name of the currency.
13	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
14	ISOCurrencyCode Δ BC28	Text[5]	Specifies the ISO currency code, which is required in Dataverse.
15	OrganizationId	Guid	Organization caption	TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId)
16	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
17	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
18	CurrencyPrecision	Integer	Currency Precision caption
19	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
20	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
21	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
22	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
23	EntityImageId	Guid	Entity Image Id caption

Keys

Key1: TransactionCurrencyId (clustered)
Key2: CurrencyName
Key3: ISOCurrencyCode

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OrganizationId: TableRelation Table 5363 “CRM Organization”

Referenced by

60 fields in 37 objects relate to this table (TableRelation or CalcFormula).

Table 5340 “CRM Systemuser”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5341 “CRM Account”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5342 “CRM Contact”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5343 “CRM Opportunity”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5346 “CRM Pricelevel”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5347 “CRM Productpricelevel”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5348 “CRM Product”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5349 “CRM Incident”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5351 “CRM Quote”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5352 “CRM Quotedetail”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5353 “CRM Salesorder”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5354 “CRM Salesorderdetail”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5355 “CRM Invoice”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5356 “CRM Invoicedetail”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5357 “CRM Contract”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5359 “CRM Team”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5360 “CRM Customeraddress”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5363 “CRM Organization”: BaseCurrencyIdName, BaseCurrencyId
Table 5364 “CRM Businessunit”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5365 “CRM Discount”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5366 “CRM Discounttype”: TransactionCurrencyIdName, TransactionCurrencyId
Table 5367 “CRM Account Statistics”: TransactionCurrencyIdName, TransactionCurrencyId
Table 7200 “CDS Connection Setup”: BaseCurrencyCode, BaseCurrencyId
Table 5330 “CRM Connection Setup”: BaseCurrencyId
Table 6400 “FS Work Order”: TransactionCurrencyId
Table 6402 “FS Work Order Product”: TransactionCurrencyId
Table 6406 “FS Work Order Service”: TransactionCurrencyId
Table 6410 “FS Bookable Resource”: TransactionCurrencyId
Table 6412 “FS Bookable Resource Booking”: TransactionCurrencyId
Table 6413 “FS BookableResourceBookingHdr”: TransactionCurrencyId
Table 6610 “FS Bookable Resource”: TransactionCurrencyId
Table 6611 “FS Bookable Resource Booking”: TransactionCurrencyId
Table 6612 “FS BookableResourceBookingHdr”: TransactionCurrencyId
Table 6617 “FS Work Order”: TransactionCurrencyId
Table 6619 “FS Work Order Product”: TransactionCurrencyId
Table 6620 “FS Work Order Service”: TransactionCurrencyId
Table 6623 “FS Connection Setup”: BaseCurrencyId

Pages and codeunits on this table

Page 5345 “CRM TransactionCurrency List” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Transactioncurrency"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.