Accounting Data Dictionary

c2g__codaCompany__c

Label: Accounting Company

Stores the Certinia company details.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
c2g__AddressIsValid__c Validated Pre-Spring 2018 Formula:
NOT ( ISBLANK(c2g__shortStreet__c) && ISBLANK(c2g__City__c) && ISBLANK(c2g__StateProvince__c) && ISBLANK(c2g__ZipPostCode__c) && ISBLANK(c2g__Country__c) ) && ( c2g__shortStreet__c = c2g__ValidatedStreet__c ) && ( c2g__City__c = c2g__ValidatedCity__c ) && ( c2g__StateProvince__c = c2g__ValidatedStateProvince__c ) && ( c2g__ZipPostCode__c = c2g__ValidatedZipPostalCode__c ) && ( c2g__Country__c = c2g__ValidatedCountry__c )
Checkbox
c2g__AllocatedOwnership__c Allocated Ownership Pre-Spring 2018 Summary
c2g__AllowPartialPaymentWhenMatching__c Allow Partial Payment when Matching Spring 2021 Indicates that Allow Partial Payments is selected by default when matching.

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

Text(18) false
c2g__AuxiliaryDimension1__c Auxiliary Dimension 1 Spring 2024 The analysis dimension 1 related to the auxiliary GLA.

Looks up to: c2g__codaDimension1__c
Lookup
c2g__AuxiliaryDimension2__c Auxiliary Dimension 2 Spring 2024 The analysis dimension 2 related to the auxiliary GLA.

Looks up to: c2g__codaDimension2__c
Lookup
c2g__AuxiliaryDimension3__c Auxiliary Dimension 3 Spring 2024 The analysis dimension 3 related to the auxiliary GLA.

Looks up to: c2g__codaDimension3__c
Lookup
c2g__AuxiliaryDimension4__c Auxiliary Dimension 4 Spring 2024 The analysis dimension 4 related to the auxiliary GLA.

Looks up to: c2g__codaDimension4__c
Lookup
c2g__AuxiliaryGLA__c Auxiliary GLA Spring 2024 The default GLA used when performing cash matching to a specific GLA.

Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__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 false
c2g__BankAccount__c Bank Account Pre-Spring 2018 Looks up to: c2g__codaBankAccount__c
Lookup
c2g__BatchProcess__c Batch Process Spring 2020 Lookup to the batch process record. The record is deleted automatically when the process completes.

Looks up to: c2g__fflib_BatchProcess__c
Lookup false
c2g__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
c2g__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
c2g__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
c2g__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
c2g__CODADaysOffset1__c Days Offset 1 Pre-Spring 2018 The number of days to add to the base date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Email
c2g__Country__c Country Pre-Spring 2018 The country

Text(40)
c2g__CustomFirstMatchBy__c Custom First Match By Spring 2025 Sales Invoice field api name

Text(80) false
c2g__CustomerCurrencyWriteOffDimension1__c Currency Write-Off Dimension 1 Pre-Spring 2018 Customer Currency Write-Off Dimension 1

Looks up to: c2g__codaDimension1__c
Lookup
c2g__CustomerCurrencyWriteOffDimension2__c Currency Write-Off Dimension 2 Pre-Spring 2018 Customer Currency Write-Off Dimension 2

Looks up to: c2g__codaDimension2__c
Lookup
c2g__CustomerCurrencyWriteOffDimension3__c Currency Write-Off Dimension 3 Pre-Spring 2018 Customer Currency Write-Off Dimension 3

Looks up to: c2g__codaDimension3__c
Lookup
c2g__CustomerCurrencyWriteOffDimension4__c Currency Write-Off Dimension 4 Pre-Spring 2018 Customer Currency Write-Off Dimension 4

Looks up to: c2g__codaDimension4__c
Lookup
c2g__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: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__CustomerCurrencyWriteOff__c Currency Write-Off GLA Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__CustomerSettlementDiscountDimension1__c Settlement Discount Dimension 1 Pre-Spring 2018 Customer Settlement Discount Dimension 1

Looks up to: c2g__codaDimension1__c
Lookup
c2g__CustomerSettlementDiscountDimension2__c Settlement Discount Dimension 2 Pre-Spring 2018 Customer Settlement Discount Dimension 2

Looks up to: c2g__codaDimension2__c
Lookup
c2g__CustomerSettlementDiscountDimension3__c Settlement Discount Dimension 3 Pre-Spring 2018 Customer Settlement Discount Dimension 3

Looks up to: c2g__codaDimension3__c
Lookup
c2g__CustomerSettlementDiscountDimension4__c Settlement Discount Dimension 4 Pre-Spring 2018 Customer Settlement Discount Dimension4

