Accounting Data Dictionary

ReportingBalance__c

Label: Reporting Balance

Extract of the Budget and Balance information used for reporting purposes.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
Account__c Account Pre-Spring 2018 Looks up to: Account

Lookup false
AccountingBook__c Accounting Book Spring 2020 Looks up to: AccountingBook__c
Lookup false
AdjustOperatingActivities__c Reclassify Profits Pre-Spring 2018 Text(5) false
BalanceUpdateTimestamp__c Balance Update Timestamp Pre-Spring 2018 DateTime false
BankAccount__c Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup false
BudgetAndBalance__c Budget and Balance Pre-Spring 2018 Looks up to: codaBudget__c
Lookup false
CashFlowCategory__c Cash Flow Category Pre-Spring 2018 Text(255) false
CashFlowLineSummary__c Cash Flow Line Summary Pre-Spring 2018 Text(255) false
Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
Lookup false
Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
Lookup false
Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
Lookup false
Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
Lookup false
DualValue__c Dual Value Pre-Spring 2018 Number(18,2) false
ExternalId__c External Id Pre-Spring 2018 Text(32) false
GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
HashCode__c Cash Flow Exception Hash Code Pre-Spring 2018 Cash Flow Exception Hash Code

Text(28) false
HomeValue__c Home Value Pre-Spring 2018 Number(18,2) false
IntersectDefinition__c Intersect Definition Pre-Spring 2018 Looks up to: codaIntersectDefinition__c
Lookup false
LocalGLA__c Local GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
NumberOfRelatedTransactionLineItems__c Number of Related Transaction Line Items Pre-Spring 2018 Number(18,0) false
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup false
PeriodNumber__c Period Number Pre-Spring 2018 Formula:
IF(ISNUMBER(Period__r.PeriodNumber__c),VALUE(Period__r.PeriodNumber__c),null)
Number(18,0) false
Period__c Period Pre-Spring 2018 Looks up to: codaPeriod__c
Lookup true
Product__c Product Pre-Spring 2018 Looks up to: Product2

Lookup false
ReportingBalanceHashCode__c Reporting Balance Hash Code Pre-Spring 2018 Text(255)
Subanalysis__c Sub-analysis Pre-Spring 2018 Formula:
BankAccount__r.AccountName__c + Product__r.Name + TaxCode__r.Name + Account__r.Name
Text false
TaxCode__c Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup false
Type__c Type Pre-Spring 2018 Picklist:
Actual
Budget
Cash Flow Exception
Forecast
HeadCountActual
HeadCountBudget
HeadCountForecast
HeadCountPlan
Shares
SharesInIssue
SharesOutstanding
SharesPrice
Size
VolumeActual
VolumeBudget
VolumeForecast
VolumePlan
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0) false
Version__c Version Pre-Spring 2018 Number(18,0) false 1
YearNumber__c Year Number Pre-Spring 2018 Formula:
IF(ISNUMBER(Period__r.YearName__r.Name),VALUE(Period__r.YearName__r.Name),null)
Number(18,0) false


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