Accounting Data Dictionary

codaCompany__c

Label: Accounting Company

Stores the Certinia company details.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AddressIsValid__c Validated Pre-Spring 2018 Formula:
NOT ( ISBLANK(shortStreet__c) && ISBLANK(City__c) && ISBLANK(StateProvince__c) && ISBLANK(ZipPostCode__c) && ISBLANK(Country__c) ) && ( shortStreet__c = ValidatedStreet__c ) && ( City__c = ValidatedCity__c ) && ( StateProvince__c = ValidatedStateProvince__c ) && ( ZipPostCode__c = ValidatedZipPostalCode__c ) && ( Country__c = ValidatedCountry__c )
Checkbox
AllocatedOwnership__c Allocated Ownership Pre-Spring 2018 Summary
AllowPartialPaymentWhenMatching__c Allow Partial Payment when Matching Spring 2021 Indicates that Allow Partial Payments is selected by default when matching.

Checkbox false
ApexJobId__c Apex Job Id Spring 2020 Unique identifier for the current batch Apex job.

Text(18)
AvalaraVATReportingStartDate__c Avalara VAT Reporting Start Date Spring 2020 Date when this company started sending transaction data to Avalara VAT Reporting using the integration. Any transactions that occurred before this date were not automatically sent to Avalara VAT Reporting.

Date
BankAccount__c Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup
BatchProcess__c Batch Process Spring 2020 Lookup to the batch process record. The record is deleted automatically when the process completes.

Looks up to: fflib_BatchProcess__c
Lookup
CODABaseDate1__c Base Date 1 Pre-Spring 2018 The date on which terms will be calculated.

Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABaseDate2__c Base Date 2 Pre-Spring 2018 The date on which terms will be calculated.

Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABaseDate3__c Base Date 3 Pre-Spring 2018 The date on which terms will be calculated.

Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABaseDate4__c Base Date 4 Pre-Spring 2018 The date on which terms will be calculated.

Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODADaysOffset1__c Days Offset 1 Pre-Spring 2018 The number of days to add to the base date

Number(18,0)
CODADaysOffset2__c Days Offset 2 Pre-Spring 2018 The number of days to add to the base date

Number(18,0)
CODADaysOffset3__c Days Offset 3 Pre-Spring 2018 The number of days to add to the base date

Number(18,0)
CODADaysOffset4__c Days Offset 4 Pre-Spring 2018 The number of days to add to the base date

Number(18,0)
CODADescription1__c Description 1 Pre-Spring 2018 The description of the settlement terms

Text(24)
CODADescription2__c Description 2 Pre-Spring 2018 The description of the settlement terms

Text(24)
CODADescription3__c Description 3 Pre-Spring 2018 The description of the settlement terms

Text(24)
CODADescription4__c Description 4 Pre-Spring 2018 The description of the settlement terms

Text(24)
CODADiscount1__c Discount 1 Pre-Spring 2018 The amount of discount to be applied

Number(5,2)
CODADiscount2__c Discount 2 Pre-Spring 2018 The amount of discount to be applied

Number(5,2)
CODADiscount3__c Discount 3 Pre-Spring 2018 The amount of discount to be applied

Number(5,2)
CODADiscount4__c Discount 4 Pre-Spring 2018 The amount of discount to be applied

Number(5,2)
CashMatchingCurrencyMode__c Matching Currency Mode Pre-Spring 2018 Specifies the default value of the Currency Mode field for matching.

Picklist:
Account
Document
City__c City Pre-Spring 2018 The city

Text(40)
ConsolidationAdjustmentCompany__c Consolidation Adjustment Company Spring 2022 Indicates that this company is a Consolidation Adjustment Company.

Checkbox false
ContactEmail__c Contact Email Pre-Spring 2018 The contact email

Email
Country__c Country Pre-Spring 2018 The country

Text(40)
CustomerCurrencyWriteOffDimension1__c Currency Write-Off Dimension 1 Pre-Spring 2018 Customer Currency Write-Off Dimension 1

Looks up to: codaDimension1__c
Lookup
CustomerCurrencyWriteOffDimension2__c Currency Write-Off Dimension 2 Pre-Spring 2018 Customer Currency Write-Off Dimension 2

Looks up to: codaDimension2__c
Lookup
CustomerCurrencyWriteOffDimension3__c Currency Write-Off Dimension 3 Pre-Spring 2018 Customer Currency Write-Off Dimension 3

