Accounting Data Dictionary

codaCurrencyRevaluation__c

Label: Currency Revaluation

Stores the master details related to a currency revaluation.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountingBook__c Accounting Book Spring 2020 A lookup to the Accounting Book.

Looks up to: AccountingBook__c
Lookup
Analysis__c Analysis Pre-Spring 2018 Picklist:
Detail Level
Summary Level
BreakdownByStandardAnalysisFields__c Standard Breakdown Pre-Spring 2018 If checked your transaction line items for the gains and losses GLA will be broken down by standard analysis fields (Account, Product, Bank Account, Tax Code).

Checkbox false
BreakdownBySubAnalysisFields__c Sub-Analysis Breakdown Pre-Spring 2018 If checked your revaluation summary and transaction line items for the gains and losses GLA will be broken down by custom sub-analysis fields.

Checkbox false
CancelPeriod__c Cancel Period Pre-Spring 2018 Looks up to: codaPeriod__c
Lookup
CancellationReason__c Cancellation Reason Pre-Spring 2018 TextArea
Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
Lookup
Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
Lookup
Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
Lookup
Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
Lookup
DimensionalAnalysis__c Dimensional Analysis On Lines Pre-Spring 2018 Picklist:
Copy from Source
Enter Dimensions
DiscardReason__c Discard Reason Pre-Spring 2018 TextArea
DocumentCurrency__c Document Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
DocumentDescription__c Document Description Pre-Spring 2018 TextArea
DocumentOrdering__c Document Ordering Spring 2020 Formula:
IF(ISBLANK(TEXT(DocumentType__c)), NULL, IF(ISPICKVAL(DocumentType__c, 'Translation'), SUBSTITUTE( Name , 'CRV','CRT'), Name))
Text
DocumentReference__c Document Reference Pre-Spring 2018 Text(80)
DocumentType__c Document Type Spring 2020 Stores the document type. Document types are Revaluation or Translation.

Picklist:
Revaluation
Translation
DualExchangeRate__c Dual Exchange Rate Pre-Spring 2018 Number(18,9)
DualValue__c Dual Value Pre-Spring 2018 Summary
ErrorListView__c Error Pre-Spring 2018 Url
ErrorText__c Error Text Pre-Spring 2018 LongTextArea(32000)
ExcludeCRVTransactions__c Exclude CRV Transactions Pre-Spring 2018 Checkbox false
ExcludeRevaluedLines__c Exclude Revalued Lines Pre-Spring 2018 Should previously revalued lines be excluded from selection by this revaluation or should they cause the revaluation to fail?

Checkbox false
GroupDisplayName__c Group Description Pre-Spring 2018 The currency revaluation group display name.

Formula:
RevalGroup__r.DisplayName__c
Text
HomeExchangeRate__c Document Exchange Rate Pre-Spring 2018 Number(18,9)
HomeValue__c Home Value Pre-Spring 2018 Summary
Locks__c Locks Pre-Spring 2018 The locking object ID used to protect updates to the owning currency revaluation field on Transaction lines.

Text(18)
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
PeriodFrom__c Period From Pre-Spring 2018 Looks up to: codaPeriod__c
Lookup
PeriodTo__c Period To Pre-Spring 2018 Looks up to: codaPeriod__c
Lookup
PostingPeriod__c Posting Period Pre-Spring 2018 Looks up to: codaPeriod__c
Lookup
ReportingExchangeRate__c Reporting Exchange Rate Fall 2021 Number(18,9)
ReportingValue__c Reporting Value Fall 2021 Summary
RevalGroup__c Group Pre-Spring 2018 Our currency revaluation group.

Looks up to: codaCurrencyRevaluationGroup__c
Lookup
RevaluationType__c Revaluation Type Pre-Spring 2018 Picklist:
Balance Sheet
Income Statement
ReversalPeriod__c Reversal Period Pre-Spring 2018 Looks up to: codaPeriod__c
Lookup
ScheduledTime__c Scheduled Time Pre-Spring 2018 Formula:
RevalGroup__r.ScheduledTime__c
DateTime
Status__c Status Pre-Spring 2018 Picklist:
Canceled
Canceling
Canceling Error
Complete
Discarded
Discarding
Generating
Generation Error
In Progress
Pending
Posting
Posting Error
Void
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
UnrealizedGainsLossesGLA__c Unrealized Gains/Losses GLA Pre-Spring 2018 The GLA that the unrealized gains and losses are posted to. However, if for the accounting company you select the Use Unrealized Losses GLA checkbox, only use this field for the unrealized gains.

Looks up to: codaGeneralLedgerAccount__c
Lookup
UnrealizedLossesGLA__c Unrealized Losses GLA Winter 2023 The GLA that the unrealized losses are posted to.

Looks up to: codaGeneralLedgerAccount__c
Lookup


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.