Accounting Data Dictionary

ReportingBalance__c

Label: Reporting Balance

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

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

Lookup
AccountingBook__c Accounting Book Spring 2020 Looks up to: AccountingBook__c
Lookup
AdjustOperatingActivities__c Reclassify Profits Pre-Spring 2018 Text(5)
BalanceUpdateTimestamp__c Balance Update Timestamp Pre-Spring 2018 DateTime
BankAccount__c Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup
BudgetAndBalance__c Budget and Balance Pre-Spring 2018 Looks up to: codaBudget__c
Lookup
CashFlowCategory__c Cash Flow Category Pre-Spring 2018 Text(255)
CashFlowLineSummary__c Cash Flow Line Summary Pre-Spring 2018 Text(255)
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
DualValue__c Dual Value Pre-Spring 2018 Number(18,2)
ExternalId__c External Id Pre-Spring 2018 Text(32)
GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
HashCode__c Cash Flow Exception Hash Code Pre-Spring 2018 Cash Flow Exception Hash Code

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

Lookup
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
TaxCode__c Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
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)
Version__c Version Pre-Spring 2018 Number(18,0) 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)


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