Looks up to: codaDimension3__c
Lookup
CustomerCurrencyWriteOffDimension4__c Currency Write-Off Dimension 4 Pre-Spring 2018 Customer Currency Write-Off Dimension 4

Looks up to: codaDimension4__c
Lookup
CustomerCurrencyWriteOffLoss__c Currency Write-Off Loss GLA Summer 2022 The currency exchange loss GLA. Required for some countries where currency gains and losses must be differentiated.

Looks up to: codaGeneralLedgerAccount__c
Lookup
CustomerCurrencyWriteOff__c Currency Write-Off GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
CustomerSettlementDiscountDimension1__c Settlement Discount Dimension 1 Pre-Spring 2018 Customer Settlement Discount Dimension 1

Looks up to: codaDimension1__c
Lookup
CustomerSettlementDiscountDimension2__c Settlement Discount Dimension 2 Pre-Spring 2018 Customer Settlement Discount Dimension 2

Looks up to: codaDimension2__c
Lookup
CustomerSettlementDiscountDimension3__c Settlement Discount Dimension 3 Pre-Spring 2018 Customer Settlement Discount Dimension 3

Looks up to: codaDimension3__c
Lookup
CustomerSettlementDiscountDimension4__c Settlement Discount Dimension 4 Pre-Spring 2018 Customer Settlement Discount Dimension4

Looks up to: codaDimension4__c
Lookup
CustomerSettlementDiscount__c Settlement Discount Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
CustomerWriteOffDimension1__c Write-off Dimension 1 Pre-Spring 2018 Customer Write-Off Dimension1

Looks up to: codaDimension1__c
Lookup
CustomerWriteOffDimension2__c Write-off Dimension 2 Pre-Spring 2018 Customer Write-off Dimension 2

Looks up to: codaDimension2__c
Lookup
CustomerWriteOffDimension3__c Write-off Dimension 3 Pre-Spring 2018 Customer Write-off Dimension 3

Looks up to: codaDimension3__c
Lookup
CustomerWriteOffDimension4__c Write-off Dimension 4 Pre-Spring 2018 Customer WriteOff Dimension4

Looks up to: codaDimension4__c
Lookup
CustomerWriteOff__c Write-off Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
DisableRecurringInvoices__c Disable Opportunity Recurring Invoices Pre-Spring 2018 Checkbox false
ECCountryCode__c Tax Country Code Pre-Spring 2018 Picklist:
AE
AT
AU
BE
BG
CA
CH
CY
CZ
DE
DK
EE
EL
ES
FI
FR
GB
GR
HK
HU
IE
IT
LT
LU
LV
MT
MY
NL
NO
NZ
PL
PT
RO
SE
SG
SI
SK
US
ZA
EInvoicingLegalEntityID__c E-Invoicing Legal Entity Identifier Fall 2021 Stores the ID generated by the external provider when registering a legal entity as a sender of e-invoices.

Text(255)
EInvoicingTaxCategory__c E-Invoicing Tax Category Fall 2021 Stores the tax category code.

Picklist:
deemed_supply
exempt
exemption_schedule_a
exemption_schedule_b
exemption_schedule_c_a
exemption_schedule_c_b
exemption_schedule_c_c
exemption_service_tax
export
intra_community
nonregulation33_exempt
not_registered
outside_scope
regulation33_exempt
reverse_charge
sales_tax
sales_tax_work
sales_to_designated_area
sales_to_export_market
sales_to_special_area
service_tax
service_tax_import
srca_c
srca_s
standard
zero_rated
EliminationCompany__c Elimination Company Pre-Spring 2018 Checkbox false
EnablePlaceOfSupplyRules__c Enable Place of Supply Rules Pre-Spring 2018 Checkbox false
ExchangeRateGroup__c Exchange Rate Group Fall 2019 A lookup to the Foundations Exchange Rate Group.

Looks up to: fferpcore__ExchangeRateGroup__c

Lookup
ExternalId__c External Id Pre-Spring 2018 Text(32)
ExternalTaxCalculation__c External Tax Calculation Pre-Spring 2018 Picklist:
Disabled
Enabled
Fax__c Fax Pre-Spring 2018 The fax

Phone
FirstMatchBy__c First Match By Spring 2021 Specifes the default value of the First Match By field for matching.