Looks up to: c2g__codaDimension4__c
Lookup
c2g__CustomerSettlementDiscount__c Settlement Discount Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__CustomerWriteOffDimension1__c Write-off Dimension 1 Pre-Spring 2018 Customer Write-Off Dimension1

Looks up to: c2g__codaDimension1__c
Lookup
c2g__CustomerWriteOffDimension2__c Write-off Dimension 2 Pre-Spring 2018 Customer Write-off Dimension 2

Looks up to: c2g__codaDimension2__c
Lookup
c2g__CustomerWriteOffDimension3__c Write-off Dimension 3 Pre-Spring 2018 Customer Write-off Dimension 3

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

Looks up to: c2g__codaDimension4__c
Lookup
c2g__CustomerWriteOff__c Write-off Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__DisableRecurringInvoices__c Disable Opportunity Recurring Invoices Pre-Spring 2018 Checkbox false
c2g__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
c2g__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) false
c2g__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
c2g__EliminationCompany__c Elimination Company Pre-Spring 2018 Checkbox false
c2g__EnablePlaceOfSupplyRules__c Enable Place of Supply Rules Pre-Spring 2018 Checkbox false
c2g__ExchangeRateGroup__c Exchange Rate Group Fall 2019 A lookup to the Foundations Exchange Rate Group.

Looks up to: fferpcore__ExchangeRateGroup__c

Lookup
c2g__ExternalId__c External Id Pre-Spring 2018 Text(32)
c2g__ExternalTaxCalculation__c External Tax Calculation Pre-Spring 2018 Picklist:
Disabled
Enabled
c2g__Fax__c Fax Pre-Spring 2018 The fax

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

Picklist:
CustomField
Customer Reference
Invoice Number
c2g__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 false
c2g__IncludeInBackgroundMatchingScheduler__c Include In Background Matching Scheduler Spring 2022 Allows company documents to be included in the Background Matching Scheduler.

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

Lookup false
c2g__LocalChartOfAccountsStructure__c Local Chart of Accounts Structure Pre-Spring 2018 Looks up to: c2g__ChartOfAccountsStructure__c
Lookup false
c2g__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
PL
SE
false
c2g__LogoImage__c Logo Pre-Spring 2018 Formula:
IF(LEN(c2g__LogoURL__c)=0,"", IMAGE(c2g__LogoURL__c,"Company Logo"))
Text
c2g__LogoURL__c Logo URL Pre-Spring 2018 Text(255)
c2g__MatchUpTo__c Match Up To Spring 2021 Specifies the default value of the Match Up To field for matching.

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

Picklist:
Cash Entry Date
Current Date
c2g__OrgWideEffectiveDate__c Org-Wide Effective Date Pre-Spring 2018 Date false
c2g__Phone__c Phone Pre-Spring 2018 The phone

Phone
c2g__ReportingCompany__c Reporting Company Fall 2021 Looks up to: c2g__codaCompany__c
Lookup
c2g__RetainedEarningsGLA__c Retained Earnings GLA Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__SalesTaxCompanyCode__c External Tax Company Code Pre-Spring 2018 The code identifies the company in external tax calculation and reporting systems

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

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

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

LongTextArea(32000)
c2g__SuspenseGLA__c Suspense GLA Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__TaxCode__c Tax Code Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup
c2g__TaxIdentificationNumber__c Tax Identification Number Pre-Spring 2018 Text(20)
c2g__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
c2g__UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
c2g__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: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__UnrealizedLossesGLA__c Unrealized Losses GLA Winter 2023 The GLA that the unrealized losses are posted to.

Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__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
c2g__UseOrgWideExchangeRates__c Use Org-Wide Exchange Rates Pre-Spring 2018 Checkbox false
c2g__UseUnrealizedLosses__c Use Unrealized Losses GLA Winter 2023 Checkbox false
c2g__VATRegistrationNumber__c Tax Registration Number Pre-Spring 2018 Identifying number used for tax purposes.

Text(255)
c2g__VAT_GST_Group__c VAT/GST Group Pre-Spring 2018 Checkbox false
c2g__ValidatedCity__c ValidatedCity Pre-Spring 2018 Text(40) false
c2g__ValidatedCountry__c Validated Country Pre-Spring 2018 Text(40) false
c2g__ValidatedStateProvince__c Validated State/Province Pre-Spring 2018 Text(20) false
c2g__ValidatedStreet__c ValidatedStreet Pre-Spring 2018 TextArea false
c2g__ValidatedZipPostalCode__c Validated Zip/Postal Code Pre-Spring 2018 Text(20) false
c2g__Website__c Website Pre-Spring 2018 The website

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

Text(20)


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