Accounting Data Dictionary

c2g__codaJournalLineItem__c

Label: Journal Line Item

Stores the details of the journal lines.

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

Lookup false
c2g__AccountReference__c Account Reference Spring 2023 Enables you to enter one or more references to be used by background matching.

Text(255)
c2g__AccountValue__c Override Account Value Pre-Spring 2018 The value in account currency

Number(18,2) false
c2g__Account__c Account Pre-Spring 2018 A journal line may refer to an account

Looks up to: Account

Lookup false
c2g__ArchivingGLAKey__c Archiving GLA Key Spring 2020 Stores the key for the Archiving Journal Line Item, based on the Account and GLA.

Formula:
IF(OR(ISNULL(c2g__GeneralLedgerAccount__c ),ISBLANK(c2g__GeneralLedgerAccount__c ), NOT(ISPICKVAL(c2g__Journal__r.c2g__Type__c, 'Archive Summarization Journal'))),'', IF(OR(ISNULL(c2g__Account__c), ISBLANK(c2g__Account__c)) , c2g__GeneralLedgerAccount__c , c2g__Account__c + "#" + c2g__GeneralLedgerAccount__c))
Text false
c2g__BankAccountValue__c Override Bank Account Value Pre-Spring 2018 The value in bank currency

Number(18,2) false
c2g__BankAccount__c Bank Account Pre-Spring 2018 A journal line may refer to a bank

Looks up to: c2g__codaBankAccount__c
Lookup false
c2g__CorrelationId__c Correlation ID Spring 2020 Records the correlation key used within the ERP system.

Text(255) false
c2g__Credits__c Credit Fall 2018 Shows the credit value in document currency, displayed without a minus sign.

Formula:
IF(c2g__Value__c < 0, c2g__Value__c * -1, 0)
Number(18,2) false
c2g__DebitCredit__c Debit/Credit Pre-Spring 2018 Picklist:
Credit
Debit
c2g__Debits__c Debit Fall 2018 Shows the debit value in document currency.

Formula:
IF(c2g__Value__c > 0, c2g__Value__c, 0)
Number(18,2) false
c2g__DeriveLineNumber__c Derive Line Number Pre-Spring 2018 Checkbox true
c2g__DestinationCompany__c Destination Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup false
c2g__DestinationLineType__c Destination Line Type Pre-Spring 2018 Picklist:
Account - Customer
Account - Vendor
Bank Account
General Ledger Account
Product - Purchases
Product - Sales
Tax Code
c2g__Dimension1Value__c Override Dimension 1 Value Pre-Spring 2018 The value in dimension currency

Number(18,2) false
c2g__Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: c2g__codaDimension1__c
Lookup false
c2g__Dimension2Value__c Override Dimension 2 Value Pre-Spring 2018 The value in dimension currency

Number(18,2) false
c2g__Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: c2g__codaDimension2__c
Lookup false
c2g__Dimension3Value__c Override Dimension 3 Value Pre-Spring 2018 The value in dimension currency

Number(18,2) false
c2g__Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: c2g__codaDimension3__c
Lookup false
c2g__Dimension4Value__c Override Dimension 4 Value Pre-Spring 2018 The value in dimension currency

Number(18,2) false
c2g__Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: c2g__codaDimension4__c
Lookup false
c2g__DualRate__c Dual Rate Pre-Spring 2018 Number(18,9)
c2g__DualValue__c Override Dual Value Pre-Spring 2018 The value in dual currency

Number(18,2) false
c2g__ExcludefromCashFlow__c Exclude from Cash Flow Fall 2020 If selected, indicates that the bank account line item is excluded from the Cash Flow Analytics dashboard in Business Analytics.

Checkbox false
c2g__ExternalId__c External Id Pre-Spring 2018 Text(32) false
c2g__GeneralLedgerAccountValue__c Override General Ledger Account Value Pre-Spring 2018 Number(18,2) false
c2g__GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 A journal line always refers to a GLA

Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__HomeValue__c Override Home Value Pre-Spring 2018 The value in home currency

Number(18,2) false
c2g__IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: c2g__codaIntercompanyTransfer__c
Lookup
c2g__JournalRate__c Journal Rate Pre-Spring 2018 Number(18,9)
c2g__Journal__c Journal Pre-Spring 2018 A journal consists of a set of journal lines

Looks up to: c2g__codaJournal__c
MasterDetail
c2g__LineDescription__c Line Description Pre-Spring 2018 A reference linking matched lines

Text(255) false
c2g__LineNumber__c Line Number Pre-Spring 2018 Number(18,0) false
c2g__LineType__c Line Type Pre-Spring 2018 Every journal line must have a line type

Picklist:
Account - Customer
Account - Vendor
Bank Account
General Ledger Account
Intercompany
Product - Purchases
Product - Sales
Tax Code
c2g__LocalGLAValue__c Override Local GLA Value Pre-Spring 2018 Number(18,2) false
c2g__LocalGLA__c Local GLA Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__OwnerCompany__c Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup false
c2g__ProductAnalysis__c Product Analysis Pre-Spring 2018 Looks up to: Product2

Lookup false
c2g__Product__c Product Pre-Spring 2018 A journal line may refer to a product

Looks up to: Product2

Lookup false
c2g__ReportingRate__c Reporting Rate Fall 2021 The rate used to report to the parent company.

Number(18,9)
c2g__ReportingValue__c Override Reporting Value Fall 2021 Overrides the value used to report to the parent company.

Number(18,2) false
c2g__TaxAnalysis1__c Tax Analysis Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup false
c2g__TaxAnalysis2__c Tax Analysis 2 Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup false
c2g__TaxAnalysis3__c Tax Analysis 3 Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup false
c2g__TaxCode__c Tax Code Pre-Spring 2018 A journal line may refer to a tax code

Looks up to: c2g__codaTaxCode__c
Lookup false
c2g__TaxValue1__c Tax Value Pre-Spring 2018 Number(18,2) false
c2g__TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2) false
c2g__TaxValue3__c Tax Value 3 Pre-Spring 2018 Number(18,2) false
c2g__TaxableValue__c Taxable Value Pre-Spring 2018 Number(18,2) false
c2g__UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0) false
c2g__Value__c Value Pre-Spring 2018 The value in document currency

Number(18,2) true 0
c2g__VendorValue__c Vendor Value Pre-Spring 2018 The value in vendor currency

Number(18,2) false 0
c2g__YearEndCriterionIdentifier__c Year End Criteria Identifier Pre-Spring 2018 Text(255) false


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