Picklist:
Customer Reference
Invoice Number
FlexibleDecimalPlacesStart__c Flexible Decimal Places - FY Start Date Fall 2020 Hidden field to record the start date of the financial year used in the Flexible Decimal Places feature.

Date
IncludeInBackgroundMatchingScheduler__c Include In Background Matching Scheduler Spring 2022 Allows company documents to be included in the Background Matching Scheduler.

Checkbox false
IntercompanyAccount__c Intercompany Account Pre-Spring 2018 Looks up to: Account

Lookup
LocalChartOfAccountsStructure__c Local Chart of Accounts Structure Pre-Spring 2018 Looks up to: ChartOfAccountsStructure__c
Lookup
Localization__c Localization Spring 2020 Stores the ISO country code of the localization.

Picklist:
AT
AU
BE
CH
DE
DK
ES
FI
FR
IT
LU
NL
NO
SE
LogoImage__c Logo Pre-Spring 2018 Formula:
IF(LEN(LogoURL__c)=0,"", IMAGE(LogoURL__c,"Company Logo"))
Text
LogoURL__c Logo URL Pre-Spring 2018 Text(255)
MatchUpTo__c Match Up To Spring 2021 Specifies the default value of the Match Up To field for matching.

Picklist:
Date
Period
MatchingDate__c Matching Date Spring 2021 Specifies the default value of the Matching Date field for matching.

Picklist:
Cash Entry Date
Current Date
OrgWideEffectiveDate__c Org-Wide Effective Date Pre-Spring 2018 Date
Phone__c Phone Pre-Spring 2018 The phone

Phone
ReportingCompany__c Reporting Company Fall 2021 Looks up to: codaCompany__c
Lookup
RetainedEarningsGLA__c Retained Earnings GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
SalesTaxCompanyCode__c External Tax Company Code Pre-Spring 2018 The code identifies the company in external tax calculation and reporting systems

Text(50)
ShortName__c Short Name Spring 2022 Short name for the Accounting Company.

Text(15)
ShortStreet__c Short Street Pre-Spring 2018 TextArea
StateProvince__c State/Province Pre-Spring 2018 Text(20)
Status__c Status Spring 2020 The current status of the batch job: "Processing", "Complete", "Error".

Picklist:
Complete
Error
Processing
Street__c Street Pre-Spring 2018 The street

LongTextArea(32000)
SuspenseGLA__c Suspense GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
TaxCode__c Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxIdentificationNumber__c Tax Identification Number Pre-Spring 2018 Text(20)
ThenMatchBy__c Then Match Remaining By Spring 2021 Specifies the default value of the Then Match Remaining By field for matching.

Picklist:
Date - Newest First
Date - Oldest First
Document Number - Newest First
Document Number - Oldest First
Outstanding Value - Highest First
Outstanding Value - Lowest First
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
UnrealizedGainsLossesGLA__c Unrealized Gains/Losses GLA Winter 2023 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
UseCurrencyWriteOffLoss__c Use Currency Write-Off Loss GLA Summer 2022 Checkbox used to enable the Currency Write-Off Loss field to use a specific GLA when the currency exchange results in a loss. Default is deselected.

Checkbox false
UseOrgWideExchangeRates__c Use Org-Wide Exchange Rates Pre-Spring 2018 Checkbox false
UseUnrealizedLosses__c Use Unrealized Losses GLA Winter 2023 Checkbox false
VATRegistrationNumber__c Tax Registration Number Pre-Spring 2018 Identifying number used for tax purposes.

Text(255)
VAT_GST_Group__c VAT/GST Group Pre-Spring 2018 Checkbox false
ValidatedCity__c ValidatedCity Pre-Spring 2018 Text(40)
ValidatedCountry__c Validated Country Pre-Spring 2018 Text(40)
ValidatedStateProvince__c Validated State/Province Pre-Spring 2018 Text(20)
ValidatedStreet__c ValidatedStreet Pre-Spring 2018 TextArea
ValidatedZipPostalCode__c Validated Zip/Postal Code Pre-Spring 2018 Text(20)
Website__c Website Pre-Spring 2018 The website

Url
YearEndMode__c Year End Mode Pre-Spring 2018 Picklist:
Full Accounting Code
GLA Only
ZipPostCode__c Zip/Postal Code Pre-Spring 2018 The zip or postal code

Text(20)